Table: dbo.Employee_Direct_Deposit_Allocation
Columns
NameTypeConstraintsDescription
employee_direct_deposit_allocation_KEYint (4)NOT NULLPrimary key for the Employee_Direct_Deposit_Allocation table.
processing_orderint (4)NOT NULLOrder in which allocations are processed
employee_KEYint (4)NOT NULLEmployee allocations are for
bank_KEYint (4)NOT NULLEmployee bank
bank_account_numbernvarchar (34)NOT NULLEmployee bank account number
bank_account_type_KEYnvarchar (22)NOT NULLEmployee bank account type
allocation_amountdecimal (9, 2)Allocation amount
allocation_percentdecimal (5, 2)Allocation percent
direct_deposit_status_KEYnvarchar (40)NOT NULLStatus of employee account
alternate_allocationbit (1)NOT NULLThis is an alternate allocation
prenote_datesmalldatetime (4)Date employee account was prenoted
prenote_createdbit (1)NOT NULLFlag indicating that a prenote file have been created for this entry
employee_direct_deposit_allocation_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
use_international_formatbit (1)NOT NULLThis allocation requires international ACH formatting.
us_gateway_operator__bank_KEYint (4)Key to bank acting as US gateway operator.
destination__country_code_KEYint (4)Key to destination country code.
prenote_effective_datesmalldatetime (4)The effective date used when prenoting this allocation.
notesnvarchar (480)NOT NULLDirect deposit processing notes when this allocation is prenoted.
Primary key
NameColumnsDescription
PK_Employee_Direct_Deposit_Allocationemployee_direct_deposit_allocation_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Direct_Deposit_Allocation$employee_direct_deposit_allocation_guidemployee_direct_deposit_allocation_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYBank (bank_KEY)
FK_Employee_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYBank (bank_KEY)
FK_Employee_Direct_Deposit_Allocation__Bank_Account_Type__bank_account_type_KEYbank_account_type_KEYBank_Account_Type (bank_account_type_KEY)
FK_Employee_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYCountry_Code (country_code_KEY)
FK_Employee_Direct_Deposit_Allocation__Direct_Deposit_Status__direct_deposit_status_KEYdirect_deposit_status_KEYDirect_Deposit_Status (direct_deposit_status_KEY)
FK_Employee_Direct_Deposit_Allocation__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram