| Table: dbo.Employee_Direct_Deposit_Allocation | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_direct_deposit_allocation_KEY | int (4) | NOT NULL | Primary key for the Employee_Direct_Deposit_Allocation table. |
| processing_order | int (4) | NOT NULL | Order in which allocations are processed |
| employee_KEY | int (4) | NOT NULL | Employee allocations are for |
| bank_KEY | int (4) | NOT NULL | Employee bank |
| bank_account_number | nvarchar (34) | NOT NULL | Employee bank account number |
| bank_account_type_KEY | nvarchar (22) | NOT NULL | Employee bank account type |
| allocation_amount | decimal (9, 2) | Allocation amount | |
| allocation_percent | decimal (5, 2) | Allocation percent | |
| direct_deposit_status_KEY | nvarchar (40) | NOT NULL | Status of employee account |
| alternate_allocation | bit (1) | NOT NULL | This is an alternate allocation |
| prenote_date | smalldatetime (4) | Date employee account was prenoted | |
| prenote_created | bit (1) | NOT NULL | Flag indicating that a prenote file have been created for this entry |
| employee_direct_deposit_allocation_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
| use_international_format | bit (1) | NOT NULL | This allocation requires international ACH formatting. |
| us_gateway_operator__bank_KEY | int (4) | Key to bank acting as US gateway operator. | |
| destination__country_code_KEY | int (4) | Key to destination country code. | |
| 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_Direct_Deposit_Allocation | employee_direct_deposit_allocation_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_Direct_Deposit_Allocation$employee_direct_deposit_allocation_guid | employee_direct_deposit_allocation_guid | ||