Search Results igs_en_elgb_ovr_all




Overview
Explore in AI Chat

Overview

The table IGS_EN_ELGB_OVR_ALL is a core data structure within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It serves as the central repository for recording and managing enrollment eligibility overrides. In the context of student administration, this table is critical for capturing exceptions to standard enrollment rules, allowing authorized users to permit a student's enrollment in a course or program when they would otherwise be deemed ineligible based on automated system validations. Its role is to provide an auditable trail of manual interventions in the enrollment process, ensuring data integrity while maintaining operational flexibility.

Key Information Stored

The table stores the master record for each eligibility override transaction. Its primary key is the system-generated identifier, ELGB_OVERRIDE_ID. The table's structure enforces a unique combination for a student within a specific academic calendar instance and operating unit, as defined by the unique key constraint on CAL_TYPE, CI_SEQUENCE_NUMBER, ORG_ID, and PERSON_ID. This design prevents duplicate override entries for the same student in the same academic context. While the provided metadata does not list all columns, the key fields indicate it stores the person identifier (PERSON_ID), the academic calendar instance (CAL_TYPE and CI_SEQUENCE_NUMBER), and the operating unit identifier (ORG_ID) to support the multi-org architecture of Oracle EBS.

Common Use Cases and Queries

A primary use case is generating reports on all eligibility overrides granted within a specific academic period or for a particular student, often for audit or academic review purposes. Administrators may query this table to understand the volume and nature of exceptions being applied. Common SQL patterns include joining to person (IGS_PE_PERSON) and calendar instance (IGS_CA_INST_ALL) tables to retrieve descriptive information. For example, a query to find overrides for a student would filter on PERSON_ID, while a report for an entire term would join on CAL_TYPE and CI_SEQUENCE_NUMBER. The table is also central to the enrollment engine's logic; when checking a student's eligibility, the system will reference this table to determine if a valid, active override exists that supersedes standard validation failures.

Related Objects

The IGS_EN_ELGB_OVR_ALL table maintains defined relationships with several other key tables in the Student System, as documented by its foreign key constraints.

  • References (Parent Table): IGS_CA_INST_ALL via columns CAL_TYPE and CI_SEQUENCE_NUMBER. This links each override to a specific academic calendar instance.
  • Referenced by (Child Tables):
    • IGS_EN_ELGB_OVR_STEP: Linked via ELGB_OVERRIDE_ID. This table likely stores detailed steps or specific eligibility criteria that were overridden for the master record.
    • IGS_PE_HOLD_REL_OVR: Linked via ELGB_OVERRIDE_ID. This table manages the relationship between an eligibility override and any student holds that were released as part of the override process.

These relationships form a cohesive data model where the IGS_EN_ELGB_OVR_ALL table acts as the header, with child tables providing granular detail on the override's scope and impact.