Table: dbo.Pay_Item
Client payroll item properties applicable only to a pay payroll item.
Columns
Name | Type | Constraints | Description
client_payroll_item_KEY | int (4) | NOT NULL | Primary key.
is_w2_allocated_tips | bit (1) | NOT NULL | Indicates that payroll item amount should display in the W-2 allocated tips box.
is_w2_third_party_sick_pay | bit (1) | NOT NULL | Used by W-2 processing to know when to mark the W-2 third-party sick pay box.
is_california_bonus | bit (1) | NOT NULL | A flag that affects tax calculations when we calculate a payroll check.
w2_kentucky_tax_credit_type_KEY | int (4) |  | Flags the pay item for Kentucky W-2 processing.
insurepay_pay_item_type_KEY | int (4) |  | A Foreign key for this table. The associated Insurepay_Pay_Item_Type primary key.
xactpay_pay_item_type_KEY | int (4) |  | A Foreign key for this table.The associated XactPay_Pay_Item_Type primary key.
ot_rate | decimal (5, 4) | NOT NULL | Default rate used when calculating overtime pay related to this pay item.
dt_rate | decimal (5, 4) | NOT NULL | Default rate used when calculating double time pay related to this pay item.
is_excluded_from_weighted_average_overtime | bit (1) | NOT NULL | Indicates if we should exclude this pay item from the weighted average overtime calculation.
is_overtime_pay_item | bit (1) | NOT NULL | When 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_overtime | bit (1) | NOT NULL | Indicates how weighted average overtime should be calculated. 0 means calculate with all hours, 1 means calculate with non-overtime hours

Primary key
Name | Columns | Description
PK_Pay_Item$client_payroll_item_KEY | client_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Pay_Item__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Pay_Item__Insurepay_Pay_Item_Type__insurepay_pay_item_type_KEY | insurepay_pay_item_type_KEY | Insurepay_Pay_Item_Type (insurepay_pay_item_type_KEY) |
FK_Pay_Item__W2_Kentucky_Tax_Credit_Type__w2_kentucky_tax_credit_type_KEY | w2_kentucky_tax_credit_type_KEY | W2_Kentucky_Tax_Credit_Type (w2_kentucky_tax_credit_type_KEY) |
FK_Pay_Item__XactPay_Pay_Item_Type__xactpay_pay_item_type_KEY | xactpay_pay_item_type_KEY | XactPay_Pay_Item_Type (xactpay_pay_item_type_KEY) |