Search Results igs_en_elgb_ovr_step




Overview
Explore in AI Chat

Overview

The IGS_EN_ELGB_OVR_STEP table is a core data structure within the Oracle E-Business Suite 12.1.1 and 12.2.2, specifically for the now-obsolete IGS (Student System) module. Its primary function is to store granular details for overrides applied during the enrollment eligibility validation process. When a student's enrollment in a course or unit requires an exception to standard business rules, an administrator can create an eligibility override. This table records the specific validation steps (e.g., prerequisite checks, fee status, academic standing) that were bypassed or approved for each override, providing a detailed audit trail of the decision.

Key Information Stored

The table's design centers on linking an override to the specific validation steps it affects. The documented structure indicates several critical columns. The ELGB_OVERRIDE_ID is a foreign key that links the step record to its parent override header in the IGS_EN_ELGB_OVR_ALL table. The STEP_OVERRIDE_TYPE column, part of a unique key, defines the category or rule of the validation step being overridden. For overrides related to specific unit offerings, the UOO_ID (Unit Offering Option ID) links to the IGS_PS_UNIT_OFR_OPT_ALL table. Furthermore, the columns UNIT_CD and VERSION_NUMBER are referenced in a foreign key relationship, suggesting the table can also store override steps tied directly to a unit's version, independent of a specific offering instance. The surrogate primary key ELGB_OVR_STEP_ID ensures each record is uniquely identifiable.

Common Use Cases and Queries

This table is essential for auditing, troubleshooting, and generating compliance reports on enrollment exceptions. A common operational query would involve joining to the parent override table to list all overridden steps for a particular student or academic period. For example, to audit all eligibility overrides for a specific unit offering, a query might join IGS_EN_ELGB_OVR_STEP to IGS_EN_ELGB_OVR_ALL on ELGB_OVERRIDE_ID and filter by UOO_ID. Reporting use cases include analyzing the frequency of specific step overrides (STEP_OVERRIDE_TYPE) to identify overly restrictive or commonly bypassed business rules. System administrators might query this table to validate data integrity or as part of a data purge strategy for obsolete override records.

Related Objects

The table maintains defined relationships with several other key entities in the Student System, as per the provided metadata:

  • IGS_EN_ELGB_OVR_ALL: This is the parent header table. The foreign key IGS_EN_ELGB_OVR_STEP.ELGB_OVERRIDE_ID references IGS_EN_ELGB_OVR_ALL, establishing that each override step belongs to a master override record.
  • IGS_PS_UNIT_OFR_OPT_ALL: This table defines specific unit offerings. The foreign key on IGS_EN_ELGB_OVR_STEP.UOO_ID links an override step to a particular unit offering option, scoping the override's applicability.
  • Self-Referential / Unit Catalog: The metadata indicates foreign key columns for UNIT_CD and VERSION_NUMBER, suggesting a relationship to a unit definition table (not fully named in the excerpt, often IGS_PS_UNIT_VER). This allows override steps to be associated with a unit in the catalog broadly, rather than a specific offering.