Skip to main content

Staff record 2014/15

Back to C14025

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.