Search Results igs_gr_crmn_round_all




Overview
Explore in AI Chat

Overview

The IGS_GR_CRMN_ROUND_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. As a multi-organization enabled table (indicated by the '_ALL' suffix), it stores data across multiple operating units. Its primary function is to define a distinct round of graduation ceremonies. A ceremony round is a logical grouping of ceremonies, typically associated with a specific academic period or term. This table serves as a master definition, enabling the administration to organize and manage multiple related graduation events under a single umbrella, which is essential for planning, scheduling, and reporting on student graduations.

Key Information Stored

The table's structure is defined by its primary key, which uniquely identifies a ceremony round. The key columns are GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER. These columns form a foreign key relationship to the IGS_CA_INST_ALL (Calendar Instance) table, thereby anchoring each ceremony round to a specific academic calendar period. While the provided metadata does not list all non-key columns, the table's purpose implies it would store descriptive and administrative attributes for the round. This likely includes data such as the round's description, status (e.g., Planned, Active, Closed), dates for key milestones (like application deadlines or ceremony dates), and configuration flags controlling the behavior of the graduation process for that specific round.

Common Use Cases and Queries

This table is central to graduation ceremony lifecycle management. Common administrative use cases include setting up a new graduation round for an upcoming term, querying active rounds to manage student applications, and closing completed rounds for historical reporting. For reporting, it is frequently joined to student graduand and award data. A typical query pattern involves joining to the calendar instance to filter rounds by academic period and then to related graduand records.

  • Sample Query to List Active Rounds: SELECT round.grd_cal_type, round.grd_ci_sequence_number, inst.calendar_desc FROM igs_gr_crmn_round_all round, igs_ca_inst_all inst WHERE round.grd_cal_type = inst.cal_type AND round.grd_ci_sequence_number = inst.sequence_number AND inst.cal_status = 'ACTIVE';
  • Reporting Use Case: Generating a list of all students (graduands) eligible for a specific ceremony round by joining IGS_GR_CRMN_ROUND_ALL to IGS_GR_GRADUAND_ALL via the shared key columns.

Related Objects

The IGS_GR_CRMN_ROUND_ALL table is a pivotal hub within the graduation data model, with several key dependencies as documented by its foreign key relationships.

  • Referenced Parent Table:
    • IGS_CA_INST_ALL (Calendar Instance): The ceremony round derives its academic context from this table via the foreign key (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER).
  • Referencing Child Tables:
    • IGS_GR_CRM_ROUND_PRD: Likely stores periods or schedules within a ceremony round.
    • IGS_GR_AWD_CRMN: Links specific award ceremonies to a parent ceremony round.
    • IGS_GR_CRMN_ALL: Stores the detailed ceremony records that belong to a round.
    • IGS_GR_GRADUAND_ALL: The core student graduand records are associated with a specific ceremony round, defining when and how a student will graduate.

All child tables reference IGS_GR_CRMN_ROUND_ALL using the same primary key columns (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER), enforcing strict referential integrity for graduation data.