XPSESC01_3.3.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Staff contract session population | XPSESC01 | 3.3.1 | 1 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- MOEMP
- ENDCON
- STARTCON
- CONFTE
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
Contact Liaison by email or on +44 (0)1242 388 531.