Table: dbo.Employee_Payroll_Item_Direct_Deposit_Allocation
Holds direct deposit allocation data for an employee payroll item.
Columns
Name | Type | Constraints | Description
employee_payroll_item_direct_deposit_allocation_KEY | int (4) | NOT NULL | Primary key.
employee_payroll_item_KEY | int (4) | NOT NULL | Key to related employee payroll item.
bank_KEY | int (4) | NOT NULL | Key to allocation bank.
bank_account_number | nvarchar (34) | NOT NULL | Allocation bank account number
bank_account_type_KEY | nvarchar (22) | NOT NULL | Key to bank account type.
direct_deposit_status_KEY | nvarchar (40) | NOT NULL | Key to direct deposit status.
prenote_date | smalldatetime (4) |  | The last date a prenote was created.
prenote_created | bit (1) | NOT NULL | Flag indicating that a prenote has been created for this allocation.
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.

Primary key
Name | Columns | Description
PK_Employee_Payroll_Item_Direct_Deposit_Allocation | employee_payroll_item_direct_deposit_allocation_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Bank (bank_KEY) |
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Bank_Account_Type__bank_account_type_KEY | bank_account_type_KEY | Bank_Account_Type (bank_account_type_KEY) |
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Direct_Deposit_Status__direct_deposit_status_KEY | direct_deposit_status_KEY | Direct_Deposit_Status (direct_deposit_status_KEY) |
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |