Search Results igs_en_config_enr_cp




Overview
Explore in AI Chat

Overview

The table IGS_EN_CONFIG_ENR_CP is a core data object within the Oracle E-Business Suite Student System (IGS) module. It serves a critical function in managing student enrollment by storing configuration rules that override standard credit point calculations for specific academic programs. Its primary role is to define enrollment credit point overrides for a given Load Calendar, enabling institutions to tailor academic load requirements based on the specific calendar, course, and version. This table is essential for ensuring accurate enrollment status determination, fee assessments, and compliance with institutional policies that may vary across different academic calendars and course offerings.

Key Information Stored

The table's structure is designed to uniquely identify an override rule and specify the credit point parameters. The primary key columns are COURSE_CD, VERSION_NUMBER, and CAL_TYPE, which together define the specific course version and calendar type for which the override applies. Based on standard implementation patterns, the table likely contains additional columns to store the actual credit point values, such as minimum and maximum credit points for full-time or part-time enrollment statuses, and effective date controls. The foreign key relationship on the CAL_TYPE column to the IGS_CA_TYPE table ensures referential integrity, linking the override to a valid calendar type within the system.

Common Use Cases and Queries

This table is primarily accessed during enrollment processing and reporting to determine a student's correct academic load. A common operational use case is during the unit enrollment process, where the system queries this table to check if a student's selected course and calendar have specific credit point limits that differ from the standard configuration. For reporting, administrators may query it to audit or list all customized enrollment rules. A typical SQL pattern would involve joining to the calendar and course tables for descriptive information:

  • SELECT cep.*, ct.s_cal_cat FROM igs.igs_en_config_enr_cp cep JOIN igs.igs_ca_type ct ON cep.cal_type = ct.cal_type WHERE course_cd = :p_course;
  • SELECT * FROM igs.igs_en_config_enr_cp WHERE cal_type = 'SEMESTER' AND version_number = 1;

Related Objects

The IGS_EN_CONFIG_ENR_CP table has defined relationships with several other key EBS objects. Its primary foreign key dependency is on the IGS_CA_TYPE table, which defines calendar types. It is also intrinsically linked to core student entities, likely referenced by or referencing tables such as IGS_EN_STDNT_PS_ATT (student program attempts) for load calculation and IGS_PS_VER (course versions) for course definition. The primary key constraint IGS_EN_CONFIG_ENR_CP_PK enforces uniqueness for the combination of course, version, and calendar. Processes within the enrollment engine and related APIs will query this table to apply the correct credit point logic during academic transactions.