Search Results hold_rel_ovr_id




Overview
Explore in AI Chat

Overview

The IGS_PE_HOLD_REL_OVR table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product. It functions as an audit and control table for managing exceptions to standard institutional hold policies applied to a person or entity. Its primary role is to record instances where a system or administrative user has either overridden a hold to allow an action to proceed or has manually released a hold before its scheduled end date. This table is critical for maintaining compliance and providing a historical audit trail of all hold-related exceptions.

Key Information Stored

The table stores metadata and transactional details for each hold override or release event. The most critical columns include the unique identifier HOLD_REL_OVR_ID and the foreign key ELGB_OVERRIDE_ID, which links the action to a specific eligibility override record. The HOLD_TYPE column specifies the category of hold being managed, while HOLD_REL_OR_OVR is a flag indicating whether the action was a full 'Release' (R) or an 'Override' (O). Temporal data is captured in ACTION_DT (when the action was taken), HOLD_OLD_END_DT (the original expiration date, stored only for releases), and START_DATE. Standard EBS WHO columns track the creation and last update details for the record.

Common Use Cases and Queries

This table is central to reporting and troubleshooting scenarios involving hold management. A common operational use case is auditing all hold exceptions for a specific student or within a date range to ensure policy compliance. For reporting, administrators may need to join this table with person or enrollment data to analyze the frequency and types of overrides. A foundational query to retrieve all records is provided in the ETRM:

SELECT HOLD_REL_OVR_ID, ELGB_OVERRIDE_ID, HOLD_TYPE,
       HOLD_REL_OR_OVR, HOLD_OLD_END_DT, ACTION_DT
FROM IGS.IGS_PE_HOLD_REL_OVR;

For practical analysis, this query is typically extended with a JOIN to the IGS_EN_ELGB_OVR_ALL table on ELGB_OVERRIDE_ID to retrieve the person or entity context for the override action.

Related Objects

The IGS_PE_HOLD_REL_OVR table is part of a defined relational schema within the IGS (iGrants) module. Its documented relationships are primarily through foreign key constraints:

  • Primary Key: IGS_PE_HOLD_REL_OVR_PK on column HOLD_REL_OVR_ID.
  • Foreign Key (References): Column ELGB_OVERRIDE_ID references the IGS_EN_ELGB_OVR_ALL table, linking the hold action to a broader eligibility override context.
  • Foreign Key (References): Column HOLD_TYPE references the IGS_FI_ENCMB_TYPE_ALL table, which defines the valid hold/encumbrance types in the system.

These relationships are essential for constructing accurate joins in reports and for understanding the data's integrity within the application's business logic.