Results for “igs_he_st_spa”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view IGS_HE_ST_SPA belongs to the IGS (Student System) product family within Oracle E-Business Suite and is documented in ETRM as obsolete. Its stated purpose is to store Student Program attempt HESA details, where HESA refers to the Higher Education Statistics Agency returns required for statutory reporting of higher education student data in the United Kingdom. The view exposes program-attempt-level information that feeds HESA student return extracts, combining student identity, course and version references, entry qualifications, funding classifications, and progression attributes into a single queryable structure.

Because IGS_HE_ST_SPA is recorded as obsolete and "Not implemented in this database," it should be regarded as a legacy object. It is unlikely to exist in a current 12.1.1 or 12.2.2 environment unless an institution has retained historical IGS student system customizations. The view nonetheless remains relevant as a reference for interpreting historical report definitions, migration mappings, and archived extract logic.

Underlying Base Objects

The view text is defined over a single base object, IGS_HE_ST_SPA_ALL, referenced with the alias A. No other documented base objects are listed in the ETRM metadata. This _ALL suffix indicates a multi-organization (multi-tenant) table, which is confirmed by the ORG_ID predicate embedded in the view definition. The view is not documented as an _ALL variant of an operating-unit-specific object; rather, it selects directly from the _ALL table and applies an organization security filter at runtime.

The row identifier is surfaced as ROW_ID from A.ROWID, and the primary key column is HESA_ST_SPA_ID. The organization filter uses USERENV('CLIENT_INFO') truncated to its first ten bytes, converting the result to a number and comparing it against the row's ORG_ID. When the client information is blank or unavailable, the NVL wrappers substitute the sentinel value -99 on both sides of the equality, so rows lacking an organization context are matched against the same default.

Key Columns

• ROW_ID, HESA_ST_SPA_ID, PERSON_ID, COURSE_CD, VERSION_NUMBER — unique identifiers and the student/course/version keys that anchor each program attempt.
• FE_STUDENT_MARKER, DOMICILE_CD, INST_LAST_ATTENDED, YEAR_LEFT_LAST_INST — further education indicators, domicile classification, and prior institution attendance.
• HIGHEST_QUAL_ON_ENTRY, DATE_QUAL_ON_ENTRY_CALC, A_LEVEL_POINT_SCORE, HIGHERS_POINTS_SCORES, TOTAL_UCAS_TARIFF — entry qualification and tariff data.
• OCCUPATION_CODE, OCCCODE, SOCIAL_CLASS_IND, DISADV_UPLIFT_ELIG_CD, DISADV_UPLIFT_FACTOR — occupational and widening-participation attributes.
• COMMENCEMENT_DT, SPECIAL_STUDENT, STUDENT_QUAL_AIM, RETURN_TYPE, CALCULATED_FTE — commencement, qualification aim, return type, and calculated full-time equivalence.
• TEACHER_TRAIN_PROG_ID, ITT_PHASE, BILINGUAL_ITT_MARKER, ITT_PROG_OUTCOME — initial teacher training fields.
• HESA_RETURN_NAME, HESA_RETURN_ID, HESA_SUBMISSION_NAME — linkage to the HESA return cycle that consumed the record.
• NHS_FUNDING_SOURCE, NHS_EMPLOYER, IMPLIED_FUND_RATE, ENH_FUND_ELIG_CD, GOV_INITIATIVES_CD, UNITS_FOR_QUAL, UNITS_COMPLETED — funding and unit-of-credit attributes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO columns for auditing.
• EXCLUDE_FLAG — controls whether the attempt is suppressed from return processing.

Common Use Cases and Queries

Historical reporting against this view typically reconciles a student's program attempts with the HESA return in which they were submitted. A simple filtered query follows:

SELECT h.HESA_ST_SPA_ID, h.PERSON_ID, h.COURSE_CD, h.VERSION_NUMBER, h.RETURN_TYPE, h.CALCULATED_FTE, h.EXCLUDE_FLAG FROM IGS_HE_ST_SPA h WHERE h.PERSON_ID = :person_id ORDER BY h.COMMENCEMENT_DT;

For archive verification, extracting all records belonging to a specific return batch supports audit and resubmission analysis:

SELECT h.HESA_RETURN_ID, h.HESA_SUBMISSION_NAME, COUNT(*) FROM IGS_HE_ST_SPA h WHERE h.EXCLUDE_FLAG = 'N' GROUP BY h.HESA_RETURN_ID, h.HESA_SUBMISSION_NAME;

Entry qualification profiles and widening-participation analysis can be derived by selecting HIGHEST_QUAL_ON_ENTRY, TOTAL_UCAS_TARIFF, SOCIAL_CLASS_IND, and DISADV_UPLIFT_ELIG_CD together. Because the view applies multi-org filtering automatically, developers should ensure CLIENT_INFO is initialized before querying it outside a standard Oracle Forms or concurrent program context.

Given its obsolete status, the view should not be used as the basis for new development. Where equivalent functionality is required in a supported environment, the underlying IGS_HE_ST_SPA_ALL table's successor objects and current student records structures should be consulted instead. The metadata above nonetheless remains the authoritative reference for interpreting historical IGS HESA program-attempt extracts.