Purge Periodic Process History (MPPR)
Purpose: Use this menu option to delete all Completed (P) or Canceled (C) Process History Header records, and their associated Process History Detail records, for all processes in all companies if the initiation date for the header record is older than the Purge history prior to initiate date specified.
If there are any Process History Detail records that are not associated with a Process History Header record, these detail records are also deleted.
Additional way to purge history: After a periodic process runs, it automatically purges history records that are older than the Periodic Process History Purge Days (L77). This automatic purge applies only to records for that periodic process. See the Periodic Process History Purge Days (L77) system control value for more information.
Determining the purge days across companies: The setting of the Purge history prior to initiate date defaults from the Periodic Process History Purge Days (L77) system control value. Because the Purge Periodic Process History option runs across all companies, it searches for a Periodic Process History Purge Days (L77) setting across companies numerically and uses the first system control value setting that is not zero. This search occurs regardless of the current company you are working in at the time you select the Purge Periodic Process History option.
Example: You are working in company 1, where the Periodic Process History Purge Days (L77) system control value is set to zero. In company 2, the system control value is set to 45. The purge function defaults a purge date that is 45 days earlier than the current date.
Reviewing history: You can review periodic process history using the Working with Periodic Process History (WPHS) menu option.
Use this screen to delete periodic process history in a completed or canceled status for all CWSerenade companies prior to a specified date.
How to display this screen: Enter MPPR in the Fast path field or select Purge Periodic Process History from a menu.
Field |
Description |
Purge history prior to initiate date |
The system defaults this date by subtracting the Periodic Process History Purge Days (L77) from the current date, but you can override this default. See above for a discussion. Numeric, 6 positions (MMDDYY format); required. |
Completing this screen:
1. Optionally, override the Purge history prior to initiate date. The system calculates the default date by subtracting the Periodic Process History Purge Days (L77) from the current date, but you can override the default. See above for a discussion.
2. Select OK to validate your entry.
3. Select Accept to advance to the Confirm Accept window. Select OK to submit the PHST_PURGE job; otherwise, select Exit to cancel.
The PHST_PURGE job:
• deletes records for all processes in all companies in the Process History Header table whose PHH status is P (Completed) or C (Canceled), and whose PHH initiation date is earlier than the Purge history prior to initiate date.
• deletes records in the Process History Detail table associated with the deleted records in the Process History Header table.
• deletes any additional Process History Detail records, for all companies, that are not associated with a Process History Header record.
