Search Results igs_ps_usec_lim_wlst_pk

Overview

IGS_PS_USEC_LIM_WLST is a table within the Oracle E-Business Suite Student System (IGS) product family, documented as Table: IGS_PS_USEC_LIM_WLST. In the ETRM metadata, the object is classified under IGS – Student System (Obsolete), which indicates that the entity belongs to a legacy or deprecated area of the EBS data model and is not implemented in the current database documented. Its stated purpose is to describe Unit Section Limits and Waitlist information, capturing the enrollment controls and waitlist rules attached to a specific unit offering option.

In Oracle EBS terms, this table acts as a configuration record that constrains how many students may enroll in a unit section, and whether excess demand is handled through a waitlist. The ETRM heuristic Data Vault classification is satellite-leaning, suggesting that this object behaves primarily as a descriptive satellite attached to a parent business entity (the unit offering option), rather than as an independent hub or a pure link. The physical schema is owned by IGS and contains 15 documented columns in the ETRM 12.1.1 metadata.

Key Information Stored

The primary surrogate key of the table is UNIT_SECTION_LIMIT_WAITLIST_ID, enforced through the constraint IGS_PS_USEC_LIM_WLST_PK. Two unique indexes are documented — IGS_PS_USEC_LIM_WLST_U1 on UNIT_SECTION_LIMIT_WAITLIST_ID and IGS_PS_USEC_LIM_WLST_U2 on UOO_ID — with UOO_ID functioning as a business-key candidate linking the limits record to a single unit offering option.

• UNIT_SECTION_LIMIT_WAITLIST_ID — the surrogate primary key identifying each limits/waitlist configuration row.
• UOO_ID — foreign key to IGS_PS_UNIT_OFR_OPT_ALL, identifying the unit offering option to which these enrollment limits apply.
• ENROLLMENT_EXPECTED — the anticipated enrollment figure for the section.
• ENROLLMENT_MINIMUM — the minimum enrollment threshold; sections below this may be cancelled or flagged.
• ENROLLMENT_MAXIMUM — the upper enrollment cap for the section.
• ADVANCE_MAXIMUM — a pre-registration or advance enrollment ceiling.
• WAITLIST_ALLOWED — flag indicating whether waitlisting is permitted for the section.
• MAX_STUDENTS_PER_WAITLIST — the capacity of the waitlist itself.
• OVERRIDE_ENROLLMENT_MAX — indicates whether the maximum may be overridden.
• MAX_AUDITORS_ALLOWED — the cap on auditors permitted in the section.
• Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on enrollment capacity planning, waitlist configuration reporting, and validation of unit offering options before registration opens. A common query joins the limits record to its parent unit offering option:

• SELECT l.UOO_ID, l.ENROLLMENT_MAXIMUM, l.WAITLIST_ALLOWED, l.MAX_STUDENTS_PER_WAITLIST FROM IGS_PS_USEC_LIM_WLST l WHERE l.UOO_ID = :uoo_id;
• Reporting sections where the waitlist is enabled but no capacity is set: WHERE WAITLIST_ALLOWED = 'Y' AND MAX_STUDENTS_PER_WAITLIST IS NULL.
• Comparing ENROLLMENT_MINIMUM against ENROLLMENT_EXPECTED to flag under-subscribed offerings.
• Identifying rows with OVERRIDE_ENROLLMENT_MAX = 'Y' for governance review.

Because the object is documented as obsolete and not implemented, these patterns apply primarily to historical datasets, migrations, or archived instances prior to the deprecation of the IGS Student System.

Related Objects

• IGS_PS_UNIT_OFR_OPT_ALL — parent table referenced by IGS_PS_USEC_LIM_WLST.UOO_ID; the primary join for resolving offering context.
• IGS_PS_USEC_WLST_PRI — child table referencing UNIT_SECTION_LIMIT_WAITLIST_ID; stores waitlist priority detail rows per limits record.
• IGS_PS_USEC_LIM_WLST_PK / _U1 / _U2 — primary key and unique indexes that define row identity and the UOO_ID business key.
• Related IGS registration and unit offering tables that share the UOO_ID namespace, used alongside the limits record for section scheduling and enrollment processing.