Search Results unit_cost_centre




Overview
Explore in AI Chat

Overview

The IGSBV_UNIT_STAT_COST_CENTRES view is a base reporting object within the Oracle E-Business Suite (EBS) Student System (IGS) product. It is owned by the APPS schema and holds a VALID status in the EBS data dictionary. Its purpose is to expose Unit Cost Center details required for UK Higher Education Statistics Agency (HESA) statutory returns, specifically the unit-level cost centre and subject apportionment data submitted as part of the UK statistics unit record.

The view functions as a read-only presentation layer over the transactional storage table that holds statistics cost centre records. Because it is defined WITH READ ONLY, consumers cannot perform DML against it; it exists purely for query, reporting, and integration extraction. In the context of EBS 12.1.1 and 12.2.2, this makes it suitable for concurrent program extracts, Oracle Reports, BI Publisher data templates, and inbound/outbound interface pulls that feed HESA returns or institutional financial-statistical reconciliation. Institutional developers searching for the unit_cost_centre attribute will typically encounter this view as the sanctioned access point rather than querying the underlying _ALL table directly.

Underlying Base Objects

The view is defined over a single documented base object: IGS_HE_ST_UV_CC_ALL, a multi-org (all-organizations) table holding HESA statistics unit cost centre rows. The alias UCC is applied to the table in the defining query, and each column of the view maps directly to a column of that table — the view performs no joins, aggregation, or derivation. Consequently, the row cardinality of IGSBV_UNIT_STAT_COST_CENTRES is identical to that of the accessible rows in IGS_HE_ST_UV_CC_ALL.

The underlying table name carries the _ALL suffix, indicating that it is partitioned by ORG_ID under the EBS multi-org model. The view does not expose ORG_ID and does not itself embed a WHERE clause restricting operating unit, so row visibility is governed by the Multi-Org views or by the security profile applied to the underlying table at runtime. Although the column renaming in the view suggests a broader "unit statistics" lineage, no additional documented base objects participate in the definition provided by ETRM metadata.

Key Columns

  • HESA_STATS_UNIT_CC_ID — Surrogate primary key, sourced from UCC.HESA_ST_UV_CC_ID. Uniquely identifies each statistics unit cost centre record.
  • UNIT_CODE — The code of the academic unit to which the cost centre data relates.
  • UNIT_VERSION_NUMBER — The version of the unit record, supporting versioned HESA returns.
  • UNIT_COST_CENTRE — The HESA cost centre code assigned to the unit; this is the attribute commonly sought when users search for unit_cost_centre.
  • UNIT_SUBJECT — The subject code associated with the unit and cost centre combination.
  • UNIT_COST_CENTRE_SUBJ_PROP — The proportion (apportionment factor) splitting the unit's activity between the cost centre and subject, normally expressed as a decimal or percentage.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording the identifying user and timestamps for row creation and most recent modification.

Common Use Cases and Queries

The primary use case is HESA return preparation: extracting the cost centre and subject apportionment for each unit, then joining to unit and student records to build the statutory submission. A secondary use is reconciliation between the Student System and institutional finance cost centre mappings.

A representative query retrieving the cost centre detail for a specific unit version:

  • SELECT unit_code, unit_version_number, unit_cost_centre, unit_subject, unit_cost_centre_subj_prop FROM igsbv_unit_stat_cost_centres WHERE unit_code = :p_unit_code AND unit_version_number = :p_version;

To validate apportionment integrity — confirming that proportions for a given unit and version sum to unity — an aggregate query may be used:

  • SELECT unit_code, unit_version_number, SUM(unit_cost_centre_subj_prop) total_prop FROM igsbv_unit_stat_cost_centres GROUP BY unit_code, unit_version_number HAVING SUM(unit_cost_centre_subj_prop) <> 1;

Because the view is read-only and carries no built-in organization filter, extraction programs should apply the appropriate operating unit context before returning rows for a HESA reporting period.