Search Results igs_gr_graduand_pk

Overview

The IGS_GR_GRADUAND_ALL table is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed to manage graduand details. A graduand is defined as a student who has completed the requirements for an award but has not yet formally graduated. This table serves as a central repository for tracking a student's progression from program completion to the formal conferral of their degree or credential. It is critical for managing the graduation lifecycle, including ceremony planning, honors calculation, and award issuance. Notably, the ETRM documentation explicitly marks the IGS - Student System product as "Obsolete," indicating this table belongs to a legacy module that may have been superseded in later EBS implementations or by Oracle's Campus Solutions.

Key Information Stored

The table's structure is anchored by a composite primary key consisting of PERSON_ID and CREATE_DT, which uniquely identifies a graduand record for an individual at a specific point in time. Based on the provided foreign key relationships, the table stores several critical pieces of information. The PERSON_ID links the graduand to the core person/party entity (HZ_PARTIES) and their specific program attempt (IGS_EN_STDNT_PS_ATT_ALL). The GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER columns reference a specific graduation ceremony round (IGS_GR_CRMN_ROUND_ALL), associating the graduand with a planned graduation event. Furthermore, the HONOURS_LEVEL column links to a defined set of honors classifications (IGS_GR_HONOURS_LEVEL_ALL), storing the calculated or assigned honors level for the student's award.

Common Use Cases and Queries

This table is primarily used in processes related to graduation management and reporting. Common operational and analytical use cases include generating lists of eligible graduands for an upcoming ceremony, producing official graduation programs, auditing the graduation pipeline, and tracking honors designations. A typical query might join this table to person and program data to create a graduand roster. For example:

• Identifying graduands for a specific ceremony round to manage seating and ticket allocation.
• Reporting on the number of graduands by college, department, or honors level for institutional planning.
• Providing a data source for batch processes that generate diplomas or official transcripts post-conferral.

Given the module's obsolete status, direct interaction with this table in new customizations is generally discouraged in favor of supported public APIs or newer data models.

Related Objects

The IGS_GR_GRADUAND_ALL table is integral to the graduation data model, with documented relationships to several other EBS entities.

• Primary Key: IGS_GR_GRADUAND_PK (PERSON_ID, CREATE_DT)
• Foreign Keys (Referenced By This Table):
  • IGS_GR_CRMN_ROUND_ALL via columns GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER.
  • IGS_GR_HONOURS_LEVEL_ALL via column HONOURS_LEVEL.
  • HZ_PARTIES via column PERSON_ID.
  • IGS_EN_STDNT_PS_ATT_ALL via columns PERSON_ID and COURSE_CD.
• Foreign Keys (Referencing This Table):
  • IGS_GR_AWD_CRMN_HIST references IGS_GR_GRADUAND_ALL via its PERSON_ID and CREATE_DT columns, creating a historical record of award and ceremony details linked to the core graduand record.