Skip to main content

XQOBTN01_9.7.1

Back to C19051

Field description Field abbreviation Field version Field length Field type
Highest qualification obtained XQOBTN01 9.7.1 3 Char

Valid entries

Code Label
C13 Access course or pathway programme at level 4
D00 Doctorate degree that meets the criteria for a research-based higher degree
D90 Advanced supervised research at level D for institutional credit
E00 Doctorate degree that does not meet the criteria for a research-based higher degree
E13 Access course or pathway programme at level 8
E40 National Vocational Qualification (NVQ) at level E
E43 Highly specialist diploma from a professional body
E90 Advanced taught study at level E for institutional credit
H13 Access course or pathway programme at level 6
L00 Masters degree that meets the criteria for a research-based higher degree
L80 Other postgraduate qualification at level L that meets the criteria for a research-based higher degree
L90 Advanced supervised research at level L for institutional credit
M00 Masters degree obtained typically by a combination of coursework and thesis/dissertation, that does not meet the criteria for a research-based higher degree
M01 Taught masters degree designed specifically as a training in research methods and intended as a preparation for advanced supervised research
M02 Masters in Teaching and Learning
M10 Post-experience taught masters degree
M11 Master of Business Administration (MBA)
M13 Access course or pathway programme at level 7
M16 Pre-registration masters degree leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
M22 Integrated undergraduate/postgraduate taught masters degree on the enhanced/extended pattern
M26 Integrated undergraduate/postgraduate taught masters degree on the enhanced/extended pattern leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
M28 Integrated undergraduate/postgraduate taught masters degree on the enhanced/extended pattern leading towards registration with the Architects Registration Board (Part 1 and Part 2 qualification)
M40 Fellowship at level M
M41 Diploma at level M
M42 Advanced professional certificate at level M
M43 National Vocational Qualification (NVQ) at level M
M44 Certificate at level M
M45 Scottish Vocational Qualification (SVQ) 5
M50 Postgraduate bachelors degree at level M obtained typically by a combination of coursework and thesis/dissertation, that does not meet the criteria for a research-based higher degree
M70 Professional taught qualification at level M other than a masters degree
M71 Postgraduate Certificate in Education or Professional Graduate Diploma in Education
M72 Post-registration education qualification at level M other than a masters degree for serving school teachers
M73 Postgraduate Diploma in Education
M76 Post-registration health & social care qualification at level M
M78 Taught qualification at level M (where qualification at level H and/or level M is a pre-requisite for course entry) leading towards registration with the Architects Registration Board (Part 3 qualification)
M79 Level 7 Diploma in Teaching in the Lifelong Learning Sector
M80 Other taught qualification at level M
M86 Taught qualification at level M leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
M88 Taught qualification at level M (where a qualification at level H is a pre-requisite for course entry) leading towards registration with the Architects Registration Board (Part 2 qualification)
M90 Taught work at level M for institutional credit
H00 First degree with honours
H11 First degree with honours leading to Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC)
H12 First degree with honours leading to Early Years Teacher Status (EYTS)
H16 Pre-registration first degree with honours leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
H18 First degree with honours leading towards registration with the Architects Registration Board (Part 1 qualification)
H22 First degree with honours on the enhanced/extended pattern but at level H
H23 First degree with honours and diploma
H41 Diploma at level H
H42 Certificate at level H
H43 National Vocational Qualification (NVQ) at level H
H50 Postgraduate bachelors degree at level H
H60 Graduate diploma/certificate at level H
H61 Graduate diploma/certificate at level H but where a previous qualification at level H is a pre-requisite for course entry
H62 Pre-registration graduate diploma/certificate leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
H70 Professional qualification at level H other than a first degree with honours
H71 Professional Graduate Certificate in Education
H72 Professional qualification at level H for serving school teachers other than a first degree with honours
H76 Post-registration health & social care qualification at level H other than a first degree with honours
H78 Other qualification at level H (where other qualifications at level H are a pre-requisite for course entry) leading towards registration with the Architects Registration Board (Part 3 qualification)
H79 Level 6 Diploma in Teaching in the Lifelong Learning Sector
H80 Other qualification at level H
H81 Other qualification at level H but where a previous qualification at level H is a pre-requisite for course entry
H88 Qualification at level H (where another qualification at level H is a pre-requisite for course entry) leading towards registration with the Architects Registration Board (Part 2 qualification)
H90 Credits at level H
I00 Ordinary (non-honours) first degree
I11 Ordinary (non-honours) first degree leading to Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC)
I12 Ordinary (non-honours) first degree leading to Early Years Teacher Status (EYTS)
I16 Pre-registration ordinary (non-honours) first degree leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
I60 Graduate diploma/certificate at level I
I61 Graduate diploma/certificate at level I but where a previous qualification at level I or H is a pre-requisite for course entry
I70 Professional qualification at level I other than an ordinary (non-honours) first degree
I71 Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC) only
I72 Professional qualification at level I for serving school teachers
I73 Early Years Teacher Status (EYTS) only
I74 Teaching certificate (trained through the medium of Welsh)
I76 Post-registration health & social care qualification at level I other than an ordinary (non-honours) first degree
I78 Level 5 Diploma in Education and Training (DET)
I79 Level 5 Diploma in Teaching in the Lifelong Learning Sector
I80 Other qualification at level I
I81 Other qualification at level I but where a previous qualification at level I or H is a pre-requisite for course entry
I90 Credits at level I
J10 Foundation degree
J13 Access course or pathway programme at level 5
J16 Foundation degree which on completion meets the entry requirement for pre-registration on a health & social care qualification
J20 Diploma of Higher Education (DipHE)
J26 Diploma of Higher Education (DipHE) leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body
J30 Higher National Diploma (HND)
J41 Diploma at level J
J42 Certificate at level J
J43 National Vocational Qualification (NVQ) at level J
J45 Scottish Vocational Qualification (SVQ) 4
J76 Post-registration health & social care qualification at level J
J80 Other qualification at level J
J90 Credits at level J
C20 Certificate of Higher Education (CertHE)
C30 Higher National Certificate (HNC)
C41 Diploma at level C
C42 Certificate at level C
C43 National Vocational Qualification (NVQ) at level C
C77 Level 4 Preparing to Teach in the Lifelong Learning Sector
C78 Level 4 Certificate in Teaching in the Lifelong Learning Sector
C80 Other qualification at level C
C90 Credits at level C
P41 Diploma at level P
P42 Certificate at level P
P43 National Vocational Qualification (NVQ) 3
P45 Scottish Vocational Qualification (SVQ) 3
P50 A/AS level
P55 Advanced Higher (Scotland)
P56 Higher (Scotland)
P70 Professional qualification at level 3
P77 Level 3 Preparing to Teach in the Lifelong Learning Sector
P78 Level 3 Certificate in Teaching in the Lifelong Learning Sector
P80 Other qualification at level 3
P85 Diploma in Foundation Studies (Art & Design) at level 3
P90 Credits at level 3
Q41 Diploma at level Q
Q42 Certificate at level Q
Q43 National Vocational Qualification (NVQ) 2
Q45 Scottish Vocational Qualification (SVQ) 2
Q50 GCSE at grade A*-C
Q56 Intermediate 2 (Scotland)
Q57 Standard Grade Credit (Scotland)
Q70 Professional qualification at level 2
Q80 Other qualification at level 2
Q90 Credits at level 2
R42 Certificate at level R
R43 National Vocational Qualification (NVQ) 1
R45 Scottish Vocational Qualification (SVQ) 1
R50 GCSE at grade D-G
R56 Intermediate 1 (Scotland)
R57 Standard Grade General (Scotland)
R70 Professional qualification at level 1
R80 Other qualification at level 1
R90 Credits at level 1
S42 National Vocational Qualification (NVQ) Entry level certificate
S57 Standard Grade Foundation (Scotland)
S80 Other qualification at further education (FE) access level
S90 Credits at further education (FE) access level
X00 Higher education (HE) access course, Quality Assurance Agency (QAA) recognised
X01 Higher education (HE) access course, not Quality Assurance Agency (QAA) recognised
X41 Welsh for Adults Entry level
X42 Welsh for Adults level 1
X43 Welsh for Adults level 2
X44 Welsh for Adults level 3
X45 Welsh for Adults level 4
X46 Welsh for Adults specialist/arbennig
___ No qualification

Dependent fields

  • XQLEV301
  • XQLEV501
  • XQLEV601
  • XQLEV701
  • XQLEV1003
  • XQPREV01
  • XCLASS01

Depend upon fields

  • QUAL

Additional information

The valid entries for this field are defined by the list of codes in QualificationsAwarded.QUAL, and this field contains all codes valid for that field together with three underscores for instances with no qualification.

Where an instance has more than one occurrence of a QualificationsAwarded entity associated with it, this field selects the highest qualification for that instance. The selection of highest qualification is based on the following grouping, which is ordered with highest qualifications at the top of the list:

Doctorate
Other higher degree
Postgraduate Certificate in Education *
Other postgraduate qualifications
First degree
First degree equivalent
Foundation degree
HND/DipHE
Other sub-degree
Further education
(* Note: Professional Graduate Certificate in Education H71 is not included).

The assessment of 'highest' is achieved through the use of a look-up table, provided by the HESA Data Management team, which includes all possible QualificationsAwarded.QUAL codes and their associated ranking value. The table, STATIC_DATA.T_QUAL_RANK_LOOKUP, consists of two columns - the QualificationsAwarded.QUAL code (QUAL, VARCHAR2(3)) and a ranking value (RANK, NUMBER).

Technical Specification

An instance may have none, one or many occurrences of the QualificationsAwarded entity associated with it.

One occurrence of the QualificationsAwarded entity
Where an instance has one occurrence of the QualificationsAwarded entity and the QualificationsAwarded.QUAL is listed in the T_QUAL_RANK_LOOKUP ranking table, the QualificationsAwarded.QUAL is returned.

Where an instance has one occurrence of the QualificationsAwarded entity and the QualificationsAwarded.QUAL not listed in the T_QUAL_RANK_LOOKUP ranking table, a null value is returned.

Many occurrences of the QualificationsAwarded entity
Where an instance has many occurrences of the QualificationsAwarded entity and none of the QualificationsAwarded.QUALs are listed in the T_QUAL_RANK_LOOKUP ranking table, a null value is returned.

Where an instance has many occurrences of the QualificationsAwarded entity and one QualificationsAwarded.QUAL is listed in the T_QUAL_RANK_LOOKUP ranking table, but others are not, only the listed QualificationsAwarded.QUAL is returned (i.e. treated as per the ranking number nearest zero).

Where an instance has many occurrences of the QualificationsAwarded entity and at least two QualificationsAwarded.QUALs are listed in the T_QUAL_RANK_LOOKUP ranking table, a ranking number is assigned to all listed occurrences of QualificationsAwarded.QUAL for that instance. The QualificationsAwarded.QUAL with the ranking number nearest zero is returned for that instance, unless two or more are ranked equally nearest zero (because they are identical). In this scenario the qualification of these with the lowest QualificationsAwarded. QUALIFICATIONSAWARDEDKEY is returned as XQOBTND01.

No occurrence of the QualificationsAwarded entity
Where an instance has no QualificationsAwarded entity associated with it, three underscores are returned.

Revision history

Date Version Notes
2020-05-19 9.7.1 Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5). Additionally valid entry H24 'First degree with honours on the intercalated pattern' has been removed as it is no longer used
2020-03-26 9.6.1 Valid entries have been updated to include new entries C13, H13, I13, E13 and M13. CSV also updated to include the new entries
2019-02-21 9.5.1 The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91
2018-02-22 9.4.1 The Technical Specification section has been updated to remove XQOBTN01 valid entry D01
2016-11-01 9.3.1 Valid entries revised to add codes associated with new valid entries in QualificationsAwarded.QUAL: M73 and I78. These entries have been added to T_QUAL_RANK_LOOKUP
2016-11-01 9.3.1 Valid entries revised to remove D01 associated with old valid entries in QualificationsAwarded.QUAL
2016-02-09 9.2.1 Technical Specification revised to delete the existing specification table, and insert references to a new centralised lookup table to be provided by Data Management - T_QUAL_RANK_LOOKUP
2014-10-16 9.1.1 Addition of new Early Years Teacher Status (EYTS) codes H12, I12, and I73 to valid entries and Technical Specification ranking table, due to their addition in QualificationsAwarded.QUAL. Technical specification amended to account for the use of this field in the AP student record, and the possibility that many QualificationsAwarded entities may be returned instead of the maximum of two permitted under Student
2013-10-21 8.1.1 New code M28 added to valid entries. Technical specification amended, adding this code to the ranking table
2013-02-05 7.1.1 New codes M44 and H62 added to valid entries. Technical specification amended, adding these codes to the ranking table
2012-05-02 6.2.3 Technical specification text clarified to aid creation of function and testing. No change to valid entries or ranking table
2012-04-11 6.2.2 Labels for valid entries D00, D01, E00, L00, L80, M00 and M50 revised to align with the guidance for research-based higher degrees. No change to meaning, nor to function
2012-02-17 6.2.1 Ranking number format changed to include leading zeroes up to three digits in length. No change to function
2010-04-09 6.1.1 New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added
2009-07-17 5.1.6 Clarification that Professional Graduate Certificate in Education is not included in the Postgraduate Certificate in Education highest qualification grouping
2009-06-11 5.1.5 Valid entry labels aligned with HESA writing standard. No change to function
2009-04-06 5.1.4 Valid entry labels to lower case A/AS level, P85 label to match 'at level 3' added
2009-03-13 5.1.3 Updated format. field type added. No change to technical specification
2008-01-01 5.1.2 Amended typo in text to clarify that '___' is valid entry for no qualification
2007-12-20 5.1.1 New Cyy051 codes added, field length 3
2004-02-13 4.1.1 New 03/04 record codes added
2003-02-12 3.1.1 New 02/03 record codes added
2002-03-08 2.1.1 Foundation degree, code 28 added
1998-09-07 1.1.1 Created

Contact Liaison by email or on +44 (0)1242 388 531.