Search Results igs_da_purge

Overview

The IGS_DA_PURGE table belongs to the IGS (Student System) product family within Oracle E-Business Suite. In release 12.1.1 and 12.2.2 it is documented as obsolete and is not implemented in the standard database, meaning it is a legacy or end-of-life object that persists only in certain historical environments. Its stated purpose is the storage of Degree Audit Requests that have been purged from the active system, effectively acting as an archive or retention table for records that have been removed from the operative degree audit processing tables.

From a dimensional modeling perspective, the mined Data Vault classification for this object is standalone, suggesting it functions as an independent hub with no dependent link or satellite relationships. The absence of foreign-key-derived relationships reinforces that this table was maintained as a self-contained staging or archive construct rather than a transactional entity participating in the broader IGS relational web.

Key Information Stored

The table is documented with 16 columns in the ETRM 12.1.1 physical schema. The most significant attributes are:

PUR_REQ_ID — the purge request identifier and part of the composite primary key.
BATCH_ID — the batch identifier, also part of the composite primary key.
PURGE_STATUS — indicates the outcome or state of the purge operation.
REQUEST_STATUS — the status of the original degree audit request at purge time.
REQUEST_TYPE — categorizes the degree audit request.
REQUEST_MODE — the mode in which the request was submitted.
REPORT_STATUS — the reporting state associated with the request.
REQUESTOR_SURNAME and REQUESTOR_GIVENNAME — identity of the individual who initiated the request.
REQUESTOR_TYPE — classification of the requestor (e.g., student, staff).
REQUEST_MADE_DATE — the date the original request was created.
Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture standard row-level auditing.

The surrogate primary key is IGS_DA_PURGE_PK, defined over PUR_REQ_ID and BATCH_ID. A unique index, IGS_DA_PURGE_U1, covers the same two columns and represents the business-key candidate, reinforcing that the combination uniquely identifies a purged audit request.

Common Use Cases and Queries

Because the table is obsolete, primary usage centers on historical audit, compliance reporting, and data-retention verification. Typical queries retrieve purged requests for a given batch or requestor:

Identify all purged requests tied to a batch: SELECT * FROM IGS_DA_PURGE WHERE BATCH_ID = :batch_id;
Trace the purge history for a specific requestor: SELECT PUR_REQ_ID, REQUEST_MADE_DATE, PURGE_STATUS FROM IGS_DA_PURGE WHERE REQUESTOR_SURNAME = :surname;
Reconcile purge volumes by status: SELECT PURGE_STATUS, COUNT(*) FROM IGS_DA_PURGE GROUP BY PURGE_STATUS;
Audit records created within a date range: SELECT * FROM IGS_DA_PURGE WHERE CREATION_DATE BETWEEN :start_date AND :end_date;

Reporting use cases include compliance evidence for data purging, trend analysis of purge activity, and verification that retention policies were applied.

Related Objects

The mined relationship data classifies IGS_DA_PURGE as standalone, with no documented foreign-key dependencies. Consequently, related objects are inferred from functional context rather than enforced constraints. The most significant are the active degree audit request tables (analogous IGS_DA_* request tables) that feed this archive, joined on PUR_REQ_ID and BATCH_ID; the IGS batch processing tables referenced through BATCH_ID; and the requestor/student master tables referenced through REQUESTOR_TYPE and requestor name fields. Because the object is not implemented in the standard database, no shipped views or public APIs depend on it, and any dependency would be environment-specific and developer-maintained.

Table: IGS_DA_PURGE 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_PURGE, object_name:IGS_DA_PURGE, status:VALID, product: IGS - Student System , description: Storage of Degree Audit Requests that have been purged from system , implementation_dba_data: IGS.IGS_DA_PURGE ,
Table: IGS_DA_PURGE 12.2.2
product: IGS - Student System (Obsolete) , description: Storage of Degree Audit Requests that have been purged from system , implementation_dba_data: Not implemented in this database ,
SYNONYM: APPS.IGS_DA_PURGE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_DA_PURGE, status:VALID,
VIEW: APPS.IGS_DA_PURGE_V 12.1.1
TABLE: IGS.IGS_DA_PURGE 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_PURGE, object_name:IGS_DA_PURGE, status:VALID,
View: IGS_DA_PURGE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_DA_PURGE_V, object_name:IGS_DA_PURGE_V, status:VALID, product: IGS - Student System , description: This view is to give the user information into all the degree audit requests that were made and purged from the system. The information will be saved as each request has been purged. , implementation_dba_data: APPS.IGS_DA_PURGE_V ,
View: IGS_DA_PURGE_V 12.2.2
product: IGS - Student System (Obsolete) , description: This view is to give the user information into all the degree audit requests that were made and purged from the system. The information will be saved as each request has been purged. , implementation_dba_data: Not implemented in this database ,
VIEW: APPS.IGS_DA_PURGE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_DA_PURGE_V, object_name:IGS_DA_PURGE_V, status:VALID,
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
eTRM - IGS Tables and Views 12.1.1
description: Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'. ,
eTRM - IGS Tables and Views 12.1.1
description: Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'. ,