Search Results igs_en_dcnt_reasoncd_v




Overview
Explore in AI Chat

Overview

IGS_EN_DCNT_REASONCD_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family, historically delivered as part of the Oracle Student System / Enterprise Enrollment module. In ETRM metadata for releases 12.1.1 and 12.2.2 the object is classified under IGS – Student System (Obsolete), and the metadata explicitly states that it is not implemented in the current database. Its single documented purpose is to consolidate the reasons that may be selected when a student discontinues a course or a unit.

The view exposes discontinuation reason codes together with their descriptive attributes, default indicators, closed indicators, program-level and unit-level applicability flags, and the lookup translation of the associated discontinuation reason type. Because it presents a denormalized, lookup-joined projection of the underlying reason code entity, it serves reporting, validation, and integration consumers that need a ready-to-read list of valid discontinuation reasons without re-implementing the lookup joins themselves. Like most IGS views, it is a read-only construct intended for query and reference rather than for direct DML.

Underlying Base Objects

The documented view text is defined over two objects:

  • IGS_EN_DCNT_REASONCD — the primary base table holding reason code records, aliased DR. It supplies the reason code, description, default and system default indicators, closed indicator, reason type, comments, course/unit applicability flags, and standard WHO audit columns.
  • IGS_LOOKUPS_VIEW — a lookup view aliased LKUPS, joined to IGS_EN_DCNT_REASONCD on the lookup code and restricted to LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE' and CLOSED_IND = 'N'.

The definition is a UNION of two branches. The first branch returns rows whose S_DISCONTINUATION_REASON_TYPE is not null and joins to the lookup view to populate MEANING and DSP_CLOSED_IND with the translated reason type and the lookup's closed indicator. The second branch returns rows where S_DISCONTINUATION_REASON_TYPE is null and substitutes TO_CHAR(NULL) for MEANING and DSP_CLOSED_IND. Rows are keyed by DR.ROWID as ROW_ID. The ETRM metadata documents no referenced base objects beyond these two, and no additional objects should be assumed.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_EN_DCNT_REASONCD row; used as a surrogate row identifier.
  • DISCONTINUATION_REASON_CD — the reason code identifier that answers the user's search term "discontinuation_reason_cd".
  • DESCRIPTION — the user-facing description of the reason.
  • DFLT_IND / SYS_DFLT_IND — flags marking the default and system default reason, respectively.
  • CLOSED_IND — indicates whether the reason code itself is closed (inactive).
  • S_DISCONTINUATION_REASON_TYPE — the lookup code classifying the reason type.
  • MEANING / DSP_CLOSED_IND — the translated lookup meaning for the reason type and the lookup's closed indicator; both are null when the reason type is null.
  • COMMENTS — free-text notes on the reason.
  • DCNT_PROGRAM_IND / DCNT_UNIT_IND — flags indicating applicability to programs and to units.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical consumers use this view to populate LOVs, validate discontinuation input, and drive extracts for enrollment reporting. A simple listing of active reasons within a specific reason type can be produced with:

  • SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS_EN_DCNT_REASONCD_V WHERE CLOSED_IND = 'N' ORDER BY DESCRIPTION;
  • SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS_EN_DCNT_REASONCD_V WHERE MEANING = :reason_type AND CLOSED_IND = 'N';
  • SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS_EN_DCNT_REASONCD_V WHERE DFLT_IND = 'Y';

For program- or unit-specific validation, add predicates on DCNT_PROGRAM_IND and DCNT_UNIT_IND. Because the object is documented as obsolete and not implemented in the current database, these queries are meaningful only in environments where the IGS Student System schema objects remain deployed.