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. |