Data Futures Return: Qualification Subject Entity
Extract records are created if the ‘Include Course entities’ parameter has been selected. For each QUALID in the Qualification Extract for the return with an active status, up to 5 entities are created. These are arranged in descending order of percentage, selected by Institution and QUALID from the most recent effective dated HESA Qualification record where the effective date is on or before the reporting period end date record.
If no HECoS Subjects are defined for the Qualification, a single entity is derived using the default value for QUALSUBJECT from HESA Returns Setup (if defined) and QUALPROPORTION = 100, or a single entity is derived with QUALSUBJECT and QUALPROPORTION is derived as NULL ERROR.
Return: Data Futures
Entity: Qualification Subject
Page Used:
|
Page |
Page Element |
|---|---|
|
HESA Qualification — HECoS Subjects |
Percentage |
Field Derivation Rule: Include for all entities
Derivation Step:
-
Derive value from the HESA Qualification percentage.
-
Derive as 100 when QUALSUBJECT is derived as the default value.
-
Derive as NULL ERROR.
Return: Data Futures
Entity: Qualification Subject
Page Used:
|
Page |
Page Element |
|---|---|
|
HESA Qualification — HECoS Subjects |
ITT Subject |
Field Derivation Rule: Derive a value if one of the following conditions is met:
Country = England and at least one associated Course.TTCIDC = 01
Country = Scotland and at least one associated Course.TTCIDC = 01 and at least one associated Curriculum Accreditation entity exists with CURACCID = 06603 (GTCS Secondary)
Derivation Steps:
If ITT Subject is selected on the HESA Qualification – HECoS Subjects page, derive as 01.
Derive as null.
Return: Data Futures
Entity: Qualification Subject
Page Used:
|
Page |
Page Element |
|---|---|
|
HESA Qualification — HECoS Subjects |
Subject |
Field Derivation Rule: Include for all entities
Derivation Steps:
-
Derive from the HESA Qualification page.
-
Use default.
-
Derive as NULL ERROR.