Results for “igs_re_sprvsr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_RE_SPRVSR table is a core transactional entity within the Oracle EBS IGS — Student System product family, describing the supervisory relationship between a research student and the person who supervises their research. It resides in the IGS schema and holds status VALID in both Oracle EBS 12.1.1 and 12.2.2. Each row records an assignment of an individual supervisor to a research candidate, together with the effective dates, supervision and funding percentages, the supervisor's role type, and organizational context.

From a dimensional modeling perspective, the mined foreign-key topology classifies this object as satellite-leaning. The table's identity is anchored to the research candidature (IGS_RE_CANDIDATURE_ALL) rather than functioning as an independent hub. A satellite classification is a modeling suggestion: IGS_RE_SPRVSR behaves as a descriptive, time-bound child of the candidature, carrying changing supervisory attributes keyed to a parent person/candidature combination.

Key Information Stored

The 20 documented columns capture supervisory assignment data. The most significant are:

• CA_PERSON_ID and CA_SEQUENCE_NUMBER — the composite reference to the research candidate's record in IGS_RE_CANDIDATURE_ALL. These anchor the supervisor row to a specific candidature.
• PERSON_ID and SEQUENCE_NUMBER — reference the supervisor as a party, plus a sequence distinguishing multiple supervisor records for the same person.
• RESEARCH_SUPERVISOR_TYPE — the role/type of supervision; validated against IGS_RE_SPRVSR_TYPE.
• START_DT and END_DT — the effective period during which the supervisory relationship is active.
• SUPERVISION_PERCENTAGE and FUNDING_PERCENTAGE — the proportion of supervisory responsibility and the funding contribution attributed to this supervisor.
• ORG_UNIT_CD and OU_START_DT — organizational unit responsible for the supervision, and the effective date of that assignment.
• SUPERVISOR_PROFESSION — the supervisor's professional classification.
• REPLACED_PERSON_ID and REPLACED_SEQUENCE_NUMBER — a self-referencing link capturing supervisor succession (who this supervisor replaced).
• COMMENTS — free-text remarks.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

The surrogate-style primary key is defined by IGS_RE_SPRVSR_PK over (CA_PERSON_ID, CA_SEQUENCE_NUMBER, PERSON_ID, SEQUENCE_NUMBER). The unique index IGS_RE_SPRVSR_U1 covers the same four columns, marking this quartet as the business-key candidate and confirming that a given supervisor may appear only once per candidature context.

Common Use Cases and Queries

Typical reporting scenarios include listing active supervisors for a research student, computing total supervision load across a department, and tracking supervisor succession. Because supervision is time-bound, queries should honor START_DT/END_DT.

• Active supervisors for a candidature:
  SELECT PERSON_ID, RESEARCH_SUPERVISOR_TYPE, SUPERVISION_PERCENTAGE
FROM IGS_RE_SPRVSR
WHERE CA_PERSON_ID = :p_person AND CA_SEQUENCE_NUMBER = :p_seq
AND TRUNC(SYSDATE) BETWEEN START_DT AND NVL(END_DT, SYSDATE+1);
• Organizational supervision load:
  SELECT ORG_UNIT_CD, COUNT(*)
FROM IGS_RE_SPRVSR
WHERE TRUNC(SYSDATE) BETWEEN START_DT AND NVL(END_DT, SYSDATE+1)
GROUP BY ORG_UNIT_CD;
• Supervisor succession history via the self-referencing replaced columns.

Reporting tools such as Oracle BI Publisher and the Student System inquiry forms read this table to present supervisor assignments and funding splits.

Related Objects

The following are the most significant related objects, derived from the documented relationships:

• IGS_RE_CANDIDATURE_ALL — parent candidature; joined on CA_PERSON_ID and CA_SEQUENCE_NUMBER.
• HZ_PARTIES — the party master for the supervisor; joined on PERSON_ID.
• IGS_RE_SPRVSR_TYPE — lookup of valid supervisor types; joined on RESEARCH_SUPERVISOR_TYPE.
• IGS_RE_SPRVSR — self-referencing relationship through REPLACED_PERSON_ID/REPLACED_SEQUENCE_NUMBER, and also referenced by itself via CA_PERSON_ID.

Its foreign-key topology places IGS_RE_SPRVSR at the intersection of the candidature record and the party master, reinforcing its role as a linked, time-versioned supervision satellite within the IGS research student subsystem.