Search Results igs_gr_stat_u1

Overview

IGS.IGS_GR_STAT is a reference (lookup) table in the Oracle E-Business Suite student system, owned by the IGS schema. It describes the institution-defined statuses that may be assigned to a graduand — that is, a student who has applied for, is being assessed for, or has been awarded a graduation outcome. The table is the master list of graduand statuses used throughout the graduation subsystem, and each row maps an institution-defined status to a corresponding Oracle-delivered system status. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, while its unique index is held in APPS_TS_TX_IDX.

From a Data Vault modeling perspective, the documented heuristics classify IGS_GR_STAT as standalone, and it is best regarded as a hub: it carries a single natural business key, GRADUAND_STATUS, which is also enforced as the primary key (IGS_GR_STAT_PK) and the unique business key (IGS_GR_STAT_U1). Its descriptive attributes (DESCRIPTION, S_GRADUAND_STATUS, CLOSED_IND) act as satellite-style context. The status is VALID in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table is compact, comprising nine documented columns. The most significant are:

• GRADUAND_STATUS — VARCHAR2(10), the primary key and the unique-indexed business key (IGS_GR_STAT_U1). Holds the institution-defined status code, e.g. prospectv or complete.
• DESCRIPTION — VARCHAR2(60). The human-readable explanation of the institution-defined status.
• S_GRADUAND_STATUS — VARCHAR2(10). The Oracle system graduand status to which the institution-defined status is mapped. System statuses drive specific functionality within the graduation subsystem, so this mapping is the functional heart of the row.
• CLOSED_IND — VARCHAR2 flag. When set, the status is closed and cannot be used in new or modified graduand records. This provides soft-disable behaviour without deleting the reference row.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, providing audit lineage.

The surrogate/primary key is GRADUAND_STATUS; the business-key candidate is the same column via IGS_GR_STAT_U1. No separate numeric surrogate key is documented.

Common Use Cases and Queries

This table is queried whenever graduand records must be decoded into meaningful status text, or when validating which statuses remain active for selection. Typical reporting includes graduation progress dashboards, status-code listings, and validation rules that exclude closed statuses. The documented query is:

SELECT GRADUAND_STATUS, DESCRIPTION, S_GRADUAND_STATUS, CLOSED_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS.IGS_GR_STAT;

Common filtered patterns include selecting only open statuses (WHERE CLOSED_IND = 'N') for dropdown lists, resolving the system mapping (WHERE S_GRADUAND_STATUS = :system_status) to find all institution codes mapped to a given Oracle behaviour, and joining to graduand records to produce readable status labels in reports.

Related Objects

The ETRM metadata states that IGS_GR_STAT does not reference any other database object (it is a standalone parent), but it is referenced by the APPS synonym IGS_GR_STAT and consumed by graduand processing objects within the graduation subsystem. The GRADUAND_STATUS column is the foreign-key target for graduand status assignments, and the S_GRADUAND_STATUS mapping ties each row to Oracle's system graduand statuses. Practically, the significant related objects are the graduand records that carry a GRADUAND_STATUS reference and the system-status lookup against which S_GRADUAND_STATUS is mapped; both join to IGS_GR_STAT on the GRADUAND_STATUS / S_GRADUAND_STATUS columns respectively. Because the table is dependency-free, it can be maintained, seeded, and reported upon in isolation, which simplifies migration and data-load operations across 12.1.1 and 12.2.2.