Search Results class_meet_group_id




Overview
Explore in AI Chat

Overview

IGS_PS_USO_CM_GRP_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family. It joins class meeting group definitions to their associated calendar instances, producing a denormalized result set that combines scheduling attributes from both the meeting group record and the calendar instance it references. In the ETRM 12.2.2 documentation, this object is classified under IGS – Student System (Obsolete), and the implementation note states that the view is "not implemented in this database." This designation means the object exists in the ETRM metadata repository for reference purposes, but the physical view is not deployed in the documented environment. Its presence in the data dictionary reflects the historical Student System schema, where meeting group and calendar constructs are used to model timetabling and enrollment capacity for taught offerings.

Underlying Base Objects

The view is defined over two base tables: IGS_PS_USO_CM_GRP (aliased CMG) and IGS_CA_INST (aliased CI). IGS_PS_USO_CM_GRP stores the class meeting group header records, including the group name, calendar type, and sequence number. IGS_CA_INST stores calendar instance data, including alternate codes, validity dates, and sequence numbering. The join condition is CMG.CAL_TYPE = CI.CAL_TYPE AND CMG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, which links each meeting group to exactly one calendar instance for a given calendar type and sequence. Although the ETRM metadata lists no referenced base objects, the view text in the documentation excerpt explicitly identifies both tables and their join keys.

Key Columns

The view exposes fifteen columns. ROW_ID carries the row identifier of the underlying IGS_PS_USO_CM_GRP record. CLASS_MEET_GROUP_ID is the primary identifier for a class meeting group and is the column most frequently used as a search or lookup key, which corresponds directly to the user's search term. CLASS_MEET_GROUP_NAME provides the descriptive label for the group. CAL_TYPE and CI_SEQUENCE_NUMBER represent the join keys linking the meeting group to its calendar instance. ALTERNATE_CODE, START_DT, and END_DT are drawn from IGS_CA_INST and describe the calendar instance's alternate identifier and active date range. The audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN support change tracking and concurrency analysis. MAX_ENR_GROUP and MAX_OVR_GROUP define enrollment capacity thresholds for the group, distinguishing normal enrollment limits from override limits.

Common Use Cases and Queries

Typical usage centers on reporting class meeting group schedules alongside calendar instance validity periods, and on validating that enrollment capacities are correctly configured. A representative query is:

  • SELECT CLASS_MEET_GROUP_ID, CLASS_MEET_GROUP_NAME, CAL_TYPE, CI_SEQUENCE_NUMBER, ALTERNATE_CODE, START_DT, END_DT, MAX_ENR_GROUP, MAX_OVR_GROUP FROM IGS_PS_USO_CM_GRP_V WHERE CLASS_MEET_GROUP_ID = :p_group_id;
  • Reporting all active groups for a calendar type within a date window: WHERE CAL_TYPE = :p_cal_type AND START_DT <= SYSDATE AND END_DT >= SYSDATE.
  • Comparing enrollment limits across groups: ordering by MAX_ENR_GROUP or filtering on MAX_OVR_GROUP to identify groups with override capacity.

Because the object is documented as obsolete and not implemented in the reference database, these queries should be validated against the target environment before use. In supported releases, equivalent scheduling data may be sourced from the current Student System tables, but the view remains a useful reference for understanding how class meeting groups relate to calendar instances.