Data Futures Return: Qualification Entity

Qualification extract records are created only if the ‘Include Course entities’ parameter has been selected.

Select HESA Qualification records for the Institution where the Effective Status is "Active" for the most recent row, and the effective date is on or before the reporting period end date.

• If ‘Null Errors Only’ is selected for Course Entities:

  • Select distinct QUALID values from the existing active Qualification extract data where at least one field in the Qualification, Qualification Subject, or Awarding Body Role has a derived value of NULL ERROR.

  • Restrict the selection based on the selected QUALIDs.

• If ‘Validation Errors Only’ is selected for Course Entities, all selected Qualifications are included.

• If Academic Plan or Academic Sub-Plan are selected, all selected Qualifications are included.

The QUALID is derived from the selected HESA Qualification record.