Summary

The object of Purge Closed Pays is simply to remove data from database payroll tables prefixed “Current” and “TransCurrent”. Because the same data was copied to the database payroll tables prefixed “Historical” and “TransHistorical” when you closed the pay.

Note: If a pay is “Rolled back” the data is moved from “Historical” back to “Current”

Benefits:

• reduces DB size
• improves performance in some areas
• improves data integrity in some areas

Limitations:

Any reports (namely those with code prefix ‘PGPRPRIM’ will not report on purged pays.

This is usually only an issue for employers that need to rerun old payslips for employees.

Impact on Backpay Module, Rate Effectiveness or Remuneration Module

• Backpay looks at “historical” tables so is not impacted.
• Rem Module doesn’t look at payroll transaction tables.
• Rate Effectiveness uses a rate hierarchy (so doesn’t look at payroll transaction tables)… “Rate Effectiveness” is sometimes confused with “DateEffectiveness” which does use some historical tables but not the ones payroll tables prefixed “Historical” and “TransHistorical”

Process

1. Before you purge closed pays, backup your database.
2. Double-click Purge Closed Pays.
3. When the Closed Pays to Purge from Current window appears, click the checkboxes for the pay periods that you want to purge.
4. Click OK.