Table: dbo.Client_Direct_Deposit
Columns
Name | Type | Constraints | Description
checkbook_KEY | int (4) | NOT NULL | checkbook_KEY
default_direct_deposit_file_setup | bit (1) | NOT NULL | Flag indicating that this direct deposit setup is the default.
primary_bank_account | bit (1) | NOT NULL | primary_bank_account
originator__bank_KEY | int (4) | NOT NULL | ACH originator bank key
immediate_origin_name_selection | int (4) | NOT NULL | ACH immediate origin name source selection - See CK_Client_Direct_Deposit__immediate_origin_name_selection for more details.
immediate_origin_name_other | nvarchar (46) | NOT NULL | ACH immediate origin name to use if immediate_origin_name is "other"
immediate_origin_id_selection | int (4) | NOT NULL | ACH immediate origin id source selection - See CK_Client_Direct_Deposit__immediate_origin_id_selection for more details.
immediate_origin_id_other | nvarchar (20) | NOT NULL | ACH immediate origin id to use if immediate_origin_id is "other"
immediate_destination__bank_KEY | int (4) | NOT NULL | ACH immediate destination bank key
create_balanced_file_for_payroll_checks | bit (1) | NOT NULL | Balanced file creation requested for payroll checks.
create_balanced_file_for_vendor_checks | bit (1) | NOT NULL | Balanced file creation requested for vendor checks.
create_balanced_file_for_tax_deposits | bit (1) | NOT NULL | Balanced file creation requested for tax deposits.
direct_deposit_status_KEY | nvarchar (16) | NOT NULL | Status of direct deposit info.
company_name_selection | int (4) | NOT NULL | ACH company name source selection - See CK_Client_Direct_Deposit__company_name_selection for more details.
company_name_other | nvarchar (32) | NOT NULL | ACH company name if company_name is "other"
company_id_selection | int (4) | NOT NULL | ACH company id source selection - See CK_Client_Direct_Deposit__company_id_selection for more details.
company_id_other | nvarchar (20) | NOT NULL | ACH company id if company_id is "other"
leading_number | int (4) | NOT NULL | ACH leading_number
individual_id_selection | int (4) | NOT NULL | ACH individual id source selection - See CK_Client_Direct_Deposit__individual_id_selection for more details.
reference_code | nvarchar (16) | NOT NULL | ACH reference code
company_discretionary_data | nvarchar (40) | NOT NULL | ACH company discretionary data
company_descriptive_date | nvarchar (12) | NOT NULL | ACH company descriptive date
use_file_header | bit (1) | NOT NULL | Use file header for ACH
exclude_eight_record | bit (1) | NOT NULL | exclude eight record from ACH
automatically_override_waiting_status | bit (1) | NOT NULL | Automatically override waiting status
override_waiting_status_days | int (4) | NOT NULL | Override waiting status days
prenote_date | smalldatetime (4) |  | Date of prenote transaction
prenote_created | bit (1) | NOT NULL | Flag indicating that a prenote file have been created for this entry
payroll_ncv_effective_date_selection | tinyint (1) | NOT NULL | Payroll and non-commercial vendor use for effective date selection. 1== CheckDate 2 == SystemDate
payroll_ncv_effective_date_offset | smallint (2) | NOT NULL | Payroll and non-commercial vendor effective date banking days offset
commercial_vendor_effective_date_selection | tinyint (1) | NOT NULL | Commercial vendor use for effective date selection. 1== CheckDate 2 == SystemDate
commercial_vendor_effective_date_offset | smallint (2) | NOT NULL | Commercial vendor effective date banking days offset
tax_payment_effective_date_selection | tinyint (1) | NOT NULL | Tax payments use for effective date selection. 1== CheckDate 2 == SystemDate
tax_payment_effective_date_offset | smallint (2) | NOT NULL | Tax payments effective date banking days offset
child_support_effective_date_selection | tinyint (1) | NOT NULL | Child support use for effective date setting. 1== CheckDate 2 == SystemDate
child_support_effective_date_offset | smallint (2) | NOT NULL | Child support effective date banking days offset
record_created_date | smalldatetime (4) | NOT NULL | Date this record was created - used when automatically updating status to approved.
create_balanced_file_for_fund_checks | bit (1) | NOT NULL | Balanced file creation requested for fund checks.
process_via_intercept | bit (1) | NOT NULL | 1 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_KEY | int (4) | NOT NULL | Primary key to the table.
is_client_record | bit (1) | NOT NULL | Denotes this entry is for client access direct deposit (T) or firm direct deposit (F).
combine_like_company_batch | bit (1) | NOT NULL | Option to combine entry detail records under a single client batch header record where the client batch headers are identical.
prenote_effective_date | smalldatetime (4) |  | The effective date used when prenoting this allocation.
notes | nvarchar (480) | NOT NULL | Direct deposit processing notes when this allocation is prenoted.
add_crlf_to_end_of_file | bit (1) | NOT NULL | Flag 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_entry | bit (1) | NOT NULL | When true we will create a separate CCD batch for the balancing entry of a PPD transaction (assuming there is a balancing entry).

Primary key
Name | Columns | Description
PK_Client_Direct_Deposit | client_direct_deposit_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Direct_Deposit__Bank__immediate_destination__bank_KEY | immediate_destination__bank_KEY | Bank (bank_KEY) |
FK_Client_Direct_Deposit__Bank__originator__bank_KEY | originator__bank_KEY | Bank (bank_KEY) |
FK_Client_Direct_Deposit__Bank_Account_Direct_Deposit_Status__direct_deposit_status_KEY | direct_deposit_status_KEY | Bank_Account_Direct_Deposit_Status (bank_account_direct_deposit_status_KEY) |
FK_Client_Direct_Deposit__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Direct_Deposit_Fileheader__Client_Direct_Deposit__client_direct_deposit_KEY | client_direct_deposit_KEY | Direct_Deposit_Fileheader |