Table: dbo.Employee_Worker_Compensation_Item_Distribution
Holds the distribution of employee worker compensation items across multiple work locations
Columns
Name | Type | Constraints | Description
employee_worker_compensation_item_distribution_KEY | int (4) | NOT NULL | Primary key for this table.
employee_worker_compensation_item_KEY | int (4) | NOT NULL | Key to employee worker compensation item table.
employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Key to employee work location payroll department table.
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.
is_active | bit (1) | NOT NULL | Indicator of whether this distribution is marked as active

Primary key
Name | Columns | Description
PK_Employee_Worker_Compensation_Item_Distribution | employee_worker_compensation_item_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Worker_Compensation_Item_Distribution$employee_worker_compensation_item_KEY$employee_work_location_payroll_departmen | employee_worker_compensation_item_KEY, employee_work_location_payroll_department_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Worker_Compensation_Item_Distribution__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_dep | employee_work_location_payroll_department_KEY | Employee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY) |
FK_Employee_Worker_Compensation_Item_Distribution__Employee_Worker_Compensation_Item__employee_worker_compensation_item_KEY | employee_worker_compensation_item_KEY | Employee_Worker_Compensation_Item (employee_worker_compensation_item_KEY) |
FK_Employee_Worker_Compensation_Item_Distribution__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Employee_Worker_Compensation_Item_Distribution__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |