Understanding the Workfile History Purge Program

You use the Workfile History Purge program (R48S999) to purge inactive records from the Billing Workfile History table (F4812H). Records that do not have associated active records in the Billing Detail Workfile table (F4812) are considered inactive. Associated active records are those with the same G/L date and billing control ID in both the F4812H and F4812 tables.

Purging the F4812H table increases available disk space and potentially reduces processing time for other Contract and Service Billing processes. You should purge the F4812H table periodically.

Note: You should purge the F4812H table during off-peak hours.

You can choose whether to purge selected records, print a report of selected records, or do both. The report lists information about each purged record, as well as the total number of records purged. You can also run the report without purging the records to verify that the appropriate records are selected before you purge the records.

You can also choose whether to write records that are purged from the F4812H table to the Billing Workfile History Purged Save table (F4812HS), and whether to first clear the F4812HS table of any previously saved records.

The Workfile History Purge program produces a report that lists purged records.