Search Results hesa_prog_cc_id




Overview
Explore in AI Chat

Overview

IGSFV_PROG_HESA_COST_CENTRES is a read-only Oracle EBS view owned by the APPS schema and delivered as part of the IGS (Student System) product family. It presents Higher Education Statistics Agency (HESA) cost centre assignments for academic programmes, joining programme definitions to their organisational unit and cost centre coding. The view is designed for statutory HESA reporting, where institutions must return the apportionment of teaching activity across recognised cost centres. Because the view is defined WITH READ ONLY, it is intended purely for query and extraction, not for maintenance.

The user search term hesa_prog_cc_id corresponds directly to the HESA_PROG_CC_ID column, the primary surrogate identifier sourced from the base table IGS_HE_PROG_OU_CC. This identifier is the key reference used in integration extracts and downstream reporting pipelines.

Underlying Base Objects

The view is defined over two documented base objects:

  • IGS_HE_PROG_OU_CC (alias PCC) — the driving table holding the HESA programme/organisation unit/cost centre relationship, including the cost centre code, subject, and proportion.
  • IGS_PS_VER_ALL (alias PRG) — the programme version view supplying programme title, short title, abbreviation, and version details. The join is an outer join (PRG.COURSE_CD(+) = PCC.COURSE_CD AND PRG.VERSION_NUMBER(+) = PCC.VERSION_NUMBER), so cost centre rows are retained even where no matching programme version exists.

Three scalar subqueries enrich the result set: HZ_PARTIES joined to IGS_PE_HZ_PARTIES resolves the organisational unit description; IGS_HE_CODE_VALUES supplies the cost centre description for code type OSS_COSTCN; and IGS_PS_FLD_OF_STUDY supplies the subject description.

Key Columns

Common Use Cases and Queries

Typical usage is HESA statutory returns, cost centre apportionment analysis, and data extracts feeding institutional data warehouses. A representative query retrieving the full cost centre profile for a programme:

SELECT hesa_prog_cc_id, program_code, program_version_number,
      program_title, org_unit_desc, program_cost_centre,
      program_cost_centre_desc, program_subj_desc,
      program_cost_centre_prop
 FROM igsfv_prog_hesa_cost_centres
 WHERE program_code = :p_program_code;

To validate that cost centre proportions total correctly per programme version:

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

Because IGSFV_PROG_HESA_COST_CENTRES is read-only and joins only seeded IGS and HZ objects, it can be queried safely in reporting schemas without risk of data modification.