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
NameTypeConstraintsDescription
direct_deposit_fundable_transaction_KEYint (4)NOT NULLThe primary key.
user_session_guiduniqueidentifier (16)NOT NULLGuid which ties a particular user session to a table row.
client_idnvarchar (22)NOT NULLClient ID.
client_namenvarchar (100)NOT NULLClient name.
funding_type__descriptionnvarchar (40)NOT NULLFunding type description
transaction_datesmalldatetime (4)Date the direct deposit transaction was created.
impound_bank_account__descriptionnvarchar (100)NOT NULLName of the impound bank account
client_bank_account__descriptionnvarchar (100)NOT NULLName of the client bank account.
transaction_referencenvarchar (80)NOT NULLReference number associated with the transaction, usually a check number.
transaction_amountdecimal (9, 2)NOT NULLAmount being transferred between accounts.
payee_id_numbernvarchar (30)NOT NULLIdentifier associated with the payee (EIN, TIN, etc.)
payee_namenvarchar (200)NOT NULLName of the payee.
effective_datesmalldatetime (4)Date of the direct deposit transaction.
Primary key
NameColumnsDescription
PK_Direct_Deposit_Fundable_Transactiondirect_deposit_fundable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Direct_Deposit_Fundable_Transaction__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram