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. |