Search Results igs_ps_rsv_ext_pk

Overview

IGS_PS_RSV_EXT is a table within the Oracle E-Business Suite Student System (IGS) product family, historically used to manage reserve seating categories associated with unit offerings in an academic institution. The table records the number of seats allocated to each reserve seating category, enabling institutions to ring-fence capacity for specific applicant groups — for example, students admitted under a particular preference scheme, quota, or priority band. Its documented description states that it "contains the seats used for each reserve seating category."

Within the ETRM 12.1.1 and 12.2.2 documentation, this object is flagged as part of the Obsolete Student System component and is explicitly noted as "Not implemented in this database." This means that in many EBS installations, particularly those that have migrated to Oracle Student Cloud or later replacements, the table may not exist physically. When present, the entity sits beneath the unit offering option layer, tying a reserve category to a specific offering option.

From a Data Vault modelling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. The table keys off a parent offering option (UOO_ID) and carries descriptive attributes such as RSV_LEVEL and seat counts, which is characteristic of a satellite attached to a hub or link rather than a hub in its own right.

Key Information Stored

The table contains eleven documented columns in the 12.1.1 physical schema. The most significant are:

• RSV_EXT_ID — surrogate primary key, defined by IGS_PS_RSV_EXT_PK, uniquely identifying each reserve extension record.
• UOO_ID — foreign key to IGS_PS_UNIT_OFR_OPT_ALL, identifying the unit offering option to which the reserve seating applies.
• PRIORITY_ID — identifies the priority band governing the reserve category; this is the column most associated with the user search term.
• PREFERENCE_ID — identifies the preference category under which seats are reserved.
• RSV_LEVEL — indicates the level at which the reservation is applied, forming part of the business key.
• ACTUAL_SEAT_ENROLLED — records the number of seats actually consumed within the reserve category.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking record creation and modification.

The unique index IGS_PS_RSV_EXT_U1 (PREFERENCE_ID, PRIORITY_ID, RSV_LEVEL, UOO_ID) constitutes the business-key candidate, ensuring a reserve category is defined once per preference, priority, level, and offering option combination. The surrogate RSV_EXT_ID remains the technical identifier referenced by dependent tables.

Common Use Cases and Queries

Typical usage involves reporting seat allocation against offering options, reconciling reserved capacity with actual enrolment, and extracting priority-based reservation data for admissions analysis.

A representative query joins the table to its parent offering option:

• SELECT r.RSV_EXT_ID, r.UOO_ID, r.PRIORITY_ID, r.PREFERENCE_ID, r.RSV_LEVEL, r.ACTUAL_SEAT_ENROLLED FROM IGS_PS_RSV_EXT r WHERE r.PRIORITY_ID = :priority_id;
• Aggregate reserved versus enrolled seats grouped by PRIORITY_ID and PREFERENCE_ID to assess fill rates.
• Join to IGS_PS_UNIT_OFR_OPT_ALL on UOO_ID to resolve the offering option and its parent unit offering for institutional reporting.
• Join to IGS_PS_RSV_TEMP on RSV_EXT_ID to trace temporary reserve calculations produced during admission processing.

Because the object is obsolete in documented environments, report developers should verify table existence and row counts before incorporating it into production extracts.

Related Objects

• IGS_PS_UNIT_OFR_OPT_ALL — referenced via UOO_ID; the parent offering option dimension.
• IGS_PS_RSV_TEMP — references IGS_PS_RSV_EXT via RSV_EXT_ID, holding temporary reserve extension data.
• IGS_PS_RSV_EXT_PK / IGS_PS_RSV_EXT_UK / IGS_PS_RSV_EXT_U1 — primary, unique, and business-key constraints enforcing integrity.
• IGS_PS_UNIT_OFR_OPT family tables and admission preference/priority reference tables that resolve PREFERENCE_ID and PRIORITY_ID values for reporting joins.