Search Results igs_en_dcnt_reasoncd_all




Overview
Explore in AI Chat

Overview

The table IGS_EN_DCNT_REASONCD_ALL is a core reference entity within the Oracle E-Business Suite Student System (IGS). It serves as a master repository for all valid reason codes that explain why a student's enrollment in a program or course attempt is formally discontinued. This table is critical for maintaining data integrity and providing meaningful analytics on student attrition and withdrawal patterns. By standardizing discontinuation reasons across the application, it ensures consistent reporting and supports operational processes related to student status management. Its role is foundational to the enrollment and student records modules, acting as a key lookup for the primary student academic progression table.

Key Information Stored

The primary data stored in this table consists of standardized discontinuation reason codes and their descriptions. The central column is DISCONTINUATION_REASON_CD, which serves as the unique primary key for the table. Each code is associated with a descriptive meaning, such as "Non payment of fees," "Voluntary withdrawal," or "No tax file number specified," as noted in the documentation. While the specific column list is not fully detailed in the provided metadata, typical columns in such a reference table would include the code, a description, an effective date range (START_DATE, END_DATE), an active/inactive indicator, and creation/modification audit columns. The table supports the multi-org architecture in EBS, as indicated by the "_ALL" suffix, meaning it can store data for multiple operating units.

Common Use Cases and Queries

The primary use case is to validate and categorize the reason for a student discontinuing their course attempt. This is essential for administrative reporting, regulatory compliance, and academic analysis. Common operational reports include summaries of withdrawal reasons by academic period, school, or program. A typical query would join this table to the student course attempt table to translate the stored code into a readable description for a report.

Sample SQL Pattern:
SELECT st.column1,
st.DISCONTINUATION_REASON_CD,
rea.DESCRIPTION
FROM IGS_EN_STDNT_PS_ATT_ALL st,
IGS_EN_DCNT_REASONCD_ALL rea
WHERE st.DISCONTINUATION_REASON_CD = rea.DISCONTINUATION_REASON_CD
AND st.ENROLLMENT_CATEGORY = 'STANDARD';

Data maintenance tasks involve an administrator querying this table to retrieve the current list of active reason codes or inserting a new code to accommodate a new withdrawal scenario.

Related Objects

The table has a direct and critical relationship with the core student academic record table. As documented in the foreign key metadata:

  • Primary Key: IGS_EN_DCNT_REASONCD_ALL_PK on column DISCONTINUATION_REASON_CD.
  • Foreign Key Relationship: The table IGS_EN_STDNT_PS_ATT_ALL (Student Program Attempt) references IGS_EN_DCNT_REASONCD_ALL. The foreign key column is IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD. This enforces that any reason code recorded against a student's discontinued program attempt must exist as a valid code in the IGS_EN_DCNT_REASONCD_ALL table.

This relationship is fundamental to the data model, ensuring referential integrity for all student discontinuation records across the Student System.