Search Results igs_ps_fld_std_hist_pk

Overview

The IGS_PS_FLD_STD_HIST_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a historical audit trail, systematically recording all changes to the fields of study associated with specific program versions. Its primary role is to maintain a complete temporal record, ensuring data integrity for academic program structures over time. This historical perspective is critical for accurate academic reporting, auditing compliance, and supporting analyses of program evolution, such as tracking when specific specializations were added or removed from a degree curriculum.

Key Information Stored

The table's structure is designed to uniquely identify each historical record and link it to related master data. The primary key is a composite of four columns: COURSE_CD (the program code), VERSION_NUMBER (the specific version of that program), FIELD_OF_STUDY (the code for the academic specialization), and HIST_START_DT (the effective date when this field of study association began for that program version). The HIST_START_DT is the pivotal column for establishing the historical timeline. Together, these columns ensure a unique record for each point-in-time state of a program version's field of study configuration. The table does not typically store descriptive text for the codes; that information resides in the referenced foreign key tables.

Common Use Cases and Queries

A primary use case is auditing the complete history of fields of study for a given program. For example, an academic registrar may need to verify all specializations that were ever part of a Master of Business Administration (MBA) program, version 2010, for accreditation purposes. Another common scenario is determining the valid field of study for a student who enrolled in a specific term, by comparing the student's program effective date against the HIST_START_DT records. A typical query pattern involves joining to IGS_PS_VER_ALL for program details and IGS_PS_FLD_OF_STUDY_ALL for the field of study description.

SELECT hist.course_cd,
       hist.version_number,
       hist.field_of_study,
       fld.description,
       hist.hist_start_dt
FROM igs_ps_fld_std_hist_all hist,
     igs_ps_fld_of_study_all fld
WHERE hist.course_cd = 'BSC'
  AND hist.version_number = 2022
  AND hist.field_of_study = fld.field_of_study
ORDER BY hist.hist_start_dt DESC;

Related Objects

The table maintains defined foreign key relationships with two critical master tables in the Student System, ensuring referential integrity:

• IGS_PS_VER_ALL (Program Version): The relationship is established via the COURSE_CD and VERSION_NUMBER columns. This links each historical record to the specific academic program version it describes.
• IGS_PS_FLD_OF_STUDY_ALL (Field of Study): The relationship is established via the FIELD_OF_STUDY column. This links the code in the history table to the master definition containing the full name and details of the academic specialization.

The table is referenced by its primary key constraint, IGS_PS_FLD_STD_HIST_PK, and is a likely source for historical academic program reports and data extracts.