Search Results igs_en_elgb_ovr_uoo_u1

Overview

The IGS.IGS_EN_ELGB_OVR_UOO table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Student Administration module (often part of the Oracle Campus Solutions or Oracle Education product families). Its primary function is to store detailed unit and unit offering information associated with overridden enrollment eligibility steps. When an administrator overrides a standard system rule for a student's eligibility to enroll in a specific unit or course component, this table captures the precise unit details (code, version, offering) to which that override applies. It acts as a child table to the main eligibility override step definition, providing the granular linkage between an override action and the specific academic units affected.

Key Information Stored

The table's columns are designed to uniquely identify an override's unit context and capture specific override parameters. The primary and foreign key columns establish critical data integrity.

• ELGB_OVR_STEP_UOO_ID: The primary key, a system-generated unique identifier for each record in this table.
• ELGB_OVR_STEP_ID: A mandatory foreign key linking to the parent override step (IGS_EN_ELGB_OVR_STEP). This identifies which override action this unit detail record belongs to.
• UNIT_CD, VERSION_NUMBER, UOO_ID: Together, these columns precisely identify the academic unit. UNIT_CD and VERSION_NUMBER reference the unit definition (IGS_PS_UNIT_VER_ALL), while UOO_ID references the specific unit offering option (IGS_PS_UNIT_OFR_OPT_ALL).
• STEP_OVERRIDE_LIMIT: A crucial functional column that stores the override value for credit points. This is used when overriding limits for variable credit point units or for unit validation steps.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.

Common Use Cases and Queries

This table is central to reporting and auditing enrollment eligibility overrides. A common scenario involves identifying all unit-specific overrides granted for a particular student or academic period. Administrators may query this table to review overridden credit limits or to validate that overrides are correctly applied to the intended unit offerings. The following query pattern retrieves all unit details for a specific eligibility override step, joining to the unit tables for descriptive information:

SELECT ovr_uoo.*,
       uv.title AS unit_title,
       uoo.location_code,
       uoo.unit_class
FROM igs.igs_en_elgb_ovr_uoo ovr_uoo,
     igs.igs_ps_unit_ver_all uv,
     igs.igs_ps_unit_ofr_opt_all uoo
WHERE ovr_uoo.elgb_ovr_step_id = :p_override_step_id
AND ovr_uoo.unit_cd = uv.unit_cd
AND ovr_uoo.version_number = uv.version_number
AND ovr_uoo.uoo_id = uoo.uoo_id
ORDER BY ovr_uoo.unit_cd;

Another critical use case is data cleanup or validation, ensuring that no orphaned records exist where the parent override step has been deleted.

Related Objects

The IGS_EN_ELGB_OVR_UOO table maintains defined foreign key relationships with other core EBS tables, ensuring referential integrity within the enrollment eligibility framework.

• Parent Table (Foreign Key Reference): The ELGB_OVR_STEP_ID column is a foreign key to a parent eligibility override step table (not fully named in provided metadata but logically IGS_EN_ELGB_OVR_STEP). This defines the master override record.
• Referenced Tables:
  • IGS_PS_UNIT_OFR_OPT_ALL: The UOO_ID column references this table to link the override to a specific unit offering instance (e.g., a class section in a given term).
  • IGS_PS_UNIT_VER_ALL: The combination of UNIT_CD and VERSION_NUMBER references this table to link the override to the canonical definition and version of the academic unit.
• Indexes: The table is optimized for performance via two unique indexes: IGS_EN_ELGB_OVR_UOO_PK on the primary key and IGS_EN_ELGB_OVR_UOO_U1 on the combination of ELGB_OVR_STEP_ID, UNIT_CD, VERSION_NUMBER, and UOO_ID, enforcing uniqueness of unit details per override step.