Search Results igs_en_usec_stat_dsp_v




Overview
Explore in AI Chat

Overview

The IGS_EN_USEC_STAT_DSP_V view is a student system (IGS) reporting object owned by the APPS schema in Oracle E-Business Suite. It exposes the set of unit section statuses that are eligible for display to self-service users during the enrollment process. The controlling attribute is the DISPLAYED flag on the underlying configuration table, which determines whether a given unit section status is surfaced to the student-facing enrollment flow.

In the context of a search for unit_section_status, this view is the canonical exposed surface for the UNIT_SECTION_STATUS lookup values that carry a display preference. Because the view joins the configuration table to the standard lookup view, it returns every defined UNIT_SECTION_STATUS lookup code with its associated meaning, along with the display flag (defaulting to N when no explicit display record exists). This enables reporting and integration consumers to distinguish statuses that the institution intends to show to self-service enrollment users from those reserved for administrative or back-office processing.

Underlying Base Objects

The view is defined over a single base table joined to a lookup view:

  • IGS_EN_USEC_STAT_DSP — the configuration table holding the institution-specific display settings for unit section statuses. The view aliases this table as USTAT. It supplies the UNIT_SECTION_STATUS code, the DISPLAYED flag, and the standard WHO audit columns.
  • IGS_LOOKUPS_VIEW — the standard IGS lookup view, aliased LKUP, filtered to LOOKUP_TYPE = 'UNIT_SECTION_STATUS'. This provides the LOOKUP_CODE and human-readable MEANING for each status.

The join is performed as an outer join on the configuration table (USTAT.UNIT_SECTION_STATUS(+)), which means the view returns the full lookup list of unit section statuses regardless of whether a display configuration row exists. Where no configuration row is present, the display column resolves to N via the NVL expression. No base objects beyond these two are documented for the view.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_EN_USEC_STAT_DSP record, used for row identification in EBS forms and DML operations.
  • LOOKUP_CODE — the code value of the unit section status from IGS_LOOKUPS_VIEW.
  • UNIT_SECTION_STATUS — the unit section status code sourced from the configuration table.
  • MEANING — the descriptive, user-facing meaning of the lookup code.
  • DISPLAYED — the display indicator. Values are typically Y (shown to self-service users) or N (hidden). Returns N by default when no configuration row exists.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical uses include validating which unit section statuses drive self-service enrollment display, configuring institution-specific behavior, and building reports that separate visible from hidden statuses.

Retrieve all statuses that are displayed to self-service users:

SELECT LOOKUP_CODE, MEANING, DISPLAYED
FROM   APPS.IGS_EN_USEC_STAT_DSP_V
WHERE  DISPLAYED = 'Y';

List the full lookup set with effective display state, including statuses with no configuration row:

SELECT UNIT_SECTION_STATUS, MEANING, DISPLAYED
FROM   APPS.IGS_EN_USEC_STAT_DSP_V
ORDER  BY MEANING;

Identify statuses hidden from self-service enrollment for audit purposes:

SELECT LOOKUP_CODE, MEANING
FROM   APPS.IGS_EN_USEC_STAT_DSP_V
WHERE  DISPLAYED = 'N';

Because the view defaults undiscovered statuses to N, it is a reliable single source for determining exactly which unit_section_status codes are visible, without needing a separate lookup query.