Results for “igs_ps_uso_cm_grp_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_USO_CM_GRP is a table within the Oracle Student System (IGS) product family, historically shipped as part of the Oracle E-Business Suite higher-education solution. Its documented purpose is to store information about all Class Meet Groups created in Oracle Student System. A Class Meet Group represents a logical grouping construct used to organize class meeting instances so that scheduling, enrollment capacity, and instructor assignment rules can be applied uniformly across a related set of meetings.

Within Oracle EBS 12.1.1 and 12.2.2, the IGS product line is classified as obsolete. The ETRM metadata explicitly records the implementation status as "Not implemented in this database," meaning the table is retained for reference and upgrade-continuity purposes but is not created or populated in a standard EBS installation. The heuristic Data Vault classification derived from the foreign-key structure is satellite-leaning, which suggests modeling this object as a satellite attached to a class-meeting or calendar-instance hub rather than as an independent hub or a linking table.

Key Information Stored

The documented physical schema for release 12.1.1 lists eleven columns owned by the IGS schema. The most significant of these are described below.

• CLASS_MEET_GROUP_ID — the surrogate primary key of the table, enforced through IGS_PS_USO_CM_GRP_PK and also exposed as unique index IGS_PS_USO_CM_GRP_U1. It uniquely identifies each class meet group record.
• CLASS_MEET_GROUP_NAME — the user-facing name assigned to the meet group.
• CAL_TYPE and CI_SEQUENCE_NUMBER — together these form part of the composite unique index IGS_PS_USO_CM_GRP_U2 (CLASS_MEET_GROUP_NAME, CAL_TYPE, CI_SEQUENCE_NUMBER), which functions as the business-key candidate. CAL_TYPE identifies the calendar type and CI_SEQUENCE_NUMBER identifies the associated calendar instance, linking the group to a specific academic calendar context.
• MAX_ENR_GROUP and MAX_OVR_GROUP — capacity-related attributes defining maximum enrollment and maximum override thresholds for the group.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns capturing who created and last modified the record and when.

The distinction between the surrogate key (CLASS_MEET_GROUP_ID) and the business-key candidates is important: integrations and reporting should reference the surrogate identifier for joins, while the composite of name, calendar type, and sequence number governs uniqueness from a user perspective.

Common Use Cases and Queries

Because the object is obsolete, the primary practical scenarios are upgrade assessment, data archival, and historical reporting on legacy Student System installations. A typical reconciliation query joins the group to its child class meetings:

SELECT g.class_meet_group_id, g.class_meet_group_name, g.cal_type, g.ci_sequence_number, m.class_meet_id FROM igs_ps_uso_cm_grp g, igs_ps_uso_clas_meet m WHERE g.class_meet_group_id = m.class_meet_group_id;

Capacity analysis uses MAX_ENR_GROUP and MAX_OVR_GROUP against actual enrollment figures. Calendar-instance validation joins CAL_TYPE and CI_SEQUENCE_NUMBER to IGS_CA_INST_ALL to confirm that each group is anchored to a valid calendar instance.

Related Objects

• IGS_PS_USO_CLAS_MEET — the principal child table; its CLASS_MEET_GROUP_ID column references IGS_PS_USO_CM_GRP, so each class meeting is associated with its parent group.
• IGS_CA_INST_ALL — referenced by CAL_TYPE and CI_SEQUENCE_NUMBER, supplying the calendar instance definition.
• IGS_PS_USO_CM_GRP_PK and IGS_PS_USO_CM_GRP_U1 / U2 — the primary key and unique indexes that enforce record and business-key integrity.
• Broader IGS scheduling and enrollment objects that consume class meet group definitions for term-based capacity and instructor assignment reporting.