Table: dbo.Client_Direct_Deposit
Columns
NameTypeConstraintsDescription
checkbook_KEYint (4)NOT NULLcheckbook_KEY
default_direct_deposit_file_setupbit (1)NOT NULLFlag indicating that this direct deposit setup is the default.
primary_bank_accountbit (1)NOT NULLprimary_bank_account
originator__bank_KEYint (4)NOT NULLACH originator bank key
immediate_origin_name_selectionint (4)NOT NULLACH immediate origin name source selection - See CK_Client_Direct_Deposit__immediate_origin_name_selection for more details.
immediate_origin_name_othernvarchar (46)NOT NULLACH immediate origin name to use if immediate_origin_name is "other"
immediate_origin_id_selectionint (4)NOT NULLACH immediate origin id source selection - See CK_Client_Direct_Deposit__immediate_origin_id_selection for more details.
immediate_origin_id_othernvarchar (20)NOT NULLACH immediate origin id to use if immediate_origin_id is "other"
immediate_destination__bank_KEYint (4)NOT NULLACH immediate destination bank key
create_balanced_file_for_payroll_checksbit (1)NOT NULLBalanced file creation requested for payroll checks.
create_balanced_file_for_vendor_checksbit (1)NOT NULLBalanced file creation requested for vendor checks.
create_balanced_file_for_tax_depositsbit (1)NOT NULLBalanced file creation requested for tax deposits.
direct_deposit_status_KEYnvarchar (16)NOT NULLStatus of direct deposit info.
company_name_selectionint (4)NOT NULLACH company name source selection - See CK_Client_Direct_Deposit__company_name_selection for more details.
company_name_othernvarchar (32)NOT NULLACH company name if company_name is "other"
company_id_selectionint (4)NOT NULLACH company id source selection - See CK_Client_Direct_Deposit__company_id_selection for more details.
company_id_othernvarchar (20)NOT NULLACH company id if company_id is "other"
leading_numberint (4)NOT NULLACH leading_number
individual_id_selectionint (4)NOT NULLACH individual id source selection - See CK_Client_Direct_Deposit__individual_id_selection for more details.
reference_codenvarchar (16)NOT NULLACH reference code
company_discretionary_datanvarchar (40)NOT NULLACH company discretionary data
company_descriptive_datenvarchar (12)NOT NULLACH company descriptive date
use_file_headerbit (1)NOT NULLUse file header for ACH
exclude_eight_recordbit (1)NOT NULLexclude eight record from ACH
automatically_override_waiting_statusbit (1)NOT NULLAutomatically override waiting status
override_waiting_status_daysint (4)NOT NULLOverride waiting status days
prenote_datesmalldatetime (4)Date of prenote transaction
prenote_createdbit (1)NOT NULLFlag indicating that a prenote file have been created for this entry
payroll_ncv_effective_date_selectiontinyint (1)NOT NULLPayroll and non-commercial vendor use for effective date selection. 1== CheckDate 2 == SystemDate
payroll_ncv_effective_date_offsetsmallint (2)NOT NULLPayroll and non-commercial vendor effective date banking days offset
commercial_vendor_effective_date_selectiontinyint (1)NOT NULLCommercial vendor use for effective date selection. 1== CheckDate 2 == SystemDate
commercial_vendor_effective_date_offsetsmallint (2)NOT NULLCommercial vendor effective date banking days offset
tax_payment_effective_date_selectiontinyint (1)NOT NULLTax payments use for effective date selection. 1== CheckDate 2 == SystemDate
tax_payment_effective_date_offsetsmallint (2)NOT NULLTax payments effective date banking days offset
child_support_effective_date_selectiontinyint (1)NOT NULLChild support use for effective date setting. 1== CheckDate 2 == SystemDate
child_support_effective_date_offsetsmallint (2)NOT NULLChild support effective date banking days offset
record_created_datesmalldatetime (4)NOT NULLDate this record was created - used when automatically updating status to approved.
create_balanced_file_for_fund_checksbit (1)NOT NULLBalanced file creation requested for fund checks.
process_via_interceptbit (1)NOT NULL1 means Direct deposit transactions are processed by ACS via InterceptEFT. 0 means (absent another transmitter) the user will handle transmission by hand.
client_direct_deposit_KEYint (4)NOT NULLPrimary key to the table.
is_client_recordbit (1)NOT NULLDenotes this entry is for client access direct deposit (T) or firm direct deposit (F).
combine_like_company_batchbit (1)NOT NULLOption to combine entry detail records under a single client batch header record where the client batch headers are identical.
prenote_effective_datesmalldatetime (4)The effective date used when prenoting this allocation.
notesnvarchar (480)NOT NULLDirect deposit processing notes when this allocation is prenoted.
add_crlf_to_end_of_filebit (1)NOT NULLFlag which indicates the user wants a carriage return / line feed added to the end of the ACH file.
create_separate_ccd_batch_for_ppd_balancing_entrybit (1)NOT NULLWhen true we will create a separate CCD batch for the balancing entry of a PPD transaction (assuming there is a balancing entry).
Primary key
NameColumnsDescription
PK_Client_Direct_Depositclient_direct_deposit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Direct_Deposit__Bank__immediate_destination__bank_KEYimmediate_destination__bank_KEYBank (bank_KEY)
FK_Client_Direct_Deposit__Bank__originator__bank_KEYoriginator__bank_KEYBank (bank_KEY)
FK_Client_Direct_Deposit__Bank_Account_Direct_Deposit_Status__direct_deposit_status_KEYdirect_deposit_status_KEYBank_Account_Direct_Deposit_Status (bank_account_direct_deposit_status_KEY)
FK_Client_Direct_Deposit__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Direct_Deposit_Fileheader__Client_Direct_Deposit__client_direct_deposit_KEYclient_direct_deposit_KEYDirect_Deposit_Fileheader

Schema diagram