HESA Student record 2012/13
Data model
Version 1.0 Produced 2012-09-27
The HESA student record specification is based on a data model which defines the entities covered by the record and the relationship between these entities.
HESA Student record entity relationship diagram
Click on the relevant section of the model to view the fields associated with each entity. Entities with a blue background are returnable for FE students in England only.
Relationship Definitions
Entities | Relationship |
Institution to Student | An Institution must have one or many Students A Student must belong to an Institution |
Student to Learner Employment Status | A Student can have zero, one or many Learner Employment Status entities A Learner Employment Status entity must belong to a Student |
Learner Employment Status to Employment Status Monitoring | A Learner Employment Status entity must have one or many Employment Status Monitoring entities An Employment Status Monitoring entity must belong to a Learner Employment Status entity |
Student to Learner Funding and Monitoring | A Student can have zero, one or many Learner Funding and Monitoring entities A Learner Funding and Monitoring entity must belong to a Student |
Student to Instance | A Student must have one or many Student Instances A Student Instance must belong to a Student |
Course to Instance | An Instance must belong to one Course A Course can have zero, one or many Student Instances |
Course to Course Subject | A Course must have one or more Course Subjects A Course Subject must belong to a Course |
Instance to Student on Module | An Instance can have zero, one or many occurrences of Student on Module A Student on Module must belong to one Instance |
Module to Student on Module | A Student on Module must belong to one Module A Module can have zero, one or many Students on Module |
Module to Module Subject | A Module must have one or more Module Subjects A Module Subject must belong to a Module |
Instance to Entry Profile | An Instance can have zero or one Entry Profiles Entry Profile is compulsory during the first year of an Instance An Entry Profile must belong to one Instance |
Entry Profile to Qualifications on Entry | An Entry Profile can have zero, one or many Qualifications on Entry A Qualification on Entry must belong to one Entry Profile |
Instance to Qualifications Awarded | An Instance can have zero, one or many Qualifications Awarded A Qualification Awarded must belong to one Instance |
Instance to RAE Data | An Instance can have zero, one or many occurrences of RAE Data An RAE Data entity must belong to one Instance |
Instance to Learning Delivery Funding and Monitoring | An Instance can have zero or one Learning Delivery Funding and Monitoring entities A Learning Delivery Funding and Monitoring entity must belong to one Instance |
Contact Liaison by email or on +44 (0)1242 388 531.