Search Results igs_gr_testamur_type




Overview
Explore in AI Chat

Overview

The IGS_GR_TESTAMUR_TYPE table is a core reference entity within the Oracle E-Business Suite Student System (IGS) module, specifically governing graduation and award processes. It defines the distinct types or styles of testamurs (official award certificates) that an institution can issue. As a master data table, it provides a controlled list of valid testamur types, such as standard university-issued certificates or specialized versions for entrepreneurial clients or partner organizations. Its primary role is to ensure data integrity and consistency when generating and recording award documentation, serving as a key lookup for the system's graduation and credentialing functions.

Key Information Stored

The table's central column is the TESTAMUR_TYPE, which serves as the primary key and uniquely identifies each testamur style. Based on the provided metadata, a critical foreign key relationship exists via the CORRESPONDENCE_TYPE column, which references the IGS_CO_TYPE table. This link associates each testamur type with a specific correspondence or document template, indicating that the physical layout and content of the certificate are managed through the system's correspondence engine. This structure allows institutions to manage the visual and textual presentation of different certificate types separately from the award logic itself.

Common Use Cases and Queries

This table is essential during the award conferral process. When a student's award is processed, the system references the TESTAMUR_TYPE associated with their award (via the IGS_PS_AWD table) to determine the correct certificate style for printing. Common administrative tasks include maintaining the list of available certificate types and auditing which awards use which styles. A typical query would retrieve all configured testamur types along with their linked correspondence templates:

  • SELECT tt.testamur_type, ct.correspondence_type, ct.description FROM igs_gr_testamur_type tt, igs_co_type ct WHERE tt.correspondence_type = ct.correspondence_type;

Another frequent reporting use case involves listing all academic awards (from IGS_PS_AWD) and their designated testamur types for verification and batch processing of certificate generation.

Related Objects

The IGS_GR_TESTAMUR_TYPE table has defined relationships with several other key entities in the Student System. Its primary foreign key dependency is on the IGS_CO_TYPE table, which stores correspondence types. Most importantly, the IGS_PS_AWD (Academic Award) table holds a foreign key, IGS_PS_AWD.TESTAMUR_TYPE, referencing this table. This establishes that each academic award record is configured to produce a specific type of testamur. Consequently, any process or report generating graduation certificates will traverse this relationship from the award to the testamur type and finally to the corresponding document template.