Results for “igs_ps_rsv_uop_prf”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_RSV_UOP_PRF is a table in the Oracle E-Business Suite Student System (IGS) product family. It describes the seat reservation preferences associated with a specific priority level for reserved seating defined at the unit offering pattern level. In practical terms, the table stores the qualifying criteria — stage type, unit set, or version — that determines which students are granted reserved places under a given reservation priority.

The table is documented as obsolete and is not implemented in the current database, meaning it appears in the ETRM reference schema but carries no active rows or runtime logic in a standard EBS 12.1.1 or 12.2.2 installation. Its documented physical schema lists an owner of IGS and twelve columns. Within the heuristic Data Vault classification mined from the foreign key structure, the table is modelled as a link, reflecting its role in connecting a reservation priority record to the preference definitions it resolves against.

Key Information Stored

The twelve documented columns capture the identity of the preference record, its parent reservation priority, the ordering and definition of the preference itself, and standard EBS audit fields.

• RSV_UOP_PRF_ID — the surrogate primary key, enforced by IGS_PS_RSV_UOP_PRF_PK and also covered by unique index IGS_PS_RSV_UOP_PRF_U1.
• RSV_UOP_PRI_ID — foreign key to IGS_PS_RSV_UOP_PRI, identifying the reserved seating priority to which the preference belongs.
• PREFERENCE_CODE and PREFERENCE_VERSION — the preference definition; these two columns form the second business-key candidate, unique index IGS_PS_RSV_UOP_PRF_U2, in combination with RSV_UOP_PRI_ID.
• PREFERENCE_ORDER — the evaluation sequence applied when multiple preferences exist for the same priority.
• PERCENTAGE_RESERVED — the proportion of seats allocated under the preference.
• GROUP_ID — the standard EBS grouping column used in multi-org or concurrent processing contexts.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the mandatory audit trail columns present on virtually all EBS transactional tables.

Common Use Cases and Queries

Because the table is obsolete and not implemented, direct querying is relevant only for migration analysis, data archival review, or understanding legacy reserved-seating configuration. A typical enquiry resolves the preference hierarchy for a given reservation priority:

• Retrieve all preferences for a priority: SELECT rsv_uop_prf_id, preference_code, preference_version, preference_order, percentage_reserved FROM igs_ps_rsv_uop_prf WHERE rsv_uop_pri_id = :priority_id ORDER BY preference_order;
• Resolve preference definitions by joining to IGS_PS_VER_ALL on PREFERENCE_CODE and PREFERENCE_VERSION.
• Identify stage-type or unit-set based preferences by joining to IGS_PS_STAGE_TYPE or IGS_EN_UNIT_SET_ALL on PREFERENCE_CODE.
• Audit-based reporting using CREATION_DATE and LAST_UPDATE_DATE to trace configuration changes over time.

Reporting use cases centre on reconstructing the historical reserved-seating rules used for a unit offering pattern, which supports audit, historical analysis, and legacy-to-current data mapping exercises.

Related Objects

The documented foreign keys link IGS_PS_RSV_UOP_PRF to the following significant objects:

• IGS_PS_RSV_UOP_PRI — joined on RSV_UOP_PRI_ID; the parent reserved seating priority.
• IGS_PS_VER_ALL — joined on PREFERENCE_CODE and PREFERENCE_VERSION; resolves the preference version definition.
• IGS_PS_STAGE_TYPE — joined on PREFERENCE_CODE; identifies stage-type based preferences.
• IGS_EN_UNIT_SET_ALL — joined on PREFERENCE_CODE and PREFERENCE_VERSION; identifies unit-set based preferences.

Together these relationships place the table at the intersection of reserved seating priorities and student eligibility definitions, consistent with its heuristic link classification.