Search Results igs_ps_fld_of_study_all




Overview
Explore in AI Chat

Overview

The table IGS_PS_FLD_OF_STUDY_ALL is a core entity within the Oracle E-Business Suite's now-obsolete Student System (IGS). It serves as the master repository for an institution's defined fields of study or academic disciplines. A critical aspect of its design is its independence from external reporting standards; it maintains the university's internal catalog of fields, which are then mapped to government-defined equivalents, such as those required by the Australian Department of Education, Employment and Training (DEET), for official reporting. This abstraction allows for flexible internal academic structures while ensuring compliance with external mandates. The metadata explicitly notes this table was "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed in some instances of EBS 12.1.1 or 12.2.2.

Key Information Stored

The primary data stored revolves around the unique identifier for each field of study. Based on the provided metadata, the central column is FIELD_OF_STUDY, which constitutes the table's primary key (IGS_PS_FLD_OF_STUDY_PK). This key is a code that uniquely identifies an academic discipline within the system. While the full column list is not detailed in the excerpt, the existence of a foreign key relationship from IGS_RE_GV_FLD_OF_SDY to IGS_PS_FLD_OF_STUDY_ALL.GOVT_FIELD_OF_STUDY strongly suggests the table also contains a column for the corresponding government-mapped code, facilitating the DEET reporting requirement mentioned in the description.

Common Use Cases and Queries

The primary use case is the maintenance and retrieval of the master list of academic disciplines. This reference data is essential for configuring courses, units, and student academic histories. Common operational and reporting activities would include associating fields of study with program offerings and generating reports that cross-reference internal fields with their government equivalents for statutory submissions. A typical query would retrieve the mapping for reporting purposes:

  • SELECT f.field_of_study, f.govt_field_of_study, g.deet_reporting_code FROM igs_ps_fld_of_study_all f, igs_re_gv_fld_of_sdy g WHERE f.govt_field_of_study = g.govt_field_of_study;

Another fundamental query would be to list all active fields of study for use in an application form or administrative page:

  • SELECT field_of_study, description FROM igs_ps_fld_of_study_all WHERE closed_ind = 'N' ORDER BY field_of_study;

Related Objects

As evidenced by its extensive foreign key relationships, IGS_PS_FLD_OF_STUDY_ALL is a central reference table for numerous other entities in the Student System. Key related tables include: