Table: dbo.Employee_Worker_Compensation_Item
Columns
NameTypeConstraintsDescription
employee_worker_compensation_item_KEYint (4)NOT NULLunique key
employee_KEYint (4)NOT NULLemployee this state/class code worker comp info is for
worker_compensation_KEYint (4)NOT NULLclient worker compensation info this is for
is_exempt_from_worker_compensationbit (1)NOT NULLT/F: Is this employee exempt from worker compensation for this state/worker comp class code
Primary key
NameColumnsDescription
PK_Employee_Worker_Compensation_Itememployee_worker_compensation_item_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Worker_Compensation_Item$employee_KEY$worker_compensation_KEYemployee_KEY, worker_compensation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Worker_Compensation_Item__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEYworker_compensation_KEYWorker_Compensation (worker_compensation_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Worker_Compensation_Item_Distribution__Employee_Worker_Compensation_Item__employee_worker_compensation_item_KEYemployee_worker_compensation_item_KEYEmployee_Worker_Compensation_Item_Distribution

Schema diagram