Search Results program_abbreviation




Overview
Explore in AI Chat

Overview

The view APPS.IGSFV_PRG_UK_STAT_COST_CENTRES is a full (non-summary) read-only view within the IGS – Student System product family of Oracle E-Business Suite. Its documented purpose is to present UK Statistics Program Cost Center Details, aligning program-level cost centre attribution data with the Higher Education Statistics Agency (HESA) reporting model used by UK institutions. The view carries a WITH READ ONLY clause, meaning it is intended strictly for query and extraction purposes and cannot be used for DML.

The view plays a reporting and integration role: it denormalizes program cost centre records and decorates them with descriptive values sourced from code and field-of-study lookup tables, so that downstream HESA returns, cost attribution reports, and statistical extracts can be produced without additional joins at the reporting layer. It is particularly relevant where a user searches for program_short_title, since the view exposes a PROGRAM_SHORT_TITLE column derived from the program version record.

Underlying Base Objects

The view text identifies two primary base tables joined in the FROM clause:

  • IGS_HE_ST_PROG_CC (aliased PC) — the principal store of HESA statistics program cost centre records, supplying the surrogate identifier, course code, version number, cost centre, subject, and proportion values.
  • IGS_PS_VER_ALL (aliased PS) — the program version table, supplying the program title, short title, and abbreviation.

The join condition is PC.COURSE_CD = PS.COURSE_CD AND PC.VERSION_NUMBER = PS.VERSION_NUMBER, enforcing a one-to-many relationship keyed on the program code and version. The view additionally embeds two scalar subqueries: one against IGS_HE_CODE_VALUES (with CODE_TYPE = 'OSS_COSTCN') to resolve the cost centre description, and one against IGS_PS_FLD_OF_STUDY_ALL to resolve the subject description. The documented ETRM metadata lists no separately documented base objects, so the view text above constitutes the authoritative definition.

Key Columns

The view exposes fifteen columns:

Common Use Cases and Queries

Typical scenarios include HESA cost centre returns, program cost attribution analysis, and validation of subject/cost centre proportions. A representative query selecting core identifiers and descriptions:

  • SELECT program_code, program_short_title, program_version_number, program_cost_centre, program_cost_centre_desc, program_subject, program_subject_desc, program_cost_centre_subj_prop FROM igsfv_prg_uk_stat_cost_centres WHERE program_code = :course_code;
  • Use the view to reconcile total cost centre proportions per program version by aggregating PROGRAM_COST_CENTRE_SUBJ_PROP.
  • Join or filter on PROGRAM_SHORT_TITLE for output formats requiring compact program labels in statistical extracts.

Because the view is read-only and already resolves lookup descriptions, it reduces reliance on bespoke joins and helps ensure consistent UK statutory reporting from the Student System.