Results for “simultaneous_wlst_alwd_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• INST_WLST_SETUP_ID — the surrogate primary key, uniquely identifying each institution waitlist setup record. It is enforced by the unique index IGS_EN_INST_WL_STPS_PK, which the metadata identifies as the sole business-key candidate.
• WAITLIST_ALLOWED_FLAG — indicates whether waitlisting is enabled at the institution level.
• TIME_CONFL_ALWD_WLST_FLAG — controls whether a student may be placed on a waitlist despite a time conflict with another enrolled course.
• SIMULTANEOUS_WLST_ALWD_FLAG — determines whether a student may hold simultaneous waitlist positions across multiple courses.
• AUTO_ENROLL_WAITLIST_FLAG — governs whether the system automatically enrolls a student when a seat becomes available.
• INCLUDE_WAITLIST_CP_FLAG — specifies whether waitlisted credits are included in credit-point or load calculations.
• MAX_WAITLISTS_STUDENT_NUM — the maximum number of waitlists a single student may occupy.

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.