Table: dbo.Pay_Item
Client payroll item properties applicable only to a pay payroll item.
Columns
NameTypeConstraintsDescription
client_payroll_item_KEYint (4)NOT NULLPrimary key.
is_w2_allocated_tipsbit (1)NOT NULLIndicates that payroll item amount should display in the W-2 allocated tips box.
is_w2_third_party_sick_paybit (1)NOT NULLUsed by W-2 processing to know when to mark the W-2 third-party sick pay box.
is_california_bonusbit (1)NOT NULLA flag that affects tax calculations when we calculate a payroll check.
w2_kentucky_tax_credit_type_KEYint (4)Flags the pay item for Kentucky W-2 processing.
insurepay_pay_item_type_KEYint (4)A Foreign key for this table. The associated Insurepay_Pay_Item_Type primary key.
xactpay_pay_item_type_KEYint (4)A Foreign key for this table.The associated XactPay_Pay_Item_Type primary key.
ot_ratedecimal (5, 4)NOT NULLDefault rate used when calculating overtime pay related to this pay item.
dt_ratedecimal (5, 4)NOT NULLDefault rate used when calculating double time pay related to this pay item.
is_excluded_from_weighted_average_overtimebit (1)NOT NULLIndicates if we should exclude this pay item from the weighted average overtime calculation.
is_overtime_pay_itembit (1)NOT NULLWhen set true for a pay item, amounts entered in the regular hours column will be calculated as overtime wages when figuring the workers compensation wage amounts and premiums. This is needed because many users set up overtime pay as separate pay to record overtime amounts rather than using the overtime pay column on the main pay item.
is_california_weighted_average_overtimebit (1)NOT NULLIndicates how weighted average overtime should be calculated. 0 means calculate with all hours, 1 means calculate with non-overtime hours
Primary key
NameColumnsDescription
PK_Pay_Item$client_payroll_item_KEYclient_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Pay_Item__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Pay_Item__Insurepay_Pay_Item_Type__insurepay_pay_item_type_KEYinsurepay_pay_item_type_KEYInsurepay_Pay_Item_Type (insurepay_pay_item_type_KEY)
FK_Pay_Item__W2_Kentucky_Tax_Credit_Type__w2_kentucky_tax_credit_type_KEYw2_kentucky_tax_credit_type_KEYW2_Kentucky_Tax_Credit_Type (w2_kentucky_tax_credit_type_KEY)
FK_Pay_Item__XactPay_Pay_Item_Type__xactpay_pay_item_type_KEYxactpay_pay_item_type_KEYXactPay_Pay_Item_Type (xactpay_pay_item_type_KEY)

Schema diagram