Table: dbo.Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution
Holds the distribution of payroll bank transaction worker compensation items across multiple work locations
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution | payroll_bank_transaction_worker_compensation_item_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution$payroll_bank_transaction_worker_compensation_item_KEY$payroll_ | payroll_bank_transaction_worker_compensation_item_KEY, payroll_department_KEY, work_location_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Bank_Transaction_Worker_Compensation_Item__payroll_ba | payroll_bank_transaction_worker_compensation_item_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item (payroll_bank_transaction_worker_compensation_item_KEY) |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Work_Location__work_location_KEY | work_location_KEY | Work_Location (work_location_KEY) |