Search Results igs_re_ths_pnl_mbr_pk

Overview

The IGS_RE_THS_PNL_MBR table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the definitive repository for managing the composition of thesis examination panels. The table's primary role is to record the specific individuals (members) who are selected to serve on a panel for evaluating a student's thesis. This establishes a formal link between a thesis examination event, the panel members, and their designated roles within that panel, which is critical for academic governance, workflow, and auditability in higher education processes.

Key Information Stored

The table stores the unique association between a thesis panel and its members. Its composite primary key underscores the granularity of the data, uniquely identifying a member's assignment to a specific panel instance. Key columns include:

• CA_PERSON_ID, CA_SEQUENCE_NUMBER, THE_SEQUENCE_NUMBER, CREATION_DT: These columns, part of the primary key, collectively serve as a foreign key reference to a specific thesis examination record (IGS_RE_THESIS_EXAM), identifying the exact panel.
• PERSON_ID: The final component of the primary key, this column identifies the individual panel member. It references the HZ_PARTIES table, which holds master party information for persons and organizations within Oracle EBS.
• PANEL_MEMBER_TYPE: Defines the role (e.g., Chair, Internal Examiner, External Examiner) of the member within the panel, referencing the lookup or code table IGS_RE_THS_PNL_MR_TP_ALL.
• THESIS_RESULT_CD: Likely stores a result code or vote submitted by this specific panel member, linking to the IGS_RE_THESIS_RESULT_ALL table for standardized result values.

Common Use Cases and Queries

This table is central to queries and reports concerning thesis examination administration. Common use cases include generating panel rosters for examination scheduling, auditing panel composition against academic policy (e.g., ensuring required external members are present), and aggregating individual member assessments to determine a final thesis result. A typical query would join this table to thesis, person, and member type tables to produce a comprehensive panel list.

Sample SQL Pattern:
SELECT ths.ca_person_id, p.party_name, mbr.panel_member_type, res.result_meaning
FROM igs_re_ths_pnl_mbr mbr,
hz_parties p,
igs_re_ths_pnl_mr_tp_all tp,
igs_re_thesis_result_all res
WHERE mbr.person_id = p.party_id
AND mbr.panel_member_type = tp.panel_member_type
AND mbr.thesis_result_cd = res.thesis_result_cd
AND mbr.ca_person_id = :p_candidate_id;

Related Objects

The IGS_RE_THS_PNL_MBR table is integral to the thesis examination data model, with documented relationships to several key tables:

• Primary Key: IGS_RE_THS_PNL_MBR_PK (CA_PERSON_ID, CA_SEQUENCE_NUMBER, THE_SEQUENCE_NUMBER, CREATION_DT, PERSON_ID).
• Foreign Key References (This table references):
  • HZ_PARTIES on column PERSON_ID (for panel member identity).
  • IGS_RE_THESIS_EXAM on composite columns (CA_PERSON_ID, CA_SEQUENCE_NUMBER, THE_SEQUENCE_NUMBER, CREATION_DT) (for the parent thesis panel).
  • IGS_RE_THESIS_RESULT_ALL on column THESIS_RESULT_CD (for standardized result codes).
  • IGS_RE_THS_PNL_MR_TP_ALL on column PANEL_MEMBER_TYPE (for member role definitions).