| 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 | ||