Search Results igs_gr_crm_round_prd

Overview

The IGS_GR_CRM_ROUND_PRD table is a data entity within the Oracle E-Business Suite Student System (IGS), specifically in the context of Graduation (GR) processes. As indicated by its description, this table defines the specific academic completion year and period for which a parent ceremony round will process graduands. Its primary role is to serve as a junction or mapping table, linking a ceremony round to the precise academic timeframe of student completion it is intended to cover. This linkage is essential for accurately identifying and managing the cohort of students eligible for a particular graduation ceremony. It is critical to note that the ETRM metadata explicitly states this table is part of the "Student System (Obsolete)" and was "Not implemented in this database," indicating it may be a legacy or reference object from an earlier data model that was not deployed in the standard EBS 12.1.1/12.2.2 installations.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of four columns that together uniquely identify a record. The key columns are GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER, which identify the parent ceremony round, paired with COMPLETION_YEAR and COMPLETION_PERIOD, which identify the academic timeframe. The GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER columns are foreign keys pointing to the ceremony round master table, IGS_GR_CRMN_ROUND_ALL. The COMPLETION_PERIOD column is a foreign key referencing the IGS_EN_NOM_CMPL_PRD table, which holds valid nomination completion periods. This design ensures referential integrity, enforcing that a round period mapping can only be created for valid ceremony rounds and valid academic completion periods.

Common Use Cases and Queries

The primary use case for this table is to support the setup and execution of graduation ceremony processing. Administrators would use this data to configure which sets of students, grouped by their completion date, are associated with a given ceremony round. A typical reporting or validation query would join this table to the ceremony round and completion period master tables to list all configured mappings. For example: SELECT rnd.round_name, prd.completion_year, prd.completion_period
FROM igs_gr_crm_round_prd prd,
igs_gr_crmn_round_all rnd
WHERE prd.grd_cal_type = rnd.cal_type
AND prd.grd_ci_sequence_number = rnd.sequence_number
ORDER BY rnd.round_name, prd.completion_year; Given its documented status as not implemented, direct operational or data fix scripts targeting this table would be uncommon in a standard EBS instance.

Related Objects

The table maintains defined foreign key relationships with two core tables in the Student System, as per the provided metadata:

• IGS_GR_CRMN_ROUND_ALL: This is the master table for graduation ceremony rounds. The IGS_GR_CRM_ROUND_PRD table references it via the columns GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER. This relationship ties each period mapping to a specific, valid ceremony round.
• IGS_EN_NOM_CMPL_PRD: This table stores valid nomination completion periods. The IGS_GR_CRM_ROUND_PRD table references it via the COMPLETION_PERIOD column, ensuring that the period specified in the mapping is a defined and active academic period within the system.

The primary key constraint IGS_GR_CRM_ROUND_PRD_PK enforces uniqueness on the combination of these four foreign key columns.