Search Results igs_re_thesis_exam




Overview
Explore in AI Chat

Overview

The IGS_RE_THESIS_EXAM table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically designed to manage the examination process for student theses. It functions as the central repository for recording and tracking each distinct examination event associated with a thesis submission. The table's primary role is to store the examination metadata, including its type, result, panel composition, and logistical tracking information. It serves as a critical junction point, linking a specific thesis record to its examination outcomes and the administrative actions taken throughout the evaluation process. Its implementation is consistent across major EBS releases, including versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships that enforce data integrity. The primary key uniquely identifies an examination record by combining the student's PERSON_ID, the CA_SEQUENCE_NUMBER (likely identifying a course attempt), the THES_SEQUENCE_NUMBER (identifying the specific thesis submission), and the CREATION_DT of the exam record. Beyond these identifiers, key columns store the examination's classification and outcome. The THESIS_EXAM_TYPE categorizes the examination (e.g., initial defense, final review). The THESIS_RESULT_CD stores the final outcome code of the examination. The THESIS_PANEL_TYPE indicates the structure of the evaluating committee, while the TRACKING_ID links to a corresponding item in the tracking system (IGS_TR_ITEM_ALL) for workflow and correspondence management.

Common Use Cases and Queries

This table is central to reporting and process automation for graduate studies administration. Common use cases include generating examination schedules, tracking the status and results of thesis defenses, and managing examiner panel assignments. A typical reporting query would join this table to the thesis master (IGS_RE_THESIS_ALL) and related code tables to produce a list of examinations with their results.

Sample Query Pattern:
SELECT tre.person_id, tre.thesis_exam_type, tre.thesis_result_cd, tre.creation_dt
FROM igs_re_thesis_exam tre
JOIN igs_re_thesis_all tra ON tre.person_id = tra.person_id
AND tre.ca_sequence_number = tra.ca_sequence_number
AND tre.the_sequence_number = tra.the_sequence_number
WHERE tre.thesis_result_cd IS NULL; -- To find pending examinations

Related Objects

The IGS_RE_THESIS_EXAM table is deeply integrated into the Student System's data model through documented foreign key relationships.

  • Referenced Objects (Foreign Keys):
  • Referencing Objects (Child Tables):
    • IGS_RE_THS_PNL_MBR: This table references IGS_RE_THESIS_EXAM to store the individual members assigned to the examination panel, linking via the primary key columns (CA_PERSON_ID, CA_SEQUENCE_NUMBER, THE_SEQUENCE_NUMBER, CREATION_DT).