- STUDENT_COURSE_MEMBERSHIP_ID [1] *
- STUDENT_COURSE_MEMBERSHIP_SEQ [1] *
- STUDENT_ID [1]
- COURSE_ID [1]
- WITHDRAWAL_REASON [0..1]
- WITHDRAWAL_DATE [0..1] deprecated
- ENTRY_QUALS [0..1]
- ENTRY_POINTS [0..1]
- COURSE_OUTCOME [0..1]
- COURSE_GRADE [0..1]
- COURSE_AIM_ATTAINED [0..1]
- COURSE_MARK [0..1]
- COURSE_EXPECTED_END_DATE [0..1]
- COURSE_END_DATE [0..1]
- COURSE_JOIN_DATE [0..1]
- COURSE_JOIN_AGE [0..1]
- COHORT_ID [0..1]
- ACTIVE_MEMBERSHIP [0..1]
* indicates that the property is part of a composite primary key for this entity.
The institution's own unique identifier for the combination of one student and one course they are enrolled on.
To provide a unique course code for a student, for use in correctly mapping to module and assessment records.
As defined by the Student Record System.
String (255)
The student_course_membership is designed to deal with the fact that some students are enrolled on more than one course in their time at a provider. Drawing together data on their student ID alone could therefore be misleading, or at least be significantly different from students who have only ever been registered on one course. STUDENT_COURSE_MEMBERSHIP_ID partitions the study careers of those who are on multiple courses, and makes them comparable to those who have only ever been enrolled on one course.
A sequence indicator that uniquely identifies the combination of the student and the course_instance they are assigned to, to allow for cases where there is more than one such combination.
Together with STUDENT_COURSE_MEMBERSHIP_ID, the purpose of STUDENT_COURSE_MEMBERSHIP_SEQ is to provide a unique course_instance code for a student, for use in joining a student to course_instance/enrolment records.
As defined by the Student Record System.
Either a letter or digit that increments for each student - course_instance pair.
String (255)
The student_course_membership sequence ID is designed to deal with the fact that some students drop out off or enroll on more than one instance of the same course.
In cases where a sequence ID is not readily available – which includes most sites that do not use Tribal SITS –, the correct value for all instances of this student_course_membership entity is likely to be "1". The reason is that, in such cases, STUDENT_COURSE_MEMBERSHIP_ID is already unique on its own, and the sequence number of that unique instance is, therefore, 1.
Note that the ACTIVE_MEMBERSHIP property indicates whether this student_course_membership record is the last known active one.
This property will be deprecated in the next revision of the UDD.
The reason a student has withdrawn from a course (if they have)
For analytics
Based on the ILR codeset used for 'WithdrawReason' - with HESA code '05' utilised. For further information visit:
https://www.hesa.ac.uk/collection/c16051/a/WITHDRAWREASON
https://www.hesa.ac.uk/collection/c16051/a/RSNEND
| WITHDRAWAL_REASON | DESCRIPTION (ENGLISH) | DESCRIPTION (WELSH) | HESA (WITHDRAWREASON) | HESA (RSNEND) | FEILR (WITHDRAWREASON) |
| 2 | Learner has transferred to another provider | 02 | 03 | 2 | |
| 3 | Learner injury / illness | 03 | 04 | 3 | |
| 5 | Death | N/A | 05 | N/A | |
| 7 | Learner has transferred between providers due to intervention by the Skills Funding Agency | 07 | N/A | 7 | |
| 10 | Gone into employment | N/A | 10 | N/A | |
| 28 | OLASS learner withdrawn due to circumstances outside the providers’ control | N/A | N/A | 28 | |
| 29 | Learner has been made redundant | 29 | N/A | 29 | |
| 40 | Learner has transferred to a new learning aim with the same provider | 40 | N/A | 40 | |
| 41 | Learner has transferred to another provider to undertake learning that meets a specific government strategy | 41 | N/A | 41 | |
| 42 | Academic failure/left in bad standing/not permitted to progress – HE learning aims only | N/A | 02 | 42 | |
| 43 | Financial reasons | N/A | 06 | 43 | |
| 44 | Other personal reasons | N/A | 07 | 44 | |
| 45 | Written off after lapse of time (HE learning aims only) | N/A | 08 | 45 | |
| 46 | Exclusion | N/A | 09 | 46 | |
| 97 | Other | 97 | 11 | 97 | |
| 98 | Reason not known | 98 | 99 | 98 | |
| 99 | Completion of course - result unknown | N/A | 98 | N/A |
Int
The date a student has withdrawn from a course (if they have)
For analytics
https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/449779/ILRSpecification2015_16_v3_July2015.pdf https://www.hesa.ac.uk/collection/c16051/a/ENDDATE
YYYY-MM-DD
ISO 8601 Date
Would normally utilise ENDDATE (HE/ HESA) or potentially LearnActEndDate (FE/ ILR - to be confirmed) when relevant fields denote that the learner/ student has withdrawn from the learning aim/ course.
This property is deprecated, use student_course_membership.COURSE_END_DATE and student_course_membership.COURSE_OUTCOME instead.
The classification of entry qualifications, prior to entry to the institution
For display & analytics
Based on HESA codings for QUALENT3, but merged with specific element of the FE ILR field 'PriorAttain'
https://www.hesa.ac.uk/collection/c16051/a/QUALENT3
| ENTRY_QUALS | DESCRIPTION (ENGLISH) | DESCRIPTION (WELSH) | HESA(QUALENT3) | FEILR (PRIORATTAIN) |
| DUK | UK doctorate degree | DUK | ||
| DZZ | Non-UK doctorate degree | DZZ | ||
| D80 | Other qualification at level D | D80 | ||
| MUK | UK masters degree | MUK | ||
| MZZ | Non-UK masters degree | MZZ | ||
| M2X | Integrated undergraduate/postgraduate taught masters degree on the enhanced/extended pattern | M2X | ||
| M41 | Diploma at level M | M41 | ||
| M44 | Certificate at level M | M44 | ||
| M71 | Postgraduate Certificate in Education or Professional Graduate Diploma in Education | M71 | ||
| M80 | Other taught qualification at level M | M80 | ||
| M90 | Taught work at level M for provider credit | M90 | ||
| M91 | (Other) Qualification at level 7 or above | N/A | 13 | |
| HUK | UK first degree with honours | HUK | ||
| HZZ | Non-UK first degree | HZZ | ||
| H11 | First degree with honours leading to Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC) | H11 | ||
| H71 | Professional Graduate Certificate in Education | H71 | ||
| H80 | (Other) Qualification at level H or level 6 | H80 | 12 | |
| JUK | UK ordinary (non-honours) first degree | JUK | ||
| J10 | Foundation degree | J10 | ||
| J20 | Diploma of Higher Education (DipHE) | J20 | ||
| J30 | Higher National Diploma (HND) | J30 | ||
| J31 | (Other) Qualification at level 5 or above (DEPRECATED SINCE 01/08/2013) | J32 | 5 | |
| J49 | Foundation course at level J | J49 | ||
| J48 | Certificate in Education (CertEd) or Diploma in Education (DipEd) (i.e. non-graduate initial teacher training qualification) | J48 | ||
| J80 | Other qualification at level J | J80 | ||
| C20 | Certificate of Higher Education (CertHE) | C20 | ||
| C30 | Higher National Certificate (HNC) | C30 | ||
| C44 | Higher Apprenticeship (level 4) | C44 | ||
| C80 | (Other) Qualification at level C or level 4 | C80 | 4, 10 | |
| C90 | Undergraduate credits | C90 | ||
| P41 | Diploma at level 3 | P41 | ||
| P42 | Certificate at level 3 | P42 | ||
| P46 | Award at level 3 | P46 | ||
| P47 | AQA Baccalaureate (Bacc) | P47 | ||
| P50 | A/AS level | P50 | ||
| P51 | 14-19 Advanced Diploma (level 3) | P51 | ||
| P53 | Scottish Baccalaureate | P53 | ||
| P54 | Scottish Highers/Advanced Highers | P54 | ||
| P62 | International Baccalaureate (IB) Diploma | P62 | ||
| P63 | International Baccalaureate (IB) Certificate | P63 | ||
| P64 | Cambridge Pre-U Diploma | P64 | ||
| P65 | Cambridge Pre-U Certificate | P65 | ||
| P68 | Welsh Baccalaureate Advanced Diploma (level 3) | P68 | ||
| P80 | (Other) Qualification at level 3 | P80 | 3 | |
| P91 | Level 3 qualifications of which some or all are subject to UCAS Tariff | P91 | ||
| P92 | Level 3 qualifications of which none are subject to UCAS Tariff | P92 | ||
| P93 | Level 3 qualifications of which all are subject to UCAS Tariff | P93 | ||
| P94 | Level 3 qualifications of which some are subject to UCAS Tariff | P94 | ||
| Q51 | 14-19 Higher Diploma (level 2) | Q51 | ||
| Q52 | Welsh Baccalaureate Intermediate Diploma (level 2) | Q52 | ||
| Q80 | (Other) Qualification at level 2 | Q80 | 2 | |
| R51 | 14-19 Foundation Diploma (level 1) | R51 | ||
| R52 | Welsh Baccalaureate Foundation Diploma (level 1) | R52 | ||
| R80 | Other qualification at level 1 | R80 | 1 | |
| X07 | (Other) Qualification below level 1 | N/A | 7 | |
| 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 | ||
| X02 | Mature student admitted on basis of previous experience and/or admissions test | X02 | ||
| X04 | Other qualification level not known | X04 | 97 | |
| X05 | Student has no formal qualification | X05 | 99 | |
| X06 | Not known | X06 | 98 |
Alphanumeric
Omitting this property may hinder the development or use of an effective analytics model.
This field indicates the entry points gained by the student/ learner prior to entry to the institution. This is currently based on the UCAS entry points system. This field must be adapted or used to represent those points for entry into FE eg. using a formula to combine & calculate points to represent Maths and English qualifications upon entry for example
For analytics
Jisc
Any
Int
This field indicates the outcome/ status of the learner's current course or learning aim. This is based on the information provided by HESA via the RSNEND field, however this has been adapted with the addition of fields to cater for FE (via the ILR CompStatus field), and can be used to fully cater for the outcomes in granular detail
For analytics
https://www.hesa.ac.uk/collection/c16051/a/rsnend/
| COURSE_OUTCOME | DESCRIPTION (ENGLISH) | DESCRIPTION (WELSH) | HESA RSNEND code | FEILR CompStatus code |
| 01 | Successful completion of course | 01 | 2 | |
| 02 | Academic failure/left in bad standing/not permitted to progress | 02 | 3 | |
| 03 | Transferred to another provider | 03 | N/A | |
| 04 | Health reasons | 04 | N/A | |
| 05 | Death | 05 | N/A | |
| 06 | Financial reasons | 06 | N/A | |
| 07 | Other personal reasons & dropped out | 07 | N/A | |
| 08 | Written off after lapse of time | 08 | N/A | |
| 09 | Exclusion | 09 | N/A | |
| 10 | Gone into employment | 10 | N/A | |
| 11 | Other | 11 | N/A | |
| 12 | Transferred out as part of collaborative supervision arrangements | 12 | N/A | |
| 13 | The learner is continuing or intending to continue the learning activities leading to the learning aim | N/A | 1 | |
| 14 | Learner has temporarily withdrawn from the aim due to an agreed break in learning | N/A | 6 | |
| 98 | Completion of course - result unknown | 98 | N/A | |
| 99 | Unknown | 99 | N/A |
Int
Omitting this property may hinder the development or use of an effective analytics model.
Class of award achieved by the student on this course_instance. Based on HESA codeset for CLASS (HE conformity to be confirmed)
For analytics
https://www.hesa.ac.uk/collection/c16051/a/CLASS
| COURSE_GRADE | DESCRIPTION (ENGLISH) | DESCRIPTION (WELSH) |
| 1 | First class honours | |
| 2 | Upper second class honours | |
| 3 | Lower second class honours | |
| 4 | Undivided second class honours | |
| 5 | Third class honours | |
| 6 | Fourth class honours | |
| 7 | Unclassified honours | |
| 8 | Aegrotat (whether to honours or pass) | |
| 9 | Pass - degree awarded without honours following an honours course | |
| 10 | Ordinary (to include divisions of ordinary if any) - degree awarded after following a non-honours course | |
| 11 | General degree - degree awarded after following a non-honours course/degree that was not available to be classified | |
| 12 | Distinction | |
| 13 | Merit | |
| 14 | Pass | |
| 51 | A FE | |
| 52 | B FE | |
| 53 | C FE | |
| 54 | D FE | |
| 55 | E FE | |
| 56 | F FE | |
| 57 | G FE | |
| 61 | N FE | |
| 62 | U FE | |
| 63 | X FE | |
| 64 | A* FE | |
| 65 | Y FE | |
| 71 | Pass FE | |
| 72 | Merit FE | |
| 73 | Distinction FE | |
| 74 | Fail FE | |
| 81 | 1 FE | |
| 82 | 2 FE | |
| 83 | 3 FE | |
| 84 | 4 FE | |
| 85 | 5 FE | |
| 86 | 6 FE | |
| 87 | 7 FE | |
| 88 | 8 FE | |
| 89 | 9 FE | |
| 90 | 10 FE | |
| 91 | Not yet awarded |
Int
Omitting this property could impair the functionality of analytics applications such as student apps or dashboards.
The Course Aim the student attained on the course of which they are a member.
Allowing the analysis of whether a student achieved the award/aim associated with the course of which they are a member.
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)
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.
The overall mark a student attained on their course.
For display purposes and further analysis
SRS Systems
0-100
Decimal (IEEE 754)
The end date the student was expected to complete a course when they enrolled. This will be used to identify students who extend beyond this date.
Analytics and display
Jisc
YYYY-MM-DD
ISO 8601
Omitting this property may hinder the development or use of an effective analytics model.
The date on which the student left their course.
Analytics and display
Jisc
YYYY-MM-DD
ISO 8601
Note that there may be many reasons why a student leaves a course. This is recorded in WITHDRAWAL_REASON.
This field indicates the date of the student's initial commencement of studies for this student_course_membership and may relate to a date prior to the current academic/financial year. Exchange-in students should have the date they commenced their studies at the reporting provider.
Analytics
HESA COMDATE https://www.hesa.ac.uk/collection/c16051/a/COMDATE
YYYY-MM-DD
ISO 8601
The age of the student when they initially commenced their studies for this student_course_membership. Exchange-in students should have the age they commenced their studies at the reporting provider.
Analytics
Jisc
0-200
Int
This value is designed to be a secondary source to check COURSE_JOIN_DATE minus DOB. In cases where COURSE_JOIN_AGE is not stored separately, it should be calculated at the ETL stage.
An identifier for a group of students in a year cohort.
Display and grouping purposes, and but analysis.
Jisc
Any
String (255)
An identifier for a group of students in a year cohort.
Display and grouping purposes, and but analysis.
Jisc
Any
String (255)
This property indicates whether the associated student_course_membership record identifies the course a student is actively studying on, or intending to study on, at the moment the data was extracted.
Display purposes.
Jisc
| ACTIVE_MEMBERSHIP | DESCRIPTION (ENGLISH) | DESCRIPTION (WELSH) |
| 1 | active | |
| 2 | not active | |
| 3 | unknown |
String (1)
The purpose of this property is to easily identify, if there are several student_course_membership records for a given STUDENT_ID or COURSE_ID and STUDENT_ID combination, which of these records is the last known to have been actively used.
A record with ACTIVE_MEMBERSHIP=1 will generally also be the record with the most recent COURSE_JOIN_DATE. The only exceptions would be cases where a students starts on one course, switches to another, and then reverts to the original.
When updating student_course_membership records, the ACTIVE_MEMBERSHIP property may need to be updated on all records associated with one STUDENT_ID, not just one. The exception would be those cases where a student pursues more than one course simultaneously.