• C11041 Campus Information System return date is 1 June 2012. View details
  • C12025 Staff collection coding manual version 1.3 is now live
  • C12061 KIS record coding manual v1.3 available at C12061
  • C11051 Student xml validation kit rules now available. Download kit
  • HE Business and Community Interaction Survey Publication 2010/11 to be released 24 May. Pre-order your copy now.
  • Did you know you can follow HESA on twitter? @UkHESA

Student record 2009/10

Back to C09051

Data model


Version 1.0 Produced 2008-06-16

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 relavant section of the model to view the fields associated with each entity.

Student Data Model Institution Student Instance Course Entry Profile Qualifications on Entry Qualifications Awarded Student on Module Module

Key :

One to many icon

One-to-many relationship

Optional icon

Optional participation of the entity in this relationship

Optional icon

Mandatory participation of the entity in this relationship

Relationship Definitions

Entities

Relationship

Institution to StudentAn Institution must have one or many Students
A Student must belong to an Institution

Student to InstanceA Student must have one or many Student Instances
A Student Instance must belong to a Student

Course to InstanceAn Instance must belong to one Course
A Course can have zero, one or many Student Instances

Instance to Entry ProfileAn 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 EntryAn Entry Profile can have zero, one or many Qualifications on Entry
A Qualification on Entry must belong to one Entry Profile
Instance to Qualification AwardedAn Instance can have zero, one or many Qualifications Awarded
A Qualification Awarded must belong to one Instance
Instance to Student on ModuleAn 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 ModuleA Student on Module must belong to one Module
A Module can have zero, one or many Students on Module
Contact Institutional Liaison: liaison@hesa.ac.uk, tel 01242 211144