Search Results igs_gr_awd_crm_us_gp




Overview
Explore in AI Chat

Overview

The table IGS_GR_AWD_CRM_US_GP is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It is designed to manage the administrative grouping of unit sets for processing during specific graduation ceremonies. Its primary role is to act as a junction entity, logically organizing the unit sets associated with a particular award being conferred at a ceremony. This grouping facilitates batch processing and reporting for graduation operations. Notably, the provided ETRM metadata explicitly states this table is "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed or was superseded in the documented releases (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each unit set group within the context of a graduation ceremony and award. The key columns are GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER (identifying the graduation calendar instance), CEREMONY_NUMBER, AWARD_COURSE_CD and AWARD_CRS_VERSION_NUMBER (identifying the specific award course), AWARD_CD (the award itself), and US_GROUP_NUMBER. The US_GROUP_NUMBER is the pivotal field, representing the identifier for a distinct group of unit sets being processed together. The table itself likely serves as a header, with detailed unit set information stored in related child tables.

Common Use Cases and Queries

In a functional implementation, this table would support graduation ceremony planning and execution. Key use cases would include generating ceremony-specific lists of graduates grouped by their unit sets for program printing, organizing the order of proceedings, and managing the batch creation of academic documents. A typical query would join this table to the ceremony and award details to list all unit set groups for a specific event. For example:

  • Identifying all unit set groups for a ceremony: SELECT US_GROUP_NUMBER FROM IGS_GR_AWD_CRM_US_GP WHERE GRD_CAL_TYPE = :1 AND GRD_CI_SEQUENCE_NUMBER = :2 AND CEREMONY_NUMBER = :3;
  • Reporting on the distribution of groups across awards within a ceremony by joining to related award ceremony tables.

Given its "not implemented" status, direct operational use in standard EBS 12.1.1/12.2.2 is unlikely, but understanding its structure is vital for analyzing customizations or data migrations involving legacy IGS data.

Related Objects

Based on the documented foreign key relationships, IGS_GR_AWD_CRM_US_GP is a parent table to at least two other entities in the graduation model. These relationships enforce data integrity, ensuring that unit set details and ceremony notes are associated with a valid, predefined group.

  • IGS_GR_AWD_CRM_UT_ST: This table references IGS_GR_AWD_CRM_US_GP via a foreign key on all primary key columns (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_CD, US_GROUP_NUMBER). It likely stores the specific unit set details for each defined group.
  • IGS_GR_AWD_CRMN: This table also references IGS_GR_AWD_CRM_US_GP via the same full set of primary key columns. It is likely used to attach ceremony-related notes or remarks at the unit set group level.

These relationships position IGS_GR_AWD_CRM_US_GP as a central control point for grouping logic within the graduation ceremony workflow for awards.