Search Results unit_sec_waitlist_pref_id




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_WLST_PRF_V is a seeded Oracle EBS view owned by the APPS schema within the Student Systems / Student Records (IGS) product family. It exposes waitlist preference data for unit section (class section) waitlists, resolving the cryptic preference codes stored on the underlying detail table into human-readable descriptions. The view is a UNION-style construct: each branch joins the waitlist preference base table to a different source object depending on the nature of the preference — an organization, a course version, or a unit section — so that a single query returns a consistent, descriptive row regardless of preference type.

In Oracle EBS 12.1.1 and 12.2.2 the view behaves identically at the database tier; the 12.2.x online patching architecture and editioning views merely wrap the same APPS synonyms. It is principally used for reporting, Form personalization lookups, and integration extracts where a waitlist preference must be displayed with a meaningful description rather than a raw code.

Underlying Base Objects

The view is defined over three distinct branches, each combining the base preference table IGS_PS_USEC_WLST_PRF (aliased uswpr) with one descriptive source and the waitlist priority table IGS_PS_USEC_WLST_PRI (aliased uswp):

  • Organization branch — joins IGS_OR_INST_ORG_BASE_V (ou) on ou.party_number = uswpr.preference_code, returning ou.party_name as the description.
  • Course version branch — joins IGS_PS_VER (uv) on uv.course_cd = uswpr.preference_code and uv.version_number = uswpr.preference_version, returning uv.title as the description.
  • Unit section branch — joins a further source (truncated in the metadata excerpt, aliased us) returning us.title as the description.

Every branch is constrained by uswp.unit_sec_waitlist_priority_id = uswpr.unit_sec_waitlist_priority_id, anchoring each preference to its parent priority record. Note that the ETRM metadata documents no formal referenced base objects for this view, so the relationships above are derived from the view text itself.

Key Columns

  • row_id — the ROWID of the underlying preference row; used by Oracle Forms for optimistic locking and by DML-capable blocks.
  • unit_sec_waitlist_pref_id — primary key of the waitlist preference record.
  • unit_sec_waitlist_priority_id — the search term entered by the user; foreign key linking the preference to its waitlist priority definition in IGS_PS_USEC_WLST_PRI.
  • preference_order — the sequence in which this preference applies within the priority scheme.
  • preference_code / preference_version — the raw code (party number, course code, etc.) and, where applicable, its version.
  • description — the resolved display value: party name for organizations, title for course versions or unit sections.
  • created_by, creation_date, last_updated_by, last_update_date, last_update_login — standard WHO audit columns.

Common Use Cases and Queries

Typical use is resolving priorities to their preferences with meaningful labels for enrolment reporting. A representative query filters on the search term:

  • SELECT unit_sec_waitlist_priority_id, preference_order, preference_code, description FROM apps.igs_ps_usec_wlst_prf_v WHERE unit_sec_waitlist_priority_id = :p_priority_id ORDER BY preference_order;
  • Joining the view back to IGS_PS_USEC_WLST_PRI to produce a full priority-plus-preference extract for integration or BI Publisher reports.
  • Feeding LOV and validation logic in Oracle Forms, where the description column supplies the user-facing prompt.

Where downstream logic must distinguish entity types, filter on description format or join separately to each source table, since the view itself does not expose a preference-type discriminator column.