Search Results rsv_uop_prf_id




Overview
Explore in AI Chat

Overview

The IGS_PS_RSV_UOP_PRF table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (Campus Solutions) product. It is owned by the IGS (iGrants) schema and functions as a configuration table for managing reserved seating in an academic context. As defined in the ETRM, its purpose is to "describe the preferences for a given priority for reserved seating at unit offering pattern level." In practice, this table allows academic administrators to define and rank specific criteria (preferences) that determine how a pool of reserved seats within a course offering is allocated to different student priority groups, such as students in a specific major, stage, or unit set.

Key Information Stored

The table stores the detailed rules that link a seating priority to specific student attributes. The primary and foreign key columns establish critical relationships, while other columns define the allocation logic. Key columns include:

  • RSV_UOP_PRF_ID: The system-generated primary key that uniquely identifies each preference record.
  • RSV_UOP_PRI_ID: A foreign key linking to the IGS_PS_RSV_UOP_PRI table, identifying the overarching reserved seating priority to which this preference belongs.
  • PREFERENCE_ORDER: A numeric value that dictates the sequence in which multiple preferences under a single priority are evaluated.
  • PREFERENCE_CODE: A code identifying the specific criterion (e.g., a Unit Set, Stage Type, or Version) used to qualify students for the reserved seats. This column has foreign key relationships to several reference tables.
  • PREFERENCE_VERSION: The version number of the referenced PREFERENCE_CODE, providing temporal control over the rule.
  • PERCENTAGE_RESERVED: Defines the percentage of total seats within the unit offering pattern that are reserved for students meeting this specific preference criterion.
  • GROUP_ID: Links to a person group, offering another dimension for defining the student cohort eligible for the reservation.

Common Use Cases and Queries

This table is central to reporting on and auditing reserved seating configurations. A common use case involves generating a report of all reserved seating rules for a specific academic unit or course, showing the priority, preference order, target student group, and percentage of seats reserved. Administrators may query this table to validate configuration or troubleshoot seat allocation issues. A fundamental query to retrieve all preference data, as suggested by the ETRM, is:

SELECT RSV_UOP_PRF_ID, RSV_UOP_PRI_ID, PREFERENCE_ORDER, PREFERENCE_CODE, PREFERENCE_VERSION, PERCENTAGE_RESERVED, GROUP_ID FROM IGS.IGS_PS_RSV_UOP_PRF WHERE RSV_UOP_PRI_ID = :PRIORITY_ID ORDER BY PREFERENCE_ORDER;

Another critical pattern involves joining to the priority table (IGS_PS_RSV_UOP_PRI) to get the full context of the seating rule, and potentially to the tables referenced by PREFERENCE_CODE (e.g., IGS_EN_UNIT_SET_ALL) to decode the preference criteria for reporting.

Related Objects

The IGS_PS_RSV_UOP_PRF table sits within a network of related objects that define the complete reserved seating functionality. Its documented relationships are:

  • Primary Key: IGS_PS_RSV_UOP_PRF_PK on column RSV_UOP_PRF_ID.
  • Foreign Key (Parent): The table is a child of IGS_PS_RSV_UOP_PRI via the RSV_UOP_PRI_ID column. This defines the parent priority rule.
  • Foreign Keys (Referenced Codes): The PREFERENCE_CODE column references several code lookup tables, including IGS_PS_VER_ALL (Academic Version), IGS_PS_STAGE_TYPE (Academic Stage Type), and IGS_EN_UNIT_SET_ALL (Unit Set/Plan). These define the valid values for the preference criterion.
  • Referencing Objects: The ETRM indicates that the APPS synonym IGS_PS_RSV_UOP_PRF references this table, which is standard for EBS application access.