Table: dbo.Worker_Compensation_Class_Code_Detail
Columns
Name | Type | Constraints | Description
worker_compensation_class_code_detail_KEY | int (4) | NOT NULL | unique key
worker_compensation_class_code_KEY | int (4) | NOT NULL | worker comp class code key this state relates to
ste_state_code_KEY | nvarchar (4) | NOT NULL | state that uses this worker comp class code
is_active | bit (1) | NOT NULL | Boolean value used to indicate if this code for this state is still available to be selected by a client
is_user_entered | bit (1) | NOT NULL | Indicates if this state worker compensation class code was entered by the user. Normally this table is written to in a separate update process but now the user can enter codes for a state. The new column differentiates these.

Primary key
Name | Columns | Description
PK_Worker_Compensation_Class_Code_Detail | worker_compensation_class_code_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Worker_Compensation_Class_Code_Detail$worker_compensation_class_code_KEY$ste_state_code_KEY | worker_compensation_class_code_KEY, ste_state_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Worker_Compensation_Class_Code_Detail__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Worker_Compensation_Class_Code_Detail__Worker_Compensation_Class_Code__worker_compensation_class_code_KEY | worker_compensation_class_code_KEY | Worker_Compensation_Class_Code (worker_compensation_class_code_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Worker_Compensation_Limit__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEY | worker_compensation_class_code_detail_KEY | Worker_Compensation_Limit |
FK_Insurepay_Client_Class_Code__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEY | worker_compensation_class_code_detail_KEY | Insurepay_Client_Class_Code |
FK_Client_Payroll_Item__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEY | worker_compensation_class_code_detail_KEY | Client_Payroll_Item |
FK_Worker_Compensation__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEY | worker_compensation_class_code_detail_KEY | Worker_Compensation |