Student Record Return: Qualifications Awarded Entity
The Create Extract process creates Qualifications Awarded entities for each Instance entity where the student has completed the course and the academic institution has awarded a qualification to the student. The process uses the HESA Instance record for field derivation. If a field value does not exist in the HESA Instance record, the process uses the student degree records for derivation.
The process creates the Qualifications Awarded entities only if the Include Student Entities check box is selected on the Create Extract Data page. The selection logic for Qualifications Awarded that considers student degree records considers the completion term and confer dates when determining if the qualification should be included in the extract. That is, degrees should have status of Awarded with either a Confer Date that falls within the reporting period dates or a completion term that overlaps the reporting period (which means, the term end date is on or after the reporting period start date and the term begin date is on or before the reporting period end date).
The process selects Qualifications Awarded records for Instance records that have an Instance.REDUCEDI = 00, 01 or 04 (not Reduced FE or Incoming Visiting/Exchange).
Return: Student Record
Entity: Qualifications Awarded
Pages Used:
Page |
Page Element |
---|---|
HESA Instance |
Classification (Qualifications Awarded group box) |
Degree Honors |
Honors Code |
Classification (Records and Enrollment, HESA Reporting, Codes and Mappings, Code Mappings, Classification) |
Honors Code |
Field Derivation Rule: Derive a value if one of the following conditions is met:
QualificationsAwarded.QUAL = M22, M26, M28, H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, or I16
Country = England or Wales AND QualificationsAwarded.QUAL begins P, Q, R, S or X
Derivation Steps:
If the entity is derived from the HESA Instance - Qualifications Awarded record, derive as the Classification value.
If the entity is derived from Student Degrees record, use the mapping on the Classification page to derive as the HESA Honors Code. On the Classification page the HESA Honors Code must be mapped to a HESA classification and a Honors Type where the Honors Type must be Degree Honors.
Derive as NULL ERROR.
Return: Student Record
Entity: Qualifications Awarded
Pages Used:
Page |
Page Element |
---|---|
HESA Instance |
Outcome of ITT Instance (Qualifications Awarded group box) |
HESA Instance |
OUTCOME (Instance HESA Data group box) |
Field Derivation Rule: Derive a value if the following conditions are met:
Country = England or Wales
Related Course.TTCID = 1, 8, G, H, L, M, N or P
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
If the entity is derived from the HESA Instance - Qualifications Awarded record, derive as the Outcome of ITT Instance value.
If the entity is derived from Student Degrees record, derive as the OUTCOME value.
Use default.
Derive as NULL ERROR.
Return: Student Record
Entity: Qualifications Awarded
Pages Used:
Page |
Page Element |
---|---|
HESA Instance |
Qualification Awarded (Qualifications Awarded group box) |
Degree |
Degree |
Qualification (Records and Enrollment, HESA Reporting, Codes and Mappings, Code Mappings, Qualification) |
Degree |
Field Derivation Rule: Include for all Qualifications Awarded entities.
Derivation Steps:
If the entity is derived from the HESA Instance - Qualifications Awarded record, derive as the Qualification Awarded value.
If the entity is derived from Student Degrees record, use the mapping on the Qualification page to derive as the mapped HESA Degree code.
Derive as NULL ERROR.
Return: Student Record
Entity: Qualifications Awarded
Pages Used:
Page |
Page Element |
---|---|
HESA Instance |
Sector (Qualifications Awarded group box) |
HESA Instance |
TQGSEC (Instance HESA Data group box) |
Field Derivation Rule: Derive a value if the following conditions are met:
Country = Scotland or Northern Ireland
Related Course.TTCID = 1 or 2
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
If the entity is derived from the HESA Instance - Qualifications Awarded record, derive as the Sector value.
If the entity is derived from Student Degrees record, derive as the TQGSEC value. If two awards are reported, use this value for both entities.
Use default.
Derive as NULL ERROR.
Return: Student Record
Entity: Qualifications Awarded
Pages Used:
Page |
Page Element |
---|---|
HESA Instance (Qualifications Awarded group box) |
Subject 1, Subject 2, Subject 3 |
HESA Instance (Instance HESA Data group box) |
TQGSUB, TQGSUB2, TQGSUB3 |
Field Derivation Rule: Derive a value if the following conditions are met:
Country = Scotland
QualificationsAwarded.TQGSEC = 2
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
If the entity is derived from the HESA Instance - Qualifications Awarded record, derive as the Subject 1, Subject 2, and Subject 3 values.
If the entity is derived from Student Degrees record, derive as the TQGSUB, TQGSUB2, and TQGSUB3 values. Use these values for both entities if two awards are reported.
Derive single TQGSUB field as NULL ERROR.
Note: The system can derive up to three values. Each of the values is included as a separate TQGSUB field in the XML file.