Table: dbo.Payroll_Check_Payroll_Item_Distribution
Columns
NameTypeConstraintsDescription
payroll_check_payroll_item_distribution_KEYint (4)NOT NULLPrimary key for the record.
work_location_KEYint (4)NOT NULLParent client work location record.
payroll_department_KEYint (4)Optional associated payroll department.
payroll_check_payroll_item_KEYint (4)NOT NULLParent payroll item
amount_originaldecimal (9, 2)NOT NULLAmount of item based on calculation rules.
percentagedecimal (5, 2)NOT NULLpercentage
rate_originaldecimal (9, 4)NOT NULLrate
salary_hourly_ratedecimal (5, 4)NOT NULLsalary_hourly_rate
reg_hoursdecimal (5, 4)NOT NULLreg_hours
ot_hoursdecimal (5, 4)NOT NULLot_hours
dt_hoursdecimal (5, 4)NOT NULLdt_hours
reg_amountdecimal (9, 2)NOT NULLreg_amount
ot_amountdecimal (9, 2)NOT NULLot_amount
dt_amountdecimal (9, 2)NOT NULLdt_amount
gl_ledgernvarchar (16)NOT NULLgl_ledger
is_primary_work_locationbit (1)NOT NULLTells whether or not this particular distribution's work location was marked as primary when the check was created.
pay_distribution_percentdecimal (5, 2)NOT NULLDescribes what percentage of pay is allocated to this particular distribution.
amount_overridedecimal (9, 2)Overridden amount
rate_overridedecimal (9, 4)Overridden rate
ot_ratedecimal (5, 4)NOT NULLrate used when calculating overtime pay related to this pay item distribution.
dt_ratedecimal (5, 4)NOT NULLrate used when calculating double time pay related to this pay item distribution.
liability__gl_account_KEYint (4)Key to the gl_account table for the liability account.
expense__gl_account_KEYint (4)Key to the gl_account table for the expense account.
amountdecimal (9, 2)NOT NULLDisplay amount that is based on an existing override to this field. Will display the initially calculated amount if no override is present.
ratedecimal (9, 4)NOT NULLDisplay rate that is based on an existing override to this field. Will display the initially calculated rate if no override is present.
Primary key
NameColumnsDescription
PK_Payroll_Check_Payroll_Item_Distributionpayroll_check_payroll_item_distribution_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Payroll_Item_Distribution$payroll_check_payroll_item_KEY$work_location_KEY$payroll_department_KEYpayroll_check_payroll_item_KEY, work_location_KEY, payroll_department_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Payroll_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Payroll_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Payroll_Item_Distribution__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEYpayroll_check_payroll_item_KEYPayroll_Check_Payroll_Item (payroll_check_payroll_item_KEY)
FK_Payroll_Check_Payroll_Item_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Payroll_Check_Payroll_Item_Distribution__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_ppayroll_check_payroll_item_distribution_KEYPayroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail
FK_Benefit_Transaction__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_item_distribution_KEYpayroll_check_payroll_item_distribution_KEYBenefit_Transaction
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_payroll_check_payroll_item_distribution_KEYPayroll_Check_Payroll_Item_Distribution_Child_Support_Detail
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_itpayroll_check_payroll_item_distribution_KEYPayroll_Check_Payroll_Item_Distribution_Garnishment_Detail

Schema diagram