Table: dbo.Payroll_Check_Payroll_Item
Columns
NameTypeConstraintsDescription
payroll_check_payroll_item_KEYint (4)NOT NULLKey of the payroll check payroll item
bank_transaction_KEYint (4)NOT NULLKey of parent payroll check
employee_payroll_item_KEYint (4)Key of parent employee payroll item
client_payroll_item_KEYint (4)NOT NULLKey of parent client payroll item
descriptionnvarchar (60)NOT NULLDescription of Payroll_Check_Payroll_Item record.
payroll_item_calculation_type_KEYint (4)NOT NULLCalculation type.
is_hours_sensitivebit (1)Indicates if item is hours-sensitive
is_excluded_from_gross_pay_amountbit (1)Indicates if item amount is excluded from gross pay
is_excluded_net_paybit (1)Indicates if item is excluded from net pay
vendor_KEYint (4)Associated vendor for payroll payable generation. In the case of Child Support and Creditor Garnishment a null vendor key is used as there may be multiple vendors.
liability__gl_account_KEYint (4)Key to the gl_account table for liability account.
expense__gl_account_KEYint (4)Key to the gl_account table for expense account.
is_exclude_premium_wagesbit (1)Indicates that the payroll item should calculate assuming 1.0 as both the OT and DT multipliers when excluding wages.
is_excluded_from_gross_pay_hoursbit (1)NOT NULLIndicates if item hours are excluded from gross pay
Primary key
NameColumnsDescription
PK_Payroll_Check_Payroll_Itempayroll_check_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Payroll_Item__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Payroll_Check_Payroll_Item__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Payroll_Check_Payroll_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Payroll_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Payroll_Item__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)
FK_Payroll_Check_Payroll_Item__Payroll_Item_Calculation_Type__payroll_item_calculation_type_KEYpayroll_item_calculation_type_KEYPayroll_Item_Calculation_Type (payroll_item_calculation_type_KEY)
FK_Payroll_Check_Payroll_Item__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEYpayroll_check_payroll_item_KEYShortfall_Transaction_N_Payroll_Check_Payroll_Item
FK_Payroll_Check_Payroll_Item_Distribution__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEYpayroll_check_payroll_item_KEYPayroll_Check_Payroll_Item_Distribution
FK_Payable_Transaction_N_Payroll_Check_Payroll_Item__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEYpayroll_check_payroll_item_KEYPayable_Transaction_N_Payroll_Check_Payroll_Item

Schema diagram