How to quickly find Report Retention Period in PeopleSoft
PeopleSoft can be configured to purge reports/ process request entries periodically based on the how long reports/processes are needed for day to day activities or audit purposes.
There are 2 ways to quickly find out the report retention period in PeopleSoft.
- Online Page: Navigate to PeopleTools > Process Scheduler > System Settings
On ‘Process System’ page, look for the field ‘Retention Days’.
- Database Tables: Run below SQL on PeopleSoft table PS_PRCSSYSTEM to find the retention period.
SELECT PT_RETENTIONDAYS FROM PS_PRCSSYSTEM;
Based on retention period and purge process settings, PRCSYSPURGE AE process will be run to purge entries from Process Scheduler tables.