Search Results prop_taught_in_welsh




Overview
Explore in AI Chat

Overview

IGSBV_UNIT_UK_STATISTICS is a read-only Oracle EBS view owned by the APPS schema. It exposes statutory Higher Education Statistics Agency (HESA) unit-level data for United Kingdom institutions, drawing on the unit statistics entity maintained under the IGS (Student Systems) product family. In EBS 12.1.1 and 12.2.2, the object functions as a reporting and integration surface for regulatory extracts: it presents a flattened, presentation-ready projection of unit-of-study statistical attributes required for UK statutory returns, including the proportion of teaching delivered through the medium of Welsh. Because the view is created with the WITH READ ONLY clause and its definition closes with the phrase "WITH READ ONLY", no DML can be issued against it; it exists strictly to be queried.

Underlying Base Objects

The view is defined over a single documented base object, IGS_HE_ST_UNT_VS_ALL, aliased as UNT in the view text. No additional joins, aggregations, or lookup tables are documented in the ETRM metadata; the view is a straightforward column projection rather than a transformation. The base object name suggests a HESA student-unit statistics record keyed by version (the "_VS_" segment)," with "_ALL" typically indicating an unfiltered superset across organization or version contexts. Every column in the view maps one-to-one to a column with the same or a similarly named definition in the base object, so the view adds no filtering logic of its own. Consumers requiring the full breadth of unit statistical attributes should query IGS_HE_ST_UNT_VS_ALL directly; the view should be used where only the documented columns are needed.

Key Columns

Common Use Cases and Queries

The primary use case is preparation of HESA unit-level extracts, particularly Welsh-medium provision reporting, and reconciliation of statutory data ahead of submission. The view is also suitable for ad hoc auditing of versioned unit statistics and for validating EXCLUDE_FLAG handling. Typical queries include:

  • Retrieving all Welsh-teaching proportions for a given unit: SELECT unit_code, unit_version_number, prop_taught_in_welsh FROM apps.igsbv_unit_uk_statistics WHERE unit_code = :code;
  • Identifying units with non-zero Welsh provision while excluding suppressed records: SELECT unit_code, unit_location_code, prop_taught_in_welsh FROM apps.igsbv_unit_uk_statistics WHERE prop_taught_in_welsh > 0 AND exclude_flag = 'N';
  • Auditing recent changes using the audit columns: SELECT hesa_stats_unit_id, last_updated_by, last_update_date FROM apps.igsbv_unit_uk_statistics WHERE last_update_date >= TRUNC(SYSDATE) - 30;
  • Joining to unit-of-study definitions by HESA_STATS_UNIT_ID or by UNIT_CODE and UNIT_VERSION_NUMBER for institutional reporting.

Because the view carries no WHERE predicate, deployers concerned with data volume should add their own filters on unit code, version, or organization context as appropriate to the statutory reporting scope.