Results for “dcnt_unit_ind”

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

Overview

IGS_EN_DCNT_REASONCD_ALL is a reference (lookup) table within the Oracle EBS Student System (IGS) product family. It stores the controlled vocabulary of validated reasons used when a student's course attempt is discontinued. Typical seed values include Non payment of fees, Voluntary withdrawal, and No tax file number specified. Because the table supplies the coded values that downstream enrollment records point to, it functions as a low-volume, slowly changing reference entity rather than a transactional table. Under the heuristic Data Vault classification mined from its foreign-key structure, the object is hub-leaning: it holds a stable business key with descriptive attributes, and it acts as a parent to at least one dependent satellite-style enrollment table.

Key Information Stored

The table is defined in the IGS schema with fifteen documented columns. The most significant are:

• DISCONTINUATION_REASON_CD — the primary key column and the business key; both the primary key constraint IGS_EN_DCNT_REASONCD_ALL_PK and the unique index IGS_EN_DCNT_REASONCD_ALL_U1 are defined on this single column. It is the value propagated into enrollment records.
• DESCRIPTION — the user-facing text of the discontinuation reason, used in lists of values and reports.
• DFLT_IND and SYS_DFLT_IND — flags identifying the user-default and system-default reason codes.
• S_DISCONTINUATION_REASON_TYPE — a translated/seed classification column describing the category of the reason.
• DCNT_PROGRAM_IND and DCNT_UNIT_IND — indicators controlling whether the reason is valid for discontinuing a program-level attempt versus a unit-level attempt.
• CLOSED_IND — a lifecycle flag that retires a reason code from active use without deleting its historical rows.
• COMMENTS — free-text administrative notes.
• ORG_ID — the operating unit or organization discriminator that makes this an _ALL (multi-org) table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle Applications WHO audit column set.

Common Use Cases and Queries

The primary use case is populating the Discontinuation Reason list of values on the course attempt discontinuation form and validating values entered programmatically. A typical lookup query restricts to active codes for a given operating unit:

SELECT DISCONTINUATION_REASON_CD, DESCRIPTION FROM IGS.IGS_EN_DCNT_REASONCD_ALL WHERE CLOSED_IND = 'N' AND ORG_ID = :org_id ORDER BY DESCRIPTION;

Reference-data reporting commonly joins the descriptive attributes back to enrollment activity. For example, counting discontinued course attempts by reason:

SELECT r.DESCRIPTION, COUNT(*) FROM IGS.IGS_EN_STDNT_PS_ATT_ALL a, IGS.IGS_EN_DCNT_REASONCD_ALL r WHERE a.DISCONTINUATION_REASON_CD = r.DISCONTINUATION_REASON_CD GROUP BY r.DESCRIPTION;

Administrators also query DFLT_IND and SYS_DFLT_IND to confirm which reason pre-populates on entry, and audit the WHO columns to reconcile reference-data changes introduced by patches or manual maintenance.

Related Objects

The documented foreign-key relationship establishes the principal dependency: IGS_EN_STDNT_PS_ATT_ALL carries the DISCONTINUATION_REASON_CD column as a foreign key into IGS_EN_DCNT_REASONCD_ALL. That student course attempt table is the transactional consumer of this reference data, and it is the object most frequently joined for enrollment analytics. Reporting views and extracts built over IGS_EN_STDNT_PS_ATT_ALL inherit the dependency, since they resolve the reason code to DESCRIPTION through this table. Because the primary key and the unique index are both defined on DISCONTINUATION_REASON_CD, the table participates as the parent side in validation of any concurrent or custom table that reuses that same column. Enrollment discontinuation concurrent programs and the IGS enrollment forms reference this table indirectly, and any concurrent process that loads course attempt discontinuations must resolve its reason code against the active, non-closed rows here.