Search Results igs_re_ths_pnl_type




Overview
Explore in AI Chat

Overview

The IGS_RE_THS_PNL_TYPE table is a core reference table within the Oracle E-Business Suite Student System (IGS), specifically designed for managing postgraduate research administration. Its primary function is to define and store the distinct types of thesis examination panels that can be convened to assess a student's thesis. This table acts as a master list, ensuring consistency and standardization in the configuration of thesis examination processes. It is important to note that the ETRM metadata explicitly marks the IGS - Student System as "Obsolete," indicating this table belongs to a legacy module. Furthermore, the provided documentation states "Not implemented in this database," which suggests the table structure may exist in the data dictionary but is not populated or actively used in a standard deployment of the specified EBS versions (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is centered on classifying panel types. The primary and most critical column is THESIS_PANEL_TYPE, which serves as the unique identifier (Primary Key: IGS_RE_THS_PNL_TYPE_PK) for each type of panel, such as "Initial Review," "Final Defense," or "Appeal." Another significant column is TRACKING_TYPE, which establishes a foreign key relationship. This column likely links the thesis panel type to a corresponding tracking or workflow type defined in the IGS_TR_TYPE_ALL table, enabling integration with broader process tracking mechanisms within the student system.

Common Use Cases and Queries

In an active implementation, this table would be referenced whenever a thesis examination is being scheduled or configured. Administrative staff would select a valid panel type from this list. Common reporting and validation queries would include listing all available panel types or verifying the existence of a specific type before creating a thesis exam record. A typical SQL pattern for such validation or lookup would be:

  • SELECT thesis_panel_type, description FROM igs_re_ths_pnl_type WHERE enabled_flag = 'Y' ORDER BY 1;
  • SELECT COUNT(*) FROM igs_re_thesis_exam te WHERE te.thesis_panel_type = '&PANEL_TYPE'; (to find usage of a specific panel type)

Given the "Obsolete" and "Not implemented" status, direct operational or reporting use in a standard EBS 12.1.1/12.2.2 environment is unlikely. Any interaction would typically be for data analysis or migration purposes related to legacy data.

Related Objects

The table maintains defined relationships with other entities in the student system schema, as documented in the ETRM metadata.

  • References (Foreign Key Out): IGS_RE_THS_PNL_TYPE.TRACKING_TYPE column references the IGS_TR_TYPE_ALL table. This links a panel type to a system tracking type.
  • Referenced By (Foreign Key In): The IGS_RE_THESIS_EXAM table references IGS_RE_THS_PNL_TYPE via its THESIS_PANEL_TYPE column. This is the primary relationship, where individual thesis examination records are assigned a type defined in this master table.