Table: dbo.Employee_Other_State_Setting_Type
Columns
NameTypeConstraintsDescription
employee_other_state_setting_type_KEYint (4)NOT NULLThe primary key for this table.
ste_state_code_KEYnvarchar (4)NOT NULLThe code for the state this setting applies to.
employee_other_state_setting_type_group_KEYint (4)NOT NULLThis is used to group the type of setting.
descriptionnvarchar (160)NOT NULLThe description of the setting.
codenvarchar (2)NOT NULLThe code for the setting to display in dropdowns if desired.
is_standardbit (1)NOT NULLFlag that denotes which items are standard and need to be generated when the employee initially links to the related tax jurisdiction.
Primary key
NameColumnsDescription
PK_Employee_Other_State_Setting_Typeemployee_other_state_setting_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Other_State_Setting_Type__Employee_Other_State_Setting_Type_Group__employee_other_state_setting_type_group_KEYemployee_other_state_setting_type_group_KEYEmployee_Other_State_Setting_Type_Group (employee_other_state_setting_type_group_KEY)
FK_Employee_Other_State_Setting_Type__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_exemption_code__employee_otca_exemption_code__employee_other_state_setting_type_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__ca_wage_plan_code__employee_otca_wage_plan_code__employee_other_state_setting_type_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__nj_plan_type__employee_other_snj_plan_type__employee_other_state_setting_type_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Employee_Other_State_Setting_Type__wy_employee_coverage_type__empwy_employee_coverage_type__employee_other_state_setting_type_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Employee_Other_State_Setting__Employee_Other_State_Setting_Type__employee_other_state_setting_type_KEYemployee_other_state_setting_type_KEYEmployee_Other_State_Setting

Schema diagram