Search Results igs_ps_fld_of_study_pk

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:

• IGS_PS_FLD_STD_HIST_ALL and IGS_PS_US_FLD_STUDY: Likely store historical and current field of study associations for students and program units.
• IGS_PS_UNIT_FLD_STDY and IGS_PS_FIELD_STUDY: Associate fields of study with specific academic units and programs.
• IGS_RE_CDT_FLD_OF_SY and IGS_RE_GV_FLD_OF_SDY: Manage government reporting and credit-related mappings for fields of study.
• IGS_HE_* tables (e.g., IGS_HE_EN_SUSA_CC, IGS_HE_ST_PROG_CC): Support higher education-specific functionality and statutory reporting in regions like the UK.
• IGS_AD_TER_EDU and IGS_SS_AD_ACADIN_STG: Tie fields of study to admissions and tertiary education records.