Search Results igs_gr_aprv_stat_u1

Overview

IGS.IGS_GR_APRV_STAT is a reference (setup) table within the Oracle E-Business Suite Student Systems / Graduation subsystem, owned by the IGS schema. It stores the institution-defined graduand approval statuses that describe the progress of a graduand being approved to graduate. Each row represents a single status value that an institution may assign to a graduand record, and that value is mapped internally to a seeded Oracle system graduand approval status that drives functionality in the graduation subsystem. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its unique index IGS_GR_APRV_STAT_U1 — the object referenced in the user's search term — is created in APPS_TS_TX_IDX on the GRADUAND_APPR_STATUS column.

From a Data Vault modeling perspective, the heuristic classification of this object is standalone. The mined metadata records no foreign-key relationships to other tables, and the object is documented as referencing no database objects. In Data Vault terms it would naturally be modelled as a small reference satellite or hub carrying the institution-defined status code as its business key, with descriptive attributes (DESCRIPTION, S_GRADUAND_APPR_STATUS, CLOSED_IND) and the standard Who audit columns attached. Because the table is standalone, no link table is implied.

Key Information Stored

The physical schema for 12.1.1 documents nine columns. The most significant are:

• GRADUAND_APPR_STATUS (VARCHAR2(10), mandatory) — the institution-defined status indicating the progress of a graduand's approval to graduate; this is the primary key column (PK IGS_GR_APRV_STAT_PK) and the unique-index column for IGS_GR_APRV_STAT_U1.
• DESCRIPTION (VARCHAR2(60)) — the human-readable explanation of the institution-defined graduand approval status.
• S_GRADUAND_APPR_STATUS (VARCHAR2(10)) — the seeded system status to which the institution-defined value maps; system statuses enable specific graduation subsystem functionality (for example, an institution-defined "pending" mapped to system "waiting", or "confirmed" mapped to system "approved").
• CLOSED_IND (VARCHAR2) — checkbox-style indicator that, when set, closes the status and makes it unavailable for use on new or modified graduand records.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns maintained automatically by Oracle EBS for audit and concurrency.

The surrogate/business key distinction here is straightforward: GRADUAND_APPR_STATUS is both the documented primary key and the unique business-key candidate, so no separate surrogate key is exposed in the ETRM schema.

Common Use Cases and Queries

This table is primarily used for validation and lookup purposes — presenting the list of available approv