| Table: dbo.Direct_Deposit_Processable_Transaction | |||
| This table's purpose is to allow the direct deposit processing UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Processable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Processable_Transactions also needs to be updated to maintain identical structure. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| direct_deposit_processable_transaction_KEY | int (4) | NOT NULL | The primary key. |
| user_session_guid | uniqueidentifier (16) | NOT NULL | Guid which ties a particular user session to a table row. |
| client_id | nvarchar (22) | NOT NULL | Client ID. |
| client_name | nvarchar (100) | NOT NULL | Client name. |
| transaction_date | smalldatetime (4) | Date the direct deposit transaction was created. | |
| source_bank__description | nvarchar (100) | NOT NULL | Name of the bank the funds are coming from. |
| source_bank__routing_number | nvarchar (30) | NOT NULL | Bank routing number the funds are coming from. |
| source_bank__account_number | nvarchar (34) | NOT NULL | Bank account number the funds are coming from. |
| processing_method | nvarchar (30) | NOT NULL | Direct deposit processing method. |
| destination_bank__description | nvarchar (100) | NOT NULL | Name of the bank the funds are being transferred to. |
| destination_bank__routing_number | nvarchar (30) | NOT NULL | Bank routing number the funds are being transferred to. |
| destination_bank__account_number | nvarchar (34) | NOT NULL | Bank account number the funds are being transferred to. |
| transaction_reference | nvarchar (80) | NOT NULL | Reference number associated with the transaction, usually a check number. |
| transaction_amount | decimal (9, 2) | NOT NULL | Amount being transferred between accounts. |
| transaction_type | nvarchar (60) | NOT NULL | Identifier to indicate the type of transaction (Payroll, Tax payment, etc.) |
| individual_id_number | nvarchar (30) | NOT NULL | Identifier associated with the payee (EIN, TIN, etc.) |
| individual_name | nvarchar (200) | NOT NULL | Name of the payee. |
| effective_date | smalldatetime (4) | Date of the direct deposit transaction. | |
| Primary key | |||
| Name | Columns | Description | |
| PK_Direct_Deposit_Processable_Transaction | direct_deposit_processable_transaction_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Direct_Deposit_Processable_Transaction__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) | |