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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Bank (bank_KEY) |
FK_Employee_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEY | us_gateway_operator__bank_KEY | Bank (bank_KEY) |
FK_Employee_Direct_Deposit_Allocation__Bank_Account_Type__bank_account_type_KEY | bank_account_type_KEY | Bank_Account_Type (bank_account_type_KEY) |
FK_Employee_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEY | destination__country_code_KEY | Country_Code (country_code_KEY) |
FK_Employee_Direct_Deposit_Allocation__Direct_Deposit_Status__direct_deposit_status_KEY | direct_deposit_status_KEY | Direct_Deposit_Status (direct_deposit_status_KEY) |
FK_Employee_Direct_Deposit_Allocation__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |