Search Results include_waitlist_cp_flag

Overview

IGS.IGS_EN_INST_WL_STPS is the institution-level waitlist setup table within the Oracle E-Business Suite Student Systems (IGS) schema. Its ETRM subtitle, "Institution Setup for Waitlist," accurately describes its purpose: each row captures the waitlist policy controls that govern how course-section waitlisting behaves for a given institution. In practice, this is the configuration backbone behind functionality such as whether students may join waitlists, whether waitlisted units count toward credit-point totals, and whether the system can automatically promote a student from a waitlist into a section.

The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and it is classified by the supplied heuristic Data Vault model as standalone. The documentation reports no foreign keys or dependent objects, so under a Data Vault interpretation this structure is best modeled as a hub-like reference entity keyed by its natural or surrogate institution setup identifier, rather than as a link or satellite. Its transaction-oriented who-columns, however, mean it behaves like an operational setup record that is maintained, versioned, and audited rather than purely immutable.

Key Information Stored

The primary key is INST_WLST_SETUP_ID, the unique identifier for the institution setup row, enforced through the unique index IGS_EN_INST_WL_STPS_PK in the APPS_TS_TX_IDX tablespace. This is the only documented unique index and therefore the only business-key candidate. The remaining columns store configuration flags and limits:

• WAITLIST_ALLOWED_FLAG — primary switch controlling whether waitlisting is enabled at the institution, with allowable values N and Y.
• INCLUDE_WAITLIST_CP_FLAG — determines whether a waitlisted unit section is counted when calculating a student's total credit points.
• AUTO_ENROLL_WAITLIST_FLAG — governs whether automatic enrollment from the waitlist is permitted.
• TIME_CONFL_ALWD_WLST_FLAG — permits or prohibits waitlisting where a time conflict with another enrollment exists.
• SIMULTANEOUS_WLST_ALWD_FLAG — controls whether a student may waitlist simultaneously for multiple sections of the same unit.
• MAX_WAITLISTS_STUDENT_NUM — numeric ceiling on the number of waitlists a student may occupy at the institution.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard who columns used for audit and change tracking.

Common Use Cases and Queries

Typical use cases include validating waitlist policy during enrollment, reporting on credit-point treatment of waitlisted units, and auditing changes to setup flags. A direct lookup retrieves the active policy profile:

• SELECT INST_WLST_SETUP_ID, WAITLIST_ALLOWED_FLAG, INCLUDE_WAITLIST_CP_FLAG, AUTO_ENROLL_WAITLIST_FLAG FROM IGS.IGS_EN_INST_WL_STPS WHERE INST_WLST_SETUP_ID = :p_id;
• SELECT * FROM IGS.IGS_EN_INST_WL_STPS WHERE INCLUDE_WAITLIST_CP_FLAG = 'Y'; — identifies institutions that count waitlisted units in credit-point totals.
• SELECT MAX_WAITLISTS_STUDENT_NUM FROM IGS.IGS_EN_INST_WL_STPS; — reports the configured per-student waitlist limit.

Reporting queries frequently join the flag values to enrollment and waitlist activity tables to reconcile policy against actual student behavior.

Related Objects

The supplied metadata records no foreign keys and states the object has no dependents, so relationships are logical rather than enforced. Functionally, this setup table relates to institution definitions (IGS_IF_INSTITUTIONS), student waitlist and enrollment activity tables, and course-section enrollment tables whose credit-point and auto-enroll behavior is controlled by the flags above. Application code referencing INCLUDE_WAITLIST_CP_FLAG, WAITLIST_ALLOWED_FLAG, and AUTO_ENROLL_WAITLIST_FLAG implements the corresponding business rules; any change to these rows should be assessed against those consumers and the audit columns retained for traceability.