Search Results igs_en_usec_stat_dsp




Overview
Explore in AI Chat

Overview

The IGS.IGS_EN_USEC_STAT_DSP table is a configuration/reference table within the IGS (Student System) product family of Oracle E-Business Suite, available in both the 12.1.1 and 12.2.2 releases. Functionally, it governs the self-service display behavior of unit (course) section statuses during the online enrollment flow. Each row pairs a unit section status with a control flag that tells the Self-Service Enrollment application whether that status should be presented to the student, effectively acting as a display filter over the universe of enrollment statuses.

From a heuristic Data Vault modeling perspective, the FK structure mined from the metadata classifies this table as standalone — it has no outgoing foreign keys to other hubs or links and no incoming dependencies that would cast it as a link. This suggests it behaves as a reference hub combined with a small descriptive satellite: the business key (UNIT_SECTION_STATUS) is the anchor, and the display flag plus audit columns constitute the descriptive payload. It is not a transaction or intersection table.

Key Information Stored

The documented physical schema for 12.1.1 contains seven columns. The principal ones are:

  • UNIT_SECTION_STATUS — The business identifier of the enrollment status code (for example, values representing Open, Closed, Cancelled, Waitlisted, or similar section-level statuses). This is the natural/business key and is also the single column forming the composite of the primary key.
  • DISPLAYED — The governing control flag (Yes/No) that determines whether sections bearing this status appear to self-service students during enrollment. This is the functional payload of the record.
  • CREATED_BY — Standard EBS who-column identifying the application user who inserted the row.
  • CREATION_DATE — Standard EBS audit timestamp for row insertion.
  • LAST_UPDATED_BY — Application user who last modified the display configuration.
  • LAST_UPDATE_DATE — Timestamp of the most recent change, critical for auditing configuration drift.
  • LAST_UPDATE_LOGIN — Login/session identifier associated with the last update, used in EBS audit trails.

Regarding key structure: the primary key IGS_EN_USEC_STAT_DSP_PK is defined on the single column UNIT_SECTION_STATUS. The metadata additionally documents a unique index, IGS_EN_USEC_STAT_DSP_U1, also on UNIT_SECTION_STATUS. Because the PK and the unique index cover the same column, this table does not expose a separate surrogate primary key; the business key and the physical key are one and the same. This is a notable design point when the user searched for igs_en_usec_stat_dsp_pk — the constraint resolves to a business-key column rather than a generated sequence identifier.

Common Use Cases and Queries

Typical usage centers on self-service enrollment configuration and auditing which statuses are visible to students.

  • Display visibility lookup — Retrieve the current display rules:
SELECT unit_section_status, displayed
FROM   igs.igs_en_usec_stat_dsp
WHERE  displayed = 'Y';
  • Configuration audit — Identify recent changes to display rules using the who-columns:
SELECT unit_section_status, displayed, last_updated_by, last_update_date
FROM   igs.igs_en_usec_stat_dsp
ORDER BY last_update_date DESC;
  • Validation/reporting — Confirm that a section status shown in enrollment is present and enabled in this control table before publishing it to the student catalog.

Related Objects

The metadata classifies this table as standalone, so documented foreign-key relationships to other IGS objects are not enumerated. In practice, this reference table is consulted by Self-Service Enrollment components that resolve UNIT_SECTION_STATUS values against the enrollment status domain. Significant related objects include:

  • IGS_EN_USEC_STAT_DSP itself, joined to enrollment-status domain tables on UNIT_SECTION_STATUS.
  • Self-Service Enrollment status resolution logic (application layer) that reads the DISPLAYED flag.
  • Unit/section offering tables within the IGS Student System that supply candidate UNIT_SECTION_STATUS values.
  • EBS audit/who-column consumers (for example, audit reporting views) driven by LAST_UPDATE_DATE.

Because no FK relationships are documented, joins to this object should be performed on the business key UNIT_SECTION_STATUS rather than on a surrogate identifier.