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.
| 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 |