Table: dbo.Employee_Payroll_Item_Direct_Deposit_Allocation
Holds direct deposit allocation data for an employee payroll item.
Columns
NameTypeConstraintsDescription
employee_payroll_item_direct_deposit_allocation_KEYint (4)NOT NULLPrimary key.
employee_payroll_item_KEYint (4)NOT NULLKey to related employee payroll item.
bank_KEYint (4)NOT NULLKey to allocation bank.
bank_account_numbernvarchar (34)NOT NULLAllocation bank account number
bank_account_type_KEYnvarchar (22)NOT NULLKey to bank account type.
direct_deposit_status_KEYnvarchar (40)NOT NULLKey to direct deposit status.
prenote_datesmalldatetime (4)The last date a prenote was created.
prenote_createdbit (1)NOT NULLFlag indicating that a prenote has been created for this allocation.
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_Payroll_Item_Direct_Deposit_Allocationemployee_payroll_item_direct_deposit_allocation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYBank (bank_KEY)
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Bank_Account_Type__bank_account_type_KEYbank_account_type_KEYBank_Account_Type (bank_account_type_KEY)
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Direct_Deposit_Status__direct_deposit_status_KEYdirect_deposit_status_KEYDirect_Deposit_Status (direct_deposit_status_KEY)
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)

Schema diagram