Table: dbo.Employee_Worker_Compensation_Item_Distribution
Holds the distribution of employee worker compensation items across multiple work locations
Columns
NameTypeConstraintsDescription
employee_worker_compensation_item_distribution_KEYint (4)NOT NULLPrimary key for this table.
employee_worker_compensation_item_KEYint (4)NOT NULLKey to employee worker compensation item table.
employee_work_location_payroll_department_KEYint (4)NOT NULLKey to employee work location payroll department table.
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.
is_activebit (1)NOT NULLIndicator of whether this distribution is marked as active
Primary key
NameColumnsDescription
PK_Employee_Worker_Compensation_Item_Distributionemployee_worker_compensation_item_distribution_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Worker_Compensation_Item_Distribution$employee_worker_compensation_item_KEY$employee_work_location_payroll_departmenemployee_worker_compensation_item_KEY, employee_work_location_payroll_department_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Worker_Compensation_Item_Distribution__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_depemployee_work_location_payroll_department_KEYEmployee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY)
FK_Employee_Worker_Compensation_Item_Distribution__Employee_Worker_Compensation_Item__employee_worker_compensation_item_KEYemployee_worker_compensation_item_KEYEmployee_Worker_Compensation_Item (employee_worker_compensation_item_KEY)
FK_Employee_Worker_Compensation_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Employee_Worker_Compensation_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)

Schema diagram