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