System administration components: defining purge criteria

You can define purge criteria rules for data purges not related to specific document types.

Purges are the process by which old data is removed from the system database. Purges minimize the number of unused database records to increase search efficiency and reduce the size of the required physical disk.

Table 1 lists the system purge rules provided with the Sterling Order Management System.
Table 1. System-defined purge rules.

System-defined purge rules

Rule Description Retention Days
CAPACITYPRG Purges capacity data. 30
EXPORTTBLPRG Purges data from export tables that are used for publishing data to external systems. This is a Hub level purge. 30
IMPORTTBLPRG Purges data from the import tables. This is a Hub level purge. 30
INBOXPRG Purges the Alert Console messages from the user's inbox. This is a Hub level purge. 30
INVENTORYPRG Purges inventory information. The inventory purge considers the retention days when purging. All records with relevant tables with a quantity of 0 are purged. 30
MANIFESTPRG Purges manifest information. 30
PERSONINFOHISTPRG Purges historical customer information. 30
PERSONINFOPRG Purges customer information and moves it to a history table. 30
PRICELISTPRG Purges price lists. 30
REPROCESSPRG Purges any reprocessed information. This is a Hub level purge. 30
STATTBLPRG Purges statistical information. This is a Hub level purge. 30
USERACTAUDITPRG Purges all user activity audit data from the system. 30
USERACTIVITYPRG Purges all user activity data. 30