Search Results program_version_number




Overview
Explore in AI Chat

Overview

IGSBV_PRG_UK_STAT_COST_CENTRES is a read-only base view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes United Kingdom statutory cost centre detail for academic programs, and is intended primarily to support HESA (Higher Education Statistics Agency) statutory returns and related regulatory reporting. The view is defined as a thin projection over the program cost centre entity and is declared WITH READ ONLY, meaning no DML is permitted against the view under any circumstances; all maintenance must be performed against the underlying base table.

Because the view carries no transformation logic, no joins, and no derivations, it functions as a stable public interface over a narrower physical table. It presents one row per program cost centre assignment. Downstream reports, extracts, and integration programs — particularly HESA submission files — can be written against this view rather than the base table, insulating them from internal column restructuring in IGS. The view does not appear in the ETRM 12.2.2 metadata with an explicit owner or documented referenced base objects, so column-level semantics must be inferred from the view text and standard IGS conventions.

Underlying Base Objects

The view is defined over a single base object: IGS_HE_ST_PROG_CC. Although the ETRM metadata lists no referenced base objects, the view text is unambiguous and states:

  • FROM IGS_HE_ST_PROG_CC PC WITH READ ONLY

The base table stores program cost centre records keyed by the surrogate identifier HE_PROG_CC_ID. The view renames this primary key to HESA_STATS_PROGRAM_CC_ID and prefixes the remaining business columns with PROGRAM_ to make the HESA reporting context explicit. The relationship is strictly one-to-one: every row in the view corresponds to exactly one row in IGS_HE_ST_PROG_CC, with no filtering predicate applied in the view definition. Consequently, the row count and cardinality of the view equal those of the base table, and any row-level security present on the base table is inherited if the view is queried directly by a user with privileges on the underlying object.

Key Columns

  • HESA_STATS_PROGRAM_CC_ID — Surrogate primary key sourced from HE_PROG_CC_ID; uniquely identifies the program cost centre record.
  • PROGRAM_CODE — Sourced from COURSE_CD; identifies the program of study to which the cost centre assignment belongs.
  • PROGRAM_VERSION_NUMBER — Sourced from VERSION_NUMBER; distinguishes successive versions of the same program code. This is the column most commonly sought when users search for the program version in UK statistics extracts, and it is the qualifier that makes (PROGRAM_CODE, PROGRAM_VERSION_NUMBER) a meaningful composite key.
  • PROGRAM_COST_CENTRE — Sourced from COST_CENTRE; the UK statutory cost centre code (typically a three-character HESA cost centre value) assigned to the program.
  • PROGRAM_SUBJECT — Sourced from SUBJECT; the subject classification associated with the cost centre line.
  • PROGRAM_COST_CENTRE_SUBJ_PROP — Sourced from PROPORTION; the proportion of the program apportioned to that cost centre and subject combination. Values across a program normally sum to one.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE; standard EBS WHO columns inherited unchanged from the base table.

Common Use Cases and Queries

Typical usage is in HESA statutory extracts, cost centre apportionment validation, and reconciliation of program subject splits for a given academic period. A representative query retrieving all cost centre splits for a program version is:

  • SELECT program_code, program_version_number, program_cost_centre, program_subject, program_cost_centre_subj_prop FROM apps.igsbv_prg_uk_stat_cost_centres WHERE program_code = :code AND program_version_number = :version;
  • SELECT program_cost_centre, SUM(program_cost_centre_subj_prop) FROM apps.igsbv_prg_uk_stat_cost_centres GROUP BY program_cost_centre; — used to reconcile apportioned proportions by cost centre.
  • SELECT COUNT(*) FROM apps.igsbv_prg_uk_stat_cost_centres WHERE program_cost_centre IS NULL; — used to identify incomplete statutory data ahead of a submission.

Because the view is read-only and unfiltered, it should not be relied upon for row-level authorisation; any restriction required by reporting consumers must be applied through the query predicate or through EBS grants and responsibilities on the base object.