Skip to main content

HESA Student record 2012/13

Back to C12051

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.

Student Data Model Institution Student Learner Employment Status Employment Status Monitoring Learner Funding and Monitoring Instance Course Course Subject Entry Profile Qualifications on Entry Qualifications Awarded Student on Module Module Module Subject Learning Delivery Funding and Monitoring RAE Data

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.