Table: dbo.Employee_Other_State_Setting
Columns
NameTypeConstraintsDescription
employee_other_state_setting_KEYint (4)NOT NULLThe primary key for this table.
employee_KEYint (4)NOT NULLThe employee linked to this setting.
employee_other_state_setting_type_KEYint (4)NOT NULLThis key indicates the type of settings.
occupational_titlenvarchar (100)NOT NULLThe occupational title.
geographic_locationnvarchar (4)NOT NULLThe Geographic Location.
soc_codenvarchar (14)NOT NULLThis column holds Standard Occupation Classification (SOC) code for Indiana, Washington, South Carolina and North Carolina states. For these states it will be six digit soc_code or empty if not specified and for other states this will be empty.
Primary key
NameColumnsDescription
PK_Employee_Other_State_Settingemployee_other_state_setting_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Other_State_Setting__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Other_State_Setting__Employee_Other_State_Setting_Type__employee_other_state_setting_type_KEYemployee_other_state_setting_type_KEYEmployee_Other_State_Setting_Type (employee_other_state_setting_type_KEY)

Schema diagram