Update Employee Package Deductions

Use this screen to calculate the proper deduction and contribution amounts for the benefit elections that were in effect at the time of the pay period end date.

The procedure updates/inserts the deduction amounts in the Manage Employee Deductions table. If you select the Include Contributions check box, contribution amounts are also updated/inserted in the Payroll Contribution tables. If you select the Process Changes and Additions Only check box, only the benefit elections that have changes and/or additions in deduction amounts for the selected pay cycle are updated/inserted for employees.

It is critical that you run this process after you have updated all benefit package information for all employees and assigned dependents to benefit plans, and before each payroll if any benefit premiums are calculated using rate tables.

Warning: Duplicate rows with the same employee ID (EMPL_ID) and HSA start date (EFFECT_DT) values should not exist in the HB_HSA_ELEC table. You cannot manually add duplicate data with the same EMPL_ID and EFFECT_DT through the Costpoint user interface. However, it can be added directly to the database through the backend. If such duplicate data exists, the most current record will be saved and any older records will be deleted from HB_HSA_ELEC and inserted into HB_HSA_ELEC_DUPLICATES table.

You will be able to view the duplicate data when you run the Update Employee Package Deductions process. The duplicates will display on the error report and you will have to manually delete the data from HB_HSA_ELEC_DUPLICATES table.