Search Results unit_subj_desc

Overview

The view IGSFV_UNIT_HESA_COST_CENTRES belongs to the Oracle E-Business Suite IGS – Student System product family, a module now classified as obsolete in the Oracle EBS 12.1.1 and 12.2.2 documentation sets. The view exposes the relationship between academic units of study and the HESA (Higher Education Statistics Agency) cost centre classifications applied to them, together with the proportion of each unit attributed to a given subject and cost centre. It is a read-only, single-row-per-unit-cost-centre reporting view intended to support statutory returns and institutional finance/registry reporting rather than transactional data entry.

The name prefix IGSFV_ denotes a Foundation/foreign-key style view within the Student System schema, and the trailing letters "HESA" signal that the underlying data is maintained specifically to satisfy HESA reporting obligations for UK higher education institutions. Because the object is documented as obsolete and "not implemented in this database" in the ETRM record, it exists for reference and historical lineage only; it will not be present in a current 12.1.1 or 12.2.2 application schema unless the institution has retained the legacy IGS HESA extensions.

Underlying Base Objects

The view is defined over two core IGS tables and several correlated sub-queries against HESA reference and party data:

• IGS_HE_UNT_OU_CC – aliased as UCC. This is the driving table, holding the unit / organisational unit / cost centre association rows, including the cost centre code, subject code, proportion, and audit columns.
• IGS_PS_UNIT_VER_ALL – aliased as UNT. A version-aware container of unit-of-study definitions supplying title, short title and abbreviation. The join to it is an outer join (UNIT_CD(+) and VERSION_NUMBER(+)).
• HZ_PARTIES and IGS_PE_HZ_PARTIES – joined in a scalar sub-query to resolve the organisational unit description from the trading community party model.
• IGS_HE_CODE_VALUES – supplies the descriptive text for the cost centre code where CODE_TYPE = 'OSS_COSTCN'.
• IGS_PS_FLD_OF_STUDY – supplies the description for the subject field of study.

The ETRM metadata records no separately documented referenced base objects, so the view text itself is the authoritative source of its lineage.

Key Columns

• HESA_UNIT_CC_ID – Surrogate primary key of the underlying cost centre association row.
• UNIT_CODE / UNIT_VERSION_NUMBER – Identify the unit of study and its version.
• UNIT_TITLE, UNIT_SHORT_TITLE, UNIT_ABBREVIATION – Descriptive attributes resolved from the unit version table.
• ORG_UNIT_CODE / ORG_UNIT_DESC – The owning organisational unit and its party name.
• UNIT_COST_CENTRE / UNIT_COST_CENTRE_DESC – The HESA cost centre code and its decoded description.
• UNIT_SUBJ / UNIT_SUBJ_DESC – The subject (field of study) code and description.
• UNIT_COST_CENTRE_SUBJ_PROP – The proportion of the unit allocated to that cost centre/subject combination.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE – Standard audit columns inherited from the base table.

Common Use Cases and Queries

The view is typically consumed for HESA cost centre reporting, funding model analysis, and reconciliation between student records and finance allocations. A representative query is:

SELECT unit_code, unit_title, org_unit_desc, unit_cost_centre_desc,
  unit_subj_desc, unit_cost_centre_subj_prop
FROM igsfv_unit_hesa_cost_centres
WHERE org_unit_code = :p_org_unit_code
ORDER BY unit_code, unit_cost_centre;

A second common pattern aggregates proportions by cost centre to test whether unit attributions sum correctly before submission:

SELECT unit_cost_centre, unit_cost_centre_desc,
  SUM(unit_cost_centre_subj_prop) total_proportion
FROM igsfv_unit_hesa_cost_centres
GROUP BY unit_cost_centre, unit_cost_centre_desc;

Because the object is obsolete and read-only, and because searches pairing this view with the term "campus suite insolvent" point to unrelated third-party Campus Suite vendor news rather than Oracle IGS functionality, no remediation action should be expected from querying this view. It remains a documentation artefact of the legacy HESA integration.