Table: dbo.Spreadsheet_Import_Payroll_Item_Type
Table to identify the pay item type used when importing employees
Columns
NameTypeConstraintsDescription
spreadsheet_import_payroll_item_type_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (40)NOT NULLPay item import type description
sequence_numberint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Payroll_Item_Typespreadsheet_import_payroll_item_type_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Payroll_Item_Type$descriptiondescription
UK_Spreadsheet_Import_Payroll_Item_Type$sequence_numbersequence_number
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Payroll_Item_Type__spreadsheet_import_payroll_item_type_KEYspreadsheet_import_payroll_item_type_KEYImport_Template_Column_Employee_Data

Schema diagram