Skip to main content

Staff record 2018/19 - Data model

Back to C18025

Version 1.0 Produced 2018-11-12

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

Staff record entity relationship diagram

Data model

Relationship definitions

Entities

Relationship
Institution to Person
  • An Institution must have one or many Persons
  • A Person must belong to an Institution
Person to Contract
  • A Person must have one or many Contracts
  • A Contract must belong to a Person
Contract to Activity
  • A Contract must have one or many Activities
  • An Activity must belong to a Contract
Person to Governor
  • A Person can be a Governor

Need help?

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