Table: dbo.Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution
Holds the distribution of payroll bank transaction worker compensation items across multiple work locations
Columns
NameTypeConstraintsDescription
payroll_bank_transaction_worker_compensation_item_distribution_KEYint (4)NOT NULLPrimary key for this table.
payroll_bank_transaction_worker_compensation_item_KEYint (4)NOT NULLKey to payroll bank transaction worker compensation item table.
subject_amountdecimal (9, 2)NOT NULLAmount of gross pay subject to the worker comp calculation.
excluded_amountdecimal (9, 2)NOT NULLAmount of gross pay excluded from the worker comp calculation.
overtime_premium_amountdecimal (9, 2)NOT NULLAmount of overtime premium pay excluded from worker comp calculation.
ignored_amountdecimal (9, 2)NOT NULLAmount of gross pay ignored for worker comp calculation.
hours_workeddecimal (5, 4)NOT NULLHours worked on this payroll check.
premium_amount_originaldecimal (9, 2)NOT NULLWorker compensation premium. Either subject wages times percent or hours worked times hourly rate.
liability__gl_account_KEYint (4)NOT NULLKey to the gl_account for liability account to be used on liability checks. If null, the amount will be undistributed.
expense__gl_account_KEYint (4)NOT NULLKey to the gl_account for expense account to be used on liability checks. If null, the amount will be undistributed.
premium_amount_overridedecimal (9, 2)Overridden amount.
premium_amountdecimal (9, 2)NOT NULLPremium 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_KEYint (4)NOT NULLReference to work location.
payroll_department_KEYint (4)Reference to payroll department.
Primary key
NameColumnsDescription
PK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distributionpayroll_bank_transaction_worker_compensation_item_distribution_KEY
Unique constraints
NameColumnsDescription
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
NameColumnsReferenced tableDescription
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Bank_Transaction_Worker_Compensation_Item__payroll_bapayroll_bank_transaction_worker_compensation_item_KEYPayroll_Bank_Transaction_Worker_Compensation_Item (payroll_bank_transaction_worker_compensation_item_KEY)
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)

Schema diagram