XSALPNT01_2.1.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Contract salary grouping | XSALPNT01 | 2.1.1 | 3 | Char |
Valid entries
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 F01 | 001 |
> = value for spine point F01 and < value for spine point F02 | 002 |
> = value for spine point F02 and < value for spine point F03 | 003 |
> = value for spine point F03 and < value for spine point F04 | 004 |
> = value for spine point F04 and < value for spine point F05 | 005 |
> = value for spine point F05 and < value for spine point F06 | 006 |
> = value for spine point F06 and < value for spine point F07 | 007 |
> = value for spine point F07 and < value for spine point F08 | 008 |
> = value for spine point F08 and < value for spine point F09 | 009 |
> = value for spine point F09 and < value for spine point F10 | 010 |
> = value for spine point F10 and < value for spine point F11 | 011 |
> = value for spine point F11 and < value for spine point F12 | 012 |
> = value for spine point F12 and < value for spine point F13 | 013 |
> = value for spine point F13 and < value for spine point F14 | 014 |
> = value for spine point F14 and < value for spine point F15 | 015 |
> = value for spine point F15 and < value for spine point F16 | 016 |
> = value for spine point F16 and < value for spine point F17 | 017 |
> = value for spine point F17 and < value for spine point F18 | 018 |
> = value for spine point F18 and < value for spine point F19 | 019 |
> = value for spine point F19 and < value for spine point F20 | 020 |
> = value for spine point F20 and < value for spine point F21 | 021 |
> = value for spine point F21 and < value for spine point F22 | 022 |
> = value for spine point F22 and < value for spine point F23 | 023 |
> = value for spine point F23 and < value for spine point F24 | 024 |
> = value for spine point F24 and < value for spine point F25 | 025 |
> = value for spine point F25 and < value for spine point F26 | 026 |
> = value for spine point F26 and < value for spine point F27 | 027 |
> = value for spine point F27 and < value for spine point F28 | 028 |
> = value for spine point F28 and < value for spine point F29 | 029 |
> = value for spine point F29 and < value for spine point F30 | 030 |
> = value for spine point F30 and < value for spine point F31 | 031 |
> = value for spine point F31 and < value for spine point F32 | 032 |
> = value for spine point F32 and < value for spine point F33 | 033 |
> = value for spine point F33 and < value for spine point F34 | 034 |
> = value for spine point F34 and < value for spine point F35 | 035 |
> = value for spine point F35 and < value for spine point F36 | 036 |
> = value for spine point F36 and < value for spine point F37 | 037 |
> = value for spine point F37 and < value for spine point F38 | 038 |
> = value for spine point F38 and < value for spine point F39 | 039 |
> = value for spine point F39 and < value for spine point F40 | 040 |
> = value for spine point F40 and < value for spine point F41 | 041 |
> = value for spine point F41 and < value for spine point F42 | 042 |
> = value for spine point F42 and < value for spine point F43 | 043 |
> = value for spine point F43 and < value for spine point F44 | 044 |
> = value for spine point F44 and < value for spine point F45 | 045 |
> = value for spine point F45 and < value for spine point F46 | 046 |
> = value for spine point F46 and < value for spine point F47 | 047 |
> = value for spine point F47 and < value for spine point F48 | 048 |
> = value for spine point F48 and < value for spine point F49 | 049 |
> = value for spine point F49 and < value for spine point F50 | 050 |
> = value for spine point F50 and < value for spine point F51 | 051 |
> = value for spine point F51 | 052 |
0 | $$$ |
Null | Null* |
(* 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
Contact Liaison by email or on +44 (0)1242 388 531.