Search Results override_enrollment_max




Overview
Explore in AI Chat

Overview

The view IGS_PS_USEC_LIM_WLST_V is an Oracle E-Business Suite (EBS) Student System (IGS) database object owned by the APPS schema. It exposes enrollment capacity, minimum, maximum, and waitlist configuration data for unit offerings (sections) in the Oracle Student System. The view is defined as a thin projection over the base table IGS_PS_USEC_LIM_WLST, selecting every functional column plus a synthetic ROW_ID derived from the physical ROWID. Because it is a view rather than a table, it carries no independent constraints, indexes, or triggers; it is intended to provide a read-only, joined-friendly access point for reporting and integration needs.

For users searching the term enrollment_maximum, this view is the principal IGS object where that attribute is exposed. In EBS 12.1.1 and 12.2.2 the object is registered as VALID within the ETRM metadata, confirming it is a supported, queryable artifact for both releases, and its structure is unchanged between them.

Underlying Base Objects

The documented base object is IGS_PS_USEC_LIM_WLST. The view performs no filtering, joins, or aggregation — every row of the base table is returned. The relationship is therefore one-to-one at the row level: each record in IGS_PS_USEC_LIM_WLST produces exactly one record in the view, with the same column values. No additional referenced base objects are documented in the ETRM metadata for this view.

Functionally, the underlying row is keyed by UNIT_SECTION_LIMIT_WAITLIST_ID and links to a unit offering option through UOO_ID. The UOO (unit offering option) represents a specific section, and the limit/waitlist record defines the enrollment controls applied to that section.

Key Columns

  • ENROLLMENT_MAXIMUM — the ceiling on the number of students permitted to enroll in the unit offering option. This is the column most directly associated with the search term enrollment_maximum.
  • ENROLLMENT_MINIMUM — the minimum enrollment required for the section to proceed.
  • ENROLLMENT_EXPECTED — the anticipated or planned enrollment figure used for planning comparisons.
  • ADVANCE_MAXIMUM — the maximum number of students allowed to enroll in advance of a defined point.
  • OVERRIDE_ENROLLMENT_MAX — a flag/value indicating whether an override to the enrollment maximum has been applied.
  • WAITLIST_ALLOWED — indicates whether a waitlist is permitted for the section.
  • MAX_STUDENTS_PER_WAITLIST — the cap on the number of students who may occupy the waitlist.
  • MAX_AUDITORS_ALLOWED — the maximum number of auditors permitted for the option.
  • UOO_ID — foreign key to the unit offering option, the join key to section and course context.
  • UNIT_SECTION_LIMIT_WAITLIST_ID — the primary identifier for the limit/waitlist configuration row.
  • ROW_ID — synthetic identifier built from the base table ROWID, unique per row at query time.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS who-columns supporting audit and incremental extraction.

Common Use Cases and Queries

The view supports enrollment-capacity reporting, waitlist configuration audits, and integration extracts. A typical query retrieves the enrollment maximum alongside its section context:

  • Detecting sections where enrolled counts approach the maximum.
  • Auditing whether waitlists are enabled and how many waitlist slots are configured.
  • Extracting limit and waitlist configuration for downstream systems, using LAST_UPDATE_DATE for incremental loads.

Sample SQL:

  • SELECT UOO_ID, ENROLLMENT_MINIMUM, ENROLLMENT_MAXIMUM, ENROLLMENT_EXPECTED, WAITLIST_ALLOWED, MAX_STUDENTS_PER_WAITLIST FROM APPS.IGS_PS_USEC_LIM_WLST_V WHERE ENROLLMENT_MAXIMUM IS NOT NULL;
  • SELECT UOO_ID, ENROLLMENT_MAXIMUM, OVERRIDE_ENROLLMENT_MAX FROM APPS.IGS_PS_USEC_LIM_WLST_V WHERE LAST_UPDATE_DATE >= :p_since;

Because the view exposes the full base table without joins, callers must join to the unit offering option tables using UOO_ID when section, course, or term attributes are required.