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:
- THESIS_PANEL_TYPE — the primary key column and the business identifier for each panel type. It is both the single-column primary key (IGS_RE_THS_PNL_TYPE_PK) and the unique-index candidate (IGS_RE_THS_PNL_TYPE_U1). There is no separate surrogate key; the business key and the primary key coincide.
- DESCRIPTION — the human-readable name or narrative for the panel type.
- CLOSED_IND — a flag indicating whether the panel type is retired and therefore unavailable for new thesis examination assignments.
- RECOMMENDED_PANEL_SIZE — the suggested number of examiners on a panel of this type.
- TRACKING_TYPE — a foreign key to IGS_TR_TYPE_ALL, allowing the panel type to be tied to a defined tracking category.
- SELECTION_CRITERIA — free-text guidance on how panel members should be chosen.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns capturing row provenance and change history.
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.
-
This table describes the types of thesis panels which can be used for thesis examinations.
-
This entity describes the thesis examination and its actions
-
This entity describes the history of statuses of the thesis examination
-
View: IGS_RE_THESIS_EXAM_V 12.1.1
APPS.IGS_RE_THESIS_EXAM_V·↳ IGS_RE_THESIS_EXAM·Explore IGS module →
-
View: IGS_RE_THS_EXAM_HIST 12.1.1
APPS.IGS_RE_THS_EXAM_HIST·↳ IGS_RE_THS_EXAM_HIST_ALL·Explore IGS module →
-
Contains Research Thesis information to be imported into the IGS_RE_THESIS_ALL table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
-
View: IGS_RE_THS_EXAM_HIST 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_RE_THESIS_EXAM_V 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_RE_THS_PNL_TYPE 12.2.2
This table describes the types of thesis panels which can be used for thesis examinations.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_RE_VAL_TPM 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.