HESA Collections
Derived field specifications - Revisions
The table below contains the revisions for all specifications of derived fields created by HESA. They are provided to aid in understanding the onwards usage of data. They may be subject to updating during the collection year, until the database for the collection closes.
For the full list of specifications, please see the Derived field specifications - Contents page.
Search by element:
| Field name | Version | Date | Revision notes |
|---|---|---|---|
| XINSTID01 | 1.34.1 | 2019-07-25 | (The following providers have been added; 0358 UK Business College Ltd, 0359 The Film Education Training Trust Limited. Removal of existing valid entries 0133 Institute of Education. No change to technical specification.) |
| XINSTID01 | 1.33.1 | 2019-06-19 | (The following providers have been added; 0351 Leeds College of Music, 0357 ACM Guildford Limited. Removal of existing valid entries 0251 The Academy of Contemporary Music, 0235 EThames Graduate School, 0245 Grafton College, 0340 London College of Creative Media Limited.) |
| ZREF_CONFTE | 1.1.2 | 2019-05-02 | Technical specification amended to account for members of staff that have a contract start date of 31st July YYYY |
| ZREF_CONPOP | 1.1.2 | 2019-05-02 | Technical specification amended to reference the REF census date of 2019 and RESAST has been added |
| ZREF_POP | 1.1.2 | 2019-05-02 | Technical specification has been amended to remove RESAST as it does not sit on the Person entity |
| XINSTID01 | 1.32.1 | 2018-11-30 | (The following providers have been added; 0342 Christ the Redeemer College, 0343 Waltham International College Limited, 0355 London College of International Business Studies Ltd.) |
| XINSTID01 | 1.31.1 | 2018-11-05 | The following providers have been added; 0321 The Minster Centre, 0328 London School of Commerce & IT Limited, 0352 Hartpury University and 0356 LCCM AU UK Limited. The following valid entry labels have been updated following legal name changes; 0030 Ravensboure to Ravensbourne University London, 0238 London School of Business and Management to Bloomsbury Institute. No change to technical specification |
| XSALR01 | 2.4.1 | 2018-10-26 | Updated FieldType from Char to Num |
| XINSTID01 | 1.30.1 | 2018-05-11 | The following valid entries labels have been updated following legal name changes; 0037 Southampton Solent University changed to Solent University, 0184 The Queen's University of Belfast changed to Queen's University Belfast and 0185 University of Ulster changed to Ulster University. No change to technical specification |
| XINSTID01 | 1.29.1 | 2018-01-02 | The following valid entries labels have been updated: 0032 Rose Bruford College changed to Rose Bruford College of Theatre and Performance, 0121 The University of Keele changed to Keele University, 0146 The School of Oriental and African Studies changed to SOAS University of London, 0211 Leeds College of Art changed to Leeds Arts University, 0213 AECC Chiropractic College changed to AECC University College, 0217 The London Institute of Banking and Finance changed to The London Institute of Banking & Finance, 0244 Arts Educational School changed to Arts Educational Schools, 0309 Point Blank Music College changed to Point Blank Music School, 0337 The British School of Osteopathy changed to The University College of Osteopathy, 0340 London Centre of Contemporary Music changed to London College of Creative Media Limited. No change to technical specificati |
| ZREF_CONFTE | 1.1.1 | 2018-01-01 | Created for C18025 |
| ZREF_CONPOP | 1.1.1 | 2018-01-01 | New derived field created for 2018 Staff record |
| ZREF_FTE | 1.1.1 | 2018-01-01 | New derived field for C18025 Staff record |
| ZREF_POP | 1.1.1 | 2018-01-01 | New derived field created for C18025 Staff record |
| XSALR01 | 2.3.1 | 2017-05-12 | Updated FieldType from Num to Char, to allow entries to reflect all possible values |
| XINSTID01 | 1.28.1 | 2016-11-01 | Valid entries updated to include providers expected to return data to HESA for the 16/17 collections |
| XINSTID01 | 1.27.1 | 2016-09-28 | Valid entries updated to include Alternative providers (APs) contracted to return data to HESA for the 15/16 collections: ranges 0214 - 0227, 0231 - 0333 and 0338 - 0339. Removal of existing valid entry 0133 Institute of Education, which has merged with 0149 University College London. Label updates to existing valid entries 0145 St. George's, University of London; 0154 Newcastle University; 0189 Writtle University College; and 0210 University of Suffolk. No change to technical specification |
| XSALR01 | 2.2.1 | 2016-03-17 | Technical specification updated following the location change of the Pay_scales_lookup.xlsx |
| XSFTE01 | 2.2.1 | 2016-03-17 | Technical specification updated to increase in the maximum number of occurrences of the Contract.Activity entity to six) |
| XSOBS01 | 2.3.1 | 2016-03-17 | The label for valid entry 02 has changed to 'Partly financed by the higher education provider' to re-align with the terminology used in the Finance record |
| XINSTID01 | 1.26.1 | 2016-02-25 | Valid entries aligned with those providers contractually agreed to return data to HESA for the 15/16 collections, which currently excludes Alternative providers (APs). No change to technical specification |
| XINSTID01 | 1.25.1 | 2015-06-03 | Valid entry label 0010 Royal Central School of Speech and Drama changed to The Royal Central School of Speech and Drama following a name change. No change to technical specification |
| XINSTID01 | 1.24.1 | 2015-05-19 | Valid entry 0264 removed and replaced with 0327 following clarification of the structure of the Regents English Language Centre, International Bible Institute of London |
| XINSTC01 | 1.17.3 | 2015-02-12 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTC01 |
| XINSTG01 | 3.15.3 | 2015-02-12 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTG01 |
| XINSTID01 | 1.23.2 | 2015-02-12 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTID01. Additional information text updated to refer to the change in lookup table use for 2014/15 |
| XACMRK01 | 2.1.2 | 2015-01-15 | Additional information amended to clarify that a null return can only be submitted for Contract.ACEMPFUN where Standard Occupational Classification (SOC2010) in all associated Activity entities is coded outside of major groups 1, 2 or 3. References to higher education institution (HEI) have been replaced with higher education provider (HEP). Reference to institution (as a short-hand for higher education institution) has been changed to provider. The change enables HESA to refer collectively to both publicly funded higher education institutions and privately funded alternative providers within its constituency |
| XHQHELD01 | 1.2.2 | 2015-01-15 | Additional information amended to clarify that a null return can only be submitted for Person.HQHELD where no Standard Occupational Classification (SOC2010) in any associated Activity entity is coded in major groups 1, 2 or 3 |
| XMOEMP01 | 2.1.2 | 2015-01-15 | References to higher education institution (HEI) have been replaced with higher education provider (HEP). Reference to institution (as a short-hand for higher education institution) has been changed to provider. The change enables HESA to refer collectively to both publicly funded higher education institutions and privately funded alternative providers within its constituency |
| XSALG01 | 5.1.2 | 2015-01-15 | Additional information amended as the lower limit of £1 to £7000 is no longer indicative of values below the national minimum wage |
| XSNAT01 | 1.5.2 | 2015-01-15 | Additional information to clarify that European Union countries in this context are the Member States of the European Union, but not their outermost regions, overseas countries or territories. These are grouped under the 'Other Non-European Union countries' category |
| XSOBS01 | 2.2.1 | 2015-01-15 | The labels for valid entries 01 and 02 have changed to 'Wholly general financed by the higher education provider' and 'Partly general financed by the higher education provider' in line with the references to higher education institution (HEI) being replaced with higher education provider (HEP) and references to institution (as a short-hand for higher education institution) being changed to provider. The change enables HESA to refer collectively to both publicly funded higher education institutions and privately funded alternative providers within its constituency |
| XINSTID01 | 1.23.1 | 2014-11-18 | The following providers have been added to the valid entries: 0229 The National Film and Television School and 0230 Plymouth College of Art, plus providers constituent of the AP student collection. Technical specification amended to replace the lookup table used to obtain the HESA identifier value with static_data.insthqpc_lookup_(Y2)aug |
| XINSTID01 | 1.22.1 | 2014-11-17 | Valid entry label 0113 Brunel University changed to Brunel University London following name change |
| XAGEA01 | 1.6.1 | 2014-10-16 | Technical specification amended to allow for the use of this field in the Cyy054 AP student record |
| XINSTC01 | 1.17.2 | 2014-10-16 | Additional information section amended to allow for the use of this field in the Cyy054 AP student record. Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly in light of changes made to the contents |
| XINSTG01 | 3.15.2 | 2014-10-16 | Additional information section amended to allow for the use of this field in the Cyy054 AP student record. Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly in light of changes made to the contents |
| XSOBS01 | 2.1.1 | 2014-10-16 | New valid entry $$ 'Not applicable/Not known added', to derive null Contract.SOBS values. Technical specification and Additional information updated accordingly |
| XINSTID01 | 1.21.1 | 2014-09-22 | Valid entry label 0064 Leeds Metropolitan University changed to Leeds Beckett University following name change. References to the static data lookup table 'static_data.ukprn_lookup_2013_14' have been made generic with regards to the year reference it uses, with associated guidance added to explain the naming protocol. Higher education provider (HEP) name change applied to field. Subsequent long name change |
| XINSTC01 | 1.17.1 | 2014-08-27 | Higher education provider (HEP) name change applied to field. Subsequent long name change. Valid entries changed to 'England', 'Wales', 'Scotland' and 'Northern Ireland' from 'English institution', 'Scottish institution' etc |
| XINSTG01 | 3.15.1 | 2014-08-27 | Higher education provider (HEP) name change applied to field. Subsequent long name change |
| XSAFPE01 | 2.1.3 | 2014-07-31 | Correction of references to CONKEY and PERKEY fields to ContractKEY and PersonKEY respectively. These field names changed for C13025. No change to function) |
| XSFPE01 | 2.1.3 | 2014-07-31 | Correction of references to CONKEY and PERKEY fields to ContractKEY and PersonKEY respectively. These field names changed for C13025. No change to function) |
| XSFTE01 | 2.1.2 | 2014-07-31 | Correction of references to CONKEY to ContractKEY. This field name changed for C13025. No change to function) |
| XINSTID01 | 1.20.2 | 2014-06-06 | Valid entry label St Mary's University College, Twickenham changed to St Mary's University, Twickenham following name change. No change to technical specification |
| XSOBS01 | 1.1.1 | 2014-02-17 | Created |
| XSALPNT01 | 2.1.1 | 2014-02-13 | 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 |
| XACMRK01 | 2.1.1 | 2014-01-29 | To meet analytical requirement; Valid entry 9 'Not applicable' removed and Null values from ACEMPFUN grouped with 'Not an academic contract' to create 'Not an academic contract/Not applicable'. Valid entry 0 relabelled to 2 due to the change in input values. Technical specification updated, removing final row ACEMPFUN Null from valid entry 9 and adding ACEMPFUN Null to valid entry 2. Changed to version 2.1.1 due to valid entry changes |
| XSALG01 | 5.1.1 | 2014-01-29 | Valid entries changed from (1 '£7000 and under' to 01 '£1 to £7000') and ($ 'Data not required' 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 relabelled due to the change in input values. Field length changed to 2. 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 and leading zeros removed from the XSALR01 values |
| XSALR01 | 2.1.1 | 2014-01-29 | Valid entry XXXXXXX 'Not applicable' removed from the specification. Field type changed to Numeric from Character. Technical specification updated, deriving Contract.SALREF to 0 from XXXXXXX. Accompanying note to analysts added to the Additional information section. Reference in Technical specification to lookup table changed from specific collection to stream 'Cyy025' reference. Change to version 2.1.1 due to valid entry changes |
| XINSTID01 | 1.20.1 | 2014-01-13 | Technical specification updated referencing static_data.ukprn_lookup_2013_14 for 2013/14 XINSTID01. Update to legal names, removing 'The' from University of 0069 Northumbria at Newcastle, 0046 University of Worcester, 0155 University of Nottingham, 0154 University of Newcastle-upon-Tyne and 0073 University of Plymouth. Name change of 0090 University of Glamorgan to University of South Wales. Removal of the following KIS only subscribers from XINSTID01; 0216 Regent's University London, 0220 Institute of Contemporary Music Performance, 0221 Moorlands College, 0223 Redcliffe College, 0225 Mattersey Hall and 0227 London School of Science and Technology - with explanatory note added to the Additional information section |
| XINSTID01 | 1.19.1 | 2013-12-05 | The following provider has been removed from the valid entries: 0086 The University of Wales Newport. The following provider has been added to the list of valid entries: 0228 Liverpool School of Tropical Medicine |
| XINSTID01 | 1.18.1 | 2013-12-04 | The following name change has been applied: 0139 Queen Mary University of London |
| XINSTID01 | 1.17.1 | 2013-11-06 | The following name change has been applied: 0217 IFS School of Finance to IFS University College |
| XSNAT01 | 1.5.1 | 2013-10-30 | Technical specification amended to derive Croatia (HR) to valid entry 2 'European Union countries', following that country joining the EU |
| XPOPC01 | 2.4.1 | 2013-10-29 | 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 |
| XPSESC01 | 3.3.1 | 2013-10-29 | 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 |
| XINSTC01 | 1.16.2 | 2013-09-30 | Table suffixes changed to be non-year specific, with explanatory sentence added |
| XINSTG01 | 3.14.2 | 2013-09-30 | Table suffixes changed to be non-year specific, with explanatory sentence added |
| XINSTID01 | 1.16.1 | 2013-09-24 | The following provider has been removed from the valid entries: 0213 AECC Chiropractic College. 0214 BPP University College has changed its name to BPP University |
| XSALPNT01 | 1.3.1 | 2013-08-05 | 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 |
| XINSTID01 | 1.15.1 | 2013-08-01 | The following provider has been added to the valid entries: 0227 London School of Science and Technology |
| XPSESC01 | 3.2.2 | 2013-05-24 | Typo correction to Technical specification. Second row of Contract.STARTCON corrected from <=31-JUL-Y2 to >31-JUL-Y2 |
| XINSTID01 | 1.14.1 | 2013-05-02 | The following name changes have been applied: 0195 Royal Agricultural College changed to Royal Agricultural University. The following providers have been added to the valid entries: 0213 AECC Chiropractic College; 0214 BPP University College; 0215 GSM London; 0216 Regent's University London; 0217 IFS School of Finance; 0218 The University of Law; 0219 Richmond, The American International University in London; 0220 Institute of Contemporary Music Performance; 0221 Moorlands College; 0223 Redcliffe College; 0225 Mattersey Hall |
| XSAFPE01 | 2.1.2 | 2013-04-18 | Amendment of the text in the technical specification to align the specification of the XSAFPE01 denominator with that used in the function. No change to function) |
| XSFPE01 | 2.1.2 | 2013-04-18 | Amendment of the text in the technical specification to align the specification of the XSFPE01 denominator with that used in the function. No change to function) |
| XACMRK01 | 1.1.1 | 2013-03-01 | Created for C12025 |
| XSAFPE01 | 2.1.1 | 2013-03-01 | Separation of XSAFPE01 from previous XSFTE01_XSFPE01_XSAFPE01 combined field specification. Technical specification revised for creation using C12025 XML structure and fields) |
| XSFPE01 | 2.1.1 | 2013-03-01 | Separation of XSFPE01 from previous XSFTE01_XSFPE01_XSAFPE01 combined field specification. Technical specification revised for creation using C12025 XML structure and fields) |
| XSFTE01 | 2.1.1 | 2013-03-01 | Separation of XSFTE01 from previous XSFTE01_XSFPE01_XSAFPE01 combined field specification. Technical specification revised for creation using C12025 XML structure and fields. Requirement for F_ACTNUM removed due to repeating entity structure |
| XACTSOC01 | 1.1.1 | 2013-02-28 | Created for Staff C12025. Based on DLHE XSOCD02 - and reflecting the switch to XML for use of C12025 Activity.ACTSOC in the C12025_CC table |
| XINSTID01 | 1.13.1 | 2013-02-28 | The following name changes have been applied: 0014 University of St Mark and St John and 0028 Newman University |
| XSALPNT01 | 1.2.3 | 2013-02-25 | Additional information text '(as specified within the derived field XSALR01)' added to the end of the second paragraph |
| XSALR01 | 1.12.1 | 2013-02-22 | Updated for use with the C12025 XML structure. Additional information and Technical specification text updated accordingly. Default SALREF XXXXXXX and SALPOINT XXX changed to Null. Lookup tables updated for C12025. Step 4. added to the Technical specification: Where Contract.SALPOINT not found in t_lookup_Cyy025_spoint table return Null |
| XMOEMP01 | 2.1.1 | 2013-02-15 | Valid entry 03 Dormant added to field. Technical specification updated accordingly using Contract.MOEMP=6. Additional information definition of dormant added |
| XPSESC01 | 3.2.1 | 2013-02-15 | 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 |
| XPOPP01 | 1.2.1 | 2013-02-14 | Update to Technical specification to account for switch to XML format of Staff record for 2012/13. Reference to contracts table changed to Person.Contract entity |
| XPOPPA01 | 1.2.1 | 2013-02-14 | Update to Technical specification to account for switch to XML format of Staff record for 2012/13. Reference to contracts table changed to Person.Contract entity and Contract.MOEMP added to the Technical specification to exclude new C12025 MOEMP valid entry 6 'Dormant' from population |
| XSNAT01 | 1.4.3 | 2013-02-14 | Minor text edits to the Technical specification (reference to Person.Nation) and Additional information to reflect the switch to XML format of Staff record for 2012/13 |
| XPOPC01 | 2.3.1 | 2013-02-11 | 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 |
| XHQHELD01 | 1.2.1 | 2013-02-06 | Updated for use with the C12025 XML structure. Technical specification updated to reflect the change in Person.HQHELD valid entries - removal of XX and addition of Null. Additional information section updated to reflect these changes |
| XINSTC01 | 1.16.1 | 2013-02-06 | Updated for new version of lookup 13AUG. Reference to XUKPRN01 in yy025 changed to UKRPN, as this field is now collected rather than derived. Second row added to Technical specification: Where the UKPRN value is not found in INSTHQPC_LOOKUP_13AUG F_UKPRN column, return Null as XINSTC01 as an error - rather than allowing the function to fail |
| XINSTG01 | 3.14.1 | 2013-02-06 | Updated for new version of lookup 13AUG. Reference to XUKPRN01 in yy025 changed to UKRPN, as this field is now collected rather than derived. Second row added to Technical specification: Where the UKPRN value is not found in INSTHQPC_LOOKUP_yyAUG F_UKPRN column, return Null as XINSTG01 as an error - rather than allowing the function to fail |
| XAGRPB01 | 1.1.5 | 2013-02-05 | Label change to valid entry C 'Age unknown' to 'Unknown age'. This is to bring into line with XAGEA01 labelling of valid entry 99 'Unknown age'. No impact on publications where label 'Unknown' used within Age group. Minor revision to technical specification table text for clarity e.g. '01-20' changed to '01 to 20 (inclusive)'. No change to function |
| XINSTID01 | 1.12.1 | 2013-01-31 | The following name changes have been applied: 0007 Bishop Grosseteste University; 0017 Falmouth University; 0018 Harper Adams University; 0040 Leeds Trinity University; 0190 Norwich University of the Arts; 0197 The Arts University Bournemouth. Reference to independent higher education provider changed to alternative provider |
| XAGEA01 | 1.5.1 | 2013-01-17 | Technical specification amended to account for switch to XML format in Staff record for 2012/13. Additional information BIRTHDTE example format changed to ISO 8601 yyyy-mm-dd |
| XINSTID01 | 1.11.1 | 2012-12-20 | Removal of Swansea Metropolitan University (0091) and The School of Pharmacy (0147) for 2012/13 and Switch to Static_data.UKPRN_lookup_v3 to allow for the inclusion of the additional independent higher education providers (IHEPS) - which are yet to be confirmed |
| XINSTID01 | 1.10.1 | 2012-10-19 | Amended list to change 0175 Scottish Agricultural College to SRUC |
| XINSTC01 | 1.15.2 | 2012-04-12 | Reference to 'Government Office Region' changed to 'Region' in INSTHQPC column description following ONS policy change. No change to function or valid entries |
| XINSTG01 | 3.13.2 | 2012-04-12 | Field description changed to 'Region of institution location' and reference to 'Government Office Region' changed to 'Region' following ONS policy change. No change to function or valid entries |
| XSALR01 | 1.11.1 | 2012-02-27 | Updated to refer to 11025 lookup tables |
| XINSTC01 | 1.15.1 | 2012-02-09 | Updated for new version of lookup 12AUG |
| XINSTG01 | 3.13.1 | 2012-02-09 | Updated for new version of lookup table 12AUG. Reference to NSPD updated to ONSPD |
| XAGRPB01 | 1.1.4 | 2012-02-06 | Additional information text, second paragraph updated for clarity |
| XINSTID01 | 1.9.1 | 2012-01-27 | Switch to Static_data.UKPRN_lookup_v2 for valid entries. This includes the new HE institution Leeds College of Art (0211). (0096) Edinburgh College of Art and (0207) Leeds College of Music removed. Technical specification updated accordingly. Second row added to Technical specification: Where the INSTID value is not found in static_data lookup table f_instid, return Null as XUKPRN01. This to match XUKPRN01 technical specification error handling |
| XINSTID01 | 1.8.1 | 2011-10-27 | Amended list to change 0089 University of Wales Institute, Cardiff to Cardiff Metropolitan University |
| XINSTID01 | 1.7.1 | 2011-09-13 | Amended list to change name of The Royal Scottish Academy of Music and Drama (0101) to Royal Conservatoire of Scotland |
| XINSTC01 | 1.14.2 | 2011-08-31 | Updated to clarify UKRPN for Cyy031 |
| XPOPC01 | 2.2.1 | 2011-08-30 | Added row to technical specification to handle where Terms = otherwise, Startcon is within date criteria, but Endcon is earlier than date criteria |
| XINSTC01 | 1.14.1 | 2011-04-13 | Updated for new version of lookup 11AUG |
| XINSTG01 | 3.12.2 | 2011-04-13 | Updated to clarify UKRPN for Cyy031 |
| XINSTG01 | 3.12.1 | 2011-04-13 | Updated for new lookup table 11AUG |
| XSALPNT01 | 1.2.2 | 2011-04-08 | Note to developers added - Use only of Fnn S_POINT entries |
| XINSTID01 | 1.6.1 | 2011-04-07 | Amended list to change name of Thames Valley University (0080) to The University of West London |
| XINSTID01 | 1.5.1 | 2011-03-18 | Amended list to change name of UHI Millennium Institute to University of the Highlands and Islands |
| XAGRPB01 | 1.1.3 | 2011-02-22 | Valid entry 1 label changed to '20 years and under' from 'Under 21 years' |
| XSALR01 | 1.10.1 | 2011-02-22 | Updated to refer to 10025 lookup tables. Additional information text, regarding location of tables, added |
| XSNAT01 | 1.4.2 | 2011-02-21 | Minor text edit to Valid entry 1. Change (incl. Guernsey, Jersey & the Isle of Man) to (including Guernsey, Jersey and the Isle of Man). Nation text from 4 to CHAR 2 |
| XHQHELD01 | 1.1.1 | 2011-02-18 | Created |
| XMOEMP01 | 1.1.1 | 2011-02-18 | Created |
| XSALG01 | 4.1.1 | 2011-02-16 | Replaced XSALG01 valid entry M with two new values, N and P, to reflect the new upper limit of £150000 |
| XAGEA01 | 1.4.1 | 2011-01-31 | Technical specifcation amended to account for potential future value in Student record |
| XINSTC01 | 1.13.1 | 2011-01-31 | Updated for new version of lookup 11MAY |
| XINSTG01 | 3.11.1 | 2011-01-31 | Updated for new lookup table 11MAY |
| XINSTID01 | 1.4.1 | 2011-01-31 | Amended list to remove 0092 Trinity University College, update names of 0176 to University of Wales Trinity Saint David and 0079 to Teesside University |
| XAGEA01 | 1.3.4 | 2010-11-08 | Additional information for valid entry 99 added where validation is switched. No change to function |
| XINSTC01 | 1.12.3 | 2010-10-01 | yy042 added to technical specification header. No change to function |
| XINSTG01 | 3.10.2 | 2010-10-01 | yy042 added to technical specification header. No change to function |
| XINSTID01 | 1.3.2 | 2010-10-01 | yy042 added to technical specification header. No change to function |
| XINSTID01 | 1.3.1 | 2010-07-14 | Valid entry change of Ravensbourne College of Design and Communication changed to Ravensbourne |
| XINSTC01 | 1.12.2 | 2010-06-24 | Error handling clarified for circumstances where value not found in lookup table (Note to technical specification) |
| XINSTG01 | 3.10.1 | 2010-06-23 | Error handling clarified for circumstances where value not found in lookup table. Change to function required to handle |
| XINSTID01 | 1.2.2 | 2010-06-23 | Error handling clarified for circumstances where value not found in lookup table |
| XINSTG01 | 3.9.2 | 2010-05-07 | Typo corrections to Technical specification (XINSTC01 column corrected to XINSTG01 and F_CTRY to F_GOR) - No change required to function |
| XSALPNT01 | 1.2.1 | 2010-05-04 | Labels clarified to reflect technical specification, and technical specification for XSALPNT01 52 updated to refer to spine point F51 |
| XSALG01 | 3.1.1 | 2010-04-13 | Amended values for XSALG01 valid entries 1 and 2 to reflect lower limit of £7000 |
| XSALPNT01 | 1.1.1 | 2010-04-13 | Created |
| XSALR01 | 1.9.1 | 2010-04-13 | Updated to refer to 09025 lookup tables |
| XINSTC01 | 1.12.1 | 2010-04-12 | Using new lookup table - 10MAY) |
| XINSTG01 | 3.9.1 | 2010-04-12 | Using new lookup table - 10MAY |
| XAGEA01 | 1.3.3 | 2010-04-09 | Minor text amendments. Valid entries listed in full. No change to function |
| XINSTC01 | 1.11.1 | 2009-11-01 | Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09 |
| XINSTG01 | 3.8.1 | 2009-10-01 | Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09 |
| XINSTID01 | 1.2.1 | 2009-10-01 | Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09. Location of institution list specification changed to Data management |
| XSAFPE01 | 1.1.2 | 2009-07-23 | Removal of text referring to creation of CHECKSUM as this is not part of the derive process |
| XSFPE01 | 1.1.2 | 2009-07-23 | Removal of text referring to creation of CHECKSUM as this is not part of the derive process |
| XSFTE01 | 1.1.2 | 2009-07-23 | Removal of text referring to creation of CHECKSUM as this is not part of the derive process |
| XINSTC01 | 1.10.2 | 2009-07-16 | Removed yy018 from XUKPRN01 list as XINSTC01 not created for DLHE. Note added to Additional information for analysis of country of institution from DLHE record |
| XINSTG01 | 3.7.2 | 2009-07-16 | Removed yy018 from XUKPRN01 list as XINSTG01 not created for DLHE. Note added to Additional information for analysis of GOR from DLHE record |
| XINSTG01 | 3.7.1 | 2009-06-10 | Valid entry label D changed to Yorkshire and The Humber, G to East of England to match ONS description |
| XSALR01 | 1.8.1 | 2009-05-27 | Addition of 'or is completed' for SPOINT in Technical specification as HEIs may be required in some circumstances to return both SALREF and SPOINT fields from 2008/09 |
| XPOPC01 | 2.1.2 | 2009-03-25 | Format amended. Colons removed from valid entries. Field type added to. No change to technical specification |
| XPSESC01 | 3.1.2 | 2009-03-25 | Format amended. Colons removed from valid entries. Field type added. No change to technical specification |
| XSALG01 | 2.1.1 | 2009-03-25 | Valid entries and technical specification updated with additional breakdown of salaries over £70000. Code F no longer used and replaced with codes G-M |
| XSNAT01 | 1.4.1 | 2009-03-25 | NATION input values changed to ISO codes. Channel Islands changed to Guernsey and Jersey and analysis additional information updated. Colons removed from valid entries. Field type added |
| XAGEA01 | 1.3.2 | 2009-03-17 | Format amended. Colons removed from valid entries. Field type added |
| XAGRPB01 | 1.1.2 | 2009-03-12 | Colons removed from valid entries. Field type added. No change to technical specification |
| XINSTC01 | 1.10.1 | 2009-03-11 | Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added |
| XINSTG01 | 3.6.1 | 2009-03-11 | Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added |
| XINSTID01 | 1.1.5 | 2009-03-11 | More comprehensive explanation of specification provided. Field type added. No change to technical specification |
| XPOPP01 | 1.1.2 | 2009-03-11 | Removed colons following valid entry codes. Field type added. No change to technical specification |
| XPOPPA01 | 1.1.2 | 2009-03-11 | Removed colons following valid entry codes. Field type added. No change to technical specification |
| XSALR01 | 1.7.1 | 2009-03-05 | Updated to refer to 08025 lookup tables |
| XINSTG01 | 3.5.3 | 2008-10-15 | Remove superfluous semicolons from valid entry list |
| XINSTID01 | 1.1.4 | 2008-10-15 | Note added to clarify that field version applicable to a reporting period |
| XINSTG01 | 3.5.2 | 2008-10-14 | Clarification of reporting period updates – once per reporting year using yyMAY |
| XINSTC01 | 1.9.2 | 2008-10-13 | Clarification of reporting period updates - once per reporting year using yyMAY |
| XINSTID01 | 1.1.3 | 2008-10-13 | Update to text to make more generic. Valid entry reference to Data Management Institution list added, and Valid entries list removed |
| XAGRPB01 | 1.1.1 | 2008-03-12 | Created |
| XSALR01 | 1.6.1 | 2008-03-05 | Updated to refer to 07025 lookup tables |
| XINSTC01 | 1.9.1 | 2008-03-01 | Using new lookup table - 08 MAY |
| XINSTID01 | 1.1.1 | 2008-01-28 | Created |
| XSALR01 | 1.5.1 | 2007-08-07 | New format input tables to accommodate different values for Scotland, Wales, Northern Ireland and England |
| XSAFPE01 | 1.1.1 | 2007-07-17 | Created |
| XSFPE01 | 1.1.1 | 2007-07-17 | Created |
| XSFTE01 | 1.1.1 | 2007-07-17 | Created |
| XINSTC01 | 1.8.1 | 2007-03-01 | Using new lookup table - 07MAY |
| XAGEA01 | 1.2.1 | 2007-01-12 | Amended spec to deal with new default code 01/01/1901 |
| XINSTC01 | 1.7.1 | 2006-03-01 | Using new lookup table - 06MAY |
| XINSTG01 | 3.3.1 | 2006-02-21 | Using new lookup table - May 2006. Table INSTHQPC_LOOKUP_06MAY not yet created as at 21 February 2006 |
| XSALR01 | 1.3.1 | 2006-02-21 | Use updated lookup table for 05025. Note that table not yet created - and name not confirmed |
| XINSTC01 | 1.5.1 | 2005-07-07 | Using new lookup table - May 2005 |
| XPSESC01 | 3.1.1 | 2005-03-29 | For academic year 2004/05, remove TERMS clause to include atypicals |
| XINSTC01 | 1.4.1 | 2005-01-06 | Using new lookup table source |
| XINSTG01 | 3.1.1 | 2005-01-06 | Using new lookup table source and different valid entry codes |
| XPSESC01 | 2.1.1 | 2004-11-17 | Added TERMS clause to exclude atypicals. Otherwise include unknown dates |
| XPOPPA01 | 1.1.1 | 2004-05-29 | Created |
| XPOPC01 | 2.1.1 | 2004-05-28 | |
| XPOPP01 | 1.1.1 | 2004-05-28 | Created |
| XSALR01 | 1.1.1 | 2004-05-28 | Field created |
| XINSTC01 | 1.3.1 | 2004-05-11 | Code modified to use updated lookup table (R36 |
| XSALG01 | 1.1.1 | 2004-03-19 | Created |
| XINSTG01 | 2.2.1 | 2004-03-01 | Code modified to use updated lookup table (R36); 2004-02-25 |
| XINSTC01 | 1.2.1 | 2003-02-11 | Code modified to use updated lookup table (R34 |
| XINSTG01 | 2.1.1 | 2003-02-11 | Code modified to use updated lookup table (R34). Code 4 not used |
| XINSTG01 | 1.2.2 | 2002-05-13 | Specification change – new column added to lookup table |
| XAGEA01 | 1.1.2 | 2002-04-30 | Clarification of reporting year in technical spec |
| XINSTC01 | 1.1.2 | 2002-04-18 | Specification change; use lookup table |
| XINSTG01 | 1.2.1 | 2001-09-20 | Code modified to use updated lookup table (R32 |
| XINSTG01 | 1.1.1 | 2000-03-16 | Created |
| XSNAT01 | 1.1.1 | 1999-10-01 | Created |
| XAGEA01 | 1.1.1 | 1998-10-26 | Created |
| XINSTC01 | 1.1.1 | 1998-10-07 | Created |
| XAGEA01 | 1.3.1 | 1994-01-01 | Amended to deal with changed reporting of unknown birth date between student and staff streams |
| XINSTC01 | 1.9.3 | 1994-01-01 | Remove superfluous semicolons from valid entry list |
| XINSTC01 | 1.6.1 | 1994-01-01 | Using new lookup table - 05NOV |
| XINSTC01 | 1.5.2 | 1994-01-01 | Code simplified as country field is now one character length |
| XINSTG01 | 3.5.1 | 1994-01-01 | Using new lookup table - May 2008. Clarified source of lookup |
| XINSTG01 | 3.4.1 | 1994-01-01 | Using new lookup table - May 2007 |
| XINSTG01 | 3.2.1 | 1994-01-01 | Using new lookup table - May 2005 |
| XINSTID01 | 1.1.2 | 1994-01-01 | Amended field type from INTEGER to CHAR in document heading, and added text to technical specification to describe table in static data schema |
| XPSESC01 | 1.1.2 | 1994-01-01 | Specification amended |
| XPSESC01 | 1.1.1 | 1994-01-01 | Created |
| XSALR01 | 1.4.1 | 1994-01-01 | Use updated lookup table for 06025 |
| XSALR01 | 1.2.1 | 1994-01-01 | Use updated lookup table |
| XSNAT01 | 1.3.2 | 1994-01-01 | Text correction changing reference from NISR to Staff PERSON table |
| XSNAT01 | 1.3.1 | 1994-01-01 | Removed EU accession states as category |
| XSNAT01 | 1.2.1 | 1994-01-01 | Changed to update EU accession states as at 1 December 2005 |
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.