Table: dbo.Spreadsheet_Import_Deduction_Item_Type
Table to identify the deduction item type used when importing employees
Columns
NameTypeConstraintsDescription
spreadsheet_import_deduction_item_type_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (40)NOT NULLDeduction item import type description
sequence_numberint (4)NOT NULLsequence number for a deduction type
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Deduction_Item_Typespreadsheet_import_deduction_item_type_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Deduction_Item_Type$descriptiondescription
UK_Spreadsheet_Import_Deduction_Item_Type$sequence_numbersequence_number

Schema diagram