Search Results mwc_group_id




Overview
Explore in AI Chat

Overview

IGS.IGS_PS_SCH_MWC_ALL is an interface table in the Oracle E-Business Suite Student Systems (IGS) product family. Its display name, "Export Scheduling Meet-With Class Detail," indicates its purpose: it holds Unit Section "meet-with" class information intended for consumption by a third-party scheduling interface. In the Oracle EBS 12.1.1 schema it is owned by the IGS schema and registered under FND Design Data as IGS.IGS_PS_SCH_MWC_ALL. All rows carry the standard WHO audit columns, and the table resides in the APPS_TS_INTERFACE tablespace, consistent with its role as a staging/export structure rather than a core transactional table.

The object lifecycle is marked active, with public scope and the BUSINESS_ENTITY category IGS_UNIT. The documented metadata notes that the corresponding production table is IGS_PS_USO_CLAS_MEET, meaning this interface table is populated from or destined for that transactional structure. Based on the mined foreign-key topology, the heuristic Data Vault classification is satellite-leaning — that is, it is best modeled as descriptive context attached to a parent hub (the scheduling unit section occurrence/use) rather than as an independent hub or a pure link.

Key Information Stored

The surrogate primary key is MWC_GROUP_ID (IGS_PS_SCH_MWC_ALL_PK), a sequence-generated number that uniquely identifies a meet-with group. A unique index on the same column (IGS_PS_SCH_MWC_ALL_U1) reinforces it as both the physical and business-key candidate.

Common Use Cases and Queries

Typical usage centers on export and reconciliation of scheduling data exchanged with external timetabling systems. Reporting scenarios include auditing maximum-enrollment constraints, verifying host/guest pairings, and detecting stale interface rows pending load.

SELECT mwc_group_id,
       meet_with_class_group_name,
       host_uoo_id,
       guest_uoo_id,
       mwc_max_enrollment_number
  FROM   igs.igs_ps_sch_mwc_all
 WHERE   org_id = :p_org_id;

A join to the interface Unit Section table validates that each group references a loaded scheduling record:

SELECT a.mwc_group_id, a.int_usec_id, b.*
  FROM   igs.igs_ps_sch_mwc_all a,
         igs.igs_ps_sch_usec_int_all b
 WHERE   a.int_usec_id = b.int_usec_id;

Related Objects

  • IGS.IGS_PS_SCH_USEC_INT_ALL — referenced via INT_USEC_ID; the scheduling-interface Unit Section parent.
  • IGS.IGS_PS_SCH_INT_ALL — referenced via the obsolete INT_OCCURS_ID column.
  • IGS.IGS_PS_USO_CLAS_MEET — the documented production counterpart table populated from this interface.
  • Scheduling interface concurrent programs that read IGS_PS_SCH_MWC_ALL to export meet-with class detail to third-party systems.

Because interface tables are transient by design, queries should generally be scoped by ORG_ID and INT_USEC_ID and reconciled against the production table before downstream use.