Search Results testamur_type




Overview
Explore in AI Chat

Overview

The IGS_GR_TESTAMUR_TYPE table is a core reference data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules. It functions as a master repository for defining the different styles or formats of official degree certificates, known as testamurs, that an educational institution can issue. Its primary role is to provide a controlled list of testamur types, enabling the system to manage and generate distinct certificate documents for various award scenarios, such as standard university degrees, joint awards with external partners, or certificates for entrepreneurial clients.

Key Information Stored

The table stores the definitional attributes for each testamur type. The most critical columns include:

  • TESTAMUR_TYPE (VARCHAR2(10), PK): The unique institution-defined code identifying the testamur style (e.g., 'UNIVERSITY', 'JOINT').
  • DESCRIPTION (VARCHAR2(60)): A textual explanation of the testamur type.
  • CORRESPONDENCE_TYPE (VARCHAR2(10), FK): A key column linking to a correspondence type (IGS_CO_TYPE), which dictates the formatting and mailing process when testamurs are generated for distribution.
  • CLOSED_IND (VARCHAR2(1)): A flag indicating whether the testamur type is active ('N') or closed ('Y'), preventing its selection in new or modified award records.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the creation and last update of each record.

Common Use Cases and Queries

This table is central to configuration and operational reporting for degree certification. Administrators use it to maintain the list of available certificate formats. A common operational use case is generating a list of all active testamur types for setup or audit purposes. When a student award is processed, the system references the TESTAMUR_TYPE from the IGS_PS_AWD table to determine the correct certificate template. A typical query to retrieve all active types with their linked correspondence data would be:

SELECT t.testamur_type, t.description, t.correspondence_type, c.description AS corr_desc
FROM igs.igs_gr_testamur_type t,
     igs.igs_co_type c
WHERE t.correspondence_type = c.correspondence_type (+)
AND t.closed_ind = 'N'
ORDER BY t.testamur_type;

For data integrity checks, a query to find awards using a testamur type marked as closed is also valuable for cleanup activities.

Related Objects

The IGS_GR_TESTAMUR_TYPE table has defined relationships with other key entities in the student management schema:

  • Primary Key: IGS_GR_TESTAMUR_TYPE_PK on the TESTAMUR_TYPE column.
  • Foreign Key (Outgoing Reference): The CORRESPONDENCE_TYPE column references the IGS_CO_TYPE table, linking the certificate type to a specific correspondence or document generation template.
  • Foreign Key (Incoming Reference): The table is referenced by the IGS_PS_AWD (Award) table via its TESTAMUR_TYPE column. This is the primary relationship, as each student award record stores which specific testamur type from this master table applies to that award.