Skip to main content

Staff record 2013/14

Back to C13025

Data supply


Version 1.0 Produced 2014-04-30

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 C13025 submission prefixed with the appropriate entity; Person, Contract and Activity.
  • Derived fields, prefixed with an X, are standard ways of grouping data.
  • 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 table

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.NATIOND_1 National identity NATIOND_1 1
Person.NATIOND_2 National identity NATIOND_2 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.CURACCDIS_1 Current academic discipline CURACCDIS_1 4
Person.CURACCDIS_2 Current academic discipline CURACCDIS_2 4
Person.REGBODY_1 Regulatory body REGBODY_1 2
Person.REGBODY_2 Regulatory body REGBODY_2 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.ECRSTAT Early career researcher status ECRSTAT 1
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.RESAST Research assistant RESAST 1
Person.ACTCHQUAL_1 Academic teaching qualification ACTCHQUAL_1 2
Person.ACTCHQUAL_2 Academic teaching qualification ACTCHQUAL_2 2
Person.ACTCHQUAL_3 Academic teaching qualification ACTCHQUAL_3 2
Person.ACTCHQUAL_4 Academic teaching qualification ACTCHQUAL_4 2
Person.ACTCHQUAL_5 Academic teaching qualification ACTCHQUAL_5 2
Person.ACTCHQUAL_6 Academic teaching qualification ACTCHQUAL_6 2
Person.REFUOA2014 REF Unit of Assessment REFUOA2014 3
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 table

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.SOBS_1 Source of basic salary SOBS_1 2
Contract.SOBS_2 Source of basic salary SOBS_2 2
Contract.SOBS_3 Source of basic salary SOBS_3 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.CLINSUB_1 Clinical sub-specialty CLINSUB_1 4
Contract.CLINSUB_2 Clinical sub-specialty CLINSUB_2 4
Contract.CLINSUB_3 Clinical sub-specialty CLINSUB_3 4
Contract.NHSCON NHS contracts NHSCON 1
Contract.NHSCONGR NHS contract grade NHSCONGR 2
Contract.HSPEC_1 Healthcare professional specialty HSPEC_1 2
Contract.HSPEC_2 Healthcare professional specialty HSPEC_2 2
Contract.HSPEC_3 Healthcare professional specialty HSPEC_3 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
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 table

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.

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