Search Results faculty_id

Overview

The IGS.IGS_EN_SPLACE_FACS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, as indicated by the IGS schema. Its primary function is to manage the many-to-many relationship between student placements and faculty members. For each student placement record, this table stores the identifiers of the associated faculty or faculties responsible for supervising or evaluating that placement. This enables the system to track which academic staff are linked to specific experiential learning activities, a critical requirement for academic administration, reporting, and compliance.

Key Information Stored

The table is composed of two primary business columns and a set of standard audit columns. The SPLACEMENT_ID is a mandatory NUMBER column that serves as the foreign key to the main student placement record. The FACULTY_ID is a mandatory NUMBER(15) column that holds the identifier for the faculty member associated with the placement. Together, these two columns form a composite primary key, ensuring a unique relationship between a specific placement and a specific faculty member. The remaining columns—CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN—are standard EBS "Who" columns that capture audit information for every row's creation and modification.

Common Use Cases and Queries

A primary use case is generating reports on faculty workload, listing all student placements for which a specific faculty member is responsible. This is essential for departmental planning and resource allocation. Another common scenario involves validating or displaying faculty information when viewing a detailed student placement record within the application. A typical query to retrieve all faculty assigned to a specific placement would be:

• SELECT f.FACULTY_ID, p.PARTY_NAME FROM IGS_EN_SPLACE_FACS f JOIN IGS_PE_HZ_PARTIES p ON f.FACULTY_ID = p.PARTY_ID WHERE f.SPLACEMENT_ID = :placement_id;

Conversely, to find all placements supervised by a particular faculty member, the query pattern would be:

• SELECT s.* FROM IGS_EN_SPLACEMENTS s JOIN IGS_EN_SPLACE_FACS f ON s.SPLACEMENT_ID = f.SPLACEMENT_ID WHERE f.FACULTY_ID = :faculty_id;

Related Objects

The IGS_EN_SPLACE_FACS table sits at the intersection of two key entities, as defined by its foreign key relationships. It is a child table of IGS.IGS_EN_SPLACEMENTS, referencing it via the SPLACEMENT_ID column. This links each faculty association directly to a master student placement record. Secondly, it references IGS.IGS_PE_HZ_PARTIES via the FACULTY_ID column, which is the standard table for storing person and organization information within the Trading Community Architecture (TCA) model, confirming that faculty are modeled as parties within the system. The table itself is referenced by an APPS synonym (APPS.IGS_EN_SPLACE_FACS), which is the standard access point for all application code and queries.