Search Results igs_ps_faclty_degrs




Overview
Explore in AI Chat

Overview

The IGS_PS_FACLTY_DEGRS table is a data entity within the Oracle E-Business Suite, specifically the now-obsolete IGS (Integrated Student System) module. Its primary function is to store detailed academic qualification records for faculty members, establishing a formal link between an instructor and their conferred degrees. This table plays a critical role in managing faculty profiles, ensuring institutional compliance, and supporting academic administration by maintaining a verifiable history of faculty credentials. It is important to note that the ETRM documentation explicitly states this table is "Not implemented in this database" for the queried environment, indicating it may exist as a legacy definition or was part of a design not fully deployed in standard Oracle EBS 12.1.1 or 12.2.2 instances.

Key Information Stored

The table's structure is designed to uniquely identify a faculty member's specific degree. The primary identifier is the system-generated FACLTY_DEGRD_ID. The core business keys are the combination of PERSON_ID, which links to the faculty member's party record, DEGREE_CD, which links to the specific degree code, and PROGRAM. While the full column list is not provided in the excerpt, the defined keys imply the table would store data to answer fundamental questions about a faculty member's qualifications: who holds the degree, what specific degree was awarded, and potentially additional context such as the awarding institution or year via the PROGRAM column or other unlisted attributes.

Common Use Cases and Queries

In an implemented system, this table would be central to faculty-related reporting and validation. Common use cases include generating departmental faculty qualification reports, verifying instructor credentials for course assignments, and supporting accreditation audits. A typical query would join this table to person and degree master data to produce a readable profile. For example:

  • SELECT p.party_name, d.degree_name, f.program FROM igs_ps_faclty_degrs f, hz_parties p, igs_ps_degrees d WHERE f.person_id = p.party_id AND f.degree_cd = d.degree_cd;

Given its "Not implemented" status, direct operational or reporting use in a standard EBS environment is unlikely. Any functional requirement for tracking faculty degrees would be fulfilled by other, active tables within the HCM or Student system modules.

Related Objects

Based on the documented foreign key relationships, IGS_PS_FACLTY_DEGRS has defined dependencies on two core master data tables. These relationships enforce data integrity by ensuring that a faculty degree record corresponds to a valid person and a defined degree.

  • HZ_PARTIES: The table is linked via IGS_PS_FACLTY_DEGRS.PERSON_ID to the universal party repository in Oracle Trading Community Architecture. This join retrieves the faculty member's name and other party details.
  • IGS_PS_DEGREES: The table is linked via IGS_PS_FACLTY_DEGRS.DEGREE_CD to the degrees master table. This join provides the official title and attributes of the conferred degree.