Search Results dsp_priority_meaning




Overview
Explore in AI Chat

Overview

The view IGS_PS_USEC_WLST_PRI_V belongs to the IGS – Student System product family within Oracle E-Business Suite. In the ETRM metadata for release 12.2.2 the object is flagged as Obsolete, and the implementation note explicitly records that it is not implemented in this database. The view was designed to present waitlist priority information for unit (class) sections in the Student System, joining the priority definition table to the seeded lookup values that translate a stored priority code into a user-facing meaning.

Its reporting role is to denormalise the waitlist priority setup so that downstream queries, concurrent programs, or integration extracts can retrieve a priority record together with its descriptive lookup meaning in a single row, rather than requiring a separate join to IGS_LOOKUP_VALUES at the call site. Because waitlist priority determines the order in which students are promoted from a waitlist into an available section slot, this view historically served enrolment, scheduling, and student-records reporting.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text itself identifies the two sources:

The relationship is a lookup resolution join: each waitlist priority row carries a PRIORITY_VALUE code that is matched against the UNIT_WAITLIST lookup type to obtain the descriptive MEANING, exposed in the view as DSP_PRIORITY_MEANING. ROW_ID is projected from the base table ROWID, preserving row-level addressing for the underlying priority record.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_PS_USEC_WLST_PRI row.
  • UNIT_SEC_WAITLIST_PRIORITY_ID — primary identifier of the waitlist priority definition.
  • UNIT_SECTION_LIMIT_WAITLIST_ID — foreign reference to the unit section limit/waitlist configuration the priority belongs to.
  • PRIORITY_NUMBER — numeric ordering of the priority within its waitlist set.
  • PRIORITY_VALUE — the lookup code stored against LOOKUP_TYPE = 'UNIT_WAITLIST'. This is the column most relevant to a search for priority_value, as it is both the join key and the raw coded value.
  • DSP_PRIORITY_MEANING — the lookup MEANING, providing the displayable description of the priority.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
  • UOO_ID — the organisational unit / operating unit identifier associated with the priority record.

Common Use Cases and Queries

Typical usage involves listing or validating the waitlist priorities configured for section limits, translating PRIORITY_VALUE codes into readable meanings, and feeding enrolment extracts. A representative query is:

  • SELECT unit_sec_waitlist_priority_id, unit_section_limit_waitlist_id, priority_number, priority_value, dsp_priority_meaning FROM igs_ps_usec_wlst_pri_v ORDER BY unit_section_limit_waitlist_id, priority_number;
  • SELECT priority_number, priority_value, dsp_priority_meaning FROM igs_ps_usec_wlst_pri_v WHERE priority_value = :p_priority_value; — resolves a supplied code to its meaning.
  • SELECT uswp.* FROM igs_ps_usec_wlst_pri_v uswp WHERE uswp.uoo_id = :p_uooid; — restricts priorities to a given organisational unit.

Because the object is marked obsolete and not implemented in the documented 12.2.2 database, these patterns should be treated as historical reference; in supported environments the equivalent data is sourced from the base table with an explicit join to IGS_LOOKUP_VALUES.