Skip to main content

Back to C19052

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
XHEADCOUNT1.1.22020-09-08Technical specification has been updated to remove references to countries as this is no longer valid
XINSTID011.45.12020-09-03Providers 0416 Results Consortium Limited, 0417 JSA Education Group Ltd. and 0418 University Centre Quayside Limited have been added to the valid entries. No change to technical specification
XINSTID011.44.12020-08-25The following valid entries labels have been updated: 0403 Bellerbys Education Services Limited changed to Study Group, 0351 Leeds College of Music to Leeds Conservatoire. No change to technical specification
XINSTID011.43.12020-07-27Provider 1195 Itchen College has been added to the valid entries. No change to technical specification
XINSTID011.42.12020-06-25Provider 0415 Dyson Technical Training Limited has been added to the valid entries. No change to technical specification
XHEADCOUNT1.1.12020-06-19Created
XINSTID011.41.12020-06-16Valid entry label 0104 The Robert Gordon University changed to Robert Gordon University following a name change. No change to technical specification
XINSTC011.18.12020-03-26Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The F_XPROVTYPE01 and F_XPARTCAT01 fields has been replaced with F_XPROVCAT. These fields are not used in the derivation of XINSTC01. Copyright information has also been added to the additional information section
XINSTG013.16.12020-03-26Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The F_XPROVTYPE01 and F_XPARTCAT01 fields has been replaced with F_XPROVCAT. These fields are not used in the derivation of XINSTG01. Copyright information has also been added to the additional information section
XINSTID011.40.12020-03-18The following providers have been added to the valid entries: 0412 The Council of the Inns of Court, 0413 Navitas UK Holdings Limited and 0414 The Prince's Foundation. Technical specification has been updated to remove references to XPROVTYPE01 and XPARTCAT01, this has been replaced by XPROVCAT. The Additional Information section has been added to to state where some of our data is sourced
XINSTID011.39.12020-01-27A number of providers have been added, including all FECs that are submitting to Graduate Outcomes. Additional information has beeen amended to remove reference to the KIS collection. Technical specification has been updated to reference which lookup table is being used
XINSTID011.38.12020-01-16The following providers have been added to the valid entries: 0363 University Global Banking School Limited and 0401 Lamda Limited. No change to technical specification
XINSTID011.37.12019-12-13Valid entry label 0095 University of Abertay Dundee changed to Abertay University following a name change. No change to technical specification
XINSTID011.36.12019-10-09The following providers have been added to the valid entries: 0255 London College of Business Studies, 0321 The Minster Centre, 0353 Amity Global Education, 0354 The London School of Architecture, and 0361 Newbold College. No change to technical specification
XINSTID011.35.12019-09-19The following provider 0322 The Sherwood Institute, has been merged with 0407 The Sherwood Psychotherapy Training Institute Limited
XINSTID011.34.12019-07-25The 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
XINSTID011.33.12019-06-19The 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
XINSTID011.32.12018-11-30The following providers have been added; 0342 Christ the Redeemer College, 0343 Waltham International College Limited, 0355 London College of International Business Studies Ltd
XINSTID011.31.12018-11-05The 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
XINSTID011.30.12018-05-11The 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
XINSTID011.29.12018-01-02The 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 specification
XINSTID011.28.12016-11-01Valid entries updated to include providers expected to return data to HESA for the 16/17 collections
XINSTID011.27.12016-09-28Valid 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
XREGAG012.5.12016-09-12Technical specification revised to update references to T_OVERSEAS_LOOKUP_V8, which has been replaced with T_OVERSEAS_LOOKUP_V9 to accomodate Mayotte joining the EU, and consequently deriving to GREU in F_REGION
XINSTID011.26.12016-02-25Valid 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
XINSTID011.25.12015-06-03Valid 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
XINSTID011.24.12015-05-19Valid entry 0264 removed and replaced with 0327 following clarification of the structure of the Regents English Language Centre, International Bible Institute of London
XINSTC011.17.32015-02-12Technical 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
XINSTG013.15.32015-02-12Technical 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
XINSTID011.23.22015-02-12Technical 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
XREGAG012.4.22015-01-13Removal of guidance relating to Cyy051 valid entry GROO, as this can no longer be derived in Cyy051
XINSTID011.23.12014-11-18The 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
XINSTID011.22.12014-11-17Valid entry label 0113 Brunel University changed to Brunel University London following name change
XINSTC011.17.22014-10-16Additional 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
XINSTG013.15.22014-10-16Additional 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
XINSTID011.21.12014-09-22Valid 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
XINSTC011.17.12014-08-27Higher 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
XINSTG013.15.12014-08-27Higher education provider (HEP) name change applied to field. Subsequent long name change
XINSTID011.20.22014-06-06Valid entry label St Mary's University College, Twickenham changed to St Mary's University, Twickenham following name change. No change to technical specification
XINSTID011.20.12014-01-13Technical 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
XINSTID011.19.12013-12-05The 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
XINSTID011.18.12013-12-04The following name change has been applied: 0139 Queen Mary University of London
XINSTID011.17.12013-11-06The following name change has been applied: 0217 IFS School of Finance to IFS University College
XREGAG012.4.12013-10-31Technical specification revised to remove the TEMP processing stage, which is no longer required with the complete move of the source data tables to ISO-3166-1 and the consequent removal of old-style HESA country codes in T_OVERSEAS_LOOKUP_V8 for F_REGION. T_OVERSEAS_LOOKUP_V6 updated to T_OVERSEAS_LOOKUP_V8 to reflect the move to ISO-3166-1 codes in F_REGION and Croatia joining the EU, consequently deriving to GREU in F_REGION
XINSTC011.16.22013-09-30Table suffixes changed to be non-year specific, with explanatory sentence added
XINSTG013.14.22013-09-30Table suffixes changed to be non-year specific, with explanatory sentence added
XINSTID011.16.12013-09-24The following provider has been removed from the valid entries: 0213 AECC Chiropractic College. 0214 BPP University College has changed its name to BPP University
XINSTID011.15.12013-08-01The following provider has been added to the valid entries: 0227 London School of Science and Technology
XINSTID011.14.12013-05-02The 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
XINSTID011.13.12013-02-28The following name changes have been applied: 0014 University of St Mark and St John and 0028 Newman University
XREGAG012.3.12013-02-18Text added further clarifying the meaning of Guernsey and Jersey to Additional Information. Second row added to the Technical Specification 'TEMP' table: where the COUNTRY value is not found in T_OVERSEAS_LOOKUP_V6.F_DOMICILE_ISO, return Null as XREGAG01 as an error - rather than allowing the function to fail
XINSTC011.16.12013-02-06Updated 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
XINSTG013.14.12013-02-06Updated 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
XINSTID011.12.12013-01-31The 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
XINSTID011.11.12012-12-20Removal 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
XINSTID011.10.12012-10-19Amended list to change 0175 Scottish Agricultural College to SRUC
XINSTC011.15.22012-04-12Reference to 'Government Office Region' changed to 'Region' in INSTHQPC column description following ONS policy change. No change to function or valid entries
XINSTG013.13.22012-04-12Field 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
XREGAG012.2.12012-03-06Updated to use t_overseas_lookup_v6
XINSTC011.15.12012-02-09Updated for new version of lookup 12AUG
XINSTG013.13.12012-02-09Updated for new version of lookup table 12AUG. Reference to NSPD updated to ONSPD
XINSTID011.9.12012-01-27Switch 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
XINSTID011.8.12011-10-27Amended list to change 0089 University of Wales Institute, Cardiff to Cardiff Metropolitan University
XINSTID011.7.12011-09-13Amended list to change name of The Royal Scottish Academy of Music and Drama (0101) to Royal Conservatoire of Scotland
XINSTC011.14.22011-08-31Updated to clarify UKRPN for Cyy031
XINSTC011.14.12011-04-13Updated for new version of lookup 11AUG
XINSTG013.12.22011-04-13Updated to clarify UKRPN for Cyy031
XINSTG013.12.12011-04-13Updated for new lookup table 11AUG
XINSTID011.6.12011-04-07Amended list to change name of Thames Valley University (0080) to The University of West London
XINSTID011.5.12011-03-18Amended list to change name of UHI Millennium Institute to University of the Highlands and Islands
XINSTC011.13.12011-01-31Updated for new version of lookup 11MAY
XINSTG013.11.12011-01-31Updated for new lookup table 11MAY
XINSTID011.4.12011-01-31Amended list to remove 0092 Trinity University College, update names of 0176 to University of Wales Trinity Saint David and 0079 to Teesside University
XINSTC011.12.32010-10-01yy042 added to technical specification header. No change to function
XINSTG013.10.22010-10-01yy042 added to technical specification header. No change to function
XINSTID011.3.22010-10-01yy042 added to technical specification header. No change to function
XINSTID011.3.12010-07-14Valid entry change of Ravensbourne College of Design and Communication changed to Ravensbourne
XINSTC011.12.22010-06-24Error handling clarified for circumstances where value not found in lookup table (Note to technical specification
XINSTG013.10.12010-06-23Error handling clarified for circumstances where value not found in lookup table. Change to function required to handle
XINSTID011.2.22010-06-23Error handling clarified for circumstances where value not found in lookup table
XINSTG013.9.22010-05-07Typo corrections to Technical specification (XINSTC01 column corrected to XINSTG01 and F_CTRY to F_GOR) - No change required to function
XINSTC011.12.12010-04-12Using new lookup table - 10MAY
XINSTG013.9.12010-04-12Using new lookup table - 10MAY
XINSTC011.11.12009-11-01Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09
XINSTG013.8.12009-10-01Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09
XINSTID011.2.12009-10-01Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09. Location of institution list specification changed to Data management
XINSTC011.10.22009-07-16Removed yy018 from XUKPRN01 list as XINSTC01 not created for DLHE. Note added to Additional information for analysis of country of institution from DLHE record
XINSTG013.7.22009-07-16Removed yy018 from XUKPRN01 list as XINSTG01 not created for DLHE. Note added to Additional information for analysis of GOR from DLHE record
XINSTG013.7.12009-06-10Valid entry label D changed to Yorkshire and The Humber, G to East of England to match ONS description
XREGAG012.1.12009-04-30Removal of valid entry GROO as Cyy052.COUNTRY valid entries cannot derive to Non-European Union unknown
XREGAG011.1.12009-04-03Created
XLEVAG011.1.22009-03-12Field type added. Labels aligned to Student volume
XINSTC011.10.12009-03-11Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added
XINSTG013.6.12009-03-11Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added
XINSTID011.1.52009-03-11More comprehensive explanation of specification provided. Field type added. No change to technical specification
XINSTG013.5.32008-10-15Remove superfluous semicolons from valid entry list
XINSTID011.1.42008-10-15Note added to clarify that field version applicable to a reporting period
XINSTG013.5.22008-10-14Clarification of reporting period updates – once per reporting year using yyMAY
XINSTC011.9.22008-10-13Clarification of reporting period updates - once per reporting year using yyMAY
XINSTID011.1.32008-10-13Update to text to make more generic. Valid entry reference to Data Management Institution list added, and Valid entries list removed
XLEVAG011.1.12008-08-11Created
XINSTC011.9.12008-03-01Using new lookup table - 08 MAY
XINSTID011.1.12008-01-28Created
XINSTC011.8.12007-03-01Using new lookup table - 07MAY
XINSTC011.7.12006-03-01Using new lookup table - 06MAY
XINSTG013.3.12006-02-21Using new lookup table - May 2006. Table INSTHQPC_LOOKUP_06MAY not yet created as at 21 February 2006
XINSTC011.5.12005-07-07Using new lookup table - May 2005
XINSTC011.4.12005-01-06Using new lookup table source
XINSTG013.1.12005-01-06Using new lookup table source and different valid entry codes
XINSTC011.3.12004-05-11Code modified to use updated lookup table (R36
XINSTG012.2.12004-03-01Code modified to use updated lookup table (R36); 2004-02-25
XINSTC011.2.12003-02-11Code modified to use updated lookup table (R34
XINSTG012.1.12003-02-11Code modified to use updated lookup table (R34). Code 4 not used
XINSTG011.2.22002-05-13Specification change – new column added to lookup table
XINSTC011.1.22002-04-18Specification change; use lookup table
XINSTG011.2.12001-09-20Code modified to use updated lookup table (R32
XINSTG011.1.12000-03-16Created
XINSTC011.1.11998-10-07Created
XINSTC011.9.31994-01-01Remove superfluous semicolons from valid entry list
XINSTC011.6.11994-01-01Using new lookup table - 05NOV
XINSTC011.5.21994-01-01Code simplified as country field is now one character length
XINSTG013.5.11994-01-01Using new lookup table - May 2008. Clarified source of lookup
XINSTG013.4.11994-01-01Using new lookup table - May 2007
XINSTG013.2.11994-01-01Using new lookup table - May 2005
XINSTID011.1.21994-01-01Amended field type from INTEGER to CHAR in document heading, and added text to technical specification to describe table in static data schema

Need help?

Contact Liaison by email or on 01242 211144.