Results for “igs_ps_rsv_orgun_prf_u2”

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

Overview

IGS.IGS_PS_RSV_ORGUN_PRF is a transactional table within the Oracle E-Business Suite Institution General Studies (IGS) product family, which underpins the Student Systems / Higher Education vertical — the records most commonly surfaced to students and administrators during admissions, registration, and enrolment. The object stores preference definitions that determine how reserved seating capacity is allocated for a given priority within an organizational unit. As the ETRM description states, it "describes the preferences for a given priority for reserved seating at Organization unit level." Reserved seating is a common requirement in institutions that must guarantee a proportion of places to particular cohorts (for example students from a specific person group or unit). Each row therefore represents one preference line attached to a reserved-seating priority, combining the preference code and its version with a percentage of capacity reserved.

From a heuristic Data Vault perspective, the mined foreign-key structure suggests a link classification: the table's business key (RSV_ORG_UNIT_PRI_ID, PREFERENCE_CODE) joins two distinct concepts — a reserved-seating priority holder and a preference definition — rather than acting as a hub or satellite. This is a modeling suggestion only, since EBS predates Data Vault conventions.

Key Information Stored

The table carries twelve documented columns. The most significant are:

• RSV_ORG_UNIT_PRF_ID — System-generated sequence number that uniquely identifies the preference code for the corresponding reserved-seating priority at organizational-unit level. It is the surrogate primary key (IGS_PS_RSV_ORGUN_PRF_PK).
• RSV_ORG_UNIT_PRI_ID — Foreign key to the reserved-seating priority; the parent reference that gives each row its organizational-unit context.
• PREFERENCE_CODE — The preference code for the corresponding priority, stored as a VARCHAR2(30).
• PREFERENCE_ORDER — The ordering applied to the preference within its priority, controlling the sequence in which preferences are evaluated.
• PREFERENCE_VERSION — Version of the preference code, allowing historical preference definitions to be retained.
• PERCENTAGE_RESERVED — The percentage of reserved seating allocated under this preference.
• GROUP_ID — Group identifier corresponding to a person group code, tying the reservation to a cohort.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who audit columns.

Two unique indexes are documented: IGS_PS_RSV_ORGUN_PRF_U1 on RSV_ORG_UNIT_PRF_ID, and IGS_PS_RSV_ORGUN_PRF_U2 on (RSV_ORG_UNIT_PRI_ID, PREFERENCE_CODE) — the latter being the business-key candidate, which is significant because the user's search term "igs_ps_rsv_orgun_prf_u2" refers directly to this index.

Common Use Cases and Queries

Typical reporting focuses on how reserved capacity is distributed. Administrators validate that PERCENTAGE_RESERVED sums correctly across preferences for a priority, verify PREFERENCE_ORDER sequencing, and reconcile PREFERENCE_VERSION when definitions change. A retrieval pattern by the business key is:

SELECT RSV_ORG_UNIT_PRF_ID, RSV_ORG_UNIT_PRI_ID, PREFERENCE_ORDER, PREFERENCE_CODE, PREFERENCE_VERSION, PERCENTAGE_RESERVED, GROUP_ID FROM IGS.IGS_PS_RSV_ORGUN_PRF WHERE RSV_ORG_UNIT_PRI_ID = :pri AND PREFERENCE_CODE = :code;

A priority-level aggregation supports enrollment planning:

SELECT RSV_ORG_UNIT_PRI_ID, SUM(PERCENTAGE_RESERVED) FROM IGS.IGS_PS_RSV_ORGUN_PRF GROUP BY RSV_ORG_UNIT_PRI_ID;

Join patterns to the parent priority and to person-group lookups are common when building reserved-seating allocation reports.

Related Objects

• IGS_PS_RSV_ORGUN_PRI / IGS_PS_RSV_OGPRI_ALL — Parent priority, joined on RSV_ORG_UNIT_PRI_ID.
• IGS_PS_VER_ALL — Referenced via PREFERENCE_CODE.
• IGS_PS_STAGE_TYPE — Referenced via PREFERENCE_CODE.
• IGS_EN_UNIT_SET_ALL — Referenced via PREFERENCE_CODE.
• APPS synonym IGS_PS_RSV_ORGUN_PRF — The APPS-layer synonym through which application logic reads the table.