Results for “igs_en_dcnt_reasoncd_all_u1”

6 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_EN_DCNT_REASONCD_ALL is a reference (lookup) table within the Oracle E-Business Suite Student Systems / Enterprise Talent Relationship Management (ETRM) schema, owned by the IGS product. It stores the institution-defined list of reasons why a student's program attempt may be discontinued. Typical entries include non-payment of fees, voluntary withdrawal, transfer to another program, or failure to supply a tax file number. The table functions as a validation source for discontinuation reason codes and supports both open and closed reason sets, defaulting logic, and system-defined reason type mapping.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as hub-leaning. It carries a stable, unique business key (DISCONTINUATION_REASON_CD) that is referenced by transactional records, which suggests treating it as a hub for the discontinuation reason concept, with descriptive attributes (DESCRIPTION, COMMENTS, indicator flags) optionally split into a satellite. This is a suggested classification only; the physical table combines hub and descriptive columns in a single denormalized structure.

Key Information Stored

The table is uniquely identified by the primary key IGS_EN_DCNT_REASONCD_ALL_PK on DISCONTINUATION_REASON_CD, and the unique index IGS_EN_DCNT_REASONCD_ALL_U1 reinforces that column as the single business-key candidate. This is the column consumers search for and join against.

  • DISCONTINUATION_REASON_CD (VARCHAR2 10, PK): the institution-defined reason code.
  • DESCRIPTION (VARCHAR2 60): human-readable text displayed to users for the reason.
  • DFLT_IND: indicates whether this code is the institution's default discontinuation reason.
  • S_DISCONTINUATION_REASON_TYPE (VARCHAR2 30): system-defined reason type (for example, TRANSFER used when a program attempt is discontinued by the transfer process).
  • SYS_DFLT_IND: identifies the institution-defined code that system functionality auto-assigns for a given system-defined reason type.
  • CLOSED_IND: controls whether the reason is open or closed; a closed reason cannot be applied to new or modified discontinuation records.
  • COMMENTS (VARCHAR2 2000): free-text notes describing the reason.
  • DCNT_PROGRAM_IND and DCNT_UNIT_IND: flags governing applicability of the reason to program-level and unit/course-level discontinuations respectively.
  • ORG_ID: the operating unit that owns the reason row, supporting multi-org partitioning.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN: standard WHO audit columns.

Common Use Cases and Queries

The primary use case is populating discontinuation reason list-of-values controls in student program attempt forms and self-service pages. Reporting users frequently need the descriptive text alongside transaction data, and administrators manage the open/closed and default flags.

Retrieving active, default reason codes:

  • SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS.IGS_EN_DCNT_REASONCD_ALL WHERE CLOSED_IND = 'N' AND ORG_ID = :p_org ORDER BY DESCRIPTION;
  • SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS.IGS_EN_DCNT_REASONCD_ALL WHERE SYS_DFLT_IND = 'Y' AND S_DISCONTINUATION_REASON_TYPE = 'TRANSFER';

A common join resolves a student program attempt to its reason description:

Related Objects

The most significant referencing object is the student program attempt table, which carries the foreign key DISCONTINUATION_REASON_CD pointing to this lookup.

  • IGS.IGS_EN_STDNT_PS_ATT_ALL — the core student program attempt table; joins on DISCONTINUATION_REASON_CD to obtain reason text and defaults.
  • IGS_EN_DCNT_REASONCD_ALL_PK — the primary key constraint on DISCONTINUATION_REASON_CD.
  • IGS_EN_DCNT_REASONCD_ALL_U1 — the unique index on DISCONTINUATION_REASON_CD used for fast lookup and integrity.
  • Institution-defined reason type and system-mapped reason configuration tables in the IGS schema, consulted through S_DISCONTINUATION_REASON_TYPE and SYS_DFLT_IND.
  • Discontinuation reason list-of-values and validation APIs in the Student Systems modules that reference this table for code validation.

Because it is a low-volume reference table, maintenance is typically performed by institutional configuration administrators rather than through high-frequency application inserts.