Configuring Data Retention Limits

Database administrators can set the length of time data (for example, ECM and Reporting and Analytics aggregation) remains present in the database at the Enterprise and property levels.

1. Select the Enterprise level, click Setup, and then click Enterprise Parameters.
2. Click the Miscellaneous tab.
3. To set data retention limits, in the Purging section, enter the Days To Keep for the Purge Type.

   This is the number of days from the time a transaction is reported to the enterprise that the application retains it for use in reporting and auditing (for example, from 1 day to 999 days). After the number of days to keep expires, a scheduled event purges the data. By default, the purging jobs purge 1000 records per batch.

   • To set ECM data retention, enter the number of days for ECM Transaction Detail.

   • To change the PC Autosequences data retention, enter the number of days for the Pcasequence Log.

     Oracle recommends that you leave the default value set at 90 days, and that a subject matter expert change this setting if necessary. The Pcasequence Log Purge Type is available in Simphony version 2.10 and later and is compatible with Reporting and Analytics version 9.0 Patch 8 and later.

4. Click Save.