| client_payroll_item_KEY | int (4) | NOT NULL | Key for the record |
| description | nvarchar (60) | NOT NULL | Item description, which must be unique within the scope of the items for the client |
| alternate_description | nvarchar (60) | NOT NULL | This allows a user to optionally display a different description on checks and reports. |
| client_KEY | int (4) | NOT NULL | Client the item applies to. |
| payroll_item_type_KEY | int (4) | NOT NULL | Key of item type. |
| payroll_item_calculation_type_KEY | int (4) | NOT NULL | Key of calculation type. |
| amount | decimal (9, 2) | NOT NULL | Default amount copied to employee payroll item when the system adds the item to an employee. |
| percentage | decimal (5, 4) | NOT NULL | Default percentage copied to employee payroll item when the system adds the item to an employee. |
| rate | decimal (9, 4) | NOT NULL | Default rate copied to employee payroll item when the system adds the item to an employee. |
| is_excluded_from_gross_pay_amount | bit (1) | NOT NULL | Indicates if item amount is excluded from gross pay |
| is_excluded_from_net_pay | bit (1) | NOT NULL | is_excluded_net_pay |
| wage_type_KEY | nvarchar (30) | | Key of wage type. |
| ot_dt_amounts_are_supplemental_wages | bit (1) | NOT NULL | are_ot_dt_amts_supplemental_wages |
| vendor_KEY | int (4) | | Vendor to which payables are generated for this item. |
| special__deduction_type_KEY | int (4) | | Holds benefit type for this deduction item |
| related_payroll_item__client_payroll_item_KEY | int (4) | | Reference of a deduction item to a employer contribution payroll item |
| limit_calculation_type_KEY | nvarchar (30) | | Used for limit setup. Holds limit calculation type |
| calculation_limit | decimal (9, 2) | NOT NULL | Defines an optional calculation limit for the payroll item. |
| calculation_limit_related_item__client_payroll_item_KEY | int (4) | | Key of a deduction item which a user may optionally use to specify a calculation limit for a payroll item. |
| federal_unemployment_tax_exemption_type_KEY | int (4) | | Optional federal unemployment tax exemption. |
| inactive | bit (1) | NOT NULL | Flags the payroll item as inactive, which means the user does not want to use it but does not want to delete it either. |
| is_other_wages | bit (1) | NOT NULL | Flag indicating whether or not this payroll item is not regular wages, but rather other wages. |
| client_payroll_item_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
| worker_compensation_class_code_detail_KEY | int (4) | | worker compensation class code this deduction is for |
| selection_scope_KEY | int (4) | NOT NULL | worker compensation exemption type key |
| 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_auto_pay | bit (1) | NOT NULL | Flag when true specifies that the system automatically give this employee hours or pay when creating the check. |
| garnishment_type_KEY | int (4) | | If this payroll item is a garnishment, this says what kind. If not a garnishment this field should be null and not used. |
| is_w2_dependent_care_benefit | bit (1) | NOT NULL | Flag pay and deduction item amount for display in W-2 Dependent Care Benefits box. |
| w2_compensation_code_type_KEY | int (4) | | W-2 compensation code, optional for all payroll item types. When used on a payroll item, the code and associated description appear on the employee W-2. |
| is_w2_retirement_plan | bit (1) | NOT NULL | W-2 processing uses this flag to know when to mark the W-2 retirement plan check box. Applicable to deduction and employer contribution items. |
| w2_other_description | nvarchar (30) | NOT NULL | Optional description (determined by the user) for use in the W-2 other description box. Applicable to all payroll item types. |
| sequence_number | int (4) | NOT NULL | This user defined sequence number which defines the order which the payroll item should be presented. |
| special_type_KEY | int (4) | NOT NULL | The payroll item special type if needed. |
| accruable_benefits__selection_scope_KEY | int (4) | NOT NULL | Shows which type of accruable benefits to exclude from pay check calculations |
| payroll_item_special_timing_KEY | int (4) | NOT NULL | Foreign key into the Payroll Item Special timing table. |
| limit_period_type_KEY | int (4) | | Used for limit setup. Holds the selected limit triggert |
| is_excluded_from_garnishment_disposable_income | bit (1) | NOT NULL | Indicates if we should exclude this payroll item from garnishment disposal income. |
| pay_items_exclude_all_regular | bit (1) | NOT NULL | Indicates that the client payroll item should exclude regular wages from all pay items for this client. |
| pay_items_exclude_all_OT | bit (1) | NOT NULL | Indicates that the client payroll item should exclude overtime wages from all pay items for this client. |
| pay_items_exclude_all_DT | bit (1) | NOT NULL | Indicates that the client payroll item should exclude doubletime wages from all pay items for this client. |
| pay_items_exclude_all_accruable_benefits | bit (1) | NOT NULL | Indicates that the client payroll item should exclude accruable benefit wages from all pay items for this client. |
| is_exclude_premium_wages | bit (1) | NOT NULL | Indicates that the client payroll item should calculate assuming 1.0 as both the OT and DT multipliers when excluding wages. |
| w2_nonqualified_deferred_compensation_type_KEY | int (4) | | Optional type of nonqualified deferred compensation. Used for W2 processing. |
| health_plan_type_KEY | int (4) | NOT NULL | The selection for health plan type such as individual or family. |
| is_subject_to_health_savings_account_limit | bit (1) | NOT NULL | Used only for employer contribution payroll item types to indicate if the item is subject to the health savings account limit. |
| is_excluded_from_gross_pay_hours | bit (1) | NOT NULL | Indicates if item hours are excluded from gross pay |
| is_weighted_allocation | bit (1) | NOT NULL | Flag that indicates the payroll item is using a weighted allocation that will be based on gross pay per location/department distribution. |
| maximum_percentage_of_disposable_income | decimal (5, 2) | NOT NULL | Percentage field that holds the maximum percentage of disposable income that can be garnished for pay items of garnishment type. |
| use_lesser_max_percent_or_amount_exceeds_min_wage | bit (1) | NOT NULL | Use the lesser of maximun percent of disposable income or amount by which disposable income exceeds minimum wage. Only used for Other garnishment type. |
| use_federal_min_wage_that_exceeds_disposal_income | bit (1) | NOT NULL | Use federal minimum wage when determining the amount that exceeds disposable income. Only valid for Other garnishment type. Only used for Other garnishment type. |
| apply_catch_up_limit | bit (1) | | The apply_catch_up_limit is only used for Retirement plans. True indicates that catch-up contributions should be made to the Retirement plan if the employee’s age meets the catch-up criteria. False means that catch-up contributions should not be made, even if the employee’s age qualifies. This column is set to null for all items that are not Retirement plans. |
| client_payroll_item_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row. |
| client_payroll_item_force_new_version_toggle | bit (1) | NOT NULL | A bit to toggle that causes the client_payroll_item_version to update. Flip this bit when a subordinate tables are changed. |
| alternate_minimum_wage | decimal (5, 2) | | The alternate minimum wage is optionally used as an default minimum wage on special tipped wages types |
| subtract_cafeteria_125_deduction_before_calculating | bit (1) | NOT NULL | This flag determines whether or not to subtract the Section 125 Cafeteria deduction before calculating retirement plans. |
| require_direct_deposit_allocation | bit (1) | NOT NULL | If (true), direct deposit allocations are required. |
| is_deferred_fica_ss_repayment | bit (1) | NOT NULL | Flag that will indicate if this client payroll item is a special type of deduction item. |
| client_qualifies_for_increased_deferral_limit | bit (1) | NOT NULL | Flag to indicate the client qualifies for a 10% increase to the deferral limit and catch-up limit (SECURE 2.0 Act). |