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
NameTypeConstraintsDescription
direct_deposit_processable_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.
transaction_datesmalldatetime (4)Date the direct deposit transaction was created.
source_bank__descriptionnvarchar (100)NOT NULLName of the bank the funds are coming from.
source_bank__routing_numbernvarchar (30)NOT NULLBank routing number the funds are coming from.
source_bank__account_numbernvarchar (34)NOT NULLBank account number the funds are coming from.
processing_methodnvarchar (30)NOT NULLDirect deposit processing method.
destination_bank__descriptionnvarchar (100)NOT NULLName of the bank the funds are being transferred to.
destination_bank__routing_numbernvarchar (30)NOT NULLBank routing number the funds are being transferred to.
destination_bank__account_numbernvarchar (34)NOT NULLBank account number the funds are being transferred to.
transaction_referencenvarchar (80)NOT NULLReference number associated with the transaction, usually a check number.
transaction_amountdecimal (9, 2)NOT NULLAmount being transferred between accounts.
transaction_typenvarchar (60)NOT NULLIdentifier to indicate the type of transaction (Payroll, Tax payment, etc.)
individual_id_numbernvarchar (30)NOT NULLIdentifier associated with the payee (EIN, TIN, etc.)
individual_namenvarchar (200)NOT NULLName of the payee.
effective_datesmalldatetime (4)Date of the direct deposit transaction.
Primary key
NameColumnsDescription
PK_Direct_Deposit_Processable_Transactiondirect_deposit_processable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Direct_Deposit_Processable_Transaction__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram