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 |