Search Results igs_ps_usec_wlst_prf




Overview
Explore in AI Chat

Overview

The table IGS.IGS_PS_USEC_WLST_PRF is a core data object within the Oracle EBS Student System (IGS) product family. Its documented purpose is to capture the Waitlist Preferences for a Unit Section. In academic terms, a "unit section" is a specific offering of a course (unit) in a given term, and waitlisting is the mechanism by which students who cannot enroll in a full section register their interest to be considered should capacity become available. This table therefore stores the configuration rules that govern how waitlisted students are prioritized and processed for a given unit section.

The object resides in the IGS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the heuristic classification derived from its foreign key structure is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite attached to a parent hub or link (represented here by the waitlist priority entity), carrying attributes that describe the preference configuration rather than acting as an independent business key hub.

Key Information Stored

The table contains ten documented columns. The central surrogate identifier is UNIT_SEC_WAITLIST_PREF_ID, defined by the primary key constraint IGS_PS_USEC_WLST_PRF_PK and also served by the unique index IGS_PS_USEC_WLST_PRF_U1. This column uniquely identifies each waitlist preference record.

The principal business-key candidate is defined by the unique index IGS_PS_USEC_WLST_PRF_U2, which spans UNIT_SEC_WAITLIST_PRIORITY_ID, PREFERENCE_CODE, and PREFERENCE_VERSION. This composite key enforces that a given preference code and version is recorded only once per waitlist priority definition. The foreign key column UNIT_SEC_WAITLIST_PRIORITY_ID links each preference back to its parent waitlist priority record, establishing the satellite relationship.

The PREFERENCE_CODE column stores the coded value identifying the specific preference type, while PREFERENCE_VERSION provides version control for that code. The PREFERENCE_ORDER column determines the sequence in which preferences are applied or evaluated. The remaining documented columns—CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN—constitute standard Oracle EBS WHO-column auditing metadata that records record creation and modification lineage.

Common Use Cases and Queries

Institutional reporting and operational administration of waitlists rely on this table to verify that each unit section has properly defined selection preferences. A common query retrieves all preferences for a specific waitlist priority:

  • Joining IGS_PS_USEC_WLST_PRF to IGS_PS_USEC_WLST_PRI on UNIT_SEC_WAITLIST_PRIORITY_ID to present preference codes in configured order.
  • Ordering results by PREFERENCE_ORDER to reconstruct the sequence in which preferences are evaluated during waitlist processing.
  • Auditing version history using PREFERENCE_VERSION to determine which preference configuration was active at a given time.
  • Extracting configuration for integration or migration by filtering on PREFERENCE_CODE values.

Reporting use cases include confirming waitlist fairness rules, validating that preferences align with institutional policy, and generating configuration extracts for term setup cycles. Audit queries frequently filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to trace when a section's waitlist preferences were changed and by whom.

Related Objects

The most significant referencing object is IGS_PS_USEC_WLST_PRI, the parent waitlist priority table joined through UNIT_SEC_WAITLIST_PRIORITY_ID. This parent-child relationship is the documented foreign key dependency of IGS_PS_USEC_WLST_PRF. In practice, the broader Student System ecosystem—including unit section, enrollment, and waitlist processing components—consumes these preference definitions when determining the order in which waitlisted students are promoted into available seats. Consult the IGS enrollment and unit section tables alongside this object when building comprehensive waitlist analytics.