Results for “person_identifier”

50+ results




Overview
Explore in AI Chat

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

Overview

The view IGSBV_SUPERVISORS_PLACEMENTS belongs to the IGS — Student System product family within Oracle E-Business Suite, a module now classified as obsolete in the ETRM repository. Its documented purpose is to serve as a base view that returns the details storing supervisors for a placement. In practical terms, the view flattens the many-to-many association between student placements and the supervisors assigned to them, presenting one row per supervisor-to-placement relationship enriched with party and program context.

The prefix "BV" indicates a base view, meaning the object is intended as an internal building block for higher-level, user-facing views, reports, or integration extracts rather than as an end-user query surface. Consequently, it holds a narrow column set and no business logic beyond the joins required to resolve identifiers. The view was not implemented in the documented database, so its appearance in a customer instance depends on whether the IGS Student System schemas and their supporting objects were installed. A search for "supervisor_number" typically leads to this view because SUPERVISOR_NUMBER is one of its exposed column aliases, mapping the internal supervisor identifier to a human-readable party number. The object is defined with WITH READ ONLY, confirming that it is strictly a reporting and extraction artifact with no DML support.

Underlying Base Objects

The documented view text defines the object over three base tables joined on two equality predicates. IGS_EN_SPLACE_SUPS supplies the placement-to-supervisor assignment itself, including the surrogate keys and the standard "who columns" (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). HZ_PARTIES resolves the supervisor reference to a party, providing the party number used for the supervisor number column. IGS_EN_SPLACEMENTS supplies the placement detail, including the person, course, and unit offering identifiers.

The joins are defined as SUPS.SUPERVISOR_ID = PE.PARTY_ID and SUPS.SPLACEMENT_ID = SPLAC.SPLACEMENT_ID. The ETRM metadata records no separately documented referenced base objects, so the three tables above are the authoritative dependency set. Because HZ_PARTIES is a shared Oracle Trading Community Architecture table, the view crosses from the IGS placement data model into the common party model, which is what allows supervisor identification to be expressed consistently with other EBS party-based reporting.

Key Columns

  • STUDENT_PLACEMENT_IDENTIFIER — Alias over SPLACEMENT_ID from IGS_EN_SPLACEMENTS; identifies the placement record.
  • SUPERVISOR_IDENTIFIER — Alias over SUPERVISOR_ID from IGS_EN_SPLACE_SUPS; the internal key linking the assignment to a party.
  • SUPERVISOR_NUMBER — Derived from PE.PARTY_NUMBER; the user-recognizable supervisor reference and the column most commonly targeted by searches for "supervisor_number".
  • PERSON_IDENTIFIER — The placement person (student) identifier from IGS_EN_SPLACEMENTS.
  • PROGRAM_CODE — Aliases COURSE_CD, indicating the course or program context of the placement.
  • UNIT_SECTION_IDENTIFIER — Aliases UOO_ID, the unit offering option against which the placement is recorded.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns sourced from the supervisor assignment table.

Note that the view returns the party number rather than the supervisor's name; descriptive attributes such as party name reside in HZ_PARTIES and the person profile tables and are not projected here.

Common Use Cases and Queries

The typical use case is listing supervisors attached to placements for a student, program, or unit offering, and reconciling supervisor party numbers against placement records. A representative query joining the view to party name information follows:

  • SELECT v.STUDENT_PLACEMENT_IDENTIFIER, v.SUPERVISOR_NUMBER, p.party_name
  • FROM IGSBV_SUPERVISORS_PLACEMENTS v, HZ_PARTIES p
  • WHERE v.SUPERVISOR_IDENTIFIER = p.party_id
  • AND v.PROGRAM_CODE = :course_code;

A second pattern retrieves all supervisors for a given placement or student:

  • SELECT SUPERVISOR_NUMBER, SUPERVISOR_IDENTIFIER
  • FROM IGSBV_SUPERVISORS_PLACEMENTS
  • WHERE PERSON_IDENTIFIER = :person_id
  • ORDER BY SUPERVISOR_NUMBER;

Because the object is read-only and built from base tables, it is suitable for concurrent program extracts, BI Publisher data sets, and ad hoc reconciliation. Consumers should account for the possibility of multiple supervisors per placement and for the view's absence in environments where the obsolete IGS Student System was never implemented.