Search Results igs_ps_field_study

Overview

The IGS_PS_FIELD_STUDY table is a core data entity within the Oracle E-Business Suite Student System (IGS). It serves as a junction table that defines the relationship between academic programs and their associated fields of study. Its primary role is to map specific fields of study, such as majors, minors, or concentrations, to defined program offerings (courses and their versions). This mapping is essential for curriculum management, student enrollment tracking, degree audit processes, and reporting on program composition.

Key Information Stored

The table's structure is designed to enforce the relationship between a program version and a field of study. The key columns, which collectively form the table's primary key, are:

• COURSE_CD: Stores the unique code identifying the academic program or course.
• VERSION_NUMBER: Stores the version number of the specific program, allowing for curriculum changes over time.
• FIELD_OF_STUDY: Stores the code for the specific field of study (e.g., "COMPSCI", "ECON") that is applicable to the program version.

Together, these columns ensure that a given field of study can be associated only once with a specific program version, maintaining data integrity for academic planning.

Common Use Cases and Queries

This table is central to queries that analyze program structures. A common reporting use case is to list all fields of study available within a specific program. For example, to retrieve the fields of study for the 'BSC' program, version 2022:

• SELECT field_of_study FROM igs_ps_field_study WHERE course_cd = 'BSC' AND version_number = 2022;

Another critical use case is in degree audit systems, where a student's completed courses are checked against the required fields of study for their enrolled program version. Integration points often involve joining this table with student enrollment or academic plan data to validate progress. Data from this table is also frequently extracted for external accreditation reports that require a detailed breakdown of a program's curricular components.

Related Objects

The IGS_PS_FIELD_STUDY table maintains defined foreign key relationships with two primary tables, as documented in the ETRM metadata:

• IGS_PS_VER_ALL: This relationship validates that the COURSE_CD and VERSION_NUMBER in IGS_PS_FIELD_STUDY exist as a valid program version. The join is performed on the columns IGS_PS_FIELD_STUDY.COURSE_CD and IGS_PS_FIELD_STUDY.VERSION_NUMBER.
• IGS_PS_FLD_OF_STUDY_ALL: This relationship validates that the FIELD_OF_STUDY code in IGS_PS_FIELD_STUDY is a defined and active field of study. The join is performed on the column IGS_PS_FIELD_STUDY.FIELD_OF_STUDY.

These relationships ensure referential integrity, meaning a field of study cannot be assigned to a non-existent program version, and the field of study code itself must be predefined in the system.