- COURSE_ID [1] *
- SUBJECT [0..1]
- TITLE [0..1]
- COURSE_AIM [0..1]
- INST_TIER_1 [0..1]
- INST_TIER_2 [0..1]
- INST_TIER_3 [0..1]
- TENANT_ID [0..1]
* indicates that the property is the primary key for this entity.
The providers own ID for the course
To link relational database tables
https://www.hesa.ac.uk/collection/c16051/a/owncourseid/ https://www.hesa.ac.uk/collection/c16054/e/course_courseid/
Any
String (255)
HE guidance - this field could relate to actual HESA COURSEID field or the HE institution's OWNCOURSEID field for cross-referencing purposes.
Subject of study coding using JACS3.
For display purposes
https://www.hesa.ac.uk/collection/c16051/a/sbjca/
https://www.hesa.ac.uk/support/documentation/jacs
String (10) - Usually 4 characters, number followed by three digits
The JACS3 coding will be used here initially, from the HE (HESA) model. Further discussion will be required around this, to discuss subject classifications for FE/ ILR. Omitting this property could impair the functionality of analytics applications such as student apps or dashboards.
Course Name or Title
For display purposes
https://www.hesa.ac.uk/collection/c16051/a/ctitle/
Any
String (255)
Omitting this property could severely impair the functionality of analytics applications such as student apps or dashboards.
The qualification which the learner/ student is aiming for at the provider
For display purposes and further analysis
https://www.hesa.ac.uk/collection/c16051/a/courseaim/
| COURSE_AIM | DESCRIPTION (ENGLISH) | DESCRIPTION (WELSH) | HESA | FEILR |
| D00 | Doctorate degree that meets the criteria for a research-based higher degree | D00 | ||
| D01 | New Route PhD that meets the criteria for a research-based higher degree | D01 | ||
| D90 | Provider credit at level D that can count towards a research-based higher degree | D90 | ||
| E00 | Doctorate degree that does not meet the criteria for a research-based higher degree | E00 | ||
| E40 | National Vocational Qualification (NVQ) at level E | E40 | ||
| E43 | Highly specialist diploma from a professional body | E43 | ||
| E90 | Advanced taught study at level E for provider credit | E90 | ||
| L00 | Masters degree that meets the criteria for a research-based higher degree | L00 | ||
| L80 | Other postgraduate qualification at level L that meets the criteria for a research-based higher degree | L80 | ||
| L90 | Provider credit at level L that can count towards a research-based higher degree | L90 | ||
| L91 | Visiting research students at levels D or L, with formal or informal credit | L91 | ||
| L99 | Research-based higher degree where the student may ultimately study at levels D or L | L99 | ||
| 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 | M00 | ||
| M01 | Taught masters degree designed specifically as a training in research methods and intended as a preparation for a research-based higher degree | M01 | ||
| M02 | Masters in Teaching and Learning | M02 | ||
| M10 | Post-experience taught masters degree | M10 | ||
| M11 | Master of Business Administration (MBA) | M11 | ||
| M16 | Pre-registration masters degree leading towards obtaining eligibility to register to practice with a health or social care or veterinary statutory regulatory body | M16 | ||
| M22 | Integrated undergraduate/postgraduate taught masters degree on the enhanced/extended pattern | M22 | ||
| 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 | M26 | ||
| 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) | M28 | ||
| M40 | Fellowship at level M | M40 | ||
| M41 | Diploma at level M | M41 | ||
| M42 | Advanced professional certificate at level M | M42 | ||
| M43 | National Vocational Qualification (NVQ) at level M | M43 | ||
| M44 | Certificate at level M | M44 | ||
| M45 | Scottish Vocational Qualification (SVQ) 5 | M45 | ||
| 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 | M50 | ||
| M70 | Professional taught qualification at level M other than a masters degree | M70 | ||
| M71 | Postgraduate Certificate in Education or Professional Graduate Diploma in Education | M71 | ||
| M72 | Post-registration education qualification at level M other than a masters degree for serving schoolteachers | M72 | ||
| M73 | Postgraduate Diploma in Education | M73 | ||
| M76 | Post-registration health and social care qualification at level M | M76 | ||
| 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) | M78 | ||
| M79 | Level 7 Diploma in Teaching in the Lifelong Learning Sector | M79 | ||
| M80 | Other taught qualification at level M | M80 | ||
| 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 | M86 | ||
| 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) | M88 | ||
| M90 | Taught work at level M for provider credit | M90 | ||
| M91 | Visiting taught students at levels E or M, with formal or informal credit | M91 | ||
| M99 | Taught work at levels E or M with an unspecified qualification aim | M99 | ||
| H00 | First degree with honours | H00 | ||
| H11 | First degree with honours leading to Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC) | H11 | ||
| H12 | First degree with honours leading to Early Years Teacher Status (EYTS) | H12 | ||
| 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 | H16 | ||
| H18 | First degree with honours leading towards registration with the Architects Registration Board (Part 1 qualification) | H18 | ||
| H22 | First degree with honours on the enhanced/extended pattern but at level H | H22 | ||
| H23 | First degree with honours and diploma | H23 | ||
| H41 | Diploma at level H | H41 | ||
| H42 | Certificate at level H | H42 | ||
| H43 | National Vocational Qualification (NVQ) at level H | H43 | ||
| H50 | Postgraduate bachelors degree at level H | H50 | ||
| H60 | Graduate diploma/certificate at level H | H60 | ||
| H61 | Graduate diploma/certificate at level H but where a previous qualification at level H is a pre-requisite for course entry | H61 | ||
| 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 | H62 | ||
| H70 | Professional qualification at level H other than a first degree with honours | H70 | ||
| H71 | Professional Graduate Certificate in Education | H71 | ||
| H72 | Professional qualification at level H for serving schoolteachers other than a first degree with honours | H72 | ||
| H76 | Post-registration health and social care qualification at level H other than a first degree with honours | H76 | ||
| 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) | H78 | ||
| H79 | Level 6 Diploma in Teaching in the Lifelong Learning Sector | H79 | ||
| H80 | Other qualification at level H | H80 | ||
| H81 | Other qualification at level H but where a previous qualification at level H is a pre-requisite for course entry | H81 | ||
| 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) | H88 | ||
| H90 | Credits at level H | H90 | ||
| H91 | Visiting students at level H, with formal or informal credit | H91 | ||
| H99 | Taught work at level H with an unspecified qualification aim | H99 | ||
| I00 | Ordinary (non-honours) first degree | I00 | ||
| I11 | Ordinary (non-honours) first degree leading to Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC) | I11 | ||
| I12 | Ordinary (non-honours) first degree leading to Early Years Teacher Status (EYTS) | I12 | ||
| 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 | I16 | ||
| I60 | Graduate diploma/certificate at level I | I60 | ||
| I61 | Graduate diploma/certificate at level I but where a previous qualification at level I or H is a pre-requisite for course entry | I61 | ||
| I70 | Professional qualification at level I other than an ordinary (non-honours) first degree | I70 | ||
| I71 | Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC) only | I71 | ||
| I72 | Professional qualification at level I for serving schoolteachers | I72 | ||
| I73 | Early Years Teacher Status (EYTS) only | I73 | ||
| I74 | Teaching certificate (trained through the medium of Welsh) | I74 | ||
| I76 | Post-registration health and social care qualification at level I other than an ordinary (non-honours) first degree | I76 | ||
| I79 | Level 5 Diploma in Teaching in the Lifelong Learning Sector | I79 | ||
| I80 | Other qualification at level I | I80 | ||
| I81 | Other qualification at level I but where a previous qualification at level I or H is a pre-requisite for course entry | I81 | ||
| I90 | Credits at level I | I90 | ||
| I91 | Visiting students at level I, with formal or informal credit | I91 | ||
| I99 | Taught work at level I with an unspecified qualification aim | I99 | ||
| J10 | Foundation degree | J10 | ||
| J16 | Foundation degree which on completion meets entry requirement for pre-registration health and social care qualification | J16 | ||
| J20 | Diploma of Higher Education (DipHE) | J20 | ||
| 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 | J26 | ||
| J30 | Higher National Diploma (HND) | J30 | ||
| J41 | Diploma at level J | J41 | ||
| J42 | Certificate at level J | J42 | ||
| J43 | National Vocational Qualification (NVQ) at level J | J43 | ||
| J45 | Scottish Vocational Qualification (SVQ) 4 | J45 | ||
| J76 | Post-registration health and social care qualification at level J | J76 | ||
| J80 | Other qualification at level J | J80 | ||
| J90 | Credits at level J | J90 | ||
| J99 | Taught work at level J with an unspecified qualification aim | J99 | ||
| C20 | Certificate of Higher Education (CertHE) | C20 | ||
| C30 | Higher National Certificate (HNC) | C30 | ||
| C41 | Diploma at level C | C41 | ||
| C42 | Certificate at level C | C42 | ||
| C43 | National Vocational Qualification (NVQ) at level C | C43 | ||
| C77 | Level 4 Preparing to Teach in the Lifelong Learning Sector | C77 | ||
| C78 | Level 4 Certificate in Teaching in the Lifelong Learning Sector | C78 | ||
| C80 | Other qualification at level C | C80 | ||
| C90 | Credits at level C | C90 | ||
| C99 | Taught work at level C with an unspecified qualification aim | C99 | ||
| P41 | Diploma at level P | P41 | ||
| P42 | Certificate at level P | P42 | ||
| P43 | National Vocational Qualification (NVQ) 3 | P43 | ||
| P45 | Scottish Vocational Qualification (SVQ) 3 | P45 | ||
| P50 | A/AS level | P50 | ||
| P55 | Advanced Higher (Scotland) | P55 | ||
| P56 | Higher (Scotland) | P56 | ||
| P70 | Professional qualification at level 3 | P70 | ||
| P77 | Level 3 Preparing to Teach in the Lifelong Learning Sector | P77 | ||
| P78 | Level 3 Certificate in Teaching in the Lifelong Learning Sector | P78 | ||
| P80 | Other qualification at level 3 | P80 | ||
| P85 | Diploma in Foundation Studies (Art and Design) at level 3 | P85 | ||
| P90 | Credits at level 3 | P90 | ||
| Q41 | Diploma at level Q | Q41 | ||
| Q42 | Certificate at level Q | Q42 | ||
| Q43 | National Vocational Qualification (NVQ) 2 | Q43 | ||
| Q45 | Scottish Vocational Qualification (SVQ) 2 | Q45 | ||
| Q50 | GCSE at grade A*-C | Q50 | ||
| Q56 | Intermediate 2 (Scotland) | Q56 | ||
| Q57 | Standard Grade Credit (Scotland) | Q57 | ||
| Q70 | Professional qualification at level 2 | Q70 | ||
| Q80 | Other qualification at level 2 | Q80 | ||
| Q90 | Credits at level 2 | Q90 | ||
| R42 | Certificate at level R | R42 | ||
| R43 | National Vocational Qualification (NVQ) 1 | R43 | ||
| R45 | Scottish Vocational Qualification (SVQ) 1 | R45 | ||
| R50 | GCSE at grade D-G | R50 | ||
| R56 | Intermediate 1 (Scotland) | R56 | ||
| R57 | Standard Grade General (Scotland) | R57 | ||
| R70 | Professional qualification at level 1 | R70 | ||
| R80 | Other qualification at level 1 | R80 | ||
| R90 | Credits at level 1 | R90 | ||
| S42 | National Vocational Qualification (NVQ) Entry level certificate | S42 | ||
| S57 | Standard Grade Foundation (Scotland) | S57 | ||
| S80 | Other qualification at further education (FE) access level | S80 | ||
| S90 | Credits at further education (FE) access level | S90 | ||
| X00 | Higher education (HE) access course, Quality Assurance Agency (QAA) recognised | X00 | ||
| X01 | Higher education (HE) access course, not Quality Assurance Agency (QAA) recognised | X01 | ||
| X41 | Welsh for Adults Entry level | X41 | ||
| X42 | Welsh for Adults level 1 | X42 | ||
| X43 | Welsh for Adults level 2 | X43 | ||
| X44 | Welsh for Adults level 3 | X44 | ||
| X45 | Welsh for Adults level 4 | X45 | ||
| X46 | Welsh for Adults specialist/arbennig | X46 | ||
| X98 | No formal qualification aim, below FE level | N/A | ||
| X99 | No formal qualification aim, below HE level | X99 | ||
| Z99 | Course aim does not apply | Z99 |
String (255)
This field uses the HESA "COURSEAIM" codeset initially - with the addition of new code 'X98' to denote 'No formal qualification aim, below FE level' for FE equivalent denotation to HE code 'X99'. All course levels are denoted here (TBC with FE college, for final implementation). Specific use of the LARS codeset for FE (from ILR) may need to be considered, or a mapping/ amalgamation with the HESA codeset. This is to be discussed in consultation with the FE sector. Omitting this property may hinder the development or use of an effective analytics model.
Details the top level of an institutional structure (e.g. Faculty Details)
For display purposes and further analysis
https://www.hesa.ac.uk/collection/c16041/a/tier1/
Any
String (255)
Details the middle level of an institutional structure (e.g. department details)
For display purposes and further analysis
https://www.hesa.ac.uk/collection/c16041/a/tier2/
Any
String (255)
Details the lower level of an institutional structure (e.g. department details)
For display purposes and further analysis
https://www.hesa.ac.uk/collection/c16041/a/DEPARTMENT
Any
String (255)