Search Results hesa_return_name




Overview
Explore in AI Chat

Overview

IGSBV_ST_PROG_ATT_HESA_DETAILS is a base database view in the Oracle E-Business Suite Student System (IGS) module. Its documented description identifies it as the "Base View for Student Program Attempt HESA Details." The view consolidates Higher Education Statistics Agency (HESA) statutory return attributes attached to a student's program attempt record, exposing them through a single denormalized interface. This makes it the natural read layer for HESA-related reporting, extracts, and downstream integration routines that must assemble a student's statistical return profile without navigating the normalized Student Program Attempt (SPA) table directly.

In ETRM metadata for release 12.2.2 the view carries no documented base objects and the note "Not implemented in this database," indicating that its underlying HESA structures are not present in every environment. It is treated as an obsolete/legacy object under the IGS Student System. Where the HESA extension tables exist, the view provides a stable, read-only projection that reporting tools can query without incurring the join logic that the raw tables require.

Underlying Base Objects

The view text is defined over the Student Program Attempt entity, aliased SPA in the query, joined to the person table (aliased PER) to obtain the person party number. The SPA records supply all HESA-specific statistics attributes — the HESA statistics program attempt identifier, return type, funding source, qualification aims, teacher-training attributes, and the UCAS tariff fields. The person join contributes PERSON_NUMBER, translating the internal PERSON_ID into the externally meaningful party number used across EBS reporting.

No base objects are documented in the ETRM extract, and the view is reported as not implemented in the reference database. In a populated 12.1.1 or 12.2.2 environment the view therefore resolves against the HESA statistics shadow entity maintained alongside the core student program attempt record, rather than against the base IGS tables alone. Because these shadow structures are installation-dependent, availability of the view cannot be assumed from the IGS module alone.

Key Columns

The view aliases SPA columns to HESA-facing names. The most significant include:

Common Use Cases and Queries

The view is typically used to build HESA student-record extracts and to audit tariff calculation results. A user searching for "total_ucas_tariff" is most often reconciling the tariff stored against program attempts, so the primary pattern filters or aggregates on TOTAL_UCAS_TARIFF.

To list tariff values by person and program:

  • SELECT person_number, program_code, program_version_number, total_ucas_tariff, ucas_tariff_calc_last_run_date FROM igsbv_st_prog_att_hesa_details WHERE total_ucas_tariff IS NOT NULL;

To confirm which attempts have been tariffed, and when:

  • SELECT student_instance_number, program_code, ucas_tariff_calc_last_run_date FROM igsbv_st_prog_att_hesa_details ORDER BY ucas_tariff_calc_last_run_date DESC;

For return preparation, selecting the HESA context columns together with the tariff fields provides a single-row-per-attempt extract suitable for loading into HESA return staging tables. Because the object is obsolete and may be unimplemented, queries should be validated against the target environment before being embedded in concurrent programs or BI publisher data models.