Skip to Content
0
Jan 17, 2011 at 11:46 AM

ESS Leave Request database - Archiving or Maintenance

172 Views

Hi

I understand the leave request detals are stored in the following tables

PTREQ_HEADER (Request Header)

PTREQ_ITEMS (Request Items)

PTREQ_ACTOR (Request Participant)

PTREQ_NOTICE (Note for Request)

PTREQ_ATTABSDATA (Request Data for Attendances/Absences)

Over a period of time, the size must build up. IN an organization of 200,000 employees, there must be a need for maintaining the size of this database to manageable limits. I could not find any documentation for archiving or deleting the entries in this databse. there is a report rptarqdbdel, but according to documentation this is a trouble shooting tool and must be used for individual cases only and with extreme caution.

Can any one please advise as to whether there are any tools/best practices for maintaining the size of this databse periodically? As there are several tables involved one would like to avoid having to write a custom program for this.