Search Results igs_ps_uofr_wlst_prf




Overview
Explore in AI Chat

Overview

IGS_PS_UOFR_WLST_PRF is a table within the Oracle E-Business Suite Student System (IGS) product family. Its documented description identifies it as the entity that describes waitlist preferences for a Unit Offering Pattern. In functional terms, it stores the configurable preference attributes that govern how a waitlist is applied against a specific unit offering pattern — the template that controls how a unit offering is delivered in a given academic period. The table is classified in the ETRM documentation as part of the IGS - Student System (Obsolete) module, and the metadata explicitly records that it is not implemented in this database for the documented reference environment. This is a significant fact for any implementer: the object is documented structurally but may be absent, disabled, or superseded in a live 12.1.1 or 12.2.2 instance depending on the installed progressive enhancement patches and whether the obsolete student-system components were ever provisioned.

From a modeling perspective, the metadata carries a heuristic Data Vault classification of satellite-leaning. This is consistent with the observed structure: the table carries a single-column surrogate primary key (UNIT_OFR_WAITLIST_PREF_ID) and a foreign key pointing to IGS_PS_UOFR_WLST_PRI, indicating that this object behaves as a descriptive, attribute-bearing satellite attached to a parent waitlist-priority entity rather than acting as an independent hub or an associative link.

Key Information Stored

The physical schema, as documented for ETRM 12.1.1, is owned by IGS and contains ten columns. The surrogate primary key is defined by the constraint IGS_PS_UOFR_WLST_PRF_PK, keyed on UNIT_OFR_WAITLIST_PREF_ID. This identifier has no business meaning and should never be presented to end users; it exists solely to guarantee row uniqueness and to support downstream references.

Two unique indexes are documented as business-key candidates. IGS_PS_UOFR_WLST_PRF_U1 is a single-column unique index on UNIT_OFR_WAITLIST_PREF_ID, effectively mirroring the primary key. IGS_PS_UOFR_WLST_PRF_U2 is a composite unique index over (UNIT_OFR_WAITLIST_PRIORITY_ID, PREFERENCE_CODE, PREFERENCE_VERSION) and is the more meaningful candidate key, since it defines the natural uniqueness of a preference within its parent priority context and a specific version.

The remaining documented columns are:

  • UNIT_OFR_WAITLIST_PRIORITY_ID — the foreign key to IGS_PS_UOFR_WLST_PRI, anchoring each preference row to its parent waitlist priority.
  • PREFERENCE_ORDER — the sequence in which the preference is evaluated relative to siblings.
  • PREFERENCE_CODE — the coded value identifying the preference itself.
  • PREFERENCE_VERSION — the version discriminator supporting temporally distinct variants of the same code.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO-audit columns that track row provenance and change history.

Common Use Cases and Queries

Because the table is documented as obsolete and not implemented in the reference database, production queries should first verify existence before use. A defensive pattern is to confirm the object in the data dictionary, then enumerate preferences for a given priority:

  • Enabling/disabling or excluding the object when unavailable — SELECT COUNT(*) FROM all_tables WHERE table_name = 'IGS_PS_UOFR_WLST_PRF';
  • Reporting the ordered preference set for a parent priority — SELECT p.UNIT_OFR_WAITLIST_PREF_ID, p.PREFERENCE_CODE, p.PREFERENCE_VERSION, p.PREFERENCE_ORDER FROM igs.igs_ps_uofr_wlst_prf p WHERE p.UNIT_OFR_WAITLIST_PRIORITY_ID = :priority_id ORDER BY p.PREFERENCE_ORDER;
  • Resolving the effective preference via the composite business key — a lookup bounded by (UNIT_OFR_WAITLIST_PRIORITY_ID, PREFERENCE_CODE, PREFERENCE_VERSION) to return exactly one row per U2.
  • Audit reporting on recent configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Typical scenarios involve validating waitlist configuration prior to enrolment periods, and reconciling preference versions after institutional rule changes.

Related Objects

The documented foreign-key relationship defines the primary dependency structure, with several logically adjacent objects supporting it:

  • IGS_PS_UOFR_WLST_PRI — parent waitlist-priority table; joined on IGS_PS_UOFR_WLST_PRF.UNIT_OFR_WAITLIST_PRIORITY_ID = IGS_PS_UOFR_WLST_PRI.UNIT_OFR_WAITLIST_PRIORITY_ID.
  • IGS_PS_UOFR_WLST_PRF_PK — the primary key constraint defining the surrogate identity.
  • IGS_PS_UOFR_WLST_PRF_U1 and IGS_PS_UOFR_WLST_PRF_U2 — the unique indexes that expose the business-key candidates.
  • The Unit Offering Pattern family (IGS_PS_UNIT_OFR_PAT and related availability/offering structures) — reached transitively through the parent priority table.
  • CREATED_BY and LAST_UPDATED_BY against the FND_USER reference.

All relationships above are derived solely from the documented FK/PK metadata; broader reachability through the unit offering pattern hierarchy should be confirmed against the live IGS schema in each instance.