Understanding the Purge of Date-Effective Category Codes

When the category codes records become obsolete (they are no longer effective), you can purge them from the system by running Purge Date Effective Category Codes (R03012B). This program purges all category codes that meet this criteria:

• The Eff Used field has a value of Y.

• The effective date of the category codes record is on or before the date entered in the processing option of the purge program.

• The category codes record is not currently in effect.

  For example, if two category codes records exist in the table with effective dates of June 1, 2008 and June 15, 2008, and you run the purge program using a date of June 30, 2008, the system does not purge the category code record of June 15, 2008 because it is currently in effect. The system purges the category codes record of June 1, 2008 because it is not currently in effect.

The system also produces a report listing the customer number and category code records that have been purged. The system removes category code records from the F03012A table.