Search Results program_cost_centre_desc




Overview
Explore in AI Chat

Overview

The view APPS.IGSFV_PROG_HESA_COST_CENTRES is a read-only reporting construct within the Oracle EBS Student System (part of the iGS / Higher Education suite). It exposes the association between academic programmes (courses) and the cost centres to which they are mapped for statutory HESA (Higher Education Statistics Agency) reporting. In the UK higher education sector, cost centre attribution is a mandatory regulatory return; institutions must declare, for each programme of study, the proportion of activity allocated to each recognised HESA cost centre.

The view consolidates the raw mapping rows held in IGS_HE_PROG_OU_CC with descriptive attributes drawn from programme, organisational unit, and reference-code sources. Rather than presenting coded identifiers alone, the view resolves codes into human-readable descriptions for the cost centre, the owning organisational unit, and the subject field of study. This makes it directly suitable for operational reporting, reconciliation, and downstream extracts that feed statutory returns or data warehouses, without requiring joins to be re-authored by every report developer.

Underlying Base Objects

The view is defined over two primary base tables, joined with an outer join (the (+) operator) so that cost centre mapping records are retained even where a matching programme version is absent:

  • IGS_HE_PROG_OU_CC pcc — the driving table holding the HESA programme / organisational unit / cost centre mapping, including the cost centre code, subject, and proportion.
  • IGS_PS_VER_ALL prg — the programme version table, supplying title, short title, and abbreviation. Joined on COURSE_CD and VERSION_NUMBER with the outer-join operator on prg.

Three correlated scalar subqueries resolve descriptive values: HZ_PARTIES joined to IGS_PE_HZ_PARTIES yields the organisational unit name; IGS_HE_CODE_VALUES (CODE_TYPE = OSS_COSTCN) yields the cost centre description; and IGS_PS_FLD_OF_STUDY yields the subject description. Because these are inline scalar subqueries, no additional join cardinality is introduced at the top level.

Key Columns

Common Use Cases and Queries

Typical uses include validating that every active programme has a cost centre proportion totalling 100%, producing HESA cost centre extracts, and providing a user-friendly listing for administrators. A representative query retrieving cost centre descriptions for a programme:

SELECT program_code,
       program_title,
       program_cost_centre,
       program_cost_centre_desc,
       program_cost_centre_prop
FROM   apps.igsfv_prog_hesa_cost_centres
WHERE  program_code = :course_code
ORDER  BY program_cost_centre;

A data-quality check identifying mappings whose proportions do not sum to unity per programme version:

SELECT program_code, program_version_number,
       SUM(program_cost_centre_prop) total_prop
FROM   apps.igsfv_prog_hesa_cost_centres
GROUP  BY program_code, program_version_number
HAVING SUM(program_cost_centre_prop) <> 1;

Because the view is WITH READ ONLY, it is intended for query only; maintenance of the underlying mapping must be performed against the base tables through the supported application forms.