Search Results igs_he_st_prog_cc




Overview
Explore in AI Chat

Overview

The IGS_HE_ST_PROG_CC table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to store Higher Education Statistics Agency (HESA) Cost Center details that are defined at the program version level. This table is essential for institutions in the UK that are required to report detailed financial and activity data to HESA, linking specific academic programs to standardized cost centers for funding and analytical purposes. It acts as a junction table, associating program versions with specific fields of study and their corresponding HESA-defined cost classifications.

Key Information Stored

The table's structure is designed to maintain the relationship between a program version and its HESA cost center. The primary key is the unique identifier column, HE_PROG_CC_ID. Two critical foreign key columns, COURSE_CD and VERSION_NUMBER, link directly to the IGS_PS_VER_ALL table, thereby identifying the specific academic program version. Another key column is SUBJECT, which is a foreign key to the IGS_PS_FLD_OF_STUDY_ALL table, storing the code for the field of study or subject area associated with the cost center for that program. Collectively, these columns enable the system to define and retrieve the correct HESA cost center for any given instance of a student's program of study.

Common Use Cases and Queries

The primary use case for this table is the generation of accurate HESA student returns, which are mandatory regulatory submissions. Data from this table ensures that each student's program activity is reported under the correct financial cost center. Common operational queries involve validating or listing cost center assignments for audit purposes. A typical reporting query might join this table to program and student enrollment data to prepare extracts for submission.

  • Sample Query: Retrieving cost center details for all active program versions.
    SELECT pv.course_cd, pv.version_number, cc.subject, fos.description
    FROM igs_he_st_prog_cc cc,
    igs_ps_ver_all pv,
    igs_ps_fld_of_study_all fos
    WHERE cc.course_cd = pv.course_cd
    AND cc.version_number = pv.version_number
    AND cc.subject = fos.fos_cd(+);

Related Objects

IGS_HE_ST_PROG_CC has defined dependencies on several other key tables in the Student System, as indicated by its foreign keys.

  • IGS_PS_VER_ALL: The primary parent table. The foreign key (COURSE_CD, VERSION_NUMBER) enforces referential integrity to valid program versions.
  • IGS_PS_FLD_OF_STUDY_ALL: The parent table for the SUBJECT column, providing valid codes and descriptions for academic fields of study.
  • IGS_HE_ST_PROG_CC_PK: The primary key constraint on the HE_PROG_CC_ID column, guaranteeing uniqueness for each record.

This table is likely referenced by various HESA-specific reporting interfaces and processes within the IGS module to compile statutory returns.