Table: dbo.Import_Template_Column_Employee_Data
This table stores info for employees excel import grid headers
Columns
Name | Type | Constraints | Description
import_template_column_employee_data_KEY | int (4) | NOT NULL | Primary key.
import_template_column_KEY | int (4) | NOT NULL | The foreign key to Import_Template_Column
contact_phone_type_KEY | int (4) |  | The foreign key to Contact_Phone_Type
client_payroll_item_KEY | int (4) |  | The foreign key to Client_Payroll_Item
spreadsheet_import_payroll_item_type_KEY | int (4) |  | The foreign key to Spreadsheet_Import_Payroll_Item_Type
client_benefit_KEY | int (4) |  | The foreign key to Client_Benefit
spreadsheet_import_accruable_benefit_type_KEY | int (4) |  | The foreign key to Spreadsheet_Import_Accruable_Benefit_Type
spreadsheet_import_direct_deposit_allocation_type_KEY | int (4) |  |
state_filing_status__ste_state_code_KEY | nvarchar (4) |  | The foreign key to Ste_State_Code
state_allowances__ste_state_code_KEY | nvarchar (4) |  | The foreign key to Ste_State_Code
ste_state_misc_parameter_usage_KEY | int (4) |  | The foreign key to STE_State_Misc_Parameter_Usage
client_tax_item_KEY | int (4) |  |
spreadsheet_import_tax_item_type_KEY | int (4) |  |
month_information_KEY | int (4) |  |

Primary key
Name | Columns | Description
PK_Import_Template_Column_Employee_Data | import_template_column_employee_data_KEY |
Unique constraints
Name | Columns | Description
UK_Import_Template_Column_Employee_Data$import_template_column_KEY | import_template_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Import_Template_Column_Employee_Data__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |
FK_Import_Template_Column_Employee_Data__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Import_Template_Column_Employee_Data__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
FK_Import_Template_Column_Employee_Data__Contact_Phone_Type__contact_phone_type_KEY | contact_phone_type_KEY | Contact_Phone_Type (contact_phone_type_KEY) |
FK_Import_Template_Column_Employee_Data__Import_Template_Column__import_template_column_KEY | import_template_column_KEY | Import_Template_Column (import_template_column_KEY) |
FK_Import_Template_Column_Employee_Data__Month_Information__month_information_KEY | month_information_KEY | Month_Information (month_information_KEY) |
FK_Import_Template_Column_Employee_Data__Spreadsheet_Import_Accruable_Benefit_Type__spreadsheet_import_accruable_benefit_type_KE | spreadsheet_import_accruable_benefit_type_KEY | Spreadsheet_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_al | spreadsheet_import_direct_deposit_allocation_type_KEY | Spreadsheet_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_KEY | spreadsheet_import_payroll_item_type_KEY | Spreadsheet_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_KEY | spreadsheet_import_tax_item_type_KEY | Spreadsheet_Import_Tax_Item_Type (spreadsheet_import_tax_item_type_KEY) |
FK_Import_Template_Column_Employee_Data__Ste_State_Code__state_allowances__ste_state_code_KEY | state_allowances__ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Import_Template_Column_Employee_Data__Ste_State_Code__state_filing_status__ste_state_code_KEY | state_filing_status__ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Import_Template_Column_Employee_Data__STE_State_Misc_Parameter_Usage__ste_state_misc_parameter_usage_KEY | ste_state_misc_parameter_usage_KEY | STE_State_Misc_Parameter_Usage (ste_state_misc_parameter_usage_KEY) |