Search Results unit_ofr_waitlist_priority_id




Overview
Explore in AI Chat

Overview

IGS_PS_UOFR_WLST_PRF_V is a view belonging to the IGS (Student System) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its ETRM title and description classify it as obsolete: the metadata references a case and seed document, PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc, and explicitly states that the object is not implemented in the documented database. The view is associated with the waitlist preference feature of the unit offering (Unit of Offer) processing area of Oracle Student System.

The view presents waitlist preference records for unit offerings, resolving the generic PREFERENCE_CODE stored on the preference table into a human-readable DESCRIPTION value. Because the description source differs according to the nature of the preference — a party (person) or a course version — the view is built as a three-branch UNION. It therefore serves as a reporting and integration layer that presents preference data in a consistent, descriptive form, keyed by UNIT_OFR_WAITLIST_PRIORITY_ID, the identifier that a user searching on that column would be investigating.

Underlying Base Objects

The view text references three base tables and one supporting view. The waitlist preference table IGS_PS_UOFR_WLST_PRF (aliased UWPR) supplies the driving rows. The waitlist priority table IGS_PS_UOFR_WLST_PRI (aliased UWP) is joined in every branch on UNIT_OFR_WAITLIST_PRIORITY_ID, tying each preference to its priority definition. The description source varies by branch:

  • IGS_OR_INST_ORG_BASE_V (aliased OU), joined where OU.PARTY_NUMBER = UWPR.PREFERENCE_CODE, resolving preferences that reference a party.
  • IGS_PS_VER (aliased UV), joined where UV.COURSE_CD = UWPR.PREFERENCE_CODE and UV.VERSION_NUMBER = UWPR.PREFERENCE_VERSION, resolving preferences that reference a course version.
  • A third branch (truncated in the source document) selecting US.TITLE as DESCRIPTION, indicating an additional unit or offering title source.

The ETRM metadata documents no referenced base objects separately, so the view text itself is the authoritative definition. Note that because the branches use UNION rather than UNION ALL, duplicate rows are eliminated across the branches.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_PS_UOFR_WLST_PRF row, exposing row-level identity for the base table.
  • UNIT_OFR_WAITLIST_PREF_ID — primary key of the waitlist preference record.
  • UNIT_OFR_WAITLIST_PRIORITY_ID — foreign key to the waitlist priority; the column referenced in the search that prompted this summary, and the join key to IGS_PS_UOFR_WLST_PRI.
  • PREFERENCE_ORDER — sequence in which preferences are applied.
  • PREFERENCE_CODE and PREFERENCE_VERSION — the raw preference identifier and its version, resolved against parties or course versions depending on the record type.
  • DESCRIPTION — the resolved party name, course title, or offering title.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view supports reporting on waitlist preferences associated with a given unit offering priority, and on the descriptive identity of the preference target. A typical query retrieves all preferences for a specific priority:

SELECT unit_ofr_waitlist_pref_id,
       preference_order,
       preference_code,
       preference_version,
       description
FROM   igs_ps_uofer_wlst_prf_v
WHERE  unit_ofr_waitlist_priority_id = :priority_id
ORDER  BY preference_order;

A second scenario joins the view back to the priority table to report priority definitions alongside their resolved preferences. Because the object is documented as obsolete and not implemented, DBAs should verify its presence (e.g., via ALL_VIEWS) before relying on it in customizations, and should treat any dependency on it as a migration risk during upgrades between 12.1.1 and 12.2.2.