Skip to main content

XINSTID01_1.29.1

Back to C17051

Field description Field abbreviation Field version Field length Field type
HESA higher education provider identifier XINSTID01 1.29.1 4 Char

Valid entries

Code Label
0001 The Open University
0002 Cranfield University
0003 Royal College of Art
0007 Bishop Grosseteste University
0009 Buckinghamshire New University
0010 The Royal Central School of Speech and Drama
0011 University of Chester
0012 Canterbury Christ Church University
0013 York St John University
0014 University of St Mark and St John
0016 Edge Hill University
0017 Falmouth University
0018 Harper Adams University
0021 The University of Winchester
0023 Liverpool Hope University
0024 University of the Arts, London
0026 University of Bedfordshire
0027 The University of Northampton
0028 Newman University
0030 Ravensbourne
0031 Roehampton University
0032 Rose Bruford College of Theatre and Performance
0033 Royal Academy of Music
0034 Royal College of Music
0035 Royal Northern College of Music
0037 Southampton Solent University
0038 University of Cumbria
0039 St Mary's University, Twickenham
0040 Leeds Trinity University
0041 Trinity Laban Conservatoire of Music and Dance
0046 University of Worcester
0047 Anglia Ruskin University
0048 Bath Spa University
0049 The University of Bolton
0050 Bournemouth University
0051 The University of Brighton
0052 Birmingham City University
0053 The University of Central Lancashire
0054 University of Gloucestershire
0056 Coventry University
0057 University of Derby
0058 The University of East London
0059 The University of Greenwich
0060 University of Hertfordshire
0061 The University of Huddersfield
0062 The University of Lincoln
0063 Kingston University
0064 Leeds Beckett University
0065 Liverpool John Moores University
0066 The Manchester Metropolitan University
0067 Middlesex University
0068 De Montfort University
0069 University of Northumbria at Newcastle
0071 The Nottingham Trent University
0072 Oxford Brookes University
0073 University of Plymouth
0074 The University of Portsmouth
0075 Sheffield Hallam University
0076 London South Bank University
0077 Staffordshire University
0078 The University of Sunderland
0079 Teesside University
0080 The University of West London
0081 University of the West of England, Bristol
0082 The University of Chichester
0083 The University of Westminster
0085 The University of Wolverhampton
0087 Glyndŵr University
0089 Cardiff Metropolitan University
0090 University of South Wales
0095 University of Abertay Dundee
0097 Glasgow School of Art
0100 Queen Margaret University, Edinburgh
0101 Royal Conservatoire of Scotland
0104 The Robert Gordon University
0105 The University of the West of Scotland
0106 Glasgow Caledonian University
0107 Edinburgh Napier University
0108 Aston University
0109 The University of Bath
0110 The University of Birmingham
0111 The University of Bradford
0112 The University of Bristol
0113 Brunel University London
0114 The University of Cambridge
0115 City, University of London
0116 University of Durham
0117 The University of East Anglia
0118 The University of Essex
0119 The University of Exeter
0120 The University of Hull
0121 Keele University
0122 The University of Kent
0123 The University of Lancaster
0124 The University of Leeds
0125 The University of Leicester
0126 The University of Liverpool
0127 Birkbeck College
0131 Goldsmiths College
0132 Imperial College of Science, Technology and Medicine
0133 Institute of Education
0134 King's College London
0135 London Business School
0137 London School of Economics and Political Science
0138 London School of Hygiene and Tropical Medicine
0139 Queen Mary University of London
0141 Royal Holloway and Bedford New College
0143 The Royal Veterinary College
0145 St. George's, University of London
0146 SOAS University of London
0149 University College London
0151 University of London (Institutes and activities)
0152 Loughborough University
0154 Newcastle University
0155 University of Nottingham
0156 The University of Oxford
0157 The University of Reading
0158 The University of Salford
0159 The University of Sheffield
0160 The University of Southampton
0161 The University of Surrey
0162 The University of Sussex
0163 The University of Warwick
0164 The University of York
0167 The University of Edinburgh
0168 The University of Glasgow
0169 The University of Strathclyde
0170 The University of Aberdeen
0171 Heriot-Watt University
0172 The University of Dundee
0173 The University of St Andrews
0174 The University of Stirling
0175 SRUC
0176 University of Wales Trinity Saint David
0177 Aberystwyth University
0178 Bangor University
0179 Cardiff University
0180 Swansea University
0184 The Queen's University of Belfast
0185 University of Ulster
0186 The University of Wales (central functions)
0188 The Institute of Cancer Research
0189 Writtle University College
0190 Norwich University of the Arts
0193 Stranmillis University College
0194 St Mary's University College
0195 Royal Agricultural University
0196 University of the Highlands and Islands
0197 The Arts University Bournemouth
0199 Conservatoire for Dance and Drama
0200 University College Birmingham
0201 Courtauld Institute of Art
0202 London Metropolitan University
0203 The University of Buckingham
0204 The University of Manchester
0205 Heythrop College
0206 University for the Creative Arts
0208 Guildhall School of Music and Drama
0209 The Liverpool Institute for Performing Arts
0210 University of Suffolk
0211 Leeds College of Art
0213 AECC University College
0214 BPP University
0215 GSM London
0216 Regent's University London
0217 The London Institute of Banking & Finance
0218 The University of Law
0219 Richmond, The American International University in London
0220 Institute of Contemporary Music Performance
0221 Moorlands College
0225 Mattersey Hall
0227 London School of Science and Technology Limited
0228 Liverpool School of Tropical Medicine
0229 The National Film and Television School
0230 Plymouth College of Art
0231 ABI College Limited
0232 BIMM Limited
0233 West London College
0234 City of London College
0235 EThames Graduate School Limited
0236 ICON College of Technology and Management
0237 Kensington College of Business
0238 London School of Business and Management
0239 Mountview Academy of Theatre Arts
0240 Nazarene Theological College
0241 Stratford College London Limited
0243 The London College UCK
0244 Arts Educational Schools
0245 Grafton College
0246 Mont Rose College of Management and Sciences
0247 Norland College
0248 ForMission Ltd
0249 UK College of Business and Computing
0250 London Churchill College Ltd
0251 The Academy of Contemporary Music
0252 Empire College London Limited
0253 East End Computing and Business College Limited
0254 Fairfield School of Business Ltd
0256 London School of Management Education
0257 London School of Theology
0258 St Mellitus College
0260 Nelson College London Ltd
0261 Northern College of Acupuncture
0262 Pearson College
0263 Royal Academy of Dance
0265 SAE Education Limited
0266 Slough Borough Council
0267 Tottenham Hotspur Foundation
0268 Access to Music Limited
0269 Academy of Live and Recorded Arts
0270 The College of Integrated Chinese Medicine
0271 The City College
0272 Met Film School Limited
0274 London Studio Centre
0275 West London College of Business and Management Sciences Limited
0276 London School of Academics Ltd
0278 Regent College
0279 London School of Business and Finance (UK) Limited
0280 Brit College
0281 Futureworks
0282 London Bridge Business Academy
0283 St Patrick's International College
0284 Chicken Shed Theatre Company
0285 All Nations Christian College
0287 Bristol Baptist College
0288 The Cambridge Theological Federation
0291 Christie's Education Limited
0292 City and Guilds of London Art School
0293 Cliff College
0294 University College of Estate Management
0295 Waverley Abbey College
0297 ICOM
0298 The Islamic College
0299 Istituto Marangoni Limited
0300 Kaplan Open Learning
0301 KLC School of Design
0302 Kogan Academy of Dramatic Arts
0306 Luther King House Educational Trust
0308 Oxford Business College
0309 Point Blank Music School
0310 Spurgeon's College
0311 St Nicholas Montessori Training Limited
0312 West Dean College
0313 Oak Hill College
0314 The Metanoia Institute
0315 The Queen's Foundation for Ecumenical Theological Education
0316 The Salvation Army
0317 Trinity College Bristol
0320 Matrix College of Counselling and Psychotherapy Ltd
0322 The Sherwood Institute
0323 AA School of Architecture
0324 Ballet West
0326 Court Theatre Training Company Ltd
0327 Regents Theological College
0329 Apex College London
0330 New College of the Humanities
0331 The Markfield Institute of Higher Education
0332 Cambridge Arts and Sciences Limited
0333 Arden University
0334 Grŵp Llandrillo Menai
0335 Grŵp NPTC Group
0336 Gower College Swansea
0337 The University College of Osteopathy
0338 London College of Business Sciences
0339 Millennium Performing Arts Ltd
0340 London College of Creative Media Limited

Dependent fields

  • none

Depend upon fields

  • UKPRN

Additional information

The UK Provider Reference Number (UKPRN) is submitted by higher education providers (HEPs) in all HESA collections. This derived field will add HESA's own internal higher education provider identifier to relevant datasets, as listed in Data Management's HEP specification for each collection, to allow linking between streams and collections. As the HEP constituency of each collection may differ, the list of valid entries listed in this field may not be applicable to all collections.

XINSTID01 is not derived for the KIS (Cyy061) collection. Therefore the list of valid entries excludes HEPs that are a constituent, for HESA, of only this collection (known as submitting a 'KIS course only'). If a KIS course only HEP is subsequently added to other collection's constituencies it will be added to the list of valid entries for XINSTID01.

The mapping to a HESA higher education provider identifier is carried out through the use of a static data lookup table (see technical specification, below), supplied by Data Management. From 2014/15 the lookup has switched from the previous UKPRN_LOOKUP table to the INSTHQPC_LOOKUP table. The values of UKPRN are taken from UK Register of Learning Providers (http://www.ukrlp.co.uk/ukrlp.first).

DEFINITION
Each HEP in the collection will submit a UKPRN. Where specified, this is mapped using a static data lookup table to a HESA higher education provider identifier and returned in XINSTID01.

Technical Specification

Where this specification exists for a collection, XINSTID01 is added against each HEP - using a value held within the HESA Data Management static data lookup table in Oracle. If no match is made between the collection's UKPRN and a UKPRN held in the static data lookup table the function will output an invalid null value.

Please note: In the following specification, the table suffix '_(Y2)AUG' refers to a year-specific reference derived from the reporting year. For 2013/14, Y1 is 13 and Y2 is 14, thus for 2013/14 the table suffix would be 14AUG, and for 2014/15 the suffix would be 15AUG, and so on.

1. Where the UKPRN value is found in the static data lookup table F_UKPRN, return F_HHESA as XINSTID01.

2. Where the UKPRN value is not found in the static data lookup table F_UKPRN, return Null as XINSTID01. This is an error, highlighting that a value in the collection's UKPRN field is not contained in the static_data lookup table F_UKPRN column. This is designed so the derived function does not fail. Nulls are to be identified at impossible values testing to flag the issue to HESA's Data Management team.

STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table consists of 8 columns:
Column Description
F_HHESA HESA higher education provider identifier
F_OPOSTCODE Full postcode of higher education provider HQ
F_XDOMUC01 County/unitary authority of higher education provider
F_GOR Region of higher education provider
F_CTRY Country of higher education provider
F_CTRY_ISO Country of higher education provider (2-letter ISO-3166-1 format)
F_UKPRN UK Provider Reference Number
F_XPROVTYPE01 Flag to identify the the type of provider e.g HEI or AP
F_XPARTCAT01 Flag to identify the groups of collections to which a provider submits data
UKPRN (as submitted in each collection) XINSTID01 (CHAR 4)
1. Found in static_data.insthqpc_lookup_(Y2)aug.F_UKPRN static_data.insthqpc_lookup_(Y2)aug.F_HHESA
2. Not found in static_data.insthqpc_lookup_(Y2)aug.F_UKPRN Null

Revision history

Date Version Notes
2018-01-02 1.29.1 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 specification.
2016-11-01 1.28.1 Valid entries updated to include providers expected to return data to HESA for the 16/17 collections.
2016-09-28 1.27.1 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.
2016-02-25 1.26.1 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.
2015-06-03 1.25.1 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.
2015-05-19 1.24.1 Valid entry 0264 removed and replaced with 0327 following clarification of the structure of the Regents English Language Centre, International Bible Institute of London.
2015-02-12 1.23.2 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.
2014-11-18 1.23.1 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.
2014-11-17 1.22.1 Valid entry label 0113 Brunel University changed to Brunel University London following name change.
2014-09-22 1.21.1 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.
2014-06-06 1.20.2 Valid entry label St Mary's University College, Twickenham changed to St Mary's University, Twickenham following name change. No change to technical specification.
2014-01-13 1.20.1 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
2013-12-05 1.19.1 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).
2013-12-04 1.18.1 The following name change has been applied: 0139 Queen Mary University of London).
2013-11-06 1.17.1 The following name change has been applied: 0217 IFS School of Finance to IFS University College).
2013-09-24 1.16.1 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).
2013-08-01 1.15.1 The following provider has been added to the valid entries: 0227 London School of Science and Technology).
2013-05-02 1.14.1 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).
2013-02-28 1.13.1 The following name changes have been applied: 0014 University of St Mark and St John and 0028 Newman University).
2013-01-31 1.12.1 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).
2012-12-20 1.11.1 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).
2012-10-19 1.10.1 Amended list to change 0175 Scottish Agricultural College to SRUC
2012-01-27 1.9.1 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.
2011-10-27 1.8.1 Amended list to change 0089 University of Wales Institute, Cardiff to Cardiff Metropolitan University
2011-09-13 1.7.1 Amended list to change name of The Royal Scottish Academy of Music and Drama (0101) to Royal Conservatoire of Scotland
2011-04-07 1.6.1 Amended list to change name of Thames Valley University (0080) to The University of West London
2011-03-18 1.5.1 Amended list to change name of UHI Millennium Institute to University of the Highlands and Islands
2011-01-31 1.4.1 Amended list to remove 0092 Trinity University College, update names of 0176 to University of Wales Trinity Saint David and 0079 to Teesside University
2010-10-01 1.3.2 yy042 added to technical specification header. No change to function
2010-07-14 1.3.1 Valid entry change of Ravensbourne College of Design and Communication changed to Ravensbourne
2010-06-23 1.2.2 Error handling clarified for circumstances where value not found in lookup table
2009-10-01 1.2.1 Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09. Location of institution list specification changed to Data management
2009-03-11 1.1.5 More comprehensive explanation of specification provided. Field type added. No change to technical specification
2008-10-15 1.1.4 Note added to clarify that field version applicable to a reporting period
2008-10-13 1.1.3 Update to text to make more generic. Valid entry reference to Data Management Institution list added, and Valid entries list removed
2008-01-28 1.1.1 Created
1994-01-01 1.1.2 Amended field type from INTEGER to CHAR in document heading, and added text to technical specification to describe table in static data schema

Contact Liaison by email or on 01242 211144.