Search Results s_unit_set_status

Overview

IGS.IGS_EN_UNIT_SET_STAT is a reference (lookup) table in the Oracle E-Business Suite IGS schema that stores user-defined unit set statuses — for example, current or suspended. Unit set statuses are attributed to each version of an academic unit set in order to define its currency within the Oracle Student System (formerly Oracle Student Systems / OSS) and the broader ETRM (Education and Training Records Management) footprint. The object's role is to decouple the presentation layer from system behavior: an institution may define a large number of descriptive statuses, and each one maps back to one of a small number of system-recognized unit set statuses (PLANNED, INACTIVE, or ACTIVE) that drive application logic. This design lets implementers tailor status vocabulary without modifying seeded code.

Following Data Vault modeling heuristics derived from its foreign and primary key structure, IGS_EN_UNIT_SET_STAT is classified as a standalone table. It references no other database object, so it does not serve as a link. It is best modeled as a small reference or "hub-with-descriptive-attributes" structure, since its business key (UNIT_SET_STATUS) is self-contained and no foreign key relationships were identified.

Storage is defined in the APPS_TS_TX_DATA tablespace with PCT Free 10, and the unique index resides in APPS_TS_TX_IDX. The table is marked VALID.

Key Information Stored

The table contains nine documented columns. The most important are described below.

• UNIT_SET_STATUS (VARCHAR2(10), mandatory) — The user-defined unit set status code. This is both the surrogate primary key (IGS_EN_UNIT_SET_STAT_PK) and the business-key candidate, enforced by the unique index IGS_EN_UNIT_SET_STAT_U1. Because the primary key is the natural business code rather than a generated number, no separation between surrogate and business key exists here.
• S_UNIT_SET_STATUS (VARCHAR2(10)) — The system unit set status to which the user-defined value maps. Valid values are PLANNED, INACTIVE, or ACTIVE. This is the column that gives the table its functional weight, since application logic reads this value rather than the free-text user status.
• DESCRIPTION (VARCHAR2(60)) — Human-readable description of each status used to classify unit sets.
• CLOSED_IND (VARCHAR2) — Boolean indicator (Y/N checkbox) determining whether the status is open or closed. When closed, further unit sets cannot be assigned to the status.
• Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard Oracle EBS audit and concurrency tracking.

Common Use Cases and Queries

Typical uses center on validation and reporting. A common reporting query joins the user status to its system mapping to reconcile status vocabularies:

• Enumerate active statuses: SELECT UNIT_SET_STATUS, DESCRIPTION FROM IGS.IGS_EN_UNIT_SET_STAT WHERE S_UNIT_SET_STATUS = 'ACTIVE' AND NVL(CLOSED_IND,'N') = 'N';
• Find statuses that block assignment: filter on CLOSED_IND = 'Y' to identify unit sets that cannot receive new assignments.
• Audit configuration changes: order by LAST_UPDATE_DATE to detect recently modified status definitions.

The standard extracted query is:

SELECT UNIT_SET_STATUS, S_UNIT_SET_STATUS, DESCRIPTION, CLOSED_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS.IGS_EN_UNIT_SET_STAT;

Related Objects

The documented dependency metadata states that IGS_EN_UNIT_SET_STAT references no database object, so no foreign-key joins are supplied. It is, however, referenced by objects that consume its status values. Namely:

• APPS.IGS_EN_UNIT_SET_STAT — The APPS-level synonym/view that exposes the IGS table to application code and reports; this is the primary dependent object.

Because the table is flagged standalone, related unit-set version tables in the IGS schema that carry a unit set status attribute should be confirmed against local installation metadata, as no explicit FK linkage is documented here. Oracle proprietary information — refer to current ETRM documentation for authoritative relationships.