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:
- ELGB_OVR_STEP_ID — surrogate primary key (via IGS_EN_ELGB_OVR_STEP_PK), uniquely identifying each step-level override record.
- ELGB_OVERRIDE_ID — foreign key to IGS_EN_ELGB_OVR_ALL, linking the step override to its parent override header.
- STEP_OVERRIDE_TYPE — identifies the category or nature of the step override applied during eligibility validation.
- STEP_OVERRIDE_DT — the date on which the step override takes effect.
- STEP_OVERRIDE_LIMIT — any numeric or threshold limit governing the override.
- UOO_ID — foreign key to IGS_PS_UNIT_OFR_OPT_ALL, identifying the unit offering option affected.
- UNIT_CD and VERSION_NUMBER — the catalog unit and version to which the override applies.
- Standard EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
- Concurrent program tracking: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.
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_typeto 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.
-
Contains the Enrollment Eligibility Override information for each validation step.
-
This view is used to capture the Enrollment Eligibility Override of system steps.
APPS.IGS_EN_ELGB_OVR_SYS_STEP_V·↳ IGS_EN_ELGB_OVR_STEP·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_EN_ELGB_OVR_STEP_V 12.1.1
Describes the Enrollment Category Eligibility Validation Override step Details
APPS.IGS_EN_ELGB_OVR_STEP_V·↳ IGS_EN_ELGB_OVR_STEP·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
This view is used to capture the Enrollment Eligibility Override of system steps.
Not implemented in this database·Explore IGS module →
-
Table: IGS_EN_ELGB_OVR_STEP 12.2.2
Contains the Enrollment Eligibility Override information for each validation step.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_EN_GEN_015 12.1.1
-
View: IGS_EN_ELGB_OVR_STEP_V 12.2.2
Describes the Enrollment Category Eligibility Validation Override step Details
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.