Results for “thesis_panel_type”

36 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_RE_THS_PNL_TYPE table resides in the IGS (Student System) schema and is classified under the Oracle E-Business Suite product family for higher-education institutions. Its documented purpose is to describe the types of thesis panels that may be assembled for thesis examinations. In practical terms, the table functions as a reference or lookup entity within the thesis examination sub-domain of the Student System, defining the permissible categories of examination panels (for example, a standard panel versus a specialized or escalated panel) that can be associated with a thesis exam record.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is described as satellite-leaning. This suggests that, in a dimensional or Data Vault modeling exercise, the table is best treated as a descriptor-bearing satellite rather than a hub or link. Its descriptive attributes (panel size, selection criteria, closure status) support the business key without themselves constituting a relationship between two distinct hubs.

Key Information Stored

The documented physical schema in ETRM 12.1.1 lists eleven columns. The most consequential are:

Common Use Cases and Queries

Typical operational and reporting scenarios center on enumerating valid panel types and joining them to thesis exam records:

  • Listing all active panel types for use in a validation list of values: SELECT THESIS_PANEL_TYPE, DESCRIPTION, RECOMMENDED_PANEL_SIZE FROM IGS_RE_THS_PNL_TYPE WHERE CLOSED_IND = 'N';
  • Reporting thesis examinations grouped by panel type: SELECT p.THESIS_PANEL_TYPE, p.DESCRIPTION, COUNT(e.THESIS_PANEL_TYPE) FROM IGS_RE_THS_PNL_TYPE p JOIN IGS_RE_THESIS_EXAM e ON e.THESIS_PANEL_TYPE = p.THESIS_PANEL_TYPE GROUP BY p.THESIS_PANEL_TYPE, p.DESCRIPTION;
  • Retrieving panel-selection guidance for a given type: SELECT SELECTION_CRITERIA, RECOMMENDED_PANEL_SIZE FROM IGS_RE_THS_PNL_TYPE WHERE THESIS_PANEL_TYPE = :panel_type;
  • Resolving the associated tracking category through the IGS_TR_TYPE_ALL lookup for reporting or integration.
  • Auditing configuration changes by querying LAST_UPDATED_BY and LAST_UPDATE_DATE.

Related Objects

Two relationships are explicitly documented in the ETRM metadata:

  • IGS_TR_TYPE_ALL — referenced by IGS_RE_THS_PNL_TYPE.TRACKING_TYPE (this table is the child).
  • IGS_RE_THESIS_EXAM — references IGS_RE_THS_PNL_TYPE.THESIS_PANEL_TYPE, meaning thesis exam rows depend on a valid panel-type record (this table is the parent).

These two tables constitute the immediate dependency neighbourhood. Any view or concurrent program that surfaces thesis examination data will transitively depend on this reference table through the IGS_RE_THESIS_EXAM join. Additional IGS objects may reference it, but the documented FK graph identifies IGS_TR_TYPE_ALL and IGS_RE_THESIS_EXAM as the significant related entities.