Search Results igs_en_usec_stat_dsp_u1

Overview

IGS.IGS_EN_USEC_STAT_DSP is a configuration table within the Oracle E-Business Suite IGS (Intelligent Grants System / Student Systems) schema, deployed in the APPS_TS_TX_DATA tablespace. Its documented purpose is to hold the set of unit section statuses that may be presented to a self-service user during enrollment, together with a flag indicating whether each status is currently displayed. In practical terms, the table functions as a display-filter or allow-list that governs which enrollment records become visible through the self-service enrollment flow.

The object is classified as VALID in the ETRM 12.1.1 documentation and is registered under FND Design Data as IGS.IGS_EN_USEC_STAT_DSP. Because it exposes an APPS synonym (APPS.IGS_EN_USEC_STAT_DSP), it is intended to be queried and maintained through the APPS schema rather than the IGS owner directly. The heuristic Data Vault classification mined from the foreign-key structure is standalone; from a modeling perspective this suggests the row set behaves as an independent reference or lookup set (a hub-like reference entity) with no identifying links to other tables. The absence of outbound foreign keys confirms that the table carries its own business key rather than deriving identity from a parent.

Key Information Stored

The table is narrow, containing seven documented columns. The most important are:

• UNIT_SECTION_STATUS (VARCHAR2, 30) — the descriptive code for a unit section status. This column is mandatory, is the documented primary key component via IGS_EN_USEC_STAT_DSP_PK, and is also the column of the unique index IGS_EN_USEC_STAT_DSP_U1. It therefore serves simultaneously as the surrogate primary key and as the business-key candidate, ensuring one row per distinct status value.
• DISPLAYED (VARCHAR2) — the operational control flag indicating whether unit sections bearing the given status will be displayed for self-service enrollment. This is the column most frequently filtered or updated by administrators.
• CREATED_BY (NUMBER, 15), CREATION_DATE (DATE), LAST_UPDATED_BY (NUMBER, 15), LAST_UPDATE_DATE (DATE), LAST_UPDATE_LOGIN (NUMBER, 15) — the standard WHO audit columns recording row creation and last modification metadata.

No non-key attribute beyond DISPLAYED is functionally dependent on UNIT_SECTION_STATUS, which reinforces the lightweight, reference-data character of the table.

Common Use Cases and Queries

The primary use case is determining the enrollment-visible status set. A typical reporting query retrieves the active statuses as follows:

• SELECT UNIT_SECTION_STATUS, DISPLAYED FROM IGS.IGS_EN_USEC_STAT_DSP WHERE DISPLAYED = 'Y'; — returns the statuses exposed to self-service users.
• SELECT UNIT_SECTION_STATUS, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS.IGS_EN_USEC_STAT_DSP ORDER BY UNIT_SECTION_STATUS; — provides an audit view of configuration changes.
• A join pattern against enrollment records filters candidate sections: select unit section rows where the section's status exists in this table with DISPLAYED = 'Y'.

Administrators use direct DML against the APPS synonym to toggle the DISPLAYED flag when enrollment windows open or close, and developers reference the table to validate status-code membership.

Related Objects

The documented dependency data records that IGS_EN_USEC_STAT_DSP does not reference any other database object and is referenced only by its APPS synonym, APPS.IGS_EN_USEC_STAT_DSP. Consequently, the relationship set is intentionally minimal:

• APPS.IGS_EN_USEC_STAT_DSP — the synonym through which the table is accessed.
• IGS_EN_USEC_STAT_DSP_PK — primary key constraint on UNIT_SECTION_STATUS.
• IGS_EN_USEC_STAT_DSP_U1 — unique index on UNIT_SECTION_STATUS in APPS_TS_TX_IDX.

Because the object is standalone, join semantics with enrollment tables such as unit section offerings are implied by the shared UNIT_SECTION_STATUS value rather than enforced by declared foreign keys. Implementers should treat the status code as the logical join column and confirm referential expectations against the broader IGS enrollment model.