Search Results research_supervisor_type




Overview
Explore in AI Chat

Overview

The IGS_RE_SPRVSR_TYPE table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1/12.2.2, specifically in the IGS (iGrants) module. It functions as a lookup or code table that defines and maintains the various categories of supervisors assigned to research students. Its primary role is to enforce data integrity and provide a controlled list of valid supervisor types, such as "Principal," "Associate," or "Advisory," which can then be assigned to individuals in the related supervisor assignment table. This centralized definition ensures consistency across the research management functionality.

Key Information Stored

The table stores the definitional attributes for each supervisor type. The key columns include:

  • RESEARCH_SUPERVISOR_TYPE (VARCHAR2(10), Primary Key): A short code uniquely identifying the supervisor type (e.g., 'PRIN', 'ASSOC').
  • DESCRIPTION (VARCHAR2(60)): A textual explanation of the type, providing clarity for end-users and reports.
  • PRINCIPAL_SUPERVISOR_IND (VARCHAR2(1)): A critical flag indicating whether this supervisor type represents the principal supervisor. This can drive business logic, such as determining who receives official correspondence.
  • CLOSED_IND (VARCHAR2(1)): An active/inactive flag. When set, the type is closed and cannot be selected for new or modified supervisor assignments, supporting data governance.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the creation and last update details for each record.

Common Use Cases and Queries

This table is primarily used in two contexts: application setup and operational reporting. During implementation, administrators populate this table with the institution-specific supervisor types. In daily operations, it is referenced to validate supervisor assignments and generate reports. A common query is to retrieve all active supervisor types for a list of values (LOV) in a form:

SELECT research_supervisor_type, description FROM igs.igs_re_sprvsr_type WHERE closed_ind = 'N' ORDER BY description;

Another frequent reporting need is to list all principal supervisors by joining with the assignment table:

SELECT s.person_id, t.description FROM igs.igs_re_sprvsr s, igs.igs_re_sprvsr_type t WHERE s.research_supervisor_type = t.research_supervisor_type AND t.principal_supervisor_ind = 'Y';

Related Objects

The IGS_RE_SPRVSR_TYPE table has a direct parent-child relationship with the main supervisor assignment table. The documented foreign key relationship is:

  • IGS_RE_SPRVSR: This table stores the actual assignments of individuals as supervisors to research units or students. Its column RESEARCH_SUPERVISOR_TYPE is a foreign key that references IGS_RE_SPRVSR_TYPE.RESEARCH_SUPERVISOR_TYPE. This ensures that every assigned supervisor type is a valid, pre-defined type from the code table.

This relationship is fundamental, as the IGS_RE_SPRVSR_TYPE table provides the domain of valid values that constrain and describe the data in the IGS_RE_SPRVSR table.