| 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 | ||