Search Results igs_ps_usec_lim_wlst_u2

Overview

IGS.IGS_PS_USEC_LIM_WLST is a transactional table in the Oracle EBS Student Systems (IGS) product family. It stores the enrollment capacity controls and waitlist configuration applied to a unit section offering option — the combination of a teachable unit and its offered section option, identified by UOO_ID. In Oracle Student System terms, this table governs how many students may enroll in, be expected in, or be admitted beyond the standard capacity of a given section, and how waitlisted students are handled when those thresholds are reached.

The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, and its indexes are held in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the heuristic classification is satellite-leaning: the table carries descriptive, mutable enrollment-control attributes keyed to a parent unit-offering entity, with an artificial surrogate primary key rather than a composite natural key. It is best understood as an attribute-bearing dependent of the unit offering option rather than an independent hub.

Key Information Stored

The surrogate primary key is UNIT_SECTION_LIMIT_WAITLIST_ID (NUMBER(10)), which uniquely identifies each limits-and-waitlist record. Two unique indexes serve as business-key candidates: IGS_PS_USEC_LIM_WLST_U1 enforces uniqueness on UNIT_SECTION_LIMIT_WAITLIST_ID, and IGS_PS_USEC_LIM_WLST_U2 enforces uniqueness on UOO_ID. The U2 constraint is significant operationally — it establishes that each unit section offering option carries at most one active limits-and-waitlist configuration.

The most important columns fall into three groups:

• Enrollment thresholds: ENROLLMENT_EXPECTED, ENROLLMENT_MINIMUM, and ENROLLMENT_MAXIMUM define the planned, floor, and ceiling enrollment figures for the section. ADVANCE_MAXIMUM caps advance enrollments. OVERRIDE_ENROLLMENT_MAX stores the tolerance to which actual enrollment may rise before the maximum must formally be increased.
• Waitlist controls: WAITLIST_ALLOWED is documented as an obsolete indicator, while MAX_STUDENTS_PER_WAITLIST remains the operative cap on waitlisted students. MAX_AUDITORS_ALLOWED limits auditors independently of enrolled students.
• Standard Who columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide audit lineage, with the ID columns typed NUMBER(15).

Common Use Cases and Queries

Registrar and enrollment-services reporting relies on this table to answer capacity questions before and during a registration window. A typical pattern joins the table to its parent offering option to resolve descriptive context, filtering on the U2 business key:

SELECT l.UOO_ID, l.ENROLLMENT_MAXIMUM, l.MAX_STUDENTS_PER_WAITLIST, l.OVERRIDE_ENROLLMENT_MAX FROM IGS.IGS_PS_USEC_LIM_WLST l WHERE l.UOO_ID = :p_uooid;

Waitlist forecasting queries compare MAX_STUDENTS_PER_WAITLIST and MAX_AUDITORS_ALLOWED against active registrations to identify sections approaching overflow. Capacity audits look for records where ENROLLMENT_MAXIMUM is exceeded by actual enrollment but remains under OVERRIDE_ENROLLMENT_MAX, indicating sections operating on tolerance rather than an approved increase. Because the table is satellite-leaning, change-tracking extracts typically filter on LAST_UPDATE_DATE to identify recently reconfigured sections.

Related Objects

The table participates in a small but tightly coupled dependency cluster:

• IGS.IGS_PS_UNIT_OFR_OPT_ALL — the parent entity; IGS_PS_USEC_LIM_WLST.UOO_ID references it (documented twice as a foreign key, reflecting the option-level grain).
• IGS.IGS_PS_USEC_WLST_PRI — a child table whose UNIT_SECTION_LIMIT_WAITLIST_ID references this table, holding waitlist priority detail.
• IGS_PS_USEC_LIM_WLST_U1 and IGS_PS_USEC_LIM_WLST_U2 — the unique indexes enforcing the surrogate key and the one-record-per-offering rule.

Collectively these objects support enrollment capacity enforcement and waitlist prioritization across the Student System registration flow.