employee_payroll_item_KEY | int (4) | NOT NULL | Key of payroll item |
employee_KEY | int (4) | NOT NULL | Key of employee |
client_payroll_item_KEY | int (4) | NOT NULL | Client payroll item that this item is based on. |
payroll_item_calculation_type_KEY | int (4) | NOT NULL | Calculation type. |
amount | decimal (9, 2) | NOT NULL | Amount. See other calculation setup for the effect this has on the check. |
rate | decimal (9, 4) | NOT NULL | rate |
percentage | decimal (5, 4) | NOT NULL | percentage |
is_active | bit (1) | NOT NULL | is_active |
start_date | smalldatetime (4) | | start_date |
end_date | smalldatetime (4) | | end_date |
calculation_limit | decimal (9, 4) | NOT NULL | Defines an optional calculation limit for the payroll item. |
limit_calculation_type_KEY | nvarchar (30) | | The method we use to calculate a payroll item limit. For example, fixed amount or percentage of gross pay. Overrides its counterpart in the associated client payroll item. |
employee_payroll_item_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
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 | When true specifies that the system automatically give this employee hours or pay when creating the check. Defaults to the automatic pay option selected on the associated client payroll item, but may be overridden at the employee level. |
maximum_percentage_of_disposable_income | decimal (5, 2) | NOT NULL | Percentage field that holds the maximum amount of disposable income that can be garnished for child support. Defaults to whatever the user entered in the corresponding client payroll item field, but may be overridden at the employee level. |
multiple_garnishment_calculation_method_KEY | int (4) | | When a deduction has multiple garnishment orders and the max percentage is reached, we use this option to calculate how much goes to each garnishment. If this payroll item is not a garnishment this field is null and not used. Defaults to whatever the user specified in the corresponding client payroll item field, but may be overridden at the employee level. |
supports_multiple_families | bit (1) | NOT NULL | True when a child support order deduction supports more than one family. |
insurepay_employer_contribution_type_KEY | int (4) | | Foreign key for this table. The associated Insurepay_Employer_Contribution_Type KEY. |
insurepay_pay_item_type_KEY | int (4) | | Foreign key for this table. The associated Insurepay_Pay_Item_Type KEY. |
xactpay_employer_contribution_type_KEY | int (4) | | Foreign key for this table. The associated XactPay_Employer_Contribution_Type KEY. |
xactpay_multi_class_identifier_type_KEY | int (4) | | Foreign key for this table. The associated XactPay_Multi_Class_Identifier_type KEY. |
xactpay_pay_item_type_KEY | int (4) | | Foreign key for this table. The associated XactPay_Pay_Item_Type KEY. |
ot_rate | decimal (5, 4) | NOT NULL | rate used when calculating overtime pay related to this employee pay item. |
dt_rate | decimal (5, 4) | NOT NULL | rate used when calculating double time pay related to this employee pay item. |
limit_period_type_KEY | int (4) | | Used for limit setup. Holds the selected limit trigger |
limit_begin_date | smalldatetime (4) | | Date the payroll item limit began |
previously_deducted_amount_limit | decimal (9, 2) | NOT NULL | Amount previously deducted from payroll item |
subtract_from_federal_levy_basis | bit (1) | NOT NULL | Should this deduction be subracted from the federal levy basis? Not valid for child support since it uses the order date. Cannot be used for federal levy garnishment type since it is being subtracted from it. |
is_health_insurance_deduction | bit (1) | NOT NULL | Flag to indicate if this deduction item is used for health insurance |
is_dependant_health_insurance_deduction | bit (1) | NOT NULL | Flag to indicate if this deduction item is used for dependant health insurance |
health_plan_type_KEY | int (4) | NOT NULL | The selection for health plan type such as individual or family. |
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. |
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. |
amount_exempt_from_garnishment | decimal (9, 2) | NOT NULL | The amount that will be exempt from the garnishment 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 used for Other garnishment type. |
apply_catch_up_limit | bit (1) | | The apply_catch_up_limit is only used for Retirement plans. When a Retirement plan item is marked active, this column is defaulted to the Client_Payroll_Item.apply_catch_up_limit value if it has never been set before (has a null value). 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. It may also be null for non-active Retirement plan items that have never been marked active. |
alternate_minimum_wage | decimal (5, 2) | | The alternate minimum wage is optionally used as an default minimum wage on special tipped wages types |