Search Results guest_uoo_id

Overview

IGS_PS_SCH_MWC is an Oracle E-Business Suite 12.1.1 / 12.2.2 view owned by the APPS schema and defined in the Student Systems (formerly Student Information / Student Records) product family. The name decomposes as: IGS (the IGS% product family prefix used across Student Systems tables), PS (Student Schedule / program-of-study scheduling), SCH (schedule), and MWC (Meet With Class). The view therefore exposes "meet with class" group definitions — records that associate a host class or unit offering with a guest class or unit offering so that the two are scheduled to convene together, together with a maximum enrollment constraint.

In the context of the user's search term "PSM 1.2", PSM is simply the table alias adopted inside the view text (FROM IGS_PS_SCH_MWC_ALL PSM), not a separate product or module. The view presents the meet-with-class enrollment grouping metadata in a form filtered by the caller's operating unit (ORG_ID), which makes it suitable for multi-org secured reporting and integration rather than direct table access.

Because the view is defined over the _ALL variant of its base table, it is the appropriate access point for queries that must respect Oracle EBS Multi-Org security delivered through USERENV('CLIENT_INFO').

Underlying Base Objects

The view is defined on a single documented base object, IGS_PS_SCH_MWC_ALL (aliased PSM). No additional joins, but the row is projected using PSM.ROWID as the first selected column, which permits the view to support updatable/identifiable row semantics and allows callers to reference underlying rows unambiguously.

The _ALL suffix indicates the table stores records across all operating units, with each row carrying an ORG_ID. The view applies an inline Multi-Org predicate that compares the row's ORG_ID against the operating unit derived from USERENV('CLIENT_INFO'). The expression decodes the first character of CLIENT_INFO — if it is a space the value is treated as NULL, otherwise the first ten characters are converted to a number — and falls back to the sentinel -99 on failure. Both sides of the comparison use the identical NVL/TO_NUMBER/DECODE pattern, so rows are returned only when the row-level ORG_ID matches the session operating unit, or when both resolve to the -99 default.

Key Columns

• ROWID — physical row identifier projected from the base table; useful in DML and in correlated updates.
• MWC_GROUP_ID — primary identifier of the meet-with-class group.
• MEET_WITH_CLASS_GROUP_NAME — descriptive name of the group.
• HOST_USO_ID / GUEST_USO_ID — the host and guest unit set offering identifiers defining which offerings meet together.
• HOST_UOO_ID / GUEST_UOO_ID — the corresponding unit offering option identifiers, giving the more granular scheduling level.
• MWC_MAX_ENROLLMENT_NUMBER — the maximum enrollment permitted for the combined group.
• INT_OCCURS_ID — internal occurrence identifier linking the group to the scheduling occurrence.
• ORG_ID — operating unit, driving the view's Multi-Org filter.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns.

Common Use Cases and Queries

Typical usage covers validation of combined-class scheduling, reconciliation of host/guest pairings, and extraction of enrollment caps for downstream reporting. Because ORG_ID filtering is intrinsic, no additional operating-unit predicate is normally required.

• List all meet-with-class groups in the current operating unit:
  SELECT mwc_group_id, meet_with_class_group_name, host_uoo_id, guest_uoo_id, mwc_max_enrollment_number FROM apps.igs_ps_sch_mwc;
• Find groups exceeding a given enrollment cap:
  SELECT mwc_group_id, mwc_max_enrollment_number FROM apps.igs_ps_sch_mwc WHERE mwc_max_enrollment_number > 100;
• Join to unit offering option tables to resolve host/guest offering details using HOST_UOO_ID and GUEST_UOO_ID.
• Audit recently modified groups via LAST_UPDATE_DATE.

Callers should remember that rows belonging to other operating units are invisible unless the session CLIENT_INFO is set appropriately.