Search Results igs_gr_awd_crm_ut_st

Overview

The table IGS_GR_AWD_CRM_UT_ST is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically designed to support graduation ceremony processing in versions 12.1.1 and 12.2.2. It is important to note that the IGS module itself is marked as obsolete within the EBS ecosystem. This table functions as a detailed child entity, defining the specific unit sets (academic programs or groups of units) that constitute a larger unit set group being processed for a student's award during a nominated graduation ceremony. Its primary role is to maintain the granular association between a ceremony's award details and the precise academic unit sets that qualify a student for that award, ensuring accurate ceremony list generation and credential verification.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a ceremony-specific unit set record. The key columns establish critical relationships to parent entities and define the ceremony context. The GRD_CAL_TYPE and GRD_CI_SEQUENCE_NUMBER identify the graduation calendar and sequence. The CEREMONY_NUMBER, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, and AWARD_CD pinpoint the specific ceremony and the awarded credential. The US_GROUP_NUMBER links to a parent unit set group. Finally, the UNIT_SET_CD and US_VERSION_NUMBER directly reference the specific academic unit set and its version from the student's academic record. According to the provided metadata, this table was not implemented in the documented database instance, indicating it may be part of a reference data model or an unimplemented feature in some deployments.

Common Use Cases and Queries

The primary use case for this table is reporting and validation for graduation ceremonies. Administrators can query it to generate detailed lists of which unit sets are required or completed for each award being conferred in a ceremony. A typical query would join this table to the ceremony master and unit set master tables to produce a ceremony program or to audit student eligibility. For example, to list all unit sets for a specific ceremony award group, one might use a SQL pattern such as: SELECT ut_st.* FROM igs_gr_awd_crm_ut_st ut_st WHERE ut_st.grd_cal_type = :cal_type AND ut_st.grd_ci_sequence_number = :seq AND ut_st.ceremony_number = :cer_num AND ut_st.award_course_cd = :course_cd;. This supports processes like generating ceremony scripts, preparing diploma supplements, and ensuring all academic requirements mapped to the award are correctly accounted for.

Related Objects

IGS_GR_AWD_CRM_UT_ST is centrally positioned within the graduation ceremony data model, with documented foreign key relationships to two key parent tables. Its primary relationship is with the IGS_GR_AWD_CRM_US_GP (Award Ceremony Unit Set Group) table. The join is made using the ceremony and award context columns (GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_CD) plus the US_GROUP_NUMBER, defining the specific group to which the unit set belongs. Secondly, it references the master IGS_EN_UNIT_SET_ALL table via the UNIT_SET_CD and US_VERSION_NUMBER columns. This relationship ties the ceremony-specific record back to the core academic definition of the unit set, ensuring data integrity and enabling the retrieval of the unit set's full description and rules.