Results for “step_override_type”

27 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_EN_ELGB_OVR_STEP table resides in the IGS schema (Oracle Student System) and stores enrollment eligibility override information at the level of individual validation steps. In Oracle E-Business Suite 12.1.1 and 12.2.2, when a student's enrollment eligibility is evaluated against a set of validation rules, certain steps may be manually or programmatically overridden. This table captures those step-level overrides, recording the specific override type, its effective date, and any limit applied. It is therefore a transactional detail table subordinate to the parent eligibility override record.

From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as a link — it connects override headers, unit offering options, and catalog unit/version context into a single association record. This classification should be treated as a modeling suggestion rather than an authoritative design.

Key Information Stored

The documented physical schema contains 17 columns. The most significant are:

Business-key candidates are defined by unique indexes: IGS_EN_ELGB_OVR_STEP_U1 (STEP_OVERRIDE_TYPE, ELGB_OVERRIDE_ID) and IGS_EN_ELGB_OVR_STEP_U2 (ELGB_OVR_STEP_ID). The composite U1 index suggests each override header may carry only one override of a given step type.

Common Use Cases and Queries

Typical scenarios include auditing which eligibility validation steps were overridden for a given student, and reporting override activity by unit offering. A representative query joining the parent header is:

  • SELECT s.ELGB_OVR_STEP_ID, s.ELGB_OVERRIDE_ID, s.STEP_OVERRIDE_TYPE, s.STEP_OVERRIDE_DT, s.UNIT_CD, s.VERSION_NUMBER FROM IGS.IGS_EN_ELGB_OVR_STEP s WHERE s.ELGB_OVERRIDE_ID = :p_override_id;
  • Filtering by step type: add AND s.STEP_OVERRIDE_TYPE = :p_type to isolate a specific validation override.
  • Joining to the parent header to retrieve student context: JOIN IGS.IGS_EN_ELGB_OVR_ALL a ON a.ELGB_OVERRIDE_ID = s.ELGB_OVERRIDE_ID.
  • Resolving the affected unit offering option via JOIN IGS.IGS_PS_UNIT_OFR_OPT_ALL o ON o.UOO_ID = s.UOO_ID.

Reporting use cases include override audit trails, enrollment exception monitoring, and reconciliation between header-level and step-level override records.

Related Objects

  • IGS_EN_ELGB_OVR_ALL — parent override header; joined on ELGB_OVERRIDE_ID.
  • IGS_PS_UNIT_OFR_OPT_ALL — unit offering option; joined on UOO_ID.
  • IGS_EN_ELGB_OVR_UOO — child/dependent table referencing this table via ELGB_OVR_STEP_ID.
  • Catalog unit/version context referenced through UNIT_CD and VERSION_NUMBER.

These relationships position IGS_EN_ELGB_OVR_STEP as the linking detail between override headers and the unit offerings they affect.