The Payroll Audit File Record Purge Process allows for the deletion of the records in the Payroll Audit data files for a given year or range of years. There is a record retention policy of seven (7) years. It is recommended that audit data more than 7 years old be purged to reduce the file size and overhead on the system.
Data purges should be run over the weekends to avoid causing delays in both the batch queue and as a drain on the system resources.
There are four audit files from which the records can be purged:
-
Employee Audit Trail File
-
Database Audit Trail File
-
Memo Audit Trail File
-
Profile Audit Trail File
The report lists the Audit File and number of records deleted from that file
NOTE: This process will only run in batch.
Avoid the use of the single stream batches such as OPS$Batch, if possible.
Enter the Year to Begin Record Purge
-
Enter the four-digit year which records with a date equal to or older than will be purged. Note: only records older than 7 years may be purged. Only Live payrolls can have the audit data purged.
Enter Payroll ID Codes for Payrolls to Include
-
Enter the payroll ID codes (one at a time) for payrolls to be purged. Up to 8 payrolls may be selected. Use look-up for a list of valid payroll ID codes.
Select the Files to Purge
-
Enter A or enter to select All the audit files to be purged
-
Enter E to select the Employee Audit File
-
Enter D to select the Database Audit File
-
Enter M to select the Memo Audit File
-
Enter P to select the Profile Audit File
Note: You can select any combination of the files to purge, for example, E and M only.
The report lists the following:
-
Payroll
-
Number of records purged from each data file for that payroll
-
Total records purged