Search Results dsp_closed_ind




Overview
Explore in AI Chat

Overview

IGS_EN_DCNT_REASONCD_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 view owned by the APPS schema and defined within the Student Systems / Student Records (IGS) product family. It exposes the set of "discontinuation reason codes" used by the enrollment functions of Oracle Student System, combining each reason code record with its associated lookup meaning where a lookup relationship exists. The view is written as a UNION of two branches: rows whose S_DISCONTINUATION_REASON_TYPE is populated are joined to the IGS lookup view to obtain the lookup MEANING and the lookup's CLOSED_IND (aliased as DSP_CLOSED_IND), while rows whose type is NULL are returned with NULL MEANING and NULL DSP_CLOSED_IND.

Because it presents a stable, denormalized column list, the view is a reporting and integration surface rather than a transactional entity. Forms, concurrent programs, and external interfaces use it to render reason-code lists and to translate a stored code into a user-facing description without directly joining the lookup tables. The alias DSP_CLOSED_IND — the searched term — is the lookup-side closed indicator, distinct from the base table column CLOSED_IND exposed as CLOSED_IND on the same row.

Underlying Base Objects

The view is defined over two documented sources:

  • IGS_EN_DCNT_REASONCD dr — the primary table holding discontinuation reason code definitions, including description, default flags, closed indicator, type code, and audit columns.
  • IGS_LOOKUPS_VIEW lkups — the lookup view providing MEANING and CLOSED_IND for the code referenced by S_DISCONTINUATION_REASON_TYPE.

The first UNION branch restricts the join to lkups.LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE', lkups.LOOKUP_CODE = dr.S_DISCONTINUATION_REASON_TYPE, and lkups.CLOSED_IND = 'N', so only active (non-closed) lookups contribute a MEANING. The second branch covers reason codes with no type assignment, returning TO_CHAR(NULL) for MEANING and DSP_CLOSED_IND. The view preserves dr.ROWID as ROW_ID, enabling row-level identification of the base record.

Key Columns

  • ROW_ID — ROWID of the IGS_EN_DCNT_REASONCD row.
  • DISCONTINUATION_REASON_CD / DESCRIPTION — the code and its descriptive text.
  • DFLT_IND, SYS_DFLT_IND — default and system-default indicators.
  • CLOSED_IND — closed flag on the reason code record itself.
  • S_DISCONTINUATION_REASON_TYPE — the lookup type code linking to IGS_LOOKUPS_VIEW.
  • MEANING — lookup meaning; NULL when no type is set.
  • DSP_CLOSED_IND — lookup-side closed indicator (lkups.CLOSED_IND); NULL in the second UNION branch. Note that the first branch has already filtered lookups to CLOSED_IND = 'N', so this column is effectively 'N' whenever MEANING is present.
  • DCNT_PROGRAM_IND, DCNT_UNIT_IND — flags indicating applicability to program and unit discontinuation.
  • COMMENTS and standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical uses include populating reason-code LOVs, auditing which reason codes map to active lookups, and reconciling the two closed indicators. A representative query listing codes with their resolved lookup meaning follows:

  • Active reason codes with meanings:
    SELECT DISCONTINUATION_REASON_CD, DESCRIPTION, MEANING, CLOSED_IND, DSP_CLOSED_IND
    FROM APPS.IGS_EN_DCNT_REASONCD_V
    WHERE CLOSED_IND = 'N' ORDER BY DESCRIPTION;
  • Codes lacking a lookup type:
    SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM APPS.IGS_EN_DCNT_REASONCD_V WHERE S_DISCONTINUATION_REASON_TYPE IS NULL;
  • Program-applicable codes:
    SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM APPS.IGS_EN_DCNT_REASONCD_V WHERE DCNT_PROGRAM_IND = 'Y' AND CLOSED_IND = 'N';

Because DSP_CLOSED_IND is resolved from IGS_LOOKUPS_VIEW and filtered to 'N' in the UNION's first branch, it is useful chiefly as a reconciliation check against CLOSED_IND rather than as a filter for inactive lookups.