Table: dbo.Employee_Other_State_Setting_Type
Columns
Name | Type | Constraints | Description
employee_other_state_setting_type_KEY | int (4) | NOT NULL | The primary key for this table.
ste_state_code_KEY | nvarchar (4) | NOT NULL | The code for the state this setting applies to.
employee_other_state_setting_type_group_KEY | int (4) | NOT NULL | This is used to group the type of setting.
description | nvarchar (160) | NOT NULL | The description of the setting.
code | nvarchar (2) | NOT NULL | The code for the setting to display in dropdowns if desired.
is_standard | bit (1) | NOT NULL | Flag that denotes which items are standard and need to be generated when the employee initially links to the related tax jurisdiction.

Primary key
Name | Columns | Description
PK_Employee_Other_State_Setting_Type | employee_other_state_setting_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Other_State_Setting_Type__Employee_Other_State_Setting_Type_Group__employee_other_state_setting_type_group_KEY | employee_other_state_setting_type_group_KEY | Employee_Other_State_Setting_Type_Group (employee_other_state_setting_type_group_KEY) |
FK_Employee_Other_State_Setting_Type__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_exemption_code__employee_ot | ca_exemption_code__employee_other_state_setting_type_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_wage_plan_code__employee_ot | ca_wage_plan_code__employee_other_state_setting_type_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__nj_plan_type__employee_other_s | nj_plan_type__employee_other_state_setting_type_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__wy_employee_coverage_type__emp | wy_employee_coverage_type__employee_other_state_setting_type_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Employee_Other_State_Setting__Employee_Other_State_Setting_Type__employee_other_state_setting_type_KEY | employee_other_state_setting_type_KEY | Employee_Other_State_Setting |