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) |