Search Results igs_ps_uso_clas_meet




Overview
Explore in AI Chat

Overview

IGS_PS_USO_CLAS_MEET is a transactional table within the IGS (Student System) product schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its documented purpose is to record all Unit Section Occurrences that belong to a given Class Meet Group. In practical terms, the table acts as the associative container that ties scheduled meeting occurrences to the grouping structures used for class scheduling, so that multiple teaching occurrences can be collected and reported as a single class meet unit.

The table is owned by the IGS schema and holds a status of VALID. The heuristic Data Vault classification mined from its foreign key structure is link. This is a modeling suggestion rather than a shipped implementation detail: the table resolves a many-to-many style association between class meet groups and unit section occurrences, and its two foreign keys point outward to parent entities, which is the characteristic signature of a link table rather than a hub or a satellite.

Key Information Stored

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

Common Use Cases and Queries

Principal use cases center on schedule reporting and integrity validation. Typical patterns join the table to its parents to reconstruct the full scheduling context.

  • Listing all occurrences for a given class meet group: SELECT u.UNIT_SECTION_OCCURRENCE_ID, u.UOO_ID FROM IGS_PS_USO_CLAS_MEET u WHERE u.CLASS_MEET_GROUP_ID = :group_id;
  • Confirming that every occurrence in a group maps to a valid offering option via the IGS_PS_UNIT_OFR_OPT_ALL join on UOO_ID.
  • Auditing recently maintained groupings using the LAST_UPDATE_DATE and LAST_UPDATED_BY columns.
  • Reporting orphaned or duplicate associations, using the UK1 and U2 unique indexes as the expected uniqueness constraints.

Related Objects

  • IGS_PS_USO_CM_GRP — Parent class meet group; joined on IGS_PS_USO_CLAS_MEET.CLASS_MEET_GROUP_ID.
  • IGS_PS_UNIT_OFR_OPT_ALL — Unit offering option view/table; joined on IGS_PS_USO_CLAS_MEET.UOO_ID.
  • IGS_PS_UNIT_OFR_OPT — Underlying unit offering option entity, transitively reachable through the UOO_ID relationship.
  • IGS_PS_USO_CLAS_MEET_PK / _UK1 / _U1 / _U2 — Primary key and unique index constraints enforcing row identity and documented business keys.