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 |