Search Results asses_chrg_for_wlst_stud




Overview
Explore in AI Chat

Overview

IGS_EN_OR_UNIT_WLST_ALL is a configuration table in the Oracle E-Business Suite IGS (Student System) product line. Per the ETRM metadata, it is classified as Obsolete and is documented as "Not implemented in this database" for the 12.1.1 and 12.2.2 reference environments. Its logical purpose, as stated in the object description, is to store the fields required to define organization unit waitlists — that is, the parameters that govern how a student may be placed on a waitlist for a specific academic organization unit (such as a department, school, or program) and how that waitlist behaves.

Within the EBS student data model, the table functions as the waitlist configuration anchor for an organization unit and calendar period. Its schema is versioned as an "_ALL" table, implying a multi-org (Operating Unit / ORG_ID) data model consistent with the IGS convention. The heuristic Data Vault classification supplied in the metadata is satellite-leaning. This should be read as a modeling suggestion rather than a physical design fact: the table carries a surrogate primary key plus descriptive and policy attributes (flags, maximums, sequence), and its only outbound foreign key points to HZ_PARTIES via ORG_ID. That combination is characteristic of a descriptive satellite attached to an organizational hub, rather than a pure hub or a link table resolving many-to-many relationships.

Key Information Stored

The documented physical schema contains 17 columns. The most significant are summarized below.

  • ORG_UNIT_WLST_ID — the surrogate primary key, enforced by IGS_EN_OR_UNIT_WLST_ALL_PK. This is also the sole column in unique index U1, making it the definitive row identifier and the column referenced by downstream tables.
  • ORG_UNIT_CD — the organization unit code identifying which unit the waitlist configuration applies to.
  • START_DT — the effective start date of the waitlist configuration.
  • CAL_TYPE — the calendar type that scopes the configuration.

ORG_UNIT_CD, START_DT, and CAL_TYPE together form unique index U2 and therefore constitute the documented business-key candidates: any single organization unit may have only one waitlist configuration per calendar type and start date. This distinction between the surrogate key (ORG_UNIT_WLST_ID) and the composite business key is important when writing idempotent loads or reconciliation queries.

The remaining columns hold the operative policy settings: SEQUENCE_NUMBER governs ordering, WAITLIST_ALWD is the master enablement flag, MAX_WLST_PER_STUD and MAX_STUD_PER_WLST cap waitlist entries per student and students per waitlist respectively, SMTANUS_WLST_UNIT_ENR_ALWD controls whether simultaneous waitlist and unit enrollment is permitted, ASSES_CHRG_FOR_WLST_STUD determines whether charges are assessed to waitlisted students, and CLOSED_FLAG marks the configuration as inactive. Standard EBS audit columns are present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ORG_ID.

Common Use Cases and Queries

Because the table is obsolete and not implemented, queries are typically encountered when migrating from legacy Student System installations, auditing historical configurations, or mapping to successor structures. Typical patterns include:

  • Resolving the active configuration for a unit: filter on ORG_UNIT_CD, CAL_TYPE, and CLOSED_FLAG = 'N', and select the row with the greatest START_DT less than or equal to the reporting date.
  • Capacity and policy reporting: aggregate WAITLIST_ALWD, MAX_STUD_PER_WLST, and MAX_WLST_PER_STUD by ORG_UNIT_CD to review waitlist limits across the institution.
  • Multi-org filtering: restricted by ORG_ID joined to the operating unit dimension.
  • Duplicate detection: group by ORG_UNIT_CD, START_DT, CAL_TYPE to confirm the U2 uniqueness rule holds in migrated data.

A representative query joining the child priority table is:

SELECT w.ORG_UNIT_CD, w.START_DT, w.CAL_TYPE, p.*
FROM IGS_EN_OR_UNIT_WLST_ALL w
JOIN IGS_EN_ORUN_WLST_PRI p ON p.ORG_UNIT_WLST_ID = w.ORG_UNIT_WLST_ID
WHERE w.CLOSED_FLAG = 'N';

Related Objects

  • IGS_EN_ORUN_WLST_PRI — the principal dependent object; it references this table through IGS_EN_ORUN_WLST_PRI.ORG_UNIT_WLST_ID, holding the priority ordering of students on the waitlist.
  • HZ_PARTIES — referenced outbound via IGS_EN_OR_UNIT_WLST_ALL.ORG_ID, resolving the owning party or operating unit context.
  • IGS_EN_OR_UNIT_WLST_ALL_PK and IGS_EN_OR_UNIT_WLST_ALL_U2 — the primary and business-key unique indexes that constrain row identity and enforce the unit/date/calendar rule.
  • IGS student enrollment and registration tables and concurrent programs that consume waitlist policy during enrollment processing — these are functional dependents where the configuration values are read at runtime.