10.2 Archiving / Purging
The system batch process runs the purge / archive feature based on the system parameter setup. The system archives the following items:
- Applications and related data
- General ledger data
- Securitization related data
- Producers
- Producer transactions
- Account statements
- Vendor assignments
- Vendor invoices
The system purges the following items:
- Job request data
- User logins
- Output data dump related data
In the system, archiving is a two-way process:
- All the archived data is moved and stored in O tables.
- The archived data in the O tables is then moved and stored into OO tables.
You may set the default days for the archive feature by setting the following system parameters on the Administration screen. The parameters marked with _O are the items moved from O to OO tables. The other parameters are the items moved to O tables.
Table 10-1 Parameters on the Administration screen
| Parameter | Default Days | Description |
|---|---|---|
| PAP_ARCHIVE_DAYS | 999 | PURGE DAYS FOR APPLICATIONS LEVEL 1: PUR_APP_STATUS_CD IS USED TO DECIDE APPLICATIONS WITH WHAT STATUS ARE PURGED |
| PAP_OARCHIVE_DAYS | 999 | PURGE DAYS FOR APPLICATIONS LEVEL 2: |
| PGL_ARCHIVE_DAYS | 999 | PURGE DAYS FOR GL LEVEL 1: NO OF DAYS AFTER THE GL TXN WAS CREATED |
| PGL_OARCHIVE_DAYS | 999 | PURGE DAYS FOR GL LEVEL 2: |
| PJR_PURGE_DAYS | 999 | PURGE DAYS FOR JOB REQUEST LEVEL 1: NO OF DAYS AFTER JOB REQUEST COMPLETION DATE |
| POD_PURGE_DAYS | 999 | PURGE DAYS FOR OUTPUT DATA DUMP LEVEL 1: NO OF DAYS AFTER PROCESS RUN DATE |
| PPR_ARCHIVE_DAYS | 999 | PURGE DAYS FOR PRODUCERS LEVEL 1: NO OF DAYS AFTER THE PRODUCER STATUS IS SET TO ACTIVE AND THERE EXISTS NO NOT PURGED ACCOUNT WITH THIS PRODUCER NAME. |
| PPR_OARCHIVE_DAYS | 999 | PURGE DAYS FOR PRODUCERS LEVEL 2: |
| PPX_ARCHIVE_DAYS | 999 | PURGE DAYS FOR PRODUCER TXNS LEVEL 1: NO OF DAYS AFTER THE PRODUCER TXN WAS CREATED |
| PPX_OARCHIVE_DAYS | 999 | PURGE DAYS FOR PRODUCER TXNS LEVEL 2: |
| PUL_PURGE_DAYS | 999 | PURGE DAYS FOR USER LOGINS LEVEL 1: NO OF DAYS AFTER THE LOGIN END DATE |
| PVA_ARCHIVE_DAYS | 999 | PURGE DAYS FOR VENDOR ASSIGNMENTS LEVEL 1: NO OF DAYS AFTER THE ASSIGNMENT DATE AND ASSIGNMENT CODE IN COMPLETED, VOID, CLOSE |
| PVA_OARCHIVE_DAYS | 999 | PURGE DAYS FOR VENDOR ASSIGNMENTS LEVEL 2: |
| PVI_ARCHIVE_DAYS | 999 | PURGE DAYS FOR VENDOR INVOICE LEVEL 1: NO OF DAYS AFTER THE ASSIGNMENT DATE AND ASSIGNMENT CODE IN VOID, CLOSE |
| PVI_OARCHIVE_DAYS | 999 | PURGE DAYS FOR VENDOR INVOICE LEVEL 2: |
Parent topic: Application Retrieval