Search Results igs_en_enrolment_cat




Overview
Explore in AI Chat

Overview

The IGS_EN_ENROLMENT_CAT table is a core configuration entity within the Oracle E-Business Suite Student System (IGS). It defines distinct categories or types of student enrollment, such as standard, research, continuing education, or exchange. Its primary role is to govern and differentiate the business processes, validations, and workflow steps applied during the enrollment of students. By assigning a student or a course application to a specific enrollment category, the system can enforce tailored rules for fee assessment, unit selection, academic progression, and reporting, making it a critical control point for managing diverse student populations and program types within the institution.

Key Information Stored

While the provided metadata does not list specific columns, the primary key is documented as ENROLMENT_CAT, which is the unique code identifying the category (e.g., 'STANDARD', 'RESEARCH'). Based on its described purpose, the table likely contains descriptive and control columns such as a description field (e.g., ENROLMENT_CAT_DESC), status indicators (e.g., CLOSED_IND), and various flags that activate or deactivate specific enrollment sub-processes. These flags would determine behaviors like whether financial holds are checked, prerequisite validations are enforced, or specific approval workflows are triggered for enrollments classified under this category.

Common Use Cases and Queries

This table is central to setup and operational reporting. Administrators use it to define and maintain the enrollment pathways available in the system. A common operational query involves joining this table to student or application records to report on enrollment distributions or to validate category assignments. For example, to list all active enrollment categories and their descriptions, a basic query would be: SELECT enrolment_cat, description FROM igs.igs_en_enrolment_cat WHERE closed_ind = 'N';. For troubleshooting, one might join to the IGS_EN_CAT_PRC_DTL table to review all process details linked to a specific category: SELECT * FROM igs_en_enrolment_cat cat, igs_en_cat_prc_dtl prc WHERE cat.enrolment_cat = prc.enrolment_cat AND cat.enrolment_cat = '&CAT_CODE';.

Related Objects

The IGS_EN_ENROLMENT_CAT table is referenced by several key tables via foreign key relationships, primarily using the ENROLMENT_CAT column. These relationships integrate the category definition with application, enrollment, and assessment data:

  • IGS_AD_PS_APPL_INST_ALL: Links the enrollment category to specific program application instances.
  • IGS_EN_CPD_EXT_ALL: Associates the category with continuing professional development extensions.
  • IGS_EN_CAT_MAPPING: Likely used for mapping enrollment categories to other system values or categories.
  • IGS_EN_CAT_PRC_DTL: A critical child table that stores the detailed process rules (e.g., fee calculation, validation) defined for each enrollment category.
  • IGS_AS_SC_ATMPT_ENR: Connects the enrollment category to student course attempt (enrollment) records in the assessment module.
These foreign keys ensure data integrity and enable the enrollment category to drive processes across the student lifecycle.