Data Futures Return: Entry Qualification Award Entity
For each Entry Profile entity in the extract, one or more entities are created when one of the following conditions is true:
Country = England:
-
Qualification.QUALCAT starts with H, I, J or C, or is M0002.
-
EntryProfile.HIGHESTQOE begins with P (except for P0013), or is X0000 or X0001.
-
The student has an Engagement entity where HIGHESTQUALOE begins with P (except for P0013), is X0000 or X0001.
-
EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM.
-
There it at least one Entry Qualification record with Report to HESA = Y in the HESA Instance related to the Engagement entity for the student in the extract.
Undergraduate UCAS entrants from all countries:
-
Qualification.QUALCAT starts with H, I, J or C, or is M0002.
-
EntryProfile.UCASSCHEMECODE is not null.
-
There it at least one Entry Qualification record with Report to HESA = Y in the HESA Instance related to the Engagement entity for the student in the extract.
For entities created from HESA Instance – Entry Qualification, an entity is created for each record where Report to HESA = Y and the QUALTYPEID code has been imported from HESA (based on the imported flag in SSR_HE_CODES).
ENTRYQUALAWARID is created based on the SID and a sequence number.
Return: Data Futures
Entity: Entry Qualification Award
Pages Used:
|
Page |
Page Element |
|---|---|
|
Entry Profile HESA Data – Entry Qualifications |
Result (SSR_HE_QUALGRADE) |
|
Entry Profile HESA Data |
ENTRYQUALAWARDRESULT |
Field Derivation Rule: Include for all entities
Derivation Steps:
-
If the entity is created from an Entry Qualification record, derive Result from Entry Profile HESA Data.
-
If the entity is created from an External Degree record, derive ENTRYQUALAWARDRESULT from Entry Profile HESA Data.
-
Derive as NULL ERROR.
Return: Data Futures
Entity: Entry Qualification Award
Because there's no identifier for qualifications other than the ID generated for ENTRYQUALAWARID, this field will be derived as null for all entities.
Return: Data Futures
Entity: Entry Qualification Award
Page Used:
|
Page |
Page Element |
|---|---|
|
Entry Profile HESA Data – Entry Qualifications |
Result |
|
Entry Profile HESA Data |
QUALRESULTEQA |
Field Derivation Rule: Include for all entities.
Derivation Steps:
If the entity is created from an Entry Qualification record, derive Result from Entry Profile HESA Data.
If the entity is created from an External Degree record, derive QUALRESULTEQA from Entry Profile HESA Data.
Derive as NULL ERROR.
Return: Data Futures
Entity: Entry Qualification Award
Page Used:
|
Page |
Page Element |
|---|---|
|
Entry Profile HESA Data – Entry Qualifications |
Type |
|
Entry Profile HESA Data |
QUALTYPEID |
Field Derivation Rule: Include for all entities.
Derivation Steps:
If the entity is created from an Entry Qualification record, derive Type value from Entry Profile HESA Data.
If the entity is created from an External Degree record, derive QUALTYPEID defined in Entry Profile.
If the entity is created from an External Degree record, derive Degree mapped to Type in the Qualification mapping.
Derive as NULL ERROR.
Return: Data Futures
Entity: Entry Qualification Award
Page Used:
|
Page |
Page Element |
|---|---|
|
Entry Profile HESA Data – Entry Qualifications |
Award Date |
|
Entry Profile HESA Data – Entry Qualifications |
Year |
|
Student Admissions > Application/Transcript Loads > Education > Courses and Degrees |
Degree Date |
Field Derivation Rule: Include for all entities.
Derivation Steps:
-
If the entity is created from an Entry Qualification record and Award Date has a value, derived the year element.
-
If the entity is created from an Entry Qualification record and Year has a value, derive the value.
-
If the entity is created from an External Degree record, derive the year element of Degree Date.
-
Derive as null.