Search Results igs_ps_field_study




Overview
Explore in AI Chat

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.

  • Table: IGS_PS_FIELD_STUDY 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_FIELD_STUDY,  object_name:IGS_PS_FIELD_STUDY,  status:VALID,  product: IGS - Student System ,  description: This entity describes the fields of study, which apply to a program. ,  implementation_dba_data: IGS.IGS_PS_FIELD_STUDY , 

  • View: IGS_PS_FLD_STUDY_HIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_FLD_STUDY_HIST_V,  object_name:IGS_PS_FLD_STUDY_HIST_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to merge program field of study history with the current program field of study details enabling all details to be accessed over time, up till the current day. Entries represents all column values over defined time periods ,  implementation_dba_data: APPS.IGS_PS_FLD_STUDY_HIST_V , 

  • View: IGS_PS_FIELD_STUDY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_FIELD_STUDY_V,  object_name:IGS_PS_FIELD_STUDY_V,  status:VALID,  product: IGS - Student System ,  description: The entity holds information about field of study ,  implementation_dba_data: APPS.IGS_PS_FIELD_STUDY_V , 

  • Table: IGS_PS_FLD_OF_STUDY_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_FLD_OF_STUDY_ALL,  object_name:IGS_PS_FLD_OF_STUDY_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the university set of fields of study. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values. ,  implementation_dba_data: IGS.IGS_PS_FLD_OF_STUDY_ALL , 

  • Table: IGS_PS_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_VER_ALL,  object_name:IGS_PS_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the versions of programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_VER_ALL ,