Results for “selection_criteria”
50+ 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.
-
Stores material overhead rules
-
Stores material overhead rules
-
APPS.CST_MATERIAL_OVHD_RULES_V·↳ CST_COST_TYPES·↳ CST_MATERIAL_OVHD_RULES·↳ MFG_LOOKUPS·Explore BOM module →
-
APPS.CST_MATERIAL_OVHD_RULES_V·↳ CST_COST_TYPES·↳ CST_MATERIAL_OVHD_RULES·↳ MFG_LOOKUPS·Explore BOM module →
-
Calling lists supported by CP services
-
Calling lists supported by CP services
-
eTRM - IEO Tables and Views 12.1.1
Currently-defined voice messages available to be played to callee
-
eTRM - IEO Tables and Views 12.2.2
Currently-defined voice messages available to be played to callee