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|
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.|