Results for “unit_waitlist”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_USEC_WLST_PRI_V is a seeded Oracle E-Business Suite view owned by the APPS schema, residing in the Student System (IGS) product family. It presents waitlist priority information for unit sections — the ordered ranking that governs which waiting students are offered places when capacity becomes available in a unit section subject to a waitlist limit. In the context of Oracle EBS 12.1.1 and 12.2.2, this view serves as a denormalized, reporting-friendly projection of the underlying waitlist priority table, enriching each priority record with the decoded lookup meaning for its priority value.

The view is a conventional join view rather than a materialized view; it holds no data of its own and executes its defining query at runtime. Its principal role is to support inquiry screens, concurrent reports, and integration extracts that must display a human-readable priority description alongside the numeric priority value. Because it exposes the decoded dsp_priority_meaning column, consumers avoid the need to independently resolve the UNIT_WAITLIST lookup type.

Underlying Base Objects

The view is defined over two base objects: IGS_PS_USEC_WLST_PRI and IGS_LOOKUP_VALUES. The driving table is IGS_PS_USEC_WLST_PRI (aliased USWP), which stores the individual waitlist priority rows for unit section limits. The join to IGS_LOOKUP_VALUES (aliased LV) is an equality join on lookup code, constrained by the literal lookup type UNIT_WAITLIST:

• LV.LOOKUP_TYPE = 'UNIT_WAITLIST' restricts the lookup side to waitlist priority codes.
• LV.LOOKUP_CODE = USWP.PRIORITY_VALUE matches each priority record to its lookup definition.

The join is effectively an inner join, so any waitlist priority row whose priority_value has no corresponding enabled lookup code in the UNIT_WAITLIST lookup type will be excluded from the view. This dependency means lookup maintenance directly affects the result set returned.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_PS_USEC_WLST_PRI row, used by Oracle Forms and OAF for row identification.
• UNIT_SEC_WAITLIST_PRIORITY_ID — primary key identifying the waitlist priority record.
• UNIT_SECTION_LIMIT_WAITLIST_ID — foreign reference to the parent unit section limit waitlist to which the priority belongs.
• PRIORITY_NUMBER — the sequence or rank assigned to the priority within the waitlist definition.
• PRIORITY_VALUE — the coded value that is resolved against the UNIT_WAITLIST lookup type.
• DSP_PRIORITY_MEANING — the decoded, displayable description of the priority, sourced from IGS_LOOKUP_VALUES.MEANING.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns providing the audit trail.
• UOO_ID — the unit of organization identifier, supporting multi-organization or organizational unit scoping.

Common Use Cases and Queries

Typical consumers include waitlist priority inquiry forms, admissions and enrolment reporting, and interfaces that feed external scheduling or student record systems. A representative query retrieves all priorities for a given unit section limit waitlist:

SELECT unit_sec_waitlist_priority_id,
       unit_section_limit_waitlist_id,
       priority_number,
       priority_value,
       dsp_priority_meaning
FROM   apps.igs_ps_usec_wlst_pri_v
WHERE  unit_section_limit_waitlist_id = :p_waitlist_id
ORDER BY priority_number;

Because the view is not indexed independently, queries filtering on unit_section_limit_waitlist_id rely on the indexes of the base table. Analysts should also be aware that deactivated or missing UNIT_WAITLIST lookup codes will silently suppress rows, so reconciliation against IGS_PS_USEC_WLST_PRI is advisable when completeness of waitlist priority data is critical.