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 |