Search Results igs_da_purge_v

Overview

IGS_DA_PURGE_V is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It is documented under the ETRM metadata for Oracle EBS 12.1.1 and 12.2.2 as a reporting and audit view that exposes information about degree audit requests that have been purged from the system. As the description states, the view "is to give the user information into all the degree audit requests that were made and purged from the system," and the information "will be saved as each request has been purged."

In practical terms, the view functions as a historical audit trail. When degree audit requests are removed from the active request tables during a purge process, a record is written to the underlying storage so that institutions retain visibility into what was purged, when, and by whom. IGS_DA_PURGE_V presents that archived information in a query-ready form, making it suitable for operational reporting, troubleshooting, and compliance review within the student system.

Underlying Base Objects

The documented view text defines IGS_DA_PURGE_V as a simple projection over a single base table:

• IGS_DA_PURGE — the sole referenced base object documented in the ETRM metadata.

Notably, the documented base objects list states "none documented" for 12.2.2, yet the embedded view text explicitly selects from IGS_DA_PURGE. Per the ETRM excerpt, the view exposes ROWID as ROW_ID along with a set of descriptive and WHO columns. No joins to other tables are present in the documented view definition, so the view inherits the row-level granularity of IGS_DA_PURGE — one row per purged degree audit request batch record. Because the view text is provided directly, it can be treated as authoritative for this object.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_DA_PURGE row, aliased for readability.
• BATCH_ID — identifier of the degree audit batch associated with the purged request.
• PURGE_STATUS — status indicating the purge state of the request.
• REQUEST_STATUS — the outcome status of the original degree audit request.
• REQUEST_TYPE and REQUEST_MODE — classify how the request was submitted and processed.
• REPORT_STATUS — the status of the associated degree audit report; this is the column most directly relevant to users searching for "report_status," as it captures the reporting state of each purged request.
• REQUESTOR_SURNAME and REQUESTOR_GIVENNAME — name of the individual who made the request.
• REQUESTOR_TYPE — the category of requestor (for example, student or staff).
• REQUEST_MADE_DATE — when the request was originally submitted.
• CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical uses include auditing purged degree audit requests, reconciling purge batches, and reporting on the REPORT_STATUS of removed requests. A basic listing of purged requests by report status might read:

• SELECT batch_id, requestor_surname, requestor_givenname, report_status, request_made_date FROM igs_da_purge_v WHERE report_status = 'COMPLETE' ORDER BY request_made_date DESC;
• SELECT batch_id, purge_status, COUNT(*) FROM igs_da_purge_v GROUP BY batch_id, purge_status;
• SELECT requestor_type, report_status, COUNT(*) FROM igs_da_purge_v WHERE request_made_date >= TRUNC(SYSDATE) - 90 GROUP BY requestor_type, report_status;

These queries support purge auditing, workload analysis, and historical trend reporting over the degree audit purge archive.