Data Futures Return: PG Entry Qualification Award
For each Entry Profile entity in the extract, one or more entities are created when the following conditions are met:
Country = Northern Ireland:
-
Qualification.QUALCAT = M0016, M0018 or H0013 for the qualification associated with the parent Engagement entity.
-
Engagement.INCOMINGEXCHANGE is null.
-
Either the student has an External Degree with Degree Status of Complete and a Degree Date that falls on or before the reporting period end date where the Degree is mapped to a DEGREETYPEID in the Qualification mapping. If multiple mapped degrees exist, a single entity is created for the record with the latest Degree Date, or at least one Degree Qualification record exists in the HESA Instance related to the Engagement entity for the student in the extract. An entity is created for each record.
If both an External Degree and a Degree Qualification are found, only the External Degree is derived.
DEGREEID is created based on SID and a Sequence Number that defaults to 1 and is incremented for each new entity.
Return: Data Futures
Entity: PG Entry Qualification Award
Pages Used:
|
Page |
Page Element |
|---|---|
|
Entry Profile HESA Data - Degree Qualifications |
Classification |
|
Entry Profile HESA Data |
DEGREECLASS |
Field Derivation Rule: Include for all entities
Derivation Steps:
-
If the entity is created from a Degree Qualification record, the Classification value is derived.
-
If the entity is created from an External Degree record, DEGREECLASS from Entry Profile HESA Data is derived.
-
Derive as NULL ERROR.
As there is no identifier for qualifications other than the ID generated for DEGREEID, this field will be derived as null for all entities.
This is as per OWNQUALID in Entry Qualification Award.
Return: Data Futures
Entity: PG Entry Qualification Award
Pages Used:
|
Page |
Page Element |
|---|---|
|
Entry Profile HESA Data - Degree Qualifications |
Type |
|
Entry Profile HESA Data |
DEGREETYPEID |
Field Derivation Rule: Include for all entities
Derivation Steps:
-
If the entity is created from a Degree Qualification record, the Type value is derived.
-
If the entity is created from an External Degree record, DEGREETYPEID defined in Entry Profile is derived.
-
If the entity is created from an External Degree record, Degree is mapped to Type in the Qualification mapping.
-
Derive as NULL ERROR.