| Holds the distribution of payroll bank transaction worker compensation items across multiple work locations |
| payroll_bank_transaction_worker_compensation_item_distribution_KEY | int (4) | NOT NULL | Primary key for this table. |
| payroll_bank_transaction_worker_compensation_item_KEY | int (4) | NOT NULL | Key to payroll bank transaction worker compensation item table. |
| subject_amount | decimal (9, 2) | NOT NULL | Amount of gross pay subject to the worker comp calculation. |
| excluded_amount | decimal (9, 2) | NOT NULL | Amount of gross pay excluded from the worker comp calculation. |
| overtime_premium_amount | decimal (9, 2) | NOT NULL | Amount of overtime premium pay excluded from worker comp calculation. |
| ignored_amount | decimal (9, 2) | NOT NULL | Amount of gross pay ignored for worker comp calculation. |
| hours_worked | decimal (5, 4) | NOT NULL | Hours worked on this payroll check. |
| premium_amount_original | decimal (9, 2) | NOT NULL | Worker compensation premium. Either subject wages times percent or hours worked times hourly rate. |
| liability__gl_account_KEY | int (4) | NOT NULL | 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) | NOT NULL | Key to the gl_account for expense account to be used on liability checks. If null, the amount will be undistributed. |
| premium_amount_override | decimal (9, 2) | | Overridden amount. |
| premium_amount | decimal (9, 2) | NOT NULL | Premium amount of item, either premium_amount_override if not null otherwise premium_amount_original. The trigger is used to determine where to get the value from. |
| work_location_KEY | int (4) | NOT NULL | Reference to work location. |
| payroll_department_KEY | int (4) | | Reference to payroll department. |