Search Results igs_he_en_susa_cc




Overview
Explore in AI Chat

Overview

The IGS_HE_EN_SUSA_CC table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS). It is specifically designed to support Higher Education Statistics Agency (HESA) reporting requirements for institutions in the United Kingdom. The table's primary role is to store HESA Cost Center details that are defined at the granular level of a Student Unit Set Attempt (SUSA). A Unit Set Attempt represents a student's enrollment in a specific academic plan or program of study for a given period. By storing cost center information at this level, the system enables precise financial and statistical reporting aligned with HESA's mandatory data collection frameworks, ensuring institutional compliance.

Key Information Stored

The table's central purpose is to associate a Student Unit Set Attempt with specific HESA-defined classification codes. While the full column list is not detailed in the provided metadata, the documented relationships reveal its critical components. The primary key column, HE_SUSA_CC_ID, uniquely identifies each record. A crucial foreign key column is SUBJECT, which links to the IGS_PS_FLD_OF_STUDY_ALL table. This relationship stores the HESA Subject of Study code (also known as the Cost Center or JACS code) applicable to the unit set attempt. Other columns likely include a foreign key to the student's unit set attempt record, effective dates, and potentially other HESA-specific attributes like funding source indicators or percentage allocations.

Common Use Cases and Queries

The primary use case for this table is the generation of statutory HESA student returns, such as the Student Record and Alternative Provider Student Record. Data from this table is extracted to report on the cost centers (subjects) against which a student's activity is funded. Common operational queries involve listing all cost center assignments for a specific student or academic program. For reporting, a typical SQL pattern joins this table to student personal, course, and unit set attempt tables.

SELECT s.person_id, s.course_cd, susa.unit_set_cd,
       cc.subject, fost.fos_desc -- HESA Subject Description
FROM   igs_he_en_susa_cc cc,
       igs_en_su_setatmpt susa,
       igs_ps_fld_of_study_all fost,
       igs_en_stdnt_ps_att s
WHERE  cc.student_unit_set_attempt_id = susa.student_unit_set_attempt_id
AND    cc.subject = fost.fos_cd
AND    susa.person_id = s.person_id
AND    susa.course_cd = s.course_cd;

Related Objects

  • Primary Key Constraint: IGS_HE_EN_SUSA_CC_PK on column HE_SUSA_CC_ID.
  • Foreign Key Relationship (Outgoing): The table references IGS_PS_FLD_OF_STUDY_ALL via the SUBJECT column. This join retrieves the official description and details of the HESA Cost Center/Subject of Study code.
  • Parent Table (Implied): While not explicitly listed in the provided metadata, this table is a child of the Student Unit Set Attempt entity, likely IGS_EN_SU_SETATMPT. It cannot exist without a corresponding attempt record.