Staff record 2014/15
Data supply
Version 1.1 Produced 2015-06-25
Contents: CORE PERSON table | CORE CONTRACT table | CORE ACTIVITY table
Three data tables below are supplied in XML and CSV format. The CORE PERSON table contains the majority of fields. Separately provided is the CORE CONTRACT table and CORE ACTIVITY table.
The tables contain the following types of field:
- Base fields from the Cyy025 submission prefixed with the appropriate entity; Person, Contract and Activity.
- Derived fields, prefixed with an X, are standard ways of grouping data. View details of the Derived field specifications.
- PERSONKEY, CONTRACTKEY and ACTIVITYKEY are unique keys within the database used to link records across tables.
The field names for each table are also available to download into Excel ready for use in creating pivot tables. The HESA website provides guidance on creating and using pivot tables.
CORE PERSON tableBack to top
Field Name | Description | Element name in XML | Length |
Person.PERSONKEY | Unique key for every person record | PERSONKEY | 13 |
Institution.RECID | Record type indicator | RECID | 5 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Person.STAFFID | Staff identifier | STAFFID | 13 |
Person.OWNSTAFFID | Institution's own staff identifier | OWNSTAFFID | 20 |
Person.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
Person.SEX | Legal Sex | SEX | 1 |
Person.NATION | Nationality | NATION | 2 |
Person.ETHNIC | Ethnicity | ETHNIC | 2 |
Person.NATIOND1 | National identity | NATIOND1 | 1 |
Person.NATIOND2 | National identity | NATIOND2 | 1 |
Person.DATEFHEI | Date appointed at current HEI | DATEFHEI | 10 |
Person.PREVEMP | Previous employment | PREVEMP | 2 |
Person.PREVHEI | Previous HEI | PREVHEI | 4 |
Person.HQHELD | Highest qualification held | HQHELD | 2 |
Person.CURACCDIS1 | Current academic discipline | CURACCDIS1 | 4 |
Person.CURACCDIS2 | Current academic discipline | CURACCDIS2 | 4 |
Person.CURACCDIS3 | Current academic discipline | CURACCDIS3 | 4 |
Person.REGBODY1 | Regulatory body | REGBODY1 | 2 |
Person.REGBODY2 | Regulatory body | REGBODY2 | 2 |
Person.ABLWELSH | Ability to teach through the medium of Welsh | ABLWELSH | 1 |
Person.DATELEFT | Date left HEI | DATELEFT | 10 |
Person.ACTLEAVE | Activity after leaving | ACTLEAVE | 2 |
Person.LOCLEAVE | Location after leaving | LOCLEAVE | 1 |
Person.DISABLE | Disability | DISABLE | 2 |
Person.CLINARD | Clinical excellence award | CLINARD | 2 |
Person.GENDERID | Gender identity | GENDERID | 2 |
Person.SEXORT | Sexual orientation | SEXORT | 2 |
Person.PARLEAVE | Parental leave | PARLEAVE | 1 |
Person.RELBLF | Religion or belief | RELBLF | 2 |
Person.ACTCHQUAL1 | Academic teaching qualification | ACTCHQUAL1 | 2 |
Person.ACTCHQUAL2 | Academic teaching qualification | ACTCHQUAL2 | 2 |
Person.ACTCHQUAL3 | Academic teaching qualification | ACTCHQUAL3 | 2 |
Person.ACTCHQUAL4 | Academic teaching qualification | ACTCHQUAL4 | 2 |
Person.ACTCHQUAL5 | Academic teaching qualification | ACTCHQUAL5 | 2 |
Person.ACTCHQUAL6 | Academic teaching qualification | ACTCHQUAL6 | 2 |
Person.ORCID | ORCID identifier | ORCID | 19 |
XPOPP01 | Staff person population at 1 December | XPOPP01 | 1 |
XPOPPA01 | Staff atypical population | XPOPPA01 | 1 |
XAGEA01 | Age at 31 August in reporting year | XAGEA01 | 2 |
XAGRPB01 | Staff age group | XAGRPB01 | 1 |
XINSTC01 | Country of institution | XINSTC01 | 1 |
XINSTG01 | Region of institution location | XINSTG01 | 1 |
XINSTID01 | Derived HESA institution identifier | XINSTID01 | 4 |
XSNAT01 | Staff nationality | XSNAT01 | 1 |
XHQHELD01 | Highest qualification held | XHQHELD01 | 1 |
Download: XML Schema for the CORE PERSON table file.
Download: Excel field names for the CORE PERSON table for use in creating pivot tables.
CORE CONTRACT tableBack to top
Field Name | Description | Element name in XML | Length |
Contract.CONTRACTKEY | Unique key for every contract record | CONTRACTKEY | 13 |
Contract.PERSONKEY | Unique key for every person record | PERSONKEY | 13 |
Institution.RECID | Record type indicator | RECID | 5 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Contract.CAMPID | Campus identifier | CAMPID | 1 |
Person.STAFFID | Staff identifier | STAFFID | 13 |
Person.OWNSTAFFID | Institution’s own staff identifier | OWNSTAFFID | 20 |
Contract.CONTID | Contract identifier | CONTID | 20 |
Contract.OWNCONTID | Institution’s own contract identifier | OWNCONTID | 20 |
Contract.TERMS | Terms of employment | TERMS | 1 |
Contract.MOEMP | Mode of employment | MOEMP | 1 |
Contract.ACEMPFUN | Academic employment function | ACEMPFUN | 1 |
Contract.LEVELS | Contract levels | LEVELS | 2 |
Contract.CONFTE | FTE during reporting period | CONFTE | 5 |
Contract.TCHWLH | Teaching through the medium of Welsh | TCHWLH | 1 |
Contract.SOBS1 | Source of basic salary | SOBS1 | 2 |
Contract.SOBS2 | Source of basic salary | SOBS2 | 2 |
Contract.SOBS3 | Source of basic salary | SOBS3 | 2 |
Contract.PSCAG | Proportion of basic salary charged against general income | PSCAG | 5 |
Contract.SPOINT | Salary point | SPOINT | 3 |
Contract.SALREF | Basic salary at reference date | SALREF | 7 |
Contract.CLINSUB1 | Clinical sub-specialty | CLINSUB1 | 4 |
Contract.CLINSUB2 | Clinical sub-specialty | CLINSUB2 | 4 |
Contract.CLINSUB3 | Clinical sub-specialty | CLINSUB3 | 4 |
Contract.NHSCON | NHS contracts | NHSCON | 1 |
Contract.NHSCONGR | NHS contract grade | NHSCONGR | 2 |
Contract.HSPEC1 | Healthcare professional specialty | HSPEC1 | 2 |
Contract.HSPEC2 | Healthcare professional specialty | HSPEC2 | 2 |
Contract.HSPEC3 | Healthcare professional specialty | HSPEC3 | 2 |
Contract.HEIJOINT | HEI joint contract | HEIJOINT | 8 |
Contract.STARTCON | Start date of contract | STARTCON | 10 |
Contract.ENDCON | End date of contract | ENDCON | 10 |
Contract.RESCON | Reason for end of contract | RESCON | 1 |
Contract.CLINICAL | Clinical status | CLINICAL | 1 |
Contract.RESAST | Research assistant | RESAST | 1 |
XACMRK01 | Academic employment marker | XACMRK01 | 1 |
XPOPC01 | Staff contract population at 1 December | XPOPC01 | 1 |
XSALR01 | Salary at reference date | XSALR01 | 7 |
XSALG01 | Salary at reference date | XSALG01 | 1 |
XPSESC01 | Staff contract session population | XPSESC01 | 1 |
XSALPNT01 | Contract salary grouping | XSALPNT01 | 2 |
XMOEMP01 | Mode of employment | XMOEMP01 | 2 |
XSOBS01 | Source of basic salary | XSOBS01 | 2 |
Download: XML Schema for the CORE CONTRACT table file.
Download: Excel field names for the CORE CONTRACT table for use in creating pivot tables.
CORE ACTIVITY tableBack to top
Field Name | Description | Element name in XML | Length |
Activity.ACTIVITYKEY | Unique key for every activity record | ACTIVITYKEY | 13 |
Activity.CONTRACTKEY | Unique key for every contract record | CONTRACTKEY | 13 |
Institution.RECID | Record type indicator | RECID | 5 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Person.STAFFID | Staff identifier | STAFFID | 13 |
Person.OWNSTAFFID | Institution's own staff identifier | OWNSTAFFID | 20 |
Contract.CONTID | Contract identifier | CONTID | 20 |
Contract.OWNCONTID | Institution's own contract identifier | OWNCONTID | 20 |
Activity.ACTSOC | Activity Standard Occupational Classification | ACTSOC | 3 |
Activity.CCENTRE | Cost centre | CCENTRE | 3 |
Activity.CCPROP | Proportion in cost centre | CCPROP | 5 |
XACTSOC01 | Activity Standard Occupational Classification (SOC2010) major grouping | XACTSOC01 | 1 |
XSFTE01 | Staff full-time equivalent activity by cost | XSFTE01 | 7 |
XSFPE01 | Staff full-person equivalent activity by cost centre | XSFPE01 | 7 |
XSAFPE01 | Staff atypical full-person equivalent by cost centre | XSAFPE01 | 7 |
Download: XML Schema for the CORE ACTIVITY table file.
Download: Excel field names for the CORE ACTIVITY table for use in creating pivot tables.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.