Search Results dcnt_program_ind

Overview

The IGS_EN_DCNT_REASONCD view is a secured, organization-aware reporting object within the Oracle E-Business Suite Student System (IGS) product family. It exposes the catalog of discontinuation reason codes that drive student enrollment discontinuation processing — the codes an institution assigns when a student withdraws from, drops, or otherwise discontinues a program or a unit. The view is owned by the APPS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2.

Its principal role is to present the discontinuation reason code set filtered by the multi-org security context of the connected session, rather than returning every row defined across all operating units. The final predicate of the view compares ORG_ID against the operating unit derived from the USERENV('CLIENT_INFO') session attribute, using an NVL pattern that substitutes -99 when no operating unit is resolvable. This makes the view suitable for use inside Oracle Forms-based IGS windows, concurrent programs, and institution-built reports where the active organization must be respected implicitly.

Underlying Base Objects

The view is defined over a single documented base object: IGS_EN_DCNT_REASONCD_ALL. That table holds the full, unrestricted set of discontinuation reason code definitions across all operating units, including the descriptive and control attributes for each code. The view adds no joins; it is a projection of the base table's columns plus a ROWID alias, constrained by the organization security predicate described above.

Because the mapping is effectively one-to-one for rows visible to the current operating unit, the view can be treated as the secured access layer over IGS_EN_DCNT_REASONCD_ALL. The _ALL suffix on the base table confirms that organization-level partitioning occurs at the table level through the ORG_ID column, and the view simply enforces the appropriate subset for the session.

Key Columns

• ROW_ID — the ROWID of the underlying base-table row, surfaced under an alias for use as a unique row identifier.
• ORG_ID — the operating unit that owns the reason code; the same logical code may exist independently per organization.
• DISCONTINUATION_REASON_CD — the code value itself, the primary business identifier for the reason.
• DESCRIPTION — the user-facing description of the discontinuation reason.
• DFLT_IND — indicates whether the code is the default reason presented during entry.
• S_DISCONTINUATION_REASON_TYPE — the reason type classification used to group codes by category.
• SYS_DFLT_IND — system-level default flag, distinguishing seeded system defaults from user-defined defaults.
• CLOSED_IND — indicates whether the reason code has been closed and should no longer be selectable.
• COMMENTS — free-text notes attached to the code definition.
• DCNT_PROGRAM_IND — indicates the reason is applicable when a student discontinues a program.
• DCNT_UNIT_IND — indicates the reason is applicable when a student discontinues a unit.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include populating discontinuation reason lists of values in enrollment forms, validating a submitted reason code against the organization's active set, and driving reports that summarize student discontinuations by reason. The DCNT_PROGRAM_IND and DCNT_UNIT_IND flags support splitting the catalog for program-level versus unit-level discontinuation screens.

Selecting all active reasons for the current operating unit:

SELECT discontination_reason_cd, description, dflt_ind
FROM   apps.igs_en_dcnt_reasoncd
WHERE  closed_ind = 'N'
ORDER  BY description;

Isolating the default program-discontinuation reason:

SELECT discontination_reason_cd, description
FROM   apps.igs_en_dcnt_reasoncd
WHERE  dflt_ind = 'Y'
AND    dcnt_program_ind = 'Y';

Because security filtering relies on CLIENT_INFO, queries run through tools that do not set that session attribute may return only the null-organization rows. Report developers should therefore initialize the client information or query IGS_EN_DCNT_REASONCD_ALL with an explicit ORG_ID predicate when a specific organization must be targeted regardless of session context.