Results for “max_stud_per_wlst”

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

Overview

IGS_EN_OR_UNIT_WLST is an APPS-owned, VALID database view within the Oracle E-Business Suite Student System (IGS) product family. It exposes configuration data describing the wait list options that have been established for enrollment organization units. In the ETRM 12.2.2 metadata the view carries the title "View: IGS_EN_OR_UNIT_WLST" and is documented with the description "This view describes the various organization unit wait list options." Its role within the Student System is to present the wait list control attributes — capacity limits, per-student limits, charge assessment and enrollment/assessment treatment of wait-listed students — that govern how an institution manages wait lists at the organization unit level.

The view is a multi-org secured (operating unit filtered) view rather than a plain projection. The definition restricts returned rows against the ORG_ID value carried in the session's CLIENT_INFO, using a NVL/DECODE pattern that compares the logged-in operating unit to the row's ORG_ID, substituting -99 when no operating unit context is present. This makes it suitable for Forms-based inquiry and for operational reporting where the user should see only the wait list setup belonging to their current organization.

Underlying Base Objects

The ETRM metadata lists no separately documented base objects for this view; the view text itself is definitive. IGS_EN_OR_UNIT_WLST is defined as a SELECT over the table IGS_EN_OR_UNIT_WLST_ALL, which is the multi-org ("_ALL") table holding wait list options for every operating unit. The view therefore acts as the organization-secured single-org layer on top of the _ALL table, returning only rows whose ORG_ID matches the session's operating unit (or -99 when none is set). Because the view selects from the _ALL table using a ROWID-derived ROW_ID and the standard WHO columns, DML considerations are typical of _ALL/_V multi-org pairs in EBS; for reporting purposes it is read-only.

Key Columns

• ROW_ID — ROWID of the underlying row in IGS_EN_OR_UNIT_WLST_ALL.
• ORG_ID — Operating unit (organization) identifier that drives multi-org filtering.
• ORG_UNIT_WLST_ID — Primary identifier for the organization unit wait list option record.
• ORG_UNIT_CD — Organization unit code to which the wait list option applies.
• START_DT — Effective start date of the wait list option.
• CAL_TYPE — Calendar type associated with the wait list definition.
• SEQUENCE_NUMBER — Ordering sequence exposed by the view (defined as NULL in the view text).
• WAITLIST_ALWD — Indicator of whether a wait list is allowed (NULL in view text).
• MAX_WLST_PER_STUD — Maximum number of wait lists per student (NULL in view text).
• MAX_STUD_PER_WLST — Maximum number of students permitted on a wait list.
• SMTANUS_WLST_UNIT_ENR_ALWD — Flag controlling whether simultaneous wait-list and unit enrollment is allowed.
• ASSES_CHRG_FOR_WLST_STUD — Flag indicating whether charges are assessed for wait-listed students.
• CLOSED_FLAG — Indicates whether the wait list option has been closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical uses include validating wait list setup per organization unit, confirming capacity/limit configuration, and reporting on which units permit wait listing and whether wait-listed students are charged. A representative query is:

SELECT ORG_UNIT_CD, START_DT, CAL_TYPE, MAX_STUD_PER_WLST, SMTANUS_WLST_UNIT_ENR_ALWD, ASSES_CHRG_FOR_WLST_STUD, CLOSED_FLAG FROM APPS.IGS_EN_OR_UNIT_WLST WHERE CLOSED_FLAG = 'N' ORDER BY ORG_UNIT_CD, START_DT;

Users querying from a specific operating unit context see only that organization's wait list options, owing to the CLIENT_INFO-based ORG_ID predicate in the view definition. For cross-organization administration, the underlying IGS_EN_OR_UNIT_WLST_ALL table should be queried directly.