Skip to main content

XSALPNT01_2.1.1

Back to C17025

Field description Field abbreviation Field version Field length Field type
Contract salary grouping XSALPNT01 2.1.1 3 Char

Valid entries

Code Label
001 Contract salary greater than or equal to £1 and less than spine point 1
002 Contract salary greater than or equal to spine point 1 and less than spine point 2
003 Contract salary greater than or equal to spine point 2 and less than spine point 3
004 Contract salary greater than or equal to spine point 3 and less than spine point 4
005 Contract salary greater than or equal to spine point 4 and less than spine point 5
006 Contract salary greater than or equal to spine point 5 and less than spine point 6
007 Contract salary greater than or equal to spine point 6 and less than spine point 7
008 Contract salary greater than or equal to spine point 7 and less than spine point 8
009 Contract salary greater than or equal to spine point 8 and less than spine point 9
010 Contract salary greater than or equal to spine point 9 and less than spine point 10
011 Contract salary greater than or equal to spine point 10 and less than spine point 11
012 Contract salary greater than or equal to spine point 11 and less than spine point 12
013 Contract salary greater than or equal to spine point 12 and less than spine point 13
014 Contract salary greater than or equal to spine point 13 and less than spine point 14
015 Contract salary greater than or equal to spine point 14 and less than spine point 15
016 Contract salary greater than or equal to spine point 15 and less than spine point 16
017 Contract salary greater than or equal to spine point 16 and less than spine point 17
018 Contract salary greater than or equal to spine point 17 and less than spine point 18
019 Contract salary greater than or equal to spine point 18 and less than spine point 19
020 Contract salary greater than or equal to spine point 19 and less than spine point 20
021 Contract salary greater than or equal to spine point 20 and less than spine point 21
022 Contract salary greater than or equal to spine point 21 and less than spine point 22
023 Contract salary greater than or equal to spine point 22 and less than spine point 23
024 Contract salary greater than or equal to spine point 23 and less than spine point 24
025 Contract salary greater than or equal to spine point 24 and less than spine point 25
026 Contract salary greater than or equal to spine point 25 and less than spine point 26
027 Contract salary greater than or equal to spine point 26 and less than spine point 27
028 Contract salary greater than or equal to spine point 27 and less than spine point 28
029 Contract salary greater than or equal to spine point 28 and less than spine point 29
030 Contract salary greater than or equal to spine point 29 and less than spine point 30
031 Contract salary greater than or equal to spine point 30 and less than spine point 31
032 Contract salary greater than or equal to spine point 31 and less than spine point 32
033 Contract salary greater than or equal to spine point 32 and less than spine point 33
034 Contract salary greater than or equal to spine point 33 and less than spine point 34
035 Contract salary greater than or equal to spine point 34 and less than spine point 35
036 Contract salary greater than or equal to spine point 35 and less than spine point 36
037 Contract salary greater than or equal to spine point 36 and less than spine point 37
038 Contract salary greater than or equal to spine point 37 and less than spine point 38
039 Contract salary greater than or equal to spine point 38 and less than spine point 39
040 Contract salary greater than or equal to spine point 39 and less than spine point 40
041 Contract salary greater than or equal to spine point 40 and less than spine point 41
042 Contract salary greater than or equal to spine point 41 and less than spine point 42
043 Contract salary greater than or equal to spine point 42 and less than spine point 43
044 Contract salary greater than or equal to spine point 43 and less than spine point 44
045 Contract salary greater than or equal to spine point 44 and less than spine point 45
046 Contract salary greater than or equal to spine point 45 and less than spine point 46
047 Contract salary greater than or equal to spine point 46 and less than spine point 47
048 Contract salary greater than or equal to spine point 47 and less than spine point 48
049 Contract salary greater than or equal to spine point 48 and less than spine point 49
050 Contract salary greater than or equal to spine point 49 and less than spine point 50
051 Contract salary greater than or equal to spine point 50 and less than spine point 51
052 Contract salary greater than or equal to spine point 51
$$$ £0/Not applicable

Dependent fields

  • none

Depend upon fields

  • XSALR01

Additional information

This field groups salaries into bands defined by the Joint Negotiating Committee for Higher Education Staff (JNCHES) Framework Pay Spine. The salary bands are recorded in the table t_lookup_cyy025_Spine supplied by HESA analysts.

Contract salaries reported to HESA based on the reporting of the Framework Salary Spine, the Framework Clinical Spine, plus salaries not set against a nationally negotiated pay spine are included in this analysis. Where HESA is provided with both a salary point (within the Framework Pay Spine or Framework Clinical Spine) and an enhanced salary figure (e.g. London weighting), the actual enhanced salary is used (as specified within the derived field XSALR01).

Not applicable includes atypical staff for whom salary data is not required.

Note to analysts: Where Contract.SALREF is null (not applicable) this is derived to 0 (zero) in XSALR01 - as HESA's standard onward analysis removes salary returns of £0 and null. As XSALPNT01 is dependent upon XSALR01's derivation of Not applicable to 0, this is accommodated into the valid entry $$$ '£0/Not applicable'. Valid entry 001 consequently has a range of contract salary greater than or equal to £1 and less than spine point 1.

Note to developers: The t_lookup_cyy025_Spine table lists only the Fnn Framework Pay Spine entries in F_SPOINT for the creation of this field. (The Cnn Framework Clinical Spine entries, as listed in the administration specific lookup tables for XSALR01, are not required for the creation of this field).

Technical Specification

XSALR01 (Num) XSALPNT01
> = £1 and < value for spine point F01001
> = value for spine point F01 and < value for spine point F02002
> = value for spine point F02 and < value for spine point F03003
> = value for spine point F03 and < value for spine point F04004
> = value for spine point F04 and < value for spine point F05005
> = value for spine point F05 and < value for spine point F06006
> = value for spine point F06 and < value for spine point F07007
> = value for spine point F07 and < value for spine point F08008
> = value for spine point F08 and < value for spine point F09009
> = value for spine point F09 and < value for spine point F10010
> = value for spine point F10 and < value for spine point F11011
> = value for spine point F11 and < value for spine point F12012
> = value for spine point F12 and < value for spine point F13013
> = value for spine point F13 and < value for spine point F14014
> = value for spine point F14 and < value for spine point F15015
> = value for spine point F15 and < value for spine point F16016
> = value for spine point F16 and < value for spine point F17017
> = value for spine point F17 and < value for spine point F18018
> = value for spine point F18 and < value for spine point F19019
> = value for spine point F19 and < value for spine point F20020
> = value for spine point F20 and < value for spine point F21021
> = value for spine point F21 and < value for spine point F22022
> = value for spine point F22 and < value for spine point F23023
> = value for spine point F23 and < value for spine point F24024
> = value for spine point F24 and < value for spine point F25025
> = value for spine point F25 and < value for spine point F26026
> = value for spine point F26 and < value for spine point F27027
> = value for spine point F27 and < value for spine point F28028
> = value for spine point F28 and < value for spine point F29029
> = value for spine point F29 and < value for spine point F30030
> = value for spine point F30 and < value for spine point F31031
> = value for spine point F31 and < value for spine point F32032
> = value for spine point F32 and < value for spine point F33033
> = value for spine point F33 and < value for spine point F34034
> = value for spine point F34 and < value for spine point F35035
> = value for spine point F35 and < value for spine point F36036
> = value for spine point F36 and < value for spine point F37037
> = value for spine point F37 and < value for spine point F38038
> = value for spine point F38 and < value for spine point F39039
> = value for spine point F39 and < value for spine point F40040
> = value for spine point F40 and < value for spine point F41041
> = value for spine point F41 and < value for spine point F42042
> = value for spine point F42 and < value for spine point F43043
> = value for spine point F43 and < value for spine point F44044
> = value for spine point F44 and < value for spine point F45045
> = value for spine point F45 and < value for spine point F46046
> = value for spine point F46 and < value for spine point F47047
> = value for spine point F47 and < value for spine point F48048
> = value for spine point F48 and < value for spine point F49049
> = value for spine point F49 and < value for spine point F50050
> = value for spine point F50 and < value for spine point F51051
> = value for spine point F51052
0$$$
NullNull*

(* This is an error, highlighting that a value in the collection's Contract.SPOINT field is not contained in the relevant country's t_lookup_Cyy025_spoint table f_spoint column, which results in a 'Null' value in the derived field XSALR01, which is passed into XSALPNT01. This prevents the derived function for XSALPNT01 from failing. Nulls are to be identified at impossible values testing to flag the issue to HESA's Data Management team.)

Revision history

Date Version Notes
2014-02-13 2.1.1 Valid entries changed from (01 'Contract salary less than spine point 1' to 001 'Contract salary greater than or equal to £1 and less than spine point 1') and (99 'Not applicable' to $$$ '£0/Not applicable') to accommodate XSALR01 analytical requirements output. Accompanying note to analysts added to the Additional information section. Valid entry codes have been relabeled due to the change in input values. Field length changed to 3. Technical specification has been updated to match the changed XSALR01 input and valid entry output requirements. Reference to XSALR01 in Technical specification changed to Num from Char.
2013-08-05 1.3.1 Additional row added to technical specification, specifying that nulls in XSALR01 should be derived to nulls in XSALPNT01 also. This ensures that the derived function does not fail in the event of an invalid value being submitted in Contract.SPOINT.
2013-02-25 1.2.3 Additional information text '(as specified within the derived field XSALR01)' added to the end of the second paragraph.
2011-04-08 1.2.2 Note to developers added - Use only of Fnn S_POINT entries.
2010-05-04 1.2.1 Labels clarified to reflect technical specification, and technical specification for XSALPNT01 52 updated to refer to spine point F51

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