ETL 9.1: When Should We Purge Data? (Doc ID 1592062.1)

Last updated on JANUARY 21, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.


In Time and Labor 9.1,

I would like to know if there is any recommendation to purge data in the database when time’s gone by.
The background is that there are about 10,000 employees in the system, those are paid by time attendance. There are about 21 TRC Codes.

Currently there are record amount as following:-

PS_TL_RPTD_TIME = 2,061,178
PS_TL_PAYABLE_TIME = 3,723,586

Questions are as following:-
1. Should we purge data ?
2. What record can be purged i.e. TL, (for example on the above record) Payroll ?
3. When we should consider to purge ?



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms