Table: dbo.Direct_Deposit_Fundable_Transaction
This table's purpose is to allow the direct deposit funding UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Fundable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Fundable_Transactions also needs to be updated to maintain identical structure.
Columns
Name | Type | Constraints | Description
direct_deposit_fundable_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.
funding_type__description | nvarchar (40) | NOT NULL | Funding type description
transaction_date | smalldatetime (4) |  | Date the direct deposit transaction was created.
impound_bank_account__description | nvarchar (100) | NOT NULL | Name of the impound bank account
client_bank_account__description | nvarchar (100) | NOT NULL | Name of the client bank account.
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.
payee_id_number | nvarchar (30) | NOT NULL | Identifier associated with the payee (EIN, TIN, etc.)
payee_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_Fundable_Transaction | direct_deposit_fundable_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Direct_Deposit_Fundable_Transaction__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |