Search Results igs_ps_usec_wlst_prf_v




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_WLST_PRF_V is an APPS-owned database view within the Oracle E-Business Suite Student System (IGS) product family. It exposes waitlist preference records associated with unit section waitlist priorities, presenting a denormalized, presentation-friendly projection of the underlying waitlist preference data. The view is documented in ETRM with an "Obsolete" status, tied to the case and seed document PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc. This obsolescence marker indicates the object is a legacy artifact retained for backward compatibility rather than a target for new development.

Its principal role is to resolve the raw PREFERENCE_CODE stored on waitlist preference rows into a human-readable DESCRIPTION. Because a preference code may denote either an institution organization (identified by party number) or a course version (identified by course code and version number), the view applies a UNION across multiple resolution paths to produce a single descriptive label. This makes it suitable for inquiry screens, concurrent program outputs, and reporting layers that require a decoded preference description without embedding the resolution logic themselves.

Underlying Base Objects

The view is defined over three primary sources referenced in the view text:

  • IGS_PS_USEC_WLST_PRF (aliased USWPR) — the driving waitlist preference table supplying preference order, code, and version, along with WHO columns. ROWID is exposed as ROW_ID.
  • IGS_PS_USEC_WLST_PRI (aliased USWP) — the waitlist priority table, joined on UNIT_SEC_WAITLIST_PRIORITY_ID. This join restricts preference rows to those linked to a valid waitlist priority definition.
  • IGS_OR_INST_ORG_BASE_V (aliased OU) — an institution organization base view, joined on OU.PARTY_NUMBER = USWPR.PREFERENCE_CODE, used to resolve organization-type preference codes to PARTY_NAME.
  • IGS_PS_VER (aliased UV) — the course version table, joined on UV.COURSE_CD = USWPR.PREFERENCE_CODE AND UV.VERSION_NUMBER = USWPR.PREFERENCE_VERSION, resolving course-version preferences to TITLE.
  • The third UNION branch references IGS_PS_USEC_... objects resolving US.TITLE, consistent with the same decoding pattern applied to a unit section source.

Although the ETRM metadata lists no formally documented base objects, the view text establishes these dependencies explicitly. Each UNION branch contributes DESCRIPTION from a different resolution source, all keyed back to the same waitlist preference row.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_PS_USEC_WLST_PRF row, useful for row-level updates and debugging.
  • UNIT_SEC_WAITLIST_PREF_ID — primary identifier for the waitlist preference record.
  • UNIT_SEC_WAITLIST_PRIORITY_ID — foreign key linking the preference to its waitlist priority.
  • PREFERENCE_ORDER — sequence in which the preference applies.
  • PREFERENCE_CODE / PREFERENCE_VERSION — the raw coded preference and its version; used in the joins to determine which resolution branch produces DESCRIPTION.
  • DESCRIPTION — decoded label sourced from PARTY_NAME, COURSE TITLE, or unit section TITLE depending on the branch.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit (WHO) columns.

Common Use Cases and Queries

Typical usage decodes waitlist preferences for a given priority or section. For example:

  • List preferences for a priority: SELECT unit_sec_waitlist_priority_id, preference_order, preference_code, description FROM igs_ps_usec_wlst_prf_v WHERE unit_sec_waitlist_priority_id = :priority_id ORDER BY preference_order;
  • Audit recent changes: SELECT row_id, preference_code, description, last_updated_by, last_update_date FROM igs_ps_usec_wlst_prf_v WHERE last_update_date >= :from_date;
  • Feed a reporting or integration extract joining to IGS_PS_USEC_WLST_PRI for priority attributes.

Because the object is marked Obsolete, new development should prefer the current IGS waitlist APIs and base tables, treating this view strictly as a legacy read interface.