Search Results igs_gr_stat




Overview
Explore in AI Chat

Overview

IGS_GR_STAT is a reference (lookup) table in the IGS — Student System product family of Oracle E-Business Suite. As documented in the ETRM metadata, the entity "describes the statuses of a graduand" — that is, it holds the discrete lifecycle states that a graduating student (graduand) may occupy during the graduation process. Typical states in an academic graduation workflow include Applied, Eligible, Approved, Conferral Pending, Conferred, and Withdrawn, though the actual coded values are institution-defined and maintained as setup data.

The table resides in the IGS schema, is marked VALID, and carries 9 documented columns in the 12.1.1 physical schema. It is a pure validation/reference table: transactional graduation records point to a row in IGS_GR_STAT rather than storing a redundant description. The heuristic Data Vault classification mined from the foreign-key structure is standalone, which is consistent with its role as a low-volume code table. Where an integration or warehouse model is required, the most natural treatment is a small satellite-like dimension anchored on GRADUAND_STATUS, since there are no outbound foreign keys and the table is not itself a hub or a link.

Key Information Stored

  • GRADUAND_STATUS — the primary key column and the business key candidate. The unique index IGS_GR_STAT_U1 is defined on this column alone, and the primary key constraint IGS_GR_STAT_PK is also defined on GRADUAND_STATUS. It stores the internal status code used throughout the graduation subsystem.
  • DESCRIPTION — the user-facing, translatable text for the status, displayed in forms, LOVs, and reports.
  • S_GRADUAND_STATUS — the seeded/system status indicator, distinguishing delivered Oracle statuses from institution-defined ones.
  • CLOSED_IND — indicates whether the status is terminal (closed) for the graduand lifecycle; useful for filtering active versus completed graduands.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns providing audit lineage and supporting concurrent-program and audit reporting.

Because GRADUAND_STATUS is both the primary key and the sole unique business key, there is no separate surrogate identifier in the documented schema; the code itself is the surrogate. The remaining attributes are descriptive and audit-only.

Common Use Cases and Queries

The most frequent requirement is resolving a graduand status code to its description for operational and management reporting, and populating status LOVs in graduation maintenance forms.

  • Description lookup: SELECT description FROM igs_gr_stat WHERE graduand_status = :status_code;
  • Active status list for LOVs: SELECT graduand_status, description FROM igs_gr_stat WHERE NVL(closed_ind,'N') = 'N' ORDER BY description;
  • Status distribution reporting: join the status table to the graduand transaction table to count graduands per status.
  • Setup audit: identify seeded versus institution-defined statuses using S_GRADUAND_STATUS, and report recently modified rows using LAST_UPDATE_DATE.

Related Objects

The metadata documents no outbound foreign keys from IGS_GR_STAT, so it is a dependent reference table rather than a child of another entity. The objects listed below are the typical referencing and companion tables in the IGS — Student System graduation area; join on GRADUAND_STATUS in each case.

  • IGS_GR_GRADUANDS (or the equivalent graduand master table) — holds the graduand records and stores GRADUAND_STATUS as a foreign key to this table.
  • IGS_GR_GRADUAND_STAT_HIST — status history for graduands, retaining prior GRADUAND_STATUS values.
  • IGS_GR_APPLICANTS / graduation application tables — carry the current status reference through the conferral cycle.
  • IGS_GR_* setup tables — validation and lookup tables sharing the same S_* and CLOSED_IND conventions.
  • FND_LOOKUPS / IGS lookups — related flexfield and lookup infrastructure used for translated descriptions.
  • APIs and concurrent programs in the IGS graduation module — read GRADUAND_STATUS to enforce valid state transitions.

Any query or interface that consumes a graduand status should join to IGS_GR_STAT on GRADUAND_STATUS to obtain the DESCRIPTION and CLOSED_IND semantics.