How to quickly find Report Retention Period in PeopleSoft

by Prashant on May 11, 2016

in General

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.

  1. Online Page: Navigate to PeopleTools > Process Scheduler > System Settings Retention Period
    On ‘Process System’ page, look for the field ‘Retention Days’.
  2. 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.

  • PSPRCSRQST
  • PSPRCSQUE
  • PSPRCSPARMS
  • PS_MESSAGE_LOG
  • PS_MESSAGE_LOGPARM
  • PS_PRCSRQSTDIST
  • PS_CDM_LIST
  • PS_CDM_AUTH
  • PS_CDM_FILE_LIST
Also Read:  Welcome to PeopleSoft Tutorial

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: