Search Results igs_gr_crmn_all

Overview

The table IGS_GR_CRMN_ALL is a core data object within the Oracle E-Business Suite's Student System (IGS), specifically designed to manage graduation ceremonies. It functions as the master record for defining individual ceremony events within a broader graduation cycle. Each record represents a distinct ceremony, such as a morning or afternoon session, linked to a specific graduation calendar period. As indicated by the "_ALL" suffix, the table is a multi-org structure, capable of storing data partitioned by operating unit. It is critical to note the provided metadata explicitly states this table is part of an "Obsolete" module and was "Not implemented in this database" for the documented instance. This status must be considered during any analysis or integration effort, as the table may be absent or its usage superseded in specific EBS deployments.

Key Information Stored

The table's structure is centered on uniquely identifying a ceremony and its logistical details. The primary key is a composite of three columns: GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, and CEREMONY_NUMBER. This defines a hierarchy where a ceremony belongs to a specific graduation calendar instance. While the full column list is not detailed in the excerpt, the foreign key relationships reveal other critical data points. The VENUE_CD column stores a foreign key to the IGS_GR_VENUE_ALL table, indicating the physical location of the ceremony. Other typical attributes for such an entity, inferred from its purpose, would likely include ceremony date and time, capacity, status, and descriptive information.

Common Use Cases and Queries

This table supports processes related to graduation planning and execution. Common operational use cases include scheduling multiple ceremonies for a large graduating class, assigning students to specific ceremonies (via related tables like IGS_GR_AWD_CEREMONY_ALL), and managing venue logistics. For reporting, it enables analysis of ceremony utilization and planning. A fundamental query would join the ceremony to its associated venue and graduation calendar details. For example, to list all ceremonies for a given graduation period:

• SELECT crmn.*, ven.venue_name
• FROM igs_gr_crmn_all crmn,
• igs_gr_venue_all ven
• WHERE crmn.grd_cal_type = '&grad_cal_type'
• AND crmn.grd_ci_sequence_number = &grad_ci_seq_num
• AND crmn.venue_cd = ven.venue_cd(+);

Given the "obsolete" status, direct queries or customizations against this table should be approached with caution and validated against the actual application implementation.

Related Objects

The IGS_GR_CRMN_ALL table sits at the center of a defined relationship hierarchy within the Graduation module, as per the provided metadata.

• Referenced Foreign Keys (Parent Tables): This table references two parent entities for validation.
  • IGS_GR_CRMN_ROUND_ALL: Via columns GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER. This links a ceremony to its parent graduation round or cycle.
  • IGS_GR_VENUE_ALL: Via column VENUE_CD. This links the ceremony to its physical venue details.
• Referencing Foreign Keys (Child Tables): This table is referenced as a parent by two key entities.
  • IGS_GR_AWD_CEREMONY_ALL: Linked via the full primary key (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER). This table manages the assignment of awarded students to specific ceremonies.
  • IGS_GR_CRMN_NOTE_ALL: Also linked via the full primary key. This table stores additional notes or comments related to a specific ceremony.