Table: dbo.Worker_Compensation_Class_Code_Detail
Columns
NameTypeConstraintsDescription
worker_compensation_class_code_detail_KEYint (4)NOT NULLunique key
worker_compensation_class_code_KEYint (4)NOT NULLworker comp class code key this state relates to
ste_state_code_KEYnvarchar (4)NOT NULLstate that uses this worker comp class code
is_activebit (1)NOT NULLBoolean value used to indicate if this code for this state is still available to be selected by a client
is_user_enteredbit (1)NOT NULLIndicates 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
NameColumnsDescription
PK_Worker_Compensation_Class_Code_Detailworker_compensation_class_code_detail_KEY
Unique constraints
NameColumnsDescription
UK_Worker_Compensation_Class_Code_Detail$worker_compensation_class_code_KEY$ste_state_code_KEYworker_compensation_class_code_KEY, ste_state_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Worker_Compensation_Class_Code_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Worker_Compensation_Class_Code_Detail__Worker_Compensation_Class_Code__worker_compensation_class_code_KEYworker_compensation_class_code_KEYWorker_Compensation_Class_Code (worker_compensation_class_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Worker_Compensation_Limit__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYWorker_Compensation_Limit
FK_Insurepay_Client_Class_Code__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYInsurepay_Client_Class_Code
FK_Client_Payroll_Item__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYClient_Payroll_Item
FK_Worker_Compensation__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYWorker_Compensation

Schema diagram