Table: dbo.Employee_Other_State_Setting
Columns
Name | Type | Constraints | Description
employee_other_state_setting_KEY | int (4) | NOT NULL | The primary key for this table.
employee_KEY | int (4) | NOT NULL | The employee linked to this setting.
employee_other_state_setting_type_KEY | int (4) | NOT NULL | This key indicates the type of settings.
occupational_title | nvarchar (100) | NOT NULL | The occupational title.
geographic_location | nvarchar (4) | NOT NULL | The Geographic Location.
soc_code | nvarchar (14) | NOT NULL | This 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
Name | Columns | Description
PK_Employee_Other_State_Setting | employee_other_state_setting_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Other_State_Setting__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
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_Type (employee_other_state_setting_type_KEY) |