ZSTUPROV_1.1.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
UKPRN of Provider of further study | ZSTUPROV | 1.1.1 | 8 | Char |
Valid entries
Code | Label |
---|---|
10007773 | The Open University |
10007822 | Cranfield University |
10007777 | Royal College of Art |
10007811 | Bishop Grosseteste University |
10000975 | Buckinghamshire New University |
10007816 | The Royal Central School of Speech and Drama |
10007848 | University of Chester |
10001143 | Canterbury Christ Church University |
10007713 | York St John University |
10037449 | University of St Mark and St John |
10007823 | Edge Hill University |
10008640 | Falmouth University |
10040812 | Harper Adams University |
10003614 | The University of Winchester |
10003956 | Liverpool Hope University |
10007162 | University of the Arts, London |
10007152 | University of Bedfordshire |
10007138 | The University of Northampton |
10007832 | Newman University |
10005389 | Ravensbourne University London |
10007776 | Roehampton University |
10005523 | Rose Bruford College of Theatre and Performance |
10007835 | Royal Academy of Music |
10007778 | Royal College of Music |
10007837 | Royal Northern College of Music |
10006022 | Solent University |
10007842 | University of Cumbria |
10007843 | St Mary's University, Twickenham |
10003863 | Leeds Trinity University |
10008017 | Trinity Laban Conservatoire of Music and Dance |
10007139 | University of Worcester |
10000291 | Anglia Ruskin University |
10000571 | Bath Spa University |
10006841 | The University of Bolton |
10000824 | Bournemouth University |
10000886 | The University of Brighton |
10007140 | Birmingham City University |
10007141 | The University of Central Lancashire |
10007145 | University of Gloucestershire |
10001726 | Coventry University |
10007851 | University of Derby |
10007144 | The University of East London |
10007146 | The University of Greenwich |
10007147 | University of Hertfordshire |
10007148 | The University of Huddersfield |
10007151 | The University of Lincoln |
10003678 | Kingston University |
10003861 | Leeds Beckett University |
10003957 | Liverpool John Moores University |
10004180 | The Manchester Metropolitan University |
10004351 | Middlesex University |
10001883 | De Montfort University |
10001282 | University of Northumbria at Newcastle |
10004797 | The Nottingham Trent University |
10004930 | Oxford Brookes University |
10007801 | University of Plymouth |
10007155 | The University of Portsmouth |
10005790 | Sheffield Hallam University |
10004078 | London South Bank University |
10006299 | Staffordshire University |
10007159 | The University of Sunderland |
10007161 | Teesside University |
10006566 | The University of West London |
10007164 | University of the West of England, Bristol |
10007137 | The University of Chichester |
10007165 | The University of Westminster |
10007166 | The University of Wolverhampton |
10007833 | Glyndwr University |
10007854 | Cardiff Metropolitan University |
10007793 | University of South Wales |
10007849 | University of Abertay Dundee |
10002681 | Glasgow School of Art |
10005337 | Queen Margaret University, Edinburgh |
10005561 | Royal Conservatoire of Scotland |
10005500 | The Robert Gordon University |
10007800 | The University of the West of Scotland |
10007762 | Glasgow Caledonian University |
10007772 | Edinburgh Napier University |
10007759 | Aston University |
10007850 | The University of Bath |
10006840 | The University of Birmingham |
10007785 | The University of Bradford |
10007786 | The University of Bristol |
10000961 | Brunel University London |
10007788 | The University of Cambridge |
10001478 | City, University of London |
10007143 | University of Durham |
10007789 | The University of East Anglia |
10007791 | The University of Essex |
10007792 | The University of Exeter |
10007149 | The University of Hull |
10007767 | Keele University |
10007150 | The University of Kent |
10007768 | The University of Lancaster |
10007795 | The University of Leeds |
10007796 | The University of Leicester |
10006842 | The University of Liverpool |
10007760 | Birkbeck College |
10002718 | Goldsmiths College |
10003270 | Imperial College of Science, Technology and Medicine |
10003645 | King's College London |
10007769 | London Business School |
10004063 | London School of Economics and Political Science |
10007771 | London School of Hygiene and Tropical Medicine |
10007775 | Queen Mary University of London |
10005553 | Royal Holloway and Bedford New College |
10007779 | The Royal Veterinary College |
10007782 | St George's, University of London |
10007780 | SOAS University of London |
10007784 | University College London |
10007797 | University of London (Institutes and activities) |
10004113 | Loughborough University |
10007799 | Newcastle University |
10007154 | University of Nottingham |
10007774 | The University of Oxford |
10007802 | The University of Reading |
10007156 | The University of Salford |
10007157 | The University of Sheffield |
10007158 | The University of Southampton |
10007160 | The University of Surrey |
10007806 | The University of Sussex |
10007163 | The University of Warwick |
10007167 | The University of York |
10007790 | The University of Edinburgh |
10007794 | The University of Glasgow |
10007805 | The University of Strathclyde |
10007783 | The University of Aberdeen |
10007764 | Heriot-Watt University |
10007852 | The University of Dundee |
10007803 | The University of St Andrews |
10007804 | The University of Stirling |
10005700 | SRUC |
10007858 | University of Wales Trinity Saint David |
10007856 | Aberystwyth University |
10007857 | Bangor University |
10007814 | Cardiff University |
10007855 | Swansea University |
10005343 | Queen's University Belfast |
10007807 | Ulster University |
10008574 | The University of Wales (central functions) |
10003324 | The Institute of Cancer Research |
10007657 | Writtle University College |
10004775 | Norwich University of the Arts |
10008010 | Stranmillis University College |
10008026 | St Mary's University College |
10005545 | Royal Agricultural University |
10007114 | University of the Highlands and Islands |
10000385 | The Arts University Bournemouth |
10001653 | Conservatoire for Dance and Drama |
10000712 | University College Birmingham |
10007761 | Courtauld Institute of Art |
10004048 | London Metropolitan University |
10007787 | The University of Buckingham |
10007798 | The University of Manchester |
10007765 | Heythrop College |
10006427 | University for the Creative Arts |
10007825 | Guildhall School of Music and Drama |
10003945 | The Liverpool Institute for Performing Arts |
10014001 | University of Suffolk |
10003854 | Leeds Arts University |
10000163 | AECC University College |
10031982 | BPP University |
10007937 | GSM London |
10003331 | Regent's University London |
10008289 | The London Institute of Banking Finance |
10039956 | The University of Law |
10005470 | Richmond, The American International University in London |
10035638 | Institute of Contemporary Music Performance |
10023454 | Moorlands College |
10020416 | Mattersey Hall |
10008362 | London School of Science and Technology Limited |
10003958 | Liverpool School of Tropical Medicine |
10004511 | The National Film and Television School |
10005127 | Plymouth College of Art |
10019746 | ABI College Limited |
10037544 | BIMM Limited |
10003239 | ICON College of Technology and Management |
10003566 | Kensington College of Business |
10004061 | Bloomsbury Institute |
10004450 | Mountview Academy of Theatre Arts |
10004538 | Nazarene Theological College |
10022944 | Stratford College London Limited |
10015506 | The London College UCK |
10000381 | Arts Educational Schools |
10002735 | Grafton College |
10023777 | Mont Rose College of Management and Sciences |
10008397 | Norland College |
10038763 | ForMission Ltd |
10022021 | UK College of Business and Computing |
10030391 | London Churchill College Ltd |
10013357 | The Academy of Contemporary Music |
10022047 | Empire College London Limited |
10002113 | East End Computing and Business College Limited |
10033187 | Fairfield School of Business Ltd |
10022285 | London School of Management Education |
10004075 | London School of Theology |
10030776 | St Mellitus College |
10030129 | Nelson College London Ltd |
10004740 | Northern College of Acupuncture |
10042570 | Pearson College |
10005544 | Royal Academy of Dance |
10007839 | SAE Education Limited |
10005916 | Slough Borough Council |
10037822 | Tottenham Hotspur Foundation |
10000080 | Access to Music Limited |
10000248 | Academy of Live and Recorded Arts |
10001546 | The College of Integrated Chinese Medicine |
10010213 | The City College |
10045476 | Met Film School Limited |
10004079 | London Studio Centre |
10023290 | West London College of Business and Management Sciences Limited |
10032594 | London School of Academics Ltd |
10008455 | Regent College |
10028216 | Brit College |
10022087 | Futureworks |
10013109 | London Bridge Business Academy |
10006243 | St Patrick's International College |
10001386 | Chicken Shed Theatre Company |
10000216 | All Nations Christian College |
10000894 | Bristol Baptist College |
10032072 | The Cambridge Theological Federation |
10001419 | Christie's Education Limited |
10039082 | City and Guilds of London Art School |
10007912 | Cliff College |
10008173 | University College of Estate Management |
10007361 | Waverley Abbey College |
10023445 | ICOM |
10029682 | The Islamic College |
10009527 | Istituto Marangoni Limited |
10021682 | Kaplan Open Learning |
10008325 | KLC School of Design |
10009612 | Luther King House Educational Trust |
10020439 | Oxford Business College |
10019178 | Point Blank Music School |
10006093 | Spurgeon's College |
10045289 | St Nicholas Montessori Training Limited |
10032288 | West Dean College |
10010227 | Oak Hill College |
10004320 | The Metanoia Institute |
10032282 | The Queen's Foundation for Ecumenical Theological Education |
10021256 | The Salvation Army |
10023464 | Trinity College Bristol |
10023453 | Matrix College of Counselling and Psychotherapy Ltd |
10032277 | The Minster Centre |
10053279 | The Sherwood Institute |
10008071 | AA School of Architecture |
10042364 | Ballet West |
10034324 | Court Theatre Training Company Ltd |
10021100 | Regents Theological College |
10023434 | London School of Commerce IT limited |
10041898 | Apex College London |
10048199 | New College of the Humanities |
10023452 | The Markfield Institute of Higher Education |
10010308 | Cambridge Arts and Sciences Limited |
10005451 | Arden University |
10007820 | Grwp Llandrillo Menai |
10009614 | Grwp NPTC Group |
10030408 | Gower College Swansea |
10000936 | The University College of Osteopathy |
10041974 | London College of Business Sciences |
10004365 | Millennium Performing Arts Ltd |
10057951 | London College of Creative Media Limited |
10026921 | Christ the Redeemer College |
10029843 | Waltham International College Limited |
10020680 | Belfast Metropolitan College |
10020372 | Northern Regional College |
10020633 | Southern Regional College |
10020699 | South Eastern Regional College |
10020634 | North West Regional College |
10020685 | South West College |
10066551 | LCCM AU UK Limited |
10007709 | York College |
10007696 | Yeovil College |
10007434 | West Thames College |
10007977 | Heart of Worcestershire College |
10007578 | City of Wolverhampton College |
10007427 | West Nottinghamshire College |
10007419 | West Kent and Ashford College |
10007455 | The WKCIC Group |
10007553 | Wirral Metropolitan College |
10002107 | The Windsor Forest Colleges Group |
10007527 | Wiltshire College |
10007417 | West Herts College |
10007469 | Weymouth College |
10007459 | Weston College of Further and Higher Education |
10007859 | Warwickshire College |
10007321 | Waltham Forest College |
10007315 | Walsall College |
10004718 | North Warwickshire and South Leicestershire College |
10007289 | Wakefield College |
10007339 | Warrington Vale Royal College |
10001476 | United Colleges Group |
10005999 | Tyne Coast College |
10005998 | The Trafford College Group |
10004760 | Northumberland College |
10006549 | Telford College |
10006494 | Tameside College |
10006463 | Swindon College |
10001475 | City of Sunderland College |
10006378 | Strode College |
10006322 | Stephenson College |
10006226 | St Mary's College |
10006174 | St Helens College |
10003674 | South Thames Colleges Group |
10006303 | New College Stamford |
10004603 | Newcastle and Stafford Colleges Group |
10006038 | Southport College |
10006050 | Sparsholt College |
10005946 | Solihull College and University Centre |
10005822 | Shrewsbury Colleges Group |
10005788 | The Sheffield College |
10006020 | Southampton City College |
10036143 | South Gloucestershire and Stroud College |
10005981 | South Essex College of Further and Higher Education |
10005741 | Selby College |
10005736 | Seevic College |
10005977 | South Devon College |
10005967 | South City College Birmingham |
10005669 | Sandwell College |
10005032 | Salford City College |
10005583 | Ruskin College |
10005575 | Runshaw College |
10005534 | RNN Group |
10002863 | Riverside College |
10005465 | Richard Huish College |
10005469 | Richmond upon Thames College |
10005404 | Reaseheath College |
10004676 | Petroc |
10005077 | Peterborough Regional College |
10005200 | Preston College |
10005128 | City College Plymouth |
10005124 | Plumpton College |
10005072 | Peter Symonds College |
10007063 | Truro and Penwith College |
10006770 | The Oldham College |
10004835 | Oaklands College |
10004579 | New College Swindon |
10004577 | Nottingham College |
10004772 | City College Norwich |
10001503 | The Northern School of Art |
10007011 | Northampton College |
10004721 | North Kent College |
10004690 | North Hertfordshire College |
10004607 | Newham College of Further Education |
10004599 | NCG |
10004596 | Newbury College |
10004686 | North East Surrey College of Technology (NESCOT) |
10006963 | New City College |
10004576 | New College Durham |
10004552 | Nelson and Colne College |
10004478 | Myerscough College |
10004442 | Moulton College |
10003768 | Lancaster and Morecambe College |
10004340 | Mid-Kent College |
10004375 | Milton Keynes College |
10004144 | Macclesfield College |
10023139 | LTE Group |
10004112 | Loughborough College |
10003928 | Lincoln College |
10007500 | Wigan and Leigh College |
10003867 | Leicester College |
10003855 | Leeds College of Building |
10024962 | Leeds City College |
10003753 | Lakes College West Cumbria |
10003189 | Kirklees College |
10003676 | Kingston Maurward College |
10003558 | Kendal College |
10003200 | Hull College |
10003193 | Hugh Baird College |
10007945 | Highbury College Portsmouth |
10003146 | Hopwood Hall College |
10003128 | Holy Cross College |
10003088 | Richmond and Hillcroft Adult and Community College |
10003035 | Hertford Regional College |
10003022 | Hereford College of Arts |
10003023 | Herefordshire and Ludlow College |
10007193 | HCUC |
10002935 | Havering College of Further and Higher Education |
10005979 | Havant and South Downs College |
10002899 | Harlow College |
10002094 | Ealing, Hammersmith West London College |
10002852 | Halesowen College |
10002843 | Hadlow College |
10002815 | Guildford College of Further and Higher Education |
10007938 | Grimsby Institute of Further and Higher Education |
10002743 | Grantham College |
10002696 | Gloucestershire College |
10002638 | Gateshead College |
10002599 | Furness College |
10002412 | Farnborough College of Technology |
10007928 | Fareham College |
10002370 | Exeter College |
10002923 | East Sussex College Group |
10002130 | East Surrey College |
10002126 | East Riding College |
10002143 | Eastleigh College |
10007924 | Dudley College of Technology |
10004695 | DN Colleges Group |
10001919 | Derby College |
10001778 | Croydon College |
10001696 | Cornwall College |
10001743 | Craven College |
10003010 | Coventry College |
10003955 | The City of Liverpool College |
10001535 | Colchester Institute |
10005972 | Cheshire College South and West |
10007817 | Chichester College Group |
10001378 | Chesterfield College |
10003564 | Kensington and Chelsea College |
10002061 | Central Bedfordshire College |
10001165 | Cardinal Newman College |
10001116 | Cambridge Regional College |
10001093 | Calderdale College |
10001005 | Bury College |
10001000 | Burnley College |
10001004 | Burton and South Derbyshire College |
10000952 | BMC (Brooksby Melton College) |
10000948 | Bromley College of Further and Higher Education |
10000950 | Brooklands College |
10000944 | Brockenhurst College |
10000878 | Bridgwater and Taunton College |
10001467 | City of Bristol College |
10004736 | Greater Brighton Metropolitan College |
10000840 | Bradford College |
10000820 | The Bournemouth and Poole College |
10000812 | Boston College |
10000794 | Bolton College |
10000754 | Blackpool and the Fylde College |
10000747 | Blackburn College |
10000721 | Bishop Burton College |
10000720 | Bishop Auckland College |
10006442 | Birmingham Metropolitan College |
10000654 | The Berkshire College of Agriculture (BCA) |
10000610 | Bedford College |
10001465 | Bath College |
10000560 | Basingstoke College of Technology |
10000533 | Barnet Southgate College |
10000536 | Barnsley College |
10000534 | Barnfield College |
10000528 | Barking and Dagenham College |
10000473 | Aylesbury College |
10000415 | Askham Bryan College |
10004927 | Activate Learning |
10000093 | Accrington and Rossendale College |
10002919 | Hartpury College |
10000670 | Bexhill College |
10003511 | Joseph Chamberlain Sixth Form College |
10004432 | Morley College Limited |
10004344 | Middlesbrough College |
10006570 | East Kent College |
10007431 | West Suffolk College |
10019368 | London College of Business Studies |
10004023 | London College of International Business Studies Ltd |
10067853 | ACM |
10000055 | Abingdon and Witney College |
10007838 | Royal Welsh College of Music and Drama |
BSMS | Brighton and Sussex Medical School |
HYMS | Hull York Medical School |
PCMD | Peninsula Medical School |
MOOC | Online course |
4002 | Other Non-UK provider |
XXXX | Not known / Not applicable |
Dependent fields
- XSTULOCUC
- XSTULOCGR
Depend upon fields
- UCNAME
- UCNAME_OTHER
Additional information
This algorithm cleans up the provider of further study provided by a graduate responding to the Graduate Outcomes survey question "What is the name of the university or college at which you were registered on?", combining the data provided in UCNAME with that from the free text field UCNAME_OTHER.
ZSTUPROV contains a valid UKPRN or one of the provider codes BSMS, HYMS, PCMD, MOOC or 4002 or the unknown code XXXX.
Technical Specification
1. Convert the string from UCNAME_OTHER to upper case
2. Trim white space from beginning and end of the string
3. Replace '&' with 'and'
4. Replace special characters (using list below*) with a single space
5. Replace multiple spaces with a single space
6. Carry out the following steps, taking a top down approach stopping when criteria is satisfied:
- Where the upper case version of a provider name (from the list of providers used in the drop down menu) is contained within the string and corresponds to a unique provider code, return the corresponding provider code
- Where the upper case versions of the labels for any of the valid entries 10007838, BSMS, HYMS, PCMD, MOOC are contained within the string, return the corresponding provider code.
- Where the string contains the string "OVERSEAS" or "NON UK", return provider code 4002.
- Set any remaining invalid strings to XXXX
7. Where UCNAME is not NULL and not equal to OTHER or the empty string, copy the values from UCNAME into ZSTUPROV (note: due to routing, only XXXX values should be overwritten with values from UCNAME)
*Special characters include: ! # % * + \ - . / : ; < = > ? @ [ ] ^ _ ` { | } ~
Revision history
Date | Version | Notes |
---|---|---|
2019-10-10 | 1.1.1 | Field Created |
Contact Liaison by email or on +44 (0)1242 388 531.