Table: dbo.Import_Template_Column_Employee_Data
This table stores info for employees excel import grid headers
Columns
NameTypeConstraintsDescription
import_template_column_employee_data_KEYint (4)NOT NULLPrimary key.
import_template_column_KEYint (4)NOT NULLThe foreign key to Import_Template_Column
contact_phone_type_KEYint (4)The foreign key to Contact_Phone_Type
client_payroll_item_KEYint (4)The foreign key to Client_Payroll_Item
spreadsheet_import_payroll_item_type_KEYint (4)The foreign key to Spreadsheet_Import_Payroll_Item_Type
client_benefit_KEYint (4)The foreign key to Client_Benefit
spreadsheet_import_accruable_benefit_type_KEYint (4)The foreign key to Spreadsheet_Import_Accruable_Benefit_Type
spreadsheet_import_direct_deposit_allocation_type_KEYint (4)
state_filing_status__ste_state_code_KEYnvarchar (4)The foreign key to Ste_State_Code
state_allowances__ste_state_code_KEYnvarchar (4)The foreign key to Ste_State_Code
ste_state_misc_parameter_usage_KEYint (4)The foreign key to STE_State_Misc_Parameter_Usage
client_tax_item_KEYint (4)
spreadsheet_import_tax_item_type_KEYint (4)
month_information_KEYint (4)
Primary key
NameColumnsDescription
PK_Import_Template_Column_Employee_Dataimport_template_column_employee_data_KEY
Unique constraints
NameColumnsDescription
UK_Import_Template_Column_Employee_Data$import_template_column_KEYimport_template_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Import_Template_Column_Employee_Data__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_Import_Template_Column_Employee_Data__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Import_Template_Column_Employee_Data__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)
FK_Import_Template_Column_Employee_Data__Contact_Phone_Type__contact_phone_type_KEYcontact_phone_type_KEYContact_Phone_Type (contact_phone_type_KEY)
FK_Import_Template_Column_Employee_Data__Import_Template_Column__import_template_column_KEYimport_template_column_KEYImport_Template_Column (import_template_column_KEY)
FK_Import_Template_Column_Employee_Data__Month_Information__month_information_KEYmonth_information_KEYMonth_Information (month_information_KEY)
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Accruable_Benefit_Type__spreadsheet_import_accruable_benefit_type_KEspreadsheet_import_accruable_benefit_type_KEYSpreadsheet_Import_Accruable_Benefit_Type (spreadsheet_import_accruable_benefit_type_KEY)
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Direct_Deposit_Allocation_Type__spreadsheet_import_direct_deposit_alspreadsheet_import_direct_deposit_allocation_type_KEYSpreadsheet_Import_Direct_Deposit_Allocation_Type (spreadsheet_import_direct_deposit_allocation_type_KEY)
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Payroll_Item_Type__spreadsheet_import_payroll_item_type_KEYspreadsheet_import_payroll_item_type_KEYSpreadsheet_Import_Payroll_Item_Type (spreadsheet_import_payroll_item_type_KEY)
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Tax_Item_Type__spreadsheet_import_tax_item_type_KEYspreadsheet_import_tax_item_type_KEYSpreadsheet_Import_Tax_Item_Type (spreadsheet_import_tax_item_type_KEY)
FK_Import_Template_Column_Employee_Data__Ste_State_Code__state_allowances__ste_state_code_KEYstate_allowances__ste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Import_Template_Column_Employee_Data__Ste_State_Code__state_filing_status__ste_state_code_KEYstate_filing_status__ste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Import_Template_Column_Employee_Data__STE_State_Misc_Parameter_Usage__ste_state_misc_parameter_usage_KEYste_state_misc_parameter_usage_KEYSTE_State_Misc_Parameter_Usage (ste_state_misc_parameter_usage_KEY)

Schema diagram