Search Results igs_re_ths_pnl_mr_tp_pk

Overview

The table IGS_RE_THS_PNL_MR_TP_ALL is a reference data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to define and store the distinct types of members that can be appointed to a thesis examination panel. This table serves as a master list of valid panel member classifications, such as Chair, Internal Examiner, External Examiner, or Supervisor, providing a standardized framework for managing the composition of academic review committees for theses and dissertations. It is critical for ensuring data integrity and consistency in the thesis examination process. Notably, the metadata indicates this table is part of the "Obsolete" Student System, suggesting it may belong to a legacy data model that is no longer actively developed or implemented in newer installations, as confirmed by the "Not implemented in this database" note.

Key Information Stored

The table's structure is centered on a code that uniquely identifies each panel member type. The primary and most significant column is PANEL_MEMBER_TYPE, which acts as the unique key for the table. This column stores the short code or abbreviation for a specific member role. A secondary column, TRACKING_TYPE, is defined as a foreign key. This links the panel member type to a corresponding tracking type in the IGS_TR_TYPE_ALL table, potentially allowing for integration with broader workflow or correspondence tracking processes within the student system, such as automating notifications or deadline management for different panel roles.

Common Use Cases and Queries

The primary use case for this table is to validate and constrain data entry in the panel member assignment table (IGS_RE_THS_PNL_MBR). When adding a person to a thesis panel, the system validates the provided member type against this reference table. Common operational queries include retrieving the full list of available member types for a user interface drop-down list or validating a specific type. For reporting, it is typically joined to the member assignment table to translate member type codes into meaningful descriptions for examination panel rosters.

• Sample Query: Retrieve all defined panel member types.
  SELECT PANEL_MEMBER_TYPE FROM IGS_RE_THS_PNL_MR_TP_ALL ORDER BY 1;
• Sample Query: List all thesis panel members with their assigned type.
  SELECT mbr.*, tp.PANEL_MEMBER_TYPE FROM IGS_RE_THS_PNL_MBR mbr, IGS_RE_THS_PNL_MR_TP_ALL tp WHERE mbr.PANEL_MEMBER_TYPE = tp.PANEL_MEMBER_TYPE;

Related Objects

The table maintains defined relationships with other entities in the Student System schema, forming a key part of the thesis examination data model.

• Primary Key: IGS_RE_THS_PNL_MR_TP_PK on column PANEL_MEMBER_TYPE.
• Foreign Key (Outgoing Reference): The column TRACKING_TYPE references the table IGS_TR_TYPE_ALL. This links a panel member type to a broader institutional tracking type.
• Foreign Key (Incoming Reference): The table IGS_RE_THS_PNL_MBR references this table via its PANEL_MEMBER_TYPE column. This is the primary relationship, ensuring every panel member record is assigned a valid type defined in IGS_RE_THS_PNL_MR_TP_ALL.