Results for “faculty_number”

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

Overview

IGSBV_FACULTY_PLACEMENT is a read-only base view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to expose the details of faculty members who are associated with a student placement record. In the Oracle EBS 12.1.1 and 12.2.2 data models, placements are managed within the IGS_EN_SPLACEMENTS entity, while the linkage between a placement and the faculty responsible for supervising or supporting it is stored in IGS_EN_SPLACE_FACS. The view joins these two operational tables against the Trading Community Architecture party registry (HZ_PARTIES) so that faculty identity can be reported in a consistent, human-readable manner.

Because the view is defined with the WITH READ ONLY clause, it is intended strictly for query and reporting purposes. It shields consumers from the underlying normalized structures and presents a denormalized, reporting-friendly projection that pairs placement context (student, course, unit occurrence) with faculty identification (party number). This makes it suitable for operational reports, integration extracts, and ad-hoc investigation of placement supervision.

Underlying Base Objects

The view text defines three referenced objects:

• IGS_EN_SPLACE_FACS FACS — the placement-faculty assignment table, supplying the placement identifier and faculty identifier and audit columns.
• HZ_PARTIES PE — the TCA party registry, joined on FACS.FACULTY_ID = PE.PARTY_ID to resolve the faculty party number.
• IGS_EN_SPLACEMENTS SPLAC — the placement header, joined on FACS.SPLACEMENT_ID = SPLAC.SPLACEMENT_ID to supply the student, course code, and unit occurrence.

The joins are inner joins, so a row appears only where a valid faculty assignment, a matching party record, and a matching placement record all exist. No additional base objects are documented in the ETRM metadata for this view.

Key Columns

• STUDENT_PLACEMENT_IDENTIFIER (SPLACEMENT_ID) — the placement record key, inherited from IGS_EN_SPLACEMENTS.
• FACULTY_IDENTIFIER (FACULTY_ID) — the party identifier of the assigned faculty member.
• FACULTY_NUMBER (PE.PARTY_NUMBER) — the descriptive party number for the faculty member, the most reportable faculty attribute.
• PERSON_IDENTIFIER (SPLAC.PERSON_ID) — the person identifier of the placed student.
• PROGRAM_CODE (SPLAC.COURSE_CD) — the course code associated with the placement.
• UNIT_SECTION_IDENTIFIER (SPLAC.UOO_ID) — the unit occurrence/offering identifier for the placement.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns reflecting the faculty assignment record.

Common Use Cases and Queries

Typical uses include listing faculty assigned to a given placement, producing faculty supervision rosters for a course or unit occurrence, and feeding integration extracts with faculty-to-placement associations. A simple query by placement follows:

• SELECT faculty_number, faculty_identifier, program_code FROM igsbv_faculty_placement WHERE student_placement_identifier = :placement_id;
• SELECT student_placement_identifier, faculty_number FROM igsbv_faculty_placement WHERE program_code = :course_cd ORDER BY faculty_number;

Because the view is read-only and grounded in the base tables, it can be safely referenced in concurrent program extracts and BI Publisher data templates without risk of DML against the underlying entities.