Table: dbo.Payroll_Check_Payroll_Item
Columns
Name | Type | Constraints | Description
payroll_check_payroll_item_KEY | int (4) | NOT NULL | Key of the payroll check payroll item
bank_transaction_KEY | int (4) | NOT NULL | Key of parent payroll check
employee_payroll_item_KEY | int (4) |  | Key of parent employee payroll item
client_payroll_item_KEY | int (4) | NOT NULL | Key of parent client payroll item
description | nvarchar (60) | NOT NULL | Description of Payroll_Check_Payroll_Item record.
payroll_item_calculation_type_KEY | int (4) | NOT NULL | Calculation type.
is_hours_sensitive | bit (1) |  | Indicates if item is hours-sensitive
is_excluded_from_gross_pay_amount | bit (1) |  | Indicates if item amount is excluded from gross pay
is_excluded_net_pay | bit (1) |  | Indicates if item is excluded from net pay
vendor_KEY | int (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_KEY | int (4) |  | Key to the gl_account table for liability account.
expense__gl_account_KEY | int (4) |  | Key to the gl_account table for expense account.
is_exclude_premium_wages | bit (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_hours | bit (1) | NOT NULL | Indicates if item hours are excluded from gross pay

Primary key
Name | Columns | Description
PK_Payroll_Check_Payroll_Item | payroll_check_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Payroll_Item__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Payroll_Check_Payroll_Item__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Payroll_Check_Payroll_Item__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Check_Payroll_Item__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Check_Payroll_Item__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |
FK_Payroll_Check_Payroll_Item__Payroll_Item_Calculation_Type__payroll_item_calculation_type_KEY | payroll_item_calculation_type_KEY | Payroll_Item_Calculation_Type (payroll_item_calculation_type_KEY) |
FK_Payroll_Check_Payroll_Item__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEY | payroll_check_payroll_item_KEY | Shortfall_Transaction_N_Payroll_Check_Payroll_Item |
FK_Payroll_Check_Payroll_Item_Distribution__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEY | payroll_check_payroll_item_KEY | Payroll_Check_Payroll_Item_Distribution |
FK_Payable_Transaction_N_Payroll_Check_Payroll_Item__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEY | payroll_check_payroll_item_KEY | Payable_Transaction_N_Payroll_Check_Payroll_Item |