Search Results igs_re_sprvsr




Overview
Explore in AI Chat

Overview

The IGS_RE_SPRVSR table is a core data object within the Oracle E-Business Suite Student System (IGS), specifically supporting research administration. It serves as the master repository for recording supervisory relationships for research students (candidates). Each record in this table formally links a research student's candidature to a specific supervisor, defining the nature and context of that supervisory role. Its implementation is critical for managing the academic governance, progress tracking, and reporting requirements associated with higher-degree research programs in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Information Stored

The table's structure is designed to uniquely identify a supervisor assignment within the context of a specific candidature. Its composite primary key underscores this relationship, comprising CA_PERSON_ID and CA_SEQUENCE_NUMBER (identifying the research candidate) and PERSON_ID and SEQUENCE_NUMBER (identifying the supervisor). Beyond these identifiers, a critical column is RESEARCH_SUPERVISOR_TYPE, which classifies the supervisor's role (e.g., Principal, Associate, External) by referencing the code lookup table IGS_RE_SPRVSR_TYPE. The table also supports historical tracking through the REPLACED_PERSON_ID and REPLACED_SEQUENCE_NUMBER columns, which can point to a previous supervisor record that this one supersedes, effectively managing changes in supervisory panels over time.

Common Use Cases and Queries

This table is central to numerous operational and reporting functions. Administratively, it is used to build and maintain a student's supervisory committee. Common reporting use cases include generating lists of all supervisees for a given faculty member, auditing supervisor workloads, and producing compliance reports on supervisory panel composition. A typical query to retrieve a candidate's current supervisory panel would join IGS_RE_SPRVSR to IGS_RE_CANDIDATURE_ALL for candidature details and to HZ_PARTIES for supervisor person details. For example:

  • SELECT cand.person_id AS candidate_id, sup.person_id AS supervisor_id, srt.supervisor_type, sup.sequence_number FROM igs_re_sprvsr sup JOIN igs_re_candidature_all cand ON sup.ca_person_id = cand.person_id AND sup.ca_sequence_number = cand.sequence_number JOIN hz_parties hp ON sup.person_id = hp.party_id JOIN igs_re_sprvsr_type srt ON sup.research_supervisor_type = srt.research_supervisor_type WHERE cand.person_id = :student_id;

Data integrity operations, such as validating that a principal supervisor is assigned, also rely heavily on this table.

Related Objects

The IGS_RE_SPRVSR table exists within a tightly defined schema, with key relationships documented by its foreign keys. It is fundamentally a child of the IGS_RE_CANDIDATURE_ALL table, linking each supervisor record to a specific research candidature via CA_PERSON_ID and CA_SEQUENCE_NUMBER. The supervisor's identity is stored in the Trading Community Architecture (TCA) model, referenced via PERSON_ID to the HZ_PARTIES table. The supervisor's role type is validated against the code table IGS_RE_SPRVSR_TYPE via the RESEARCH_SUPERVISOR_TYPE column. Notably, the table also has a recursive foreign key relationship to itself, where the columns (CA_PERSON_ID, CA_SEQUENCE_NUMBER, REPLACED_PERSON_ID, REPLACED_SEQUENCE_NUMBER) reference another record within IGS_RE_SPRVSR. This enables the system to track the replacement of one supervisor with another for the same candidature, maintaining a complete audit trail of panel changes.

  • Table: IGS_RE_SPRVSR 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_RE_SPRVSR,  object_name:IGS_RE_SPRVSR,  status:VALID,  product: IGS - Student System ,  description: This entity describes a research student's supervisor. ,  implementation_dba_data: IGS.IGS_RE_SPRVSR , 

  • Table: IGS_RE_LGCY_SPR_INT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_RE_LGCY_SPR_INT,  object_name:IGS_RE_LGCY_SPR_INT,  status:VALID,  product: IGS - Student System ,  description: Contains Research Supervisor information to be imported into the IGS_RE_SPRVSR table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table. ,  implementation_dba_data: IGS.IGS_RE_LGCY_SPR_INT , 

  • Table: IGS_RE_SPRVSR_TYPE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_RE_SPRVSR_TYPE,  object_name:IGS_RE_SPRVSR_TYPE,  status:VALID,  product: IGS - Student System ,  description: This entity describes the various types of supervisors for research students. ,  implementation_dba_data: IGS.IGS_RE_SPRVSR_TYPE , 

  • Table: IGS_RE_CANDIDATURE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_RE_CANDIDATURE_ALL,  object_name:IGS_RE_CANDIDATURE_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the candidature details of a research student. ,  implementation_dba_data: IGS.IGS_RE_CANDIDATURE_ALL , 

  • View: IGS_RE_SPRVSR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_RE_SPRVSR_V,  object_name:IGS_RE_SPRVSR_V,  status:VALID,  product: IGS - Student System ,  description: View of RESEARCH_SUPERVISOR table ,  implementation_dba_data: APPS.IGS_RE_SPRVSR_V ,