Search Results igs_en_cpd_ext_all




Overview
Explore in AI Chat

Overview

The IGS_EN_CPD_EXT_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as the central repository for defining and storing enrollment eligibility setup information. This table is critical for configuring the business rules and prerequisites that determine a student's eligibility to enroll in specific academic programs, courses, or units. Its role is to establish the linkage between enrollment categories, enrollment methods, and the underlying rule-based logic that governs the enrollment process, thereby enforcing institutional academic policies within the system.

Key Information Stored

The table stores configuration data that defines the parameters for enrollment eligibility checks. Key columns include the surrogate primary key IGS_EN_CPD_EXT_ID and the unique key combination that defines a specific eligibility setup: ENROLMENT_CAT (enrollment category), ENR_METHOD_TYPE (enrollment method type), ORG_ID (operating unit identifier for multi-org architecture), S_ENROLMENT_STEP_TYPE, and S_STUDENT_COMM_TYPE. Crucially, it references the Rules Engine (IGS_RU) module via RUL_SEQUENCE_NUMBER and S_RULE_CALL_CD, which point to the specific validation rule (IGS_RU_RULE) and its calling context (IGS_RU_CALL) that must be evaluated to confirm eligibility.

Common Use Cases and Queries

This table is primarily accessed during enrollment processing to validate a student's request against established criteria. A common use case is to retrieve the eligibility rule for a given enrollment scenario. For reporting, administrators may query this table to audit or document the enrollment eligibility configurations across different programs or organizational units. A typical SQL pattern involves joining to the referenced lookup and rule tables to get descriptive information.

  • Sample Query: Retrieving the rule details for a specific enrollment category and method. 
    SELECT ext.*, cat.enrolment_cat_desc, mt.description method_desc
FROM igs.igs_en_cpd_ext_all ext,
     igs.igs_en_enrolment_cat cat,
     igs.igs_en_method_type mt
WHERE ext.enrolment_cat = cat.enrolment_cat
  AND ext.enr_method_type = mt.enr_method_type
  AND ext.org_id = 123
  AND ext.enrolment_cat = 'STANDARD';

Related Objects

The IGS_EN_CPD_EXT_ALL table maintains integral relationships with several key tables via foreign key constraints, as documented in the ETRM metadata.

  • IGS_EN_ENROLMENT_CAT: Joined via IGS_EN_CPD_EXT_ALL.ENROLMENT_CAT. Provides descriptive details for the enrollment category.
  • IGS_EN_METHOD_TYPE: Joined via IGS_EN_CPD_EXT_ALL.ENR_METHOD_TYPE. Defines the type of enrollment method (e.g., online, administrative).
  • IGS_RU_RULE: Joined via IGS_EN_CPD_EXT_ALL.RUL_SEQUENCE_NUMBER. Links to the specific rule sequence number that encapsulates the eligibility logic.
  • IGS_RU_CALL: Joined via IGS_EN_CPD_EXT_ALL.S_RULE_CALL_CD. Identifies the rule-calling context within the Rules Engine framework.