Purge Extracts Archive Information

You can remove redundant archive data, which is older than 7 days, to free up space and improve overall performance in your database.

Use the Business Intelligence Publisher (BIP) report to know the top 20 storage-consuming extracts and basic recommendations for purging to free up space and improve the runtime and operational efficiency of your system. You can find the Purge Recommendation Report in the BIP catalog.

Use the Purge Extracts Archive Data process to remove the unnecessary information.

Note: For significant optimization and runtime efficiency, it's recommended that you run this process for full extracts.

Here's how you can purge the redundant extracts archive information:

1. Select and search Purge Extracts Archive Data job under Scheduled Processes. The archive data includes the associated payroll actions, object actions, and action information rows generated by extracts.

2. In the Process Details page, define the criteria for the purge process by selecting the appropriate values for the process parameters.

   Parameter Name	Values	Default Value
   Report Mode	Yes/No Yes: Provides details of the archive data you want to purge No: Purges the archive data generated by the selected Extract List	Yes
   Extract List	Lists the extracts to purge or generate a report	N/A

3. Click Submit.

4. You can search for the job and check the completion status with any scheduled processes.

5. If you run the process in Report Mode, the output file provides a report including these details:

   • Extract definition Name

   • Extract Type

   • Archive data count

   • Storage recovered by the purge process

6. Use the details in the report to identify data that you want to clean up from the application.

   Note: You can run only one instance of this ESS job at any time.

Purge Extracts Archive using Remove Person Information Process

You can clean-up the extracts generated archive data, when running the Remove Person Information process for an ex-employee, by selecting the 'Extracts Archive' from the list of available business objects.

Purge process relies on the User entities used in the threading blocks and the contexts set by these user entities to determine the archive data for a given ex-employee to be purged. User entities setting any of the following contexts will facilitate associating the archive data to the person number passed to the purge process.

• Person Id

• HR Assignment Id

• Work Relationship Id

• Payroll Relationship Id

• Payroll Assignment Id

Note:

• When extracts is run again for these disposed of ex-employees, any leftover data, might still get reported in the extracts and archived. You should consider excluding these disposed of employees from your extracts run.

• You can run the Purge Extracts Archive Data to purge archive data generated by specific extracts and archives that are older than 7 days.