Search Results program_short_title




Overview
Explore in AI Chat

Overview

The view IGSFV_ST_HESA_ADMISSION_DETAIL is a full business (FND) view within the Oracle E-Business Suite Student System product family, identified by the IGS application prefix. Its purpose is to expose Student Admission Application data structured for Higher Education Statistics Agency (HESA) reporting. HESA returns are a statutory requirement for UK higher education institutions, and this view consolidates the admission-level attributes required for those returns into a single queryable object. In Oracle EBS 12.1.1 and 12.2.2 the IGS product line is classified as obsolete; the view is documented in ETRM but the metadata explicitly records an implementation status of "Not implemented in this database." Consequently, the object should be treated as a legacy reporting artifact rather than an active runtime dependency in current 12.1.1 or 12.2.2 environments.

Because the view is defined against the _ALL tables (IGS_HE_AD_DTL_ALL, IGS_PS_VER_ALL), it is multi-org aware at the underlying table level, though the view text itself does not expose an ORG_ID column or include a multi-org filter predicate. Access would therefore be governed by the privileges and operating unit context of the querying session or the custom reporting layer built upon it.

Underlying Base Objects

The documented view text establishes the following base objects and join relationships:

The ETRM metadata records no explicitly documented referenced base objects, so the join logic above is derived from the supplied view text. The view is declared WITH READ ONLY, preventing DML through the view layer.

Key Columns

Common Use Cases and Queries

Typical uses include HESA return preparation, data quality checks on coded admission attributes, and ad hoc extracts joining admission detail to person records. The view is suitable for read-only reporting only; no DML is permitted.

Retrieve admission detail for a specific surname:

SELECT person_surname,
       person_given_names,
       admission_application_number,
       nominated_program_code,
       domicile_code,
       domicile_desc
FROM   igsfv_st_hesa_admission_detail
WHERE  person_surname = :surname;

Identify records with missing HESA code descriptions:

SELECT hesa_ad_dtl_id, person_number, occupation_code
FROM   igsfv_st_hesa_admission_detail
WHERE  occupation_code IS NOT NULL
AND    occupation_desc IS NULL;

Aggregate admissions by programme and domicile:

SELECT nominated_program_code,
       domicile_desc,
       COUNT(*)
FROM   igsfv_st_hesa_admission_detail
GROUP  BY nominated_program_code, domicile_desc
ORDER  BY nominated_program_code;