Search Results igs_ps_rsv_uop_prf




Overview
Explore in AI Chat

Overview

The IGS_PS_RSV_UOP_PRF table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the central repository for defining and managing specific student preference criteria linked to a reserved seating priority rule at the unit offering pattern (UOP) level. In the context of academic administration, reserved seating allows institutions to allocate a specific number of seats in a class or unit offering to particular student cohorts based on defined priorities. This table stores the detailed preference rules—such as a specific unit set or stage type—that must be met for a student to qualify under a given seating priority. Its role is to operationalize complex enrollment management policies by linking high-level seating priorities to concrete, executable student attributes.

Key Information Stored

The table's structure is designed to link a seating priority to a specific student attribute preference. The primary identifier is the system-generated RSV_UOP_PRF_ID. The most critical foreign key is RSV_UOP_PRI_ID, which ties each preference record back to its parent reserved seating priority rule defined in the IGS_PS_RSV_UOP_PRI table. The preference itself is defined through the combination of PREFERENCE_CODE and, where applicable, PREFERENCE_VERSION columns. These columns hold codes that reference specific student criteria in related master tables, such as a unit set code from IGS_EN_UNIT_SET_ALL or a stage type from IGS_PS_STAGE_TYPE. This design allows a single seating priority (RSV_UOP_PRI_ID) to have multiple associated preference records, enabling complex, multi-faceted qualification rules.

Common Use Cases and Queries

A primary use case is the batch process that evaluates student enrollment requests against reserved seating rules. The system queries this table to retrieve all preference criteria for active priorities on a unit offering pattern to determine a student's eligibility for a reserved seat. Common reporting needs include auditing the configuration of seating rules and troubleshooting enrollment errors. A typical query would join this table to its parent priority and the referenced preference tables to produce a human-readable rule definition.

  • Sample Query: Retrieving all configured preferences for a specific unit offering pattern priority. 
    SELECT pri.priority_name, prf.preference_code, us.unit_set_name
FROM igs_ps_rsv_uop_prf prf
JOIN igs_ps_rsv_uop_pri pri ON prf.rsv_uop_pri_id = pri.rsv_uop_pri_id
LEFT JOIN igs_en_unit_set_all us ON prf.preference_code = us.unit_set_cd
WHERE pri.rsv_uop_id = :p_rsv_uop_id
ORDER BY pri.priority_number;

Related Objects

The IGS_PS_RSV_UOP_PRF table is a dependent entity with strong relationships to several master and transactional tables, as documented by its foreign key constraints.

  • IGS_PS_RSV_UOP_PRI: The direct parent table. The join is on the column RSV_UOP_PRI_ID. This relationship ensures every preference is associated with a valid seating priority.
  • IGS_EN_UNIT_SET_ALL: References a student's academic plan. The join uses columns PREFERENCE_CODE and PREFERENCE_VERSION to link to UNIT_SET_CD and VERSION_NUMBER, allowing reservations for specific unit set enrollments.
  • IGS_PS_STAGE_TYPE: References a student's academic stage or progress type. The join is on the column PREFERENCE_CODE to the STAGE_TYPE column, enabling reservations based on academic standing.
  • IGS_PS_VER_ALL: References a course version. The join uses columns PREFERENCE_CODE and PREFERENCE_VERSION to link to COURSE_CD and VERSION_NUMBER, supporting reservations for students in specific program versions.