Search Results elgb_ovr_step_uoo_id

Overview

The table IGS_EN_ELGB_OVR_UOO is a data object within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically belonging to the now-obsolete IGS (Student System) product family. Its primary function is to store detailed information related to the manual overriding of enrollment eligibility rules at the unit offering level. In the context of student administration, the system enforces a series of eligibility steps or criteria that a student must satisfy before being permitted to enroll in a specific unit or class section. This table acts as an audit and control mechanism, recording instances where an administrator has explicitly overridden these automated checks for a particular unit section (UOO), thereby authorizing an enrollment that would otherwise be blocked by the system's standard validation logic.

Key Information Stored

The table's structure is designed to link an override action to the precise academic unit and its offering instance. The primary identifier is the ELGB_OVR_STEP_UOO_ID, which uniquely defines each override record. The table also stores the core academic identifiers to pinpoint the affected unit section: the UNIT_CD (unit code), VERSION_NUMBER (unit version), and UOO_ID (unit offering option ID, representing a specific class section). These columns form a unique key (IGS_EN_ELGB_OVR_UOO_UK1) alongside the primary key, ensuring data integrity for the combination of an override step and its associated unit offering details. The metadata indicates this table was not implemented in the referenced database, suggesting it may represent a legacy or planned data model that was not deployed in all instances.

Common Use Cases and Queries

The primary use case is administrative reporting and audit trails for non-standard enrollments. A system administrator or academic auditor might query this table to identify all enrollment eligibility overrides performed for a specific unit or within a given academic period. A typical query would join this table to the unit offering (IGS_PS_UNIT_OFR_OPT_ALL) and unit version (IGS_PS_UNIT_VER_ALL) tables to retrieve descriptive information. For example, to find all overrides for a unit code 'MATH101', one might use a SQL pattern such as: SELECT ovr.*, uoo.* FROM igs_en_elgb_ovr_uoo ovr JOIN igs_ps_unit_ver_all uv ON ovr.unit_cd = uv.unit_cd AND ovr.version_number = uv.version_number JOIN igs_ps_unit_ofr_opt_all uoo ON ovr.uoo_id = uoo.uoo_id WHERE ovr.unit_cd = 'MATH101';. This supports compliance reporting and analysis of exception-based enrollment practices.

Related Objects

IGS_EN_ELGB_OVR_UOO maintains defined foreign key relationships with core academic structures in the Student System, ensuring referential integrity. The documented relationships are:

• IGS_PS_UNIT_OFR_OPT_ALL: The UOO_ID column in IGS_EN_ELGB_OVR_UOO references the IGS_PS_UNIT_OFR_OPT_ALL table. This links each override record to a specific unit offering option (class section).
• IGS_PS_UNIT_VER_ALL: The UNIT_CD and VERSION_NUMBER columns in IGS_EN_ELGB_OVR_UOO together reference the IGS_PS_UNIT_VER_ALL table. This links the override to the master definition and version of the academic unit.

These relationships are critical for contextualizing the override data within the broader academic catalog and schedule.