Search Results igs_ps_sch_mwc_all




Overview
Explore in AI Chat

Overview

IGS_PS_SCH_MWC_ALL is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It stores information about "meet with group" configurations associated with a unit section occurrence for a particular transaction. In the context of Oracle EBS 12.1.1 and 12.2.2, the IGS product supports higher-education scheduling, enrollment, and academic records processing, and this table captures the grouping relationships that govern how students meet — physically or virtually — within scheduled class structures.

The table is owned by the IGS schema and resides in the APPS-accessible synonym layer, meaning it is normally queried through the APPS schema or via the corresponding _ALL synonym. Its documented physical schema in ETRM 12.1.1 shows 15 columns, a single-column primary key (IGS_PS_SCH_MWC_ALL_PK on MWC_GROUP_ID), and one unique index (IGS_PS_SCH_MWC_ALL_U1 on MWC_GROUP_ID). The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. As a modeling suggestion, this implies the table behaves as a descriptive satellite attached to a parent hub or link — here, the unit section occurrence — rather than acting as an independent hub of business identity.

Key Information Stored

The table distinguishes its surrogate primary key from its business-key candidates as follows:

Common Use Cases and Queries

Typical scenarios include validating meet-with group capacity, reconciling host and guest section assignments, and reporting enrollment limits across scheduled occurrences. A common pattern joins the table to its parent occurrence to resolve context:

  • Capacity reporting: SELECT mwc_group_id, meet_with_class_group_name, mwc_max_enrollment_number FROM igs_ps_sch_mwc_all WHERE org_id = :p_org;
  • Host/guest reconciliation: join HOST_USO_ID and GUEST_USO_ID back to unit section occurrence tables to confirm the pairing.
  • Occurrence linkage: join INT_OCCURS_ID to IGS_PS_SCH_INT_ALL for scheduling detail.
  • Audit extraction: filter on LAST_UPDATE_DATE to capture recently modified group definitions for downstream integration.

Related Objects

The most significant related objects are derived from the documented foreign keys and the surrounding IGS scheduling model:

  • IGS_PS_SCH_USEC_INT_ALL — referenced through INT_USEC_ID; the primary parent occurrence link.
  • IGS_PS_SCH_INT_ALL — referenced through INT_OCCURS_ID; defines the scheduled occurrence.
  • Unit section occurrence and unit offering option tables — resolved via HOST_USO_ID, GUEST_USO_ID, HOST_UOO_ID, and GUEST_UOO_ID.
  • APPS synonyms and the _ALL view layer — the standard access path for reporting and 12.2 Online Patching compatibility.
  • IGS enrollment and scheduling APIs — consume meet-with group data when validating section capacity and enrollment eligibility.

Because _ALL denotes multi-org awareness, queries should generally be filtered by ORG_ID to align with operating unit security in EBS 12.1.1 and 12.2.2.