Skip to main content

Unistats record 2022/23

Back to C22061

Unistats record 2022/23 - Data model

Version 1.0 Produced 2022-02-25

The HESA Unistats record specification is based on a data model which defines the entities covered by the record and the relationship between these entities.

In data modelling terms, an entity is a thing about which information needs to be held. Examples in the Unistats record include the provider (institution), the course and the location.

The data model differs from the file structure required for the submission of the data, as attributes are expressed as repeating elements for efficiency. For further details, please see file structure.

Unistats record entity relationship diagram

KIS Data Model

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 KISCourseAn Institution must have one or many KISCourses
A KISCourse must belong to an Institution
Institution to LocationAn Institution must have a location entity, unless they ONLY run distance learning courses
A Location must belong to an Institution
KISCourse to HESACourseA KISCourse can have zero, one or up to 500 HESACourses
A HESACourse must belong to a KISCourse
KISCourse to ILRAimsA KISCourse can have zero, one or up to 25 ILR Aims
An ILRAim must belong to a KISCourse
KISCourse to AccreditationA KISCourse can have zero, one or up to 10 Accreditations
An Accreditation must belong to a KISCourse
Location to KISCourseA KISCourse can have multiple Locations
A Location must be used in a KISCourse

Need help?

Contact Liaison by email or on +44 (0)1242 388 531.