Search Results rsv_level

Overview

IGS.IGS_PS_RSV_EXT is a transactional table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Higher Education / Student System (IGS) schema. It occupies the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and records the seats consumed against each reserve seating category. In the terminology of Oracle's reserve seating setup, a reservation is composed of a priority and a preference defined at a particular organizational level; IGS_PS_RSV_EXT captures the actual enrollment volume measured against that combination for a specific unit offering option. Because the table stores measured facts (seats enrolled) that describe a combination of reference entities rather than the entities themselves, the supplied metadata classifies it heuristically as satellite-leaning within a Data Vault modeling suggestion. The table is registered in FND Design Data as IGS.IGS_PS_RSV_EXT and carries a VALID status in the ETRM documentation.

Key Information Stored

The table contains eleven documented columns. The surrogate primary key, enforced by constraint IGS_PS_RSV_EXT_PK, is RSV_EXT_ID, a NUMBER(15) that uniquely identifies each reservation-seat record. Two unique index definitions are documented, and it is important to distinguish them:

• IGS_PS_RSV_EXT_U1 — a UNIQUE index on (PREFERENCE_ID, PRIORITY_ID, RSV_LEVEL, UOO_ID). These four columns together form the business-key candidate, guaranteeing that only one seat-count row exists per priority/preference/level/unit-offering-option combination.
• IGS_PS_RSV_EXT_U2 — a NONUNIQUE index on RSV_EXT_ID, supporting lookups by the primary key surrogate.

The most significant non-key columns are:

• UOO_ID — the Unit Section (unit offering option) for which the actual enrollment against the reservation is created. This is a foreign key to IGS.IGS_PS_UNIT_OFR_OPT_ALL.
• PRIORITY_ID — the priority identifier from reserve seating setup.
• PREFERENCE_ID — the preference identifier from reserve seating setup.
• RSV_LEVEL — a VARCHAR2(10) value indicating the level at which priority and preference are defined; documented allowable values are USEC, UOPT, and ORG.
• ACTUAL_SEAT_ENROLLED — the actual number of seats enrolled against the priority and preference of the reservation; this is the primary quantitative fact of the table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns present in all Oracle EBS transactional tables.

Common Use Cases and Queries

The table is primarily queried to reconcile reserved capacity against actual seat consumption for admission and enrollment reporting. A typical reporting query joins the reservation rows to the unit offering option to confirm which sections are over- or under-subscribed:

SELECT r.RSV_EXT_ID, r.UOO_ID, r.PRIORITY_ID, r.PREFERENCE_ID, r.RSV_LEVEL, r.ACTUAL_SEAT_ENROLLED FROM IGS.IGS_PS_RSV_EXT r WHERE r.UOO_ID = :p_uooid AND r.RSV_LEVEL = 'UOPT';

Because RSV_LEVEL distinguishes whether priority and preference are applied at the unit section (USEC), unit offering option (UOPT), or organization (ORG) level, a common analytical use case aggregates ACTUAL_SEAT_ENROLLED by RSV_LEVEL to validate that each level's reserves are conserved. Another routine pattern filters by PRIORITY_ID and PREFERENCE_ID to retrieve the seat total for a single reserve seating rule. The WHO columns support change-tracking audits to determine when seat balances were last adjusted.

Related Objects

• IGS.IGS_PS_UNIT_OFR_OPT_ALL — parent unit offering option; joined via IGS_PS_RSV_EXT.UOO_ID = IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID.
• IGS.IGS_PS_RSV_TEMP — references IGS_PS_RSV_EXT.RSV_EXT_ID, indicating a staging or temporary reservation process that depends on the persisted reserve extension rows.
• APPS.IGS_PS_RSV_EXT — the APPS-synonym accessible to concurrent programs and forms.
• Reserve seating setup tables underlying PRIORITY_ID and PREFERENCE_ID, which define the priority and preference values consumed here.
• IGS enrollment and registration base tables that supply the UOO context for the seat counts recorded by this object.