Table: dbo.Worker_Compensation
Columns
Name | Type | Constraints | Description
worker_compensation_KEY | int (4) | NOT NULL |
client_KEY | int (4) | NOT NULL | Link to a particular client
vendor_KEY | int (4) |  | link to non-tax vendor agent for agent liabilities
worker_compensation_class_code_detail_KEY | int (4) | NOT NULL | link to the sate's worker comp class code
is_primary_code | bit (1) | NOT NULL | T/F: Is this the primary code for this state for this client
is_inactive | bit (1) | NOT NULL | T/F: Is this code for this state inactive
liability__gl_account_KEY | int (4) |  | Key to the gl_account for liability account to be used on liability checks. If null, the amount will be undistributed.
expense__gl_account_KEY | int (4) |  | Key to the gl_account for expense account to be used on liability checks. If null, the amount will be undistributed.

Primary key
Name | Columns | Description
PK_Worker_Compensation | worker_compensation_KEY |
Unique constraints
Name | Columns | Description
UK_Worker_Compensation$client_KEY$vendor_KEY$worker_compensation_class_code_detail_KEY | client_KEY, vendor_KEY, worker_compensation_class_code_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Worker_Compensation__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Worker_Compensation__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Worker_Compensation__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Worker_Compensation__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Worker_Compensation__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEY | worker_compensation_class_code_detail_KEY | Worker_Compensation_Class_Code_Detail (worker_compensation_class_code_detail_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Worker_Compensation_Rate__Worker_Compensation__worker_compensation_KEY | worker_compensation_KEY | Worker_Compensation_Rate |
FK_Employee_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEY | worker_compensation_KEY | Employee_Worker_Compensation_Item |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEY | worker_compensation_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item |