- STUDENT_COURSE_MEMBERSHIP_ID [1] *
- COURSE_INSTANCE_ID [1] *
- STUDENT_COURSE_MEMBERSHIP_SEQ [1] *
- STUDENT_ID [1]
- MODE [0..1]
- YEAR_COM [0..1] deprecated
- YEAR_PRG [0..1]
- YEAR_STU [0..1]
- COURSE_LOCATION [0..1]
- X_COURSE_AVERAGE_MARK [0..1]
- X_YEAR_AVERAGE_MARK [0..1]
* indicates that the property is part of a composite primary key for this entity.
Mode of study (eg part-time or full time)
For analytics
https://www.hesa.ac.uk/collection/c16051/a/MODE
| MODE | DESCRIPTION(ENGLISH) | DESCRIPTION(WELSH) | HESA(MODE) | FEILR(PlanLearnHours) |
| 1 | Full-time according to funding council definitions | 01 | PlanLearnHours > 540 | |
| 2 | Other full-time | 02 | N/A | |
| 12 | FE students full-time 30 weeks or more | 12 | N/A | |
| 13 | FE students full-time 4-29 weeks | 13 | N/A | |
| 14 | FE students full-time less than 4 weeks | 14 | N/A | |
| 23 | Sandwich (thick) according to funding council definitions | 23 | N/A | |
| 24 | Sandwich (thin) according to funding council definitions | 24 | N/A | |
| 25 | Other sandwich course/programme | 25 | N/A | |
| 31 | Part-time | 31 | PlanLearnHours ≤ 540 | |
| 33 | FE students part-time released from employment | 33 | N/A | |
| 34 | FE students part-time not released from employment | 34 | N/A | |
| 35 | FE students evening only | 35 | N/A | |
| 36 | FE students open or distance learning | 36 | N/A | |
| 38 | Structured part-time (providers in Scotland) | 38 | N/A | |
| 39 | Other part-time (providers in Scotland) | 39 | N/A | |
| 43 | Writing-up - previously full-time | 43 | N/A | |
| 44 | Writing-up - previously part-time | 44 | N/A | |
| 51 | Sabbatical | 51 | N/A | |
| 63 | Dormant - previously full-time | 63 | N/A | |
| 64 | Dormant - previously part-time | 64 | N/A | |
| 65 | FE students continuous delivery day/daytime | 65 | N/A | |
| 73 | Change to dormant status - previously full-time | 73 | N/A | |
| 74 | Change to dormant status - previously part-time | 74 | N/A | |
| 99 | FE students in England | 99 | N/A | |
| 98 | Not Known / Not in Early Statistics / HEIFES population / not applicable | 98 | N/A |
Int
Yes (if applicable)
Mapping based on HESA codeset, and ILE (FE) initial mapping suggested above on ILR field 'PlanLearnHours'. HESA 2015 'mode' does not have code 98, but HESA 2016 'mode' does. Omitting this property may hinder the development or use of an effective analytics model.
This field indicates the year number that the learning aim/ course started. It duplicates COURSE_JOIN_DATE on student_course_membership.
For analytics
https://www.hesa.ac.uk/collection/c16051/a/COMDATE
Any
Int
Use COURSE_JOIN_DATE on student_course_membership instead.
This field indicates the year number of the course that the student is currently studying. This could be different from the year of student if the student has changed course or re-taken a year.
For analytics
https://www.hesa.ac.uk/collection/c16051/a/YEARPRG
Any
Int
Omitting this property may hinder the development or use of an effective analytics model.
Year number that the student is in since enrolling for a course
For analytics
https://www.hesa.ac.uk/collection/c16051/a/YEARSTU
Any
Int
Omitting this property may hinder the development or use of an effective analytics model.
Identifies the location with which a student on a course_instance is associated, be it a building, a site or a campus.
For analytics (predictive model building) and for presenting analytics.
Loosely based on https://www.hesa.ac.uk/collection/c16051/a/CAMPID
Any
String (255)
The current (LIVE) average of all module marks from across a learner's whole course.
For analytics
Jisc
0-1
Float
This data is generated internally to the learning record warehouse from existing data, and does not need to be supplied by an institution.
The current (LIVE) average of all of this academic year's module marks from across a learner's whole course.
For analytics
Jisc
0-1
Float
This data is generated internally to the learning record warehouse from existing data, and does not need to be supplied by an institution.