Award Qualification (Dim_Award_Qualification) Award Qualification (Dim_Award_Qualification)

This holds details of the qualifications which the students achieve, or are expected to achieve.  It is based upon the SITS Award (AWD) table.

Column Name Data Type Description Derivation
award_qualification_sk integer This uniquely identifies the qualification record. The value increments each time a record is entered into the table.
award_qualification varchar Description of the award  
hesa_qualification_level_code varchar

Taken from Hesa Mapping field on the External Qualification Aim table (eqa.eqa_hesa)

award_qualification_source varchar Taken from Award Code on Award table (awd.awd_code)  
hesa_qualification_level_desc varchar The HESA Qualification 10 way category for the qualification.