Search Results igs_re_sprvsr_type




Overview
Explore in AI Chat

Overview

The IGS_RE_SPRVSR_TYPE table is a foundational reference entity within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary role is to define and maintain the distinct categories or classifications of supervisors assigned to research students. This table acts as a master list of valid supervisor types, such as Principal Supervisor, Associate Supervisor, or External Advisor, ensuring data integrity and consistency across the research supervision module. It is critical for enforcing business rules related to supervisor responsibilities, reporting hierarchies, and compliance within academic research programs. Notably, the ETRM metadata explicitly classifies the IGS - Student System product as "Obsolete," indicating this table belongs to a legacy functional area that may be phased out or replaced in more recent EBS versions or Oracle's subsequent product roadmap.

Key Information Stored

Based on the provided metadata, the table's structure centers on a code-based primary key. The most critical column is RESEARCH_SUPERVISOR_TYPE, which serves as the unique identifier (Primary Key: IGS_RE_SPRVSR_TYPE_PK) for each supervisor type. While the specific descriptive name column is not detailed in the excerpt, standard practice for such reference tables suggests the likely presence of a column such as DESCRIPTION to provide a meaningful name for each type code. The table's purpose is to store a controlled, non-transactional list of these type codes, which are then referenced by transactional data elsewhere in the system.

Common Use Cases and Queries

The primary use case for this table is to validate and constrain data entry in the supervisory assignment process. When assigning a supervisor to a research candidate, the application ensures the selected type exists in IGS_RE_SPRVSR_TYPE. Common reporting and query scenarios include generating lists of all defined supervisor types for setup purposes or analyzing the distribution of supervisor roles across a faculty. A typical SQL pattern involves joining this table to the main supervision transactional table.

  • Listing all configured supervisor types: SELECT research_supervisor_type FROM igs_re_sprvsr_type ORDER BY 1;
  • Finding all supervisors of a specific type (e.g., 'PRINCIPAL'): SELECT s.* FROM igs_re_sprvsr s, igs_re_sprvsr_type t WHERE s.research_supervisor_type = t.research_supervisor_type AND t.research_supervisor_type = 'PRINCIPAL';

It is crucial to note the ETRM's "Not implemented in this database" flag, which implies that in the specific database instance documented, this table may exist as a shell without populated data, potentially altering its practical use.

Related Objects

The table maintains a direct parent-child relationship with the primary supervision assignment table. The documented foreign key relationship is:

  • IGS_RE_SPRVSR: This is the core table storing records of individuals assigned to supervise specific research students. Its column RESEARCH_SUPERVISOR_TYPE is a foreign key (FK) that references IGS_RE_SPRVSR_TYPE.RESEARCH_SUPERVISOR_TYPE. This relationship ensures that every supervisor assignment in the IGS_RE_SPRVSR table must have a type that is valid and pre-defined in the IGS_RE_SPRVSR_TYPE reference table.