Skip to main content


Back to C18025

Field description Field abbreviation Field version Field length Field type
Staff contract session population XPSESC01 3.3.1 1 Char

Valid entries

Code Label
0 Contract not counted within session population
1 Contract counted within session population

Dependent fields

  • none

Depend upon fields


Additional information

The HESA staff contract session population is an indicator of those contracts that are active during the HESA reporting period.

Staff returned with a dormant mode of employment (Contract.MOEMP=6) are excluded from this population.

Atypical staff (Contract.TERMS=3) are included in this population.

The HESA staff contract session population is only used in analyses of staff full-time equivalents (FTE) cost centre activity - (XSAFPE01) on the Cyy025_CC (cost centre) table - or when summing full-time equivalents (Contract.CONFTE) from the Person.Contract entity.

Technical Specification

* Note to developers: The length of Contract.CONFTE is a maximum of 5 characters (nnn.n), however the move to XML enables data to be returned with or without leading zeros or the decimal place, e.g. '000.0', '00.0', '0.0' or '0' are equally acceptable.

Contract.MOEMP (CHAR 1) Contract.ENDCON (DATE) Contract.STARTCON (DATE) Contract.CONFTE (nnn.n*) XPSESC01
1, 2, 3, 4, 5 <01-AUG-Y1 0
>= 01-AUG-Y1 or Null <=31-JUL-Y2 000.0 or null 0
Otherwise 1
>31-JUL-Y2 0
Null 000.0 or null 0
Otherwise 1
6 0

Revision history

Date Version Notes
2013-10-29 3.3.1 Technical specification amended to allow for null values in Contract.CONFTE, which can only be present if validation is switched. Such values will derive to 0 in this field
2013-05-24 3.2.2 Typo correction to Technical specification. Second row of Contract.STARTCON corrected from 31-JUL-Y2
2013-02-15 3.2.1 Update to Technical specification to account for switch to XML format of Staff record for 2012/13. Contract.MOEMP added to the Technical specification to exclude new C12025 MOEMP valid entry 6 'Dormant' from population. Default STARTCON and ENDCON date 99991231 changed to Null. Potential format differences to XML Contract.CONFTE highlighted in Technical specification
2009-03-25 3.1.2 Format amended. Colons removed from valid entries. Field type added. No change to technical specification
2005-03-29 3.1.1 For academic year 2004/05, remove TERMS clause to include atypicals
2004-11-17 2.1.1 Added TERMS clause to exclude atypicals. Otherwise include unknown dates
1994-01-01 1.1.2 Specification amended
1994-01-01 1.1.1 Created

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