Search Results module_length




Overview
Explore in AI Chat

Overview

The IGSBV_UNIT_UK_STATISTICS view is a read-only reporting object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to serve as the "Base View for UK Statistics Unit Details." It exposes attributes of academic units that are relevant to United Kingdom statutory statistical returns — principally the Higher Education Statistics Agency (HESA) data collections. The BV prefix conventionally denotes a "base view," indicating that the object is intended as a stable foundation layer over which further reporting views, concurrent program extracts, or integration queries may be constructed.

Because the view is defined with the WITH READ ONLY clause, it cannot be used as a DML target. It is strictly a query and reporting interface. In an EBS 12.1.1 or 12.2.2 environment, it functions as an abstraction layer that shields downstream reporting from the physical structure of the underlying transaction table.

Underlying Base Objects

The view text documented in the ETRM metadata shows that IGSBV_UNIT_UK_STATISTICS is defined over a single base table: IGS_HE_ST_UNT_VS_ALL, aliased as UNT. The _ALL suffix is consistent with the multi-organization (partitioned by operating unit or organization) table convention used throughout EBS, where a corresponding _V or filtered view typically restricts rows by organization context. The base view performs no joins, aggregations, or calculated expressions; it is a direct projection of selected columns, applying column aliases only. Notably, the ETRM 12.2.2 documented metadata records no referenced base objects, so the view text excerpt remains the authoritative source for this dependency.

Key Columns

Common Use Cases and Queries

Typical usage centres on extraction of unit-level data for HESA returns, validation of statistical attributes prior to submission, and reconciliation of versioned unit records.

  • Retrieve all statistical units for a specific unit code across all of its versions, using UNIT_VERSION_NUMBER to order or filter:

SELECT UNIT_CODE, UNIT_VERSION_NUMBER, UNIT_LOCATION_CODE, PROP_OF_FTE, EXCLUDE_FLAG FROM APPS.IGSBV_UNIT_UK_STATISTICS WHERE UNIT_CODE = :p_unit_code ORDER BY UNIT_VERSION_NUMBER;

  • Isolate the latest version of each unit using an analytic function, which is useful when only the current statistical record should be reported.
  • Filter out excluded units before a statutory extract: ... WHERE EXCLUDE_FLAG = 'N';
  • Audit recently changed records using LAST_UPDATE_DATE within a date range.

Because the view is read-only and unaggregated, it is safe to embed in downstream custom views and BI Publisher data models without risk of DML side effects.