Search Results completion_period

Overview

The IGS_GR_CRM_ROUND_PRD table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically for the Graduations module. It functions as a configuration and control table for the graduand identification process. Its primary role is to define the academic completion criteria—specifically the year and period—that a given graduation ceremony round will use to select eligible students (graduands). By associating multiple completion years and periods with a single ceremony round, it provides the necessary parameters for the system to automatically identify which student program attempts qualify for inclusion in a specific graduation event.

Key Information Stored

The table stores the linkage between a ceremony round and the academic completion parameters for graduand selection. The key columns are:

• GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER: These columns together form a foreign key reference to a specific graduation ceremony round (IGS_GR_CRMN_ROUND_ALL), defining the parent event.
• COMPLETION_YEAR (NUMBER): The nominated or derived completion year used to filter valid student program attempts.
• COMPLETION_PERIOD (VARCHAR2(30)): The nominated or derived completion period, such as a term or semester, used in conjunction with the completion year. This column has a foreign key relationship to IGS_EN_NOM_CMPL_PRD.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): For auditing and tracking data changes.

The combination of GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, COMPLETION_YEAR, and COMPLETION_PERIOD constitutes the table's unique primary key (IGS_GR_CRM_ROUND_PRD_PK).

Common Use Cases and Queries

This table is central to setting up and reporting on graduation ceremony eligibility. A common administrative use case is configuring which cohorts of students (defined by their program completion date) are processed for an upcoming ceremony. For reporting, it is used to verify the completion criteria applied to a round or to list all rounds that include students from a specific academic period. A fundamental query involves joining to the ceremony round table to see the full context:

SELECT rnd.crm_name,
       prd.grd_cal_type,
       prd.grd_ci_sequence_number,
       prd.completion_year,
       prd.completion_period
FROM igs.igs_gr_crm_round_prd prd,
     igs.igs_gr_crmn_round_all rnd
WHERE prd.grd_cal_type = rnd.cal_type
  AND prd.grd_ci_sequence_number = rnd.ci_sequence_number
  AND rnd.crm_name = 'JUNE 2024 CEREMONY';

Another critical pattern is using the table's data as a filter in queries against student academic records to identify the population of graduands selected for a given round, based on the matching of completion_year and completion_period.

Related Objects

The table has defined relationships with other key entities in the Graduations schema:

• Primary Key: IGS_GR_CRM_ROUND_PRD_PK on (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, COMPLETION_YEAR, COMPLETION_PERIOD).
• Foreign Key (Parent: Ceremony Round): References IGS_GR_CRMN_ROUND_ALL via columns GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER. This links the completion period rule to a specific ceremony instance.
• Foreign Key (Parent: Completion Period): References IGS_EN_NOM_CMPL_PRD via the COMPLETION_PERIOD column. This validates the period value against a master list of academic periods.

These relationships ensure referential integrity, guaranteeing that ceremony rounds and completion periods referenced in IGS_GR_CRM_ROUND_PRD are valid and exist within the system.