Search Results igs_ps_us_fld_study




Overview
Explore in AI Chat

Overview

The IGS_PS_US_FLD_STUDY table is a core data entity within the Oracle E-Business Suite Student System (Product IGS), specifically designed to manage academic program structures. As indicated by its description, this table describes the field of study details for a unit set. In the context of higher education, a unit set (or unit of study set) typically represents a major, minor, specialization, or other defined academic track within a broader course or program. This table establishes the formal linkage between these unit sets and their associated, standardized fields of study, enabling institutions to categorize and report on academic offerings according to recognized classification schemes. It is critical to note that the ETRM metadata explicitly marks the IGS - Student System module as "Obsolete" and states this specific table is "Not implemented in this database," indicating it may be a legacy or reference object in the documented releases (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental data it holds. The key columns are UNIT_SET_CD, VERSION_NUMBER, and FIELD_OF_STUDY. The UNIT_SET_CD and VERSION_NUMBER together uniquely identify a specific instance of an academic unit set, linking to the IGS_EN_UNIT_SET_ALL table. The FIELD_OF_STUDY column stores a code representing a specific academic discipline or classification (e.g., "COMPSCI," "BIOCHEM"), which is validated against the IGS_PS_FLD_OF_STUDY_ALL table. Each record, therefore, represents a single, valid association between one version of a unit set and one field of study classification.

Common Use Cases and Queries

The primary use case for this table is academic administration and reporting. It allows institutions to answer questions such as: "Which majors (unit sets) are classified under the field of study 'Computer Science'?" or "List all fields of study associated with the Bachelor of Science program." For regulatory reporting, it provides the structured data needed to map internal programs to government or accreditation body classification standards. A typical analytical query would join this table to its parent tables to retrieve descriptive information.

SELECT us.unit_set_cd,
       us.version_number,
       us.unit_set_name,
       fos.field_of_study,
       fos.description
FROM igs_ps_us_fld_study usfs,
     igs_en_unit_set_all us,
     igs_ps_fld_of_study_all fos
WHERE usfs.unit_set_cd = us.unit_set_cd
  AND usfs.version_number = us.version_number
  AND usfs.field_of_study = fos.field_of_study;

Related Objects

As documented in the provided metadata, IGS_PS_US_FLD_STUDY has defined foreign key relationships with two primary tables, forming the backbone of its data integrity.

  • IGS_EN_UNIT_SET_ALL: This is the master table for unit sets. The relationship is established via the columns UNIT_SET_CD and VERSION_NUMBER in IGS_PS_US_FLD_STUDY, which reference the corresponding columns in IGS_EN_UNIT_SET_ALL. This ensures every field-of-study association is tied to a valid, existing unit set.
  • IGS_PS_FLD_OF_STUDY_ALL: This is the master table for field of study codes and descriptions. The FIELD_OF_STUDY column in IGS_PS_US_FLD_STUDY references the FIELD_OF_STUDY column in this table, ensuring that only officially defined academic classifications are assigned to unit sets.