Search Results igs_en_inst_wl_stps




Overview
Explore in AI Chat

Overview

The IGS_EN_INST_WL_STPS table (Institution Setup for Waitlist) is a configuration table within the IGS — Student System product of Oracle E-Business Suite. It stores institution-level parameters that govern how waitlist processing behaves for students attempting to enroll in courses that have reached capacity. Rather than capturing transactional waitlist activity itself, this table holds the setup flags and thresholds that the enrollment engine consults when determining whether waitlisting is permitted, how conflicts are handled, and whether automatic enrollment from a waitlist should occur. As such, it functions as a control/master record that parameterizes downstream waitlist processing across an institution.

The ETRM metadata classifies this object heuristically as standalone under Data Vault modeling conventions. This suggests it be modeled as an independent hub-like reference entity, since no foreign-key relationships to other tables were mined from its FK structure. In practice, its rows are keyed by a single surrogate identifier and reference no external parent, reinforcing its role as a self-contained setup entity.

Key Information Stored

The table contains 12 documented columns in the 12.1.1 schema. The most significant are the controlling setup flags and limits:

The remaining columns are standard Oracle audit attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. Notably, no institution or organization foreign key is documented among the columns, consistent with the standalone classification.

Common Use Cases and Queries

This table is primarily consulted by enrollment and registration logic to validate waitlist actions, and by administrators configuring waitlist policy. Typical reporting includes auditing which institutions permit waitlisting and reviewing auto-enrollment behavior. A representative query retrieving the active policy for a setup record follows:

  • SELECT INST_WLST_SETUP_ID, WAITLIST_ALLOWED_FLAG, AUTO_ENROLL_WAITLIST_FLAG, MAX_WAITLISTS_STUDENT_NUM FROM IGS.IGS_EN_INST_WL_STPS WHERE INST_WLST_SETUP_ID = :id;
  • Reporting all institutions with waitlisting disabled: ... WHERE WAITLIST_ALLOWED_FLAG = 'N';
  • Auditing auto-enrollment configuration: ... WHERE AUTO_ENROLL_WAITLIST_FLAG = 'Y';

These queries support functional setup validation and troubleshooting of student waitlist eligibility.

Related Objects

The metadata documents no foreign-key relationships, so this object is a setup parent rather than a dependent. It is logically referenced by waitlist processing components of the IGS enrollment engine, and its audit columns align with the standard Oracle Applications audit convention shared across IGS tables such as those in the IGS_EN_* family. Administrators typically configure values here through the Student System setup user interface rather than direct DML, and the flags are consumed at runtime by enrollment APIs that determine student waitlist eligibility and automatic seat assignment.