Search Results igs_en_or_unit_wlst




Overview
Explore in AI Chat

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

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.