Search Results gac_id




Overview
Explore in AI Chat

Overview

The IGS_GR_AWD_CRMN table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically designed to manage graduation ceremonies. As indicated by its description, this table stores the detailed association between individual graduands (students eligible for an award) and a specific award ceremony. It serves as a critical junction table, linking student award records to the logistical and scheduling details of the ceremony event. It is important to note that the metadata explicitly labels the IGS - Student System as "Obsolete," indicating this table is part of a legacy product line. Furthermore, the provided documentation states it is "Not implemented in this database," which may suggest it is a reference object from a data model that was not fully deployed in certain instances or versions, including the referenced 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to track a graduand's participation in a ceremony. Its structure is defined by a composite primary key (IGS_GR_AWD_CRMN_PK) on the GAC_ID column, which uniquely identifies each graduand-ceremony association. The table's foreign key relationships reveal other critical data points it stores. These include identifiers for the graduation calendar (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER), the specific ceremony (CEREMONY_NUMBER), and the awarded qualification (AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_CD). It also holds practical ceremony details for the graduand, such as ACADEMIC_GOWN_SIZE and ACADEMIC_HAT_SIZE, which are foreign keys to the IGS_GE_MEASUREMENT table for standardized sizing.

Common Use Cases and Queries

This table enables key administrative processes for graduation event management. Common use cases include generating the official list of participants for a ceremony, managing the physical logistics of academic regalia by size, and confirming a student's scheduled attendance. A typical reporting query would join this table to student personal and award data to produce a ceremony roster. For example:

  • Identifying all graduands in a specific ceremony for seating or name-reading order.
  • Aggregating academic gown and hat size requirements for a ceremony to facilitate vendor orders.
  • Verifying a student's assigned ceremony details against their awarded program.

Given the "obsolete" and "not implemented" status, direct operational use in active EBS 12.1.1/12.2.2 environments is unlikely, but the table remains important for understanding historical data models or for custom extensions.

Related Objects

The IGS_GR_AWD_CRMN table has defined relationships with several other entities in the Graduation model, as per the provided foreign key metadata:

  • IGS_GR_AWD_CRM_US_GP: Linked via multiple ceremony and award course columns (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_CD) and US_GROUP_NUMBER. This likely manages ceremony user groups.
  • IGS_GR_CRMN_ROUND_ALL: Linked via the graduation calendar columns (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER). This associates the graduand with a specific round or session of the ceremony.
  • IGS_GE_MEASUREMENT (two relationships): Linked separately via the ACADEMIC_GOWN_SIZE and ACADEMIC_HAT_SIZE columns to a centralized table for measurement values.