Search Results igs_ps_usec_wlst_pri




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_WLST_PRI is a Student System (IGS) entity within Oracle E-Business Suite that describes the Waitlist Priorities for a Unit Section. In the context of Oracle EBS 12.1.1 and 12.2.2, this table forms part of the obsolete Student System schema and is documented in ETRM but explicitly flagged as "Not implemented in this database." It therefore serves as a reference/data-model artifact rather than an active transactional object in standard EBS installations.

The entity captures the priority ordering applied to students placed on a waitlist for a specific unit section (a class offering). The heuristic Data Vault classification derived from the foreign-key structure is satellite-leaning, meaning the table is best modeled as a descriptive satellite attached to a parent hub (the unit offering option and the unit section waitlist limit). It is dependent on its referenced parents for business meaning and holds priority-specific descriptive attributes.

Key Information Stored

The documented physical schema for 12.1.1 records 10 columns owned by the IGS schema. The most significant columns are:

Two unique indexes document the business-key candidates: IGS_PS_USEC_WLST_PRI_U1 on UNIT_SEC_WAITLIST_PRIORITY_ID (mirroring the primary key) and IGS_PS_USEC_WLST_PRI_U2 on the composite (UOO_ID, PRIORITY_VALUE). The U2 constraint establishes that a given unit offering option may hold only one record per priority value, making this pair the natural business key.

Common Use Cases and Queries

Because the object is not implemented in standard databases, use cases are primarily architectural, migration-related, or analytical exercises where the IGS data model is being mapped or selectively reinstated. Typical reporting patterns involve joining the priority records back to their parent unit offering option and waitlist limit.

A representative query resolves waitlist priorities for a unit offering option:

  • SELECT p.unit_sec_waitlist_priority_id, p.priority_number, p.priority_value, p.uoo_id FROM igs_ps_usec_wlst_pri p WHERE p.uo

Extending the pattern to include the offering option description:

  • SELECT p.priority_value, o.* FROM igs_ps_usec_wlst_pri p, igs_ps_unit_ofr_opt_all o WHERE p.uoo_id = o.uo

Joining to the waitlist limit configuration supports capacity and prioritization analysis:

  • SELECT l.*, p.priority_number, p.priority_value FROM igs_ps_usec_wlst_pri p, igs_ps_usec_lim_wlst l WHERE p.unit_section_limit_waitlist_id = l.unit_section_limit_waitlist_id

Reporting typically focuses on confirming uniqueness of PRIORITY_VALUE per unit offering option, validating the U2 business rule, and auditing the WHO columns for change history.

Related Objects

The following objects are directly implicated by the documented FK and PK relationships:

  • IGS_PS_UNIT_OFR_OPT_ALL — parent of UOO_ID; the unit offering option that the priority qualifies.
  • IGS_PS_USEC_LIM_WLST — parent of UNIT_SECTION_LIMIT_WAITLIST_ID; the waitlist limit configuration for the unit section.
  • IGS_PS_USEC_WLST_PRF — child table referencing UNIT_SEC_WAITLIST_PRIORITY_ID; holds waitlist priority preference detail.
  • IGS_PS_USEC_WLST_PRI_PK / _UK / _U1 / _U2 — the primary, unique, and unique-index constraints governing row identity and business rules.

Together these objects frame the waitlist prioritization model within the obsolete IGS Student System, informing any data-migration or retrospective analysis effort.