The monthly purge program calls two purge programs.
Employee Masterfile Purge (BPP600) – this program reads all Employee Masterfile (BPEM00P) records. If the employee status is C = Closed, this program searches the timesheet transaction (BPET00P) file for any outstanding timesheet transactions with a status of E = Entered for the employee ID. If the program can’t find any outstanding transaction, the employee masterfile record is then deleted.
Timesheet Transaction Purge (BPP610) – this program first calculates the retention period in months by looking at TMSBP/RTN-TS. The retention period is then subtracted from the current system date, giving a retention date. The program then reads all timesheet transaction (BPET00P) records. If a timesheet transaction record has a date less than the retention date and its status is P = Posted, this record is deleted.
Purge employee records and timesheet transactions
- In the menu, expand Publishing Modules > Book Publishing > Others > Timesheets > Others and double-click BP Timesheet Monthly Purge. BPP000-BP Monthly Purge – Controlling Program panel is displayed.
Field | Description |
Company |
A range of companies can be selected for purging. |
- Enter the required information.
- Click OK to confirm. Once these two programs have completed, the two files Employee Masterfile (BPEM00P) and Timesheet Transactions (BPET00P) are updated and re-organised.