Search Results oss_crdtscm




Overview
Explore in AI Chat

Overview

APPS.IGS_HE_ST_UNV_DTLS_V is a reporting view in the Oracle E-Business Suite higher-education (Student System) module, exposing statutory unit-of-study detail records for the Higher Education Statistics Agency (HESA) student return. The view presents a denormalised read of the HESA student unit-version entity, joining the base record to unit version, code value, and campus location reference data. Its role is to provide a stable, human-readable projection of the underlying transactional table for statutory reporting, extracts, and integration interfaces.

The view is owned by the APPS schema and is registered as a documented object within ETRM for EBS 12.2.2, with lineage tracing back to the tables listed below. It is customarily consumed in read-only fashion by reporting tools and outbound extracts; because a ROWID from the driving table is exposed as ROW_ID, the view can also be used by forms or concurrent programs that require a unique key reference.

Underlying Base Objects

The view is defined over four objects:

The two joins to units and code values are mandatory (inner), while the joins to code values and location are outer joins (noted by the (+) operator), so records are retained even when a credit transfer scheme description or campus location description is absent.

Key Columns

Common Use Cases and Queries

Typical usage covers HESA extract preparation, unit-level reporting, and validation of credit transfer and location mappings. The view removes the need for report authors to encode the four-table join manually.

SELECT row_id,
       hesa_st_unt_vs_id,
       unit_cd,
       version_number,
       short_title,
       value_description,
       proportion_of_fte,
       location_desc,
       exclude_flag
  FROM apps.igs_he_st_unv_dtls_v
 WHERE unit_cd = :p_unit_cd;

Filtering by credit transfer scheme, or isolating records excluded from the return, is equally straightforward:

SELECT unit_cd, version_number, location_desc
  FROM apps.igs_he_st_unv_dtls_v
 WHERE credit_transfer_scheme IS NOT NULL
   AND exclude_flag = 'N';

Because the view contains no aggregation, it is suitable as a base for further joins to student enrolment data and for direct outbound extraction. Access should be granted through the standard APPS synonym and appropriate responsibility menus.