Table: dbo.Spreadsheet_Import_Direct_Deposit_Allocation_Type
Table to identify the direct deposit allocation type used when importing employees
Columns
NameTypeConstraintsDescription
spreadsheet_import_direct_deposit_allocation_type_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (40)NOT NULLdirect deposit allocation item import type description
sequence_numberint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Direct_Deposit_Allocation_Typespreadsheet_import_direct_deposit_allocation_type_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Direct_Deposit_Allocation_Type$descriptiondescription
UK_Spreadsheet_Import_Direct_Deposit_Allocation_Type$sequence_numbersequence_number
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_Vendor_Data__Spreadsheet_Import_Direct_Deposit_Allocation_Type__direct_deposit_allocation_type_KEYdirect_deposit_allocation_type_KEYImport_Template_Column_Vendor_Data
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Direct_Deposit_Allocation_Type__spreadsheet_import_direct_deposit_alspreadsheet_import_direct_deposit_allocation_type_KEYImport_Template_Column_Employee_Data

Schema diagram