Search Results igs_ps_rsv_uop_pri

Overview

The IGS_PS_RSV_UOP_PRI table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the master repository for defining and storing priority rules associated with reserved seating at the Unit Offering Pattern (UOP) level. This table is essential for managing controlled enrollment, allowing institutions to allocate a specific number of seats in a class offering to defined student cohorts based on a priority ranking system. Its existence directly supports complex enrollment strategies and ensures compliance with institutional policies for seat reservation.

Key Information Stored

The table stores the definition of each priority rule, linking it to a specific academic offering and assigning its rank. The primary unique identifier is the system-generated RSV_UOP_PRI_ID. The table's structure enforces a composite unique key (IGS_PS_RSV_UOP_PRI_UK) on a combination of columns that precisely identifies the academic context and priority value: UNIT_CD, VERSION_NUMBER, CALENDER_TYPE, and CI_SEQUENCE_NUMBER together identify the specific Unit Offering Pattern, while PRIORITY_VALUE denotes the rank of this rule (e.g., 1 for highest priority). This design ensures that within a single offering pattern, no two priority rules can have the same rank.

Common Use Cases and Queries

The primary use case is the administration and execution of reserved seating processes during enrollment. Administrators create and maintain priority rules in this table, which are then referenced by detailed preference records (in IGS_PS_RSV_UOP_PRF) that specify which student groups (e.g., by major, cohort, or student attribute) qualify for each priority level. Common reporting and validation queries involve listing all priorities for an offering or checking for data integrity.

• Listing priorities for a specific unit offering: SELECT * FROM igs.igs_ps_rsv_uop_pri WHERE unit_cd = 'MATH101' AND version_number = 1 AND calender_type = 'SEMESTER' AND ci_sequence_number = 202301 ORDER BY priority_value;
• Identifying offering patterns with reserved seating configured: SELECT DISTINCT unit_cd, version_number, calender_type, ci_sequence_number FROM igs.igs_ps_rsv_uop_pri;

Related Objects

IGS_PS_RSV_UOP_PRI sits at the center of a key relationship hierarchy for reserved seating. It has a mandatory foreign key relationship to the IGS_PS_UNIT_OFR_PAT_ALL table, which defines the Unit Offering Pattern itself. This ensures every priority rule is attached to a valid academic offering. Furthermore, it is the parent table to IGS_PS_RSV_UOP_PRF (Reserved Unit Offering Pattern Preference). The RSV_UOP_PRI_ID column is referenced by the foreign key in IGS_PS_RSV_UOP_PRF, establishing a one-to-many relationship where a single priority rule can have multiple detailed student cohort preferences defined against it.