Results for “igs_en_inst_wlst_opt”

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

Overview

The IGS_EN_INST_WLST_OPT view is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. As documented in the ETRM metadata for release 12.2.2, it "holds all the institution specific wait list options." The view exposes configuration data that governs how wait lists are handled for enrollment at the institution level, allowing functional users, reports, and external interfaces to retrieve wait list policy settings without directly querying the underlying multi-organization table.

Because the view is owned by the APPS schema and carries a status of VALID, it is intended to be referenced by name from custom reports, concurrent programs, and integration extracts in both 12.1.1 and 12.2.2 environments. The defining characteristic of the view is that it is organization-aware: it applies an operating unit (ORG_ID) filter derived from the session's client information, presenting only the wait list options relevant to the current institution context.

Underlying Base Objects

The view is defined over a single documented base object, IGS_EN_INST_WLST_OPT_ALL, which stores the institution-specific wait list options across all operating units. The view text selects from this table and applies a predicate that restricts rows to the current organization.

The organization filter is implemented using the standard multi-organization access pattern:

• A value is obtained from USERENV('CLIENT_INFO'), extracting up to ten characters beginning at position one.
• A DECODE converts a leading space to NULL; otherwise the extracted value is used.
• The result is converted with TO_NUMBER and compared, using NVL(..., -99), to the ORG_ID of the base row.
• Rows whose ORG_ID is NULL are matched against a fallback value of -99, allowing globally defined options to be visible.

The ETRM metadata documents no additional referenced base objects beyond IGS_EN_INST_WLST_OPT_ALL; the view is a straightforward filtered projection of that table.

Key Columns

The view exposes the following columns:

• ROW_ID — the base table ROWID, aliased for use in updatable or identifying contexts.
• ORG_ID — the operating unit (institution) to which the wait list option belongs.
• INST_WAITLIST_ID — the identifier of the institution wait list option record.
• CAL_TYPE — the calendar type to which the wait list option applies, distinguishing the academic calendar context.
• SEQUENCE_NUMBER — the ordering sequence used to prioritize wait list options within a calendar type.
• WAITLIST_ALWD — flag indicating whether wait listing is allowed for the institution/calendar configuration.
• SMLNES_WAITLIST_ALWD — flag indicating whether simultaneous wait listing is allowed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns recording who created and last modified the row and when.

Common Use Cases and Queries

Typical uses include reporting on institutional wait list policy, validating configuration before an enrollment cycle, and feeding integration extracts that require wait list settings per calendar type.

Retrieve all wait list options visible to the current institution:

SELECT org_id, inst_waitlist_id, cal_type, sequence_number,
       waitlist_alwd, smlnes_waitlist_alwd
FROM   igs_en_inst_wlst_opt
ORDER BY cal_type, sequence_number;

Identify options where wait listing is enabled:

SELECT org_id, cal_type, sequence_number
FROM   igs_en_inst_wlst_opt
WHERE  waitlist_alwd = 'Y';

Inspect audit information for a specific option:

SELECT inst_waitlist_id, created_by, creation_date,
       last_updated_by, last_update_date
FROM   igs_en_inst_wlst_opt
WHERE  cal_type = :cal_type;

Because the view enforces the operating unit filter, queries executed from an APPS session return only rows for the active organization, and callers must set the client information context appropriately to retrieve the intended institution's data.