Table: dbo.Worker_Compensation
Columns
NameTypeConstraintsDescription
worker_compensation_KEYint (4)NOT NULL
client_KEYint (4)NOT NULLLink to a particular client
vendor_KEYint (4)link to non-tax vendor agent for agent liabilities
worker_compensation_class_code_detail_KEYint (4)NOT NULLlink to the sate's worker comp class code
is_primary_codebit (1)NOT NULLT/F: Is this the primary code for this state for this client
is_inactivebit (1)NOT NULLT/F: Is this code for this state inactive
liability__gl_account_KEYint (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_KEYint (4)Key to the gl_account for expense account to be used on liability checks. If null, the amount will be undistributed.
Primary key
NameColumnsDescription
PK_Worker_Compensationworker_compensation_KEY
Unique constraints
NameColumnsDescription
UK_Worker_Compensation$client_KEY$vendor_KEY$worker_compensation_class_code_detail_KEYclient_KEY, vendor_KEY, worker_compensation_class_code_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Worker_Compensation__Client__client_KEYclient_KEYClient (client_KEY)
FK_Worker_Compensation__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Worker_Compensation__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Worker_Compensation__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Worker_Compensation__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYWorker_Compensation_Class_Code_Detail (worker_compensation_class_code_detail_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Worker_Compensation_Rate__Worker_Compensation__worker_compensation_KEYworker_compensation_KEYWorker_Compensation_Rate
FK_Employee_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEYworker_compensation_KEYEmployee_Worker_Compensation_Item
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEYworker_compensation_KEYPayroll_Bank_Transaction_Worker_Compensation_Item

Schema diagram