Table: dbo.Spreadsheet_Import_Accruable_Benefit_Type
Table to identify the accruable benefit type used when importing employees
Columns
NameTypeConstraintsDescription
spreadsheet_import_accruable_benefit_type_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (40)NOT NULLaccruable benefit item import type description
sequence_numberint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Spreadsheet_Import_Accruable_Benefit_Typespreadsheet_import_accruable_benefit_type_KEY
Unique constraints
NameColumnsDescription
UK_Spreadsheet_Import_Accruable_Benefit_Type$descriptiondescription
UK_Spreadsheet_Import_Accruable_Benefit_Type$sequence_numbersequence_number
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Accruable_Benefit_Type__spreadsheet_import_accruable_benefit_type_KEspreadsheet_import_accruable_benefit_type_KEYImport_Template_Column_Employee_Data

Schema diagram