4 Purge Parameters Configuration

For the initial purge parameter configuration, ODT utility for generating the Purge routines is to be used. The tool will be used to generate the packages that will have the purge logic based on the criteria. The tool will be used for the following –

1. . Maintaining the list of entities that need to be purged. This includes maintaining the Master-Child relationship between the tables. Each entity will have the following
   1. Parent table
   2. Primary key for the parent table and the data-types of the key fields
   3. List of child tables
   4. Relation with the parent tables and the data-types of the key fields
2. Maintaining the purge behavior – whether the data is to be deleted or archived
3. Maintaining the mode of purge – whether it is bulk or record level
4. Maintaining the archive table suffix if the purge behavior is to archive the data
5. Maintaining the filter criteria to determine what data to purge. These filter criteria will be applied on the parent table to identify the data to purge and based on the setup, corresponding data will be purged from the child tables also