XDOMUC01_6.3.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Domicile (county/region/unitary authority/local government district level) | XDOMUC01 | 6.3.1 | 4 | Char |
Valid entries
Code | Label |
---|---|
C800 | Bath and North East Somerset |
C822 | Bedford |
C823 | Central Bedfordshire |
C889 | Blackburn with Darwen |
C890 | Blackpool |
C837 | Bournemouth |
C867 | Bracknell Forest |
C846 | Brighton and Hove |
C825 | Buckinghamshire |
C873 | Cambridgeshire |
C895 | Cheshire East |
C896 | Cheshire West and Chester |
C801 | City of Bristol |
C831 | City of Derby |
C810 | City of Kingston upon Hull |
C856 | City of Leicester |
C892 | City of Nottingham |
C879 | City of Plymouth |
C851 | City of Portsmouth |
C852 | City of Southampton |
C861 | City of Stoke-on-Trent |
C816 | City of York |
C908 | Cornwall |
C909 | Cumbria |
C841 | Darlington |
C830 | Derbyshire |
C878 | Devon |
C835 | Dorset |
C840 | County Durham |
C811 | East Riding of Yorkshire |
C845 | East Sussex |
C881 | Essex |
C916 | Gloucestershire |
C329 | Greater London |
C369 | Greater Manchester |
C876 | Halton |
C850 | Hampshire |
C805 | Hartlepool |
C884 | Herefordshire |
C919 | Hertfordshire |
C921 | Isle of Wight |
C420 | Isles of Scilly |
C886 | Kent |
C888 | Lancashire |
C855 | Leicestershire |
C925 | Lincolnshire |
C821 | Luton |
C887 | Medway |
C349 | Merseyside |
C806 | Middlesbrough |
C826 | Milton Keynes |
C926 | Norfolk |
C812 | North East Lincolnshire |
C813 | North Lincolnshire |
C802 | North Somerset |
C815 | North Yorkshire |
C928 | Northamptonshire |
C929 | Northumberland |
C891 | Nottinghamshire |
C931 | Oxfordshire |
C874 | Peterborough |
C836 | Poole |
C870 | Reading |
C807 | Redcar and Cleveland |
C857 | Rutland |
C893 | Shropshire |
C871 | Slough |
C933 | Somerset |
C803 | South Gloucestershire |
C379 | South Yorkshire |
C882 | Southend-on-Sea |
C860 | Staffordshire |
C808 | Stockton-on-Tees |
C935 | Suffolk |
C936 | Surrey |
C866 | Swindon |
C894 | Telford and Wrekin |
C883 | Thurrock |
C880 | Torbay |
C399 | Tyne and Wear |
C877 | Warrington |
C937 | Warwickshire |
C869 | West Berkshire |
C339 | West Midlands |
C938 | West Sussex |
C389 | West Yorkshire |
C865 | Wiltshire |
C868 | Windsor and Maidenhead |
C872 | Wokingham |
C885 | Worcestershire |
C677 | Blaenau Gwent - Blaenau Gwent |
C672 | Pen-Y-Bont Ar Ogwr - Bridgend |
C676 | Caerffili - Caerphilly |
C681 | Caerdydd - Cardiff |
C669 | Sir Gaerfyrddin - Carmarthenshire |
C667 | Sir Ceredigion - Ceredigion |
C662 | Conwy - Conwy |
C663 | Sir Ddinbych - Denbighshire |
C664 | Sir Y Fflint - Flintshire |
C661 | Gwynedd - Gwynedd |
C660 | Sir Ynys Môn - Isle of Anglesey |
C675 | Merthyr Tudful - Merthyr Tydfil |
C679 | Sir Fynwy - Monmouthshire |
C671 | Castell-Nedd Port Talbot - Neath Port Talbot |
C680 | Casnewydd - Newport |
C668 | Sir Benfro - Pembrokeshire |
C666 | Powys - Powys |
C674 | Rhondda, Cynon, Taff - Rhondda, Cynon, Taff |
C670 | Abertawe - Swansea |
C678 | Tor-Faen - Torfaen |
C673 | Bro Morgannwg - The Vale of Glamorgan |
C665 | Wrecsam - Wrexham |
C110 | Aberdeenshire |
C120 | Angus |
C130 | Argyll and Bute |
C100 | City of Aberdeen |
C180 | City of Dundee |
C230 | City of Edinburgh |
C260 | City of Glasgow |
C150 | Clackmannanshire |
C170 | Dumfries and Galloway |
C190 | East Ayrshire |
C200 | East Dunbartonshire |
C210 | East Lothian |
C220 | East Renfrewshire |
C240 | Falkirk |
C250 | Fife |
C270 | Highland |
C280 | Inverclyde |
C290 | Midlothian |
C300 | Moray |
C310 | North Ayrshire |
C320 | North Lanarkshire |
C330 | Orkney Islands |
C340 | Perth and Kinross |
C350 | Renfrewshire |
C355 | Scottish Borders |
C360 | Shetland Islands |
C370 | South Ayrshire |
C380 | South Lanarkshire |
C390 | Stirling |
C395 | West Dunbartonshire |
C400 | West Lothian |
C410 | Western Isles (Eilean Siar) |
C041 | Antrim and Newtownabbey |
C042 | Armagh, Banbridge and Craigavon |
C043 | Belfast |
C044 | Causeway Coast and Glens |
C045 | Derry and Strabane |
C046 | Fermanagh and Omagh |
C047 | Lisburn and Castlereagh |
C048 | Mid and East Antrim |
C049 | Mid Ulster |
C050 | Newry, Mourne and Down |
C051 | North Down and Ards |
NOTK | Not known |
AF | Afghanistan |
XQ | Africa not otherwise specified |
AX | Åland Islands |
AL | Albania |
DZ | Algeria |
AS | American Samoa |
AD | Andorra |
AO | Angola |
AI | Anguilla |
XX | Antarctica and Oceania not otherwise specified |
AG | Antigua and Barbuda |
AR | Argentina |
AM | Armenia |
AW | Aruba |
XS | Asia (Except Middle East) not otherwise specified |
AU | Australia |
AT | Austria |
AZ | Azerbaijan |
BS | Bahamas, The |
BH | Bahrain |
BD | Bangladesh |
BB | Barbados |
BY | Belarus |
BE | Belgium |
BZ | Belize |
BJ | Benin |
BM | Bermuda |
BT | Bhutan |
BO | Bolivia [Bolivia, Plurinational State of] |
BQ | Bonaire, Sint Eustatius and Saba |
BA | Bosnia and Herzegovina |
BW | Botswana |
BR | Brazil |
VG | British Virgin Islands [Virgin Islands, British] |
BN | Brunei [Brunei Darussalam] |
BG | Bulgaria |
BF | Burkina Faso |
MM | Burma [Myanmar] |
BI | Burundi |
KH | Cambodia |
CM | Cameroon |
CA | Canada |
IC | Canary Islands |
CV | Cape Verde |
XW | Caribbean not otherwise specified |
KY | Cayman Islands |
CF | Central African Republic |
XU | Central America not otherwise specified |
TD | Chad |
XL | Channel Islands not otherwise specified |
CL | Chile |
CN | China |
CX | Christmas Island |
CC | Cocos (Keeling) Islands |
CO | Colombia |
KM | Comoros |
CG | Congo |
CD | Congo (Democratic Republic) [Congo (The Democratic Republic of the)] |
CK | Cook Islands |
CR | Costa Rica |
HR | Croatia |
CU | Cuba |
CW | Curaçao |
XA | Cyprus (European Union) |
XB | Cyprus (Non-European Union) |
XC | Cyprus not otherwise specified |
CZ | Czech Republic |
DK | Denmark |
DJ | Djibouti |
DM | Dominica |
DO | Dominican Republic |
TL | East Timor [Timor Leste] |
EC | Ecuador |
EG | Egypt |
SV | El Salvador |
XF | England |
GQ | Equatorial Guinea |
ER | Eritrea |
EE | Estonia |
ET | Ethiopia |
XP | Europe not otherwise specified |
EU | European Union not otherwise specified |
FK | Falkland Islands [Falkland Islands (Malvinas)] |
FO | Faroe Islands |
FJ | Fiji |
FI | Finland |
FR | France |
GF | French Guiana |
PF | French Polynesia |
GA | Gabon |
GM | Gambia, The |
GE | Georgia |
DE | Germany |
GH | Ghana |
GI | Gibraltar |
GR | Greece |
GL | Greenland |
GD | Grenada |
GP | Guadeloupe |
GU | Guam |
GT | Guatemala |
GG | Guernsey |
GN | Guinea |
GW | Guinea-Bissau |
GY | Guyana |
HT | Haiti |
HN | Honduras |
HK | Hong Kong (Special Administrative Region of China) [Hong Kong] |
HU | Hungary |
IS | Iceland |
IN | India |
ID | Indonesia |
IR | Iran [Iran, Islamic Republic of] |
IQ | Iraq |
IE | Ireland |
IM | Isle of Man |
IL | Israel |
IT | Italy |
CI | Ivory Coast [Côte D'ivoire] |
JM | Jamaica |
JP | Japan |
JE | Jersey |
JO | Jordan |
KZ | Kazakhstan |
KE | Kenya |
KI | Kiribati |
KP | Korea (North) [Korea, Democratic People's Republic of] |
KR | Korea (South) [Korea, Republic of] |
QO | Kosovo |
KW | Kuwait |
KG | Kyrgyzstan |
LA | Laos [Lao People's Democratic Republic] |
LV | Latvia |
LB | Lebanon |
LS | Lesotho |
LR | Liberia |
LY | Libya |
LI | Liechtenstein |
LT | Lithuania |
LU | Luxembourg |
MO | Macao (Special Administrative Region of China) [Macao] |
MK | Macedonia [Macedonia, The Former Yugoslav Republic of] |
MG | Madagascar |
MW | Malawi |
MY | Malaysia |
MV | Maldives |
ML | Mali |
MT | Malta |
MH | Marshall Islands |
MQ | Martinique |
MR | Mauritania |
MU | Mauritius |
YT | Mayotte |
MX | Mexico |
FM | Micronesia [Micronesia, Federated States of] |
XR | Middle East not otherwise specified |
MD | Moldova [Moldova, Republic of] |
MC | Monaco |
MN | Mongolia |
ME | Montenegro |
MS | Montserrat |
MA | Morocco |
MZ | Mozambique |
NA | Namibia |
NR | Nauru |
NP | Nepal |
NL | Netherlands |
AN | Netherlands Antilles |
NC | New Caledonia |
NZ | New Zealand |
NI | Nicaragua |
NE | Niger |
NG | Nigeria |
NU | Niue |
NF | Norfolk Island |
XT | North America not otherwise specified |
XG | Northern Ireland |
MP | Northern Mariana Islands |
NO | Norway |
PS | Occupied Palestinian Territories [Palestine, State of] |
OM | Oman |
PK | Pakistan |
PW | Palau |
PA | Panama |
PG | Papua New Guinea |
PY | Paraguay |
PE | Peru |
PH | Philippines |
PN | Pitcairn, Henderson, Ducie and Oeno Islands [Pitcairn] |
PL | Poland |
PT | Portugal |
PR | Puerto Rico |
QA | Qatar |
RE | Réunion |
RO | Romania |
RU | Russia [Russian Federation] |
RW | Rwanda |
WS | Samoa |
SM | San Marino |
ST | Sao Tome and Principe |
SA | Saudi Arabia |
XH | Scotland |
SN | Senegal |
RS | Serbia |
SC | Seychelles |
SL | Sierra Leone |
SG | Singapore |
SX | Sint Maarten (Dutch part) |
SK | Slovakia |
SI | Slovenia |
SB | Solomon Islands |
SO | Somalia |
ZA | South Africa |
XV | South America not otherwise specified |
GS | South Georgia and The South Sandwich Islands |
SS | South Sudan |
ES | Spain |
LK | Sri Lanka |
BL | St Barthélemy |
SH | St Helena, Ascension and Tristan da Cunha |
KN | St Kitts and Nevis |
LC | St Lucia |
MF | St Martin (French Part) [St Martin] |
PM | St Pierre and Miquelon |
VC | St Vincent and The Grenadines |
SD | Sudan |
SR | Suriname |
SJ | Svalbard and Jan Mayen |
SZ | Swaziland |
SE | Sweden |
CH | Switzerland |
SY | Syria [Syrian Arab Republic] |
TW | Taiwan [Taiwan, Province of China] |
TJ | Tajikistan |
TZ | Tanzania [Tanzania, United Republic of] |
TH | Thailand |
TG | Togo |
TK | Tokelau |
TO | Tonga |
TT | Trinidad and Tobago |
TN | Tunisia |
TR | Turkey |
TM | Turkmenistan |
TC | Turks and Caicos Islands |
TV | Tuvalu |
UG | Uganda |
UA | Ukraine |
AE | United Arab Emirates |
XK | United Kingdom, not otherwise specified |
US | United States |
VI | United States Virgin Islands [Virgin Islands, U. S.] |
UY | Uruguay |
UZ | Uzbekistan |
VU | Vanuatu |
VA | Vatican City [Holy See (Vatican City State)] |
VE | Venezuela [Venezuela, Bolivarian Republic of] |
VN | Vietnam [Viet Nam] |
XI | Wales |
WF | Wallis and Futuna |
EH | Western Sahara |
YE | Yemen |
ZM | Zambia |
ZW | Zimbabwe |
Dependent fields
- XDOMREG01
Depend upon fields
- DOMICILE
- POSTCODE
Additional information
This algorithm uses look-up tables provided from data initially supplied by the Office for National Statistics (ONS). Postcodes (full and outward) are mapped to UK counties, regions, unitary authorities and local government districts to provide an XDOMUC01 value.
Where a valid postcode is provided, and this matches on the ONS Postcode Directory (ONSPD), then the XDOMUC01 value is output. Where a valid postcode is provided (valid postcodes include terminated postcodes), but does not match the ONSPD, then UK not otherwise specified is output. (This would only occur as the result of a validation switch for a postcode introduced after the release of the ONSPD version in use by HESA).
Country codes are returned for other UK and non-UK domiciled students.
The August ONSPD update is used to ensure that all postcodes valid in a reporting period can be validated during submission.
Technical Specification
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.
The HESA Data Management table STATIC_DATA.FULLPC_LOOKUP_(Y2)AUG consists of 6 columns: Full Postcode (F_FULLPC, VARCHAR2, 8); X coordinate (F_OSEAST1M, NUMBER); Y coordinate (F_OSNRTH1M, NUMBER); Region (F_GOR, CHAR, 2); Country (F_CTRY, VARCHAR2, 2) and County/Unitary Authority code (F_XDOMUC01, VARCHAR2, 4). This table is created as part of the processing when the ONS postcode data is loaded into Oracle.
The HESA Data Management table STATIC_DATA.OUTPC_LOOKUP_(Y2)AUG consists of 7 columns; Full Postcode (F_FULLPC, VARCHAR2, 8); Outward Postcode (F_OUTPC, VARCHAR2, 4); X coordinate (F_OSEAST1M, NUMBER); Y coordinate (F_OSNRTH1M, NUMBER); Region (F_GOR, CHAR, 2), Country (F_CTRY, VARCHAR2, 2) and County/Unitary Authority code (F_XDOMUC01, VARCHAR2, 4). This table is created as part of the processing when the ONS postcode data is loaded into Oracle.
EntryProfile.POSTCODE | EntryProfile. DOMICILE | XDOMUC01 |
---|---|---|
Null | ZZ or null | NOTK |
Otherwise | EntryProfile.DOMICILE | |
Found in FULLPC_LOOKUP_(Y2)AUG .F_FULLPC | FULLPC_LOOKUP_(Y2)AUG .F_XDOMUC01 | |
Set of characters (max. of 4) up to first space, if there is one, found in OUTPC_LOOKUP_(Y2)AUG .F_OUTPC | OUTPC_LOOKUP_(Y2)AUG .F_XDOMUC01 | |
Otherwise | XK |
The EntryProfile.POSTCODE and EntryProfile.DOMICILE fields will be either supplied in incoming data or data stored at HESA and linked to incoming instances.
Revision history
Date | Version | Notes |
---|---|---|
2016-10-15 | 6.3.1 | The labels for valid entries BF 'Burkina [Burkina Faso]' and SR 'Surinam [Suriname]' have been updated to 'Burkina Faso' and 'Suriname' respectively. This follows a change in the labels used by the National Statistics Country Classification, which now align with the labels used by ISO-3166. |
2015-06-03 | 6.2.1 | Valid entries for Northern Ireland revised in line with changes to local government geographies. Valid entries C011 - C036 removed, C040 - C051 added. |
2014-10-16 | 6.1.1 | Technical specification revised to remove the stage which referred to the FEEELIG field. Null entries in POSTCODE in combination with null or 'ZZ' in DOMICILE will now derive directly to new valid entry NOTK 'Not known'. Removal of valid entry FSOS 'Overseas - determined by fee eligibility' as a consequence. |
2014-05-09 | 5.4.1 | Valid entry BO relabelled to 'Bolivia [Bolivia, Plurinational State of]', LY to 'Libya' and and VE 'Venezuela [Venezuela, Bolivarian Republic of]' to reflect the ISO-3166-1 and the National Statistics Country Classification (NSCC) standards. |
2013-09-27 | 5.3.1 | Technical 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 the postcode lookup tables. Table suffixes changed to be non-year specific, with explanatory sentence added. |
2013-01-09 | 5.2.1 | Updated for new version of lookup 13AUG. Valid entry PS relabelled from 'Occupied Palestinian Territories [Palestinian Territory, Occupied] {formerly West Bank (including East Jerusalem) and Gaza Strip}' to 'Occupied Palestinian Territories [Palestine, State of] {formerly West Bank (including East Jerusalem) and Gaza Strip}' to align with ISO 3166-1 |
2012-04-12 | 5.1.2 | Reference to 'Government Office Region' changed to 'Region' in the lookup table column descriptions following ONS policy change. No change to function or valid entries |
2012-02-09 | 5.1.1 | New valid entries (CW) Curaçao, (SX) Sint Maarten (Dutch part), (BQ) Bonaire, Sint Eustatius and Saba, and (SS) South Sudan added. Relabeling of valid entry SH from St Helena to St Helena, Ascension and Tristan da Cunha. Minor text updates to existing valid entry labels: City of Kingston-upon-Hull to City of Kingston upon Hull; Medway Towns to Medway; Rhondda Cynon Taff to Rhondda, Cynon, Taff; Vale of Glamorgan to The Vale of Glamorgan. Technical specification: Updated for new version of lookup 12AUG. Additional information text: Reference to National Statistics Postcode Directory (NSPD) replaced by Office for National Statistics Postcode Directory ONSPD |
2011-04-13 | 4.4.1 | Updated for new version of lookup 11AUG |
2011-01-31 | 4.3.1 | Updated for new version of lookup 11MAY |
2010-05-14 | 4.2.1 | Otherwise XK row added to bottom of Technical specification to deal with any postcodes (not in pc lookup tables) allowed via an agreed exception switch - to prevent this function failing. No change to valid entries |
2010-04-09 | 4.1.1 | New output values - C820 Bedfordshire replaced with C822 Bedford and C823 Central Bedfordshire, C875 Cheshire replaced with C895 Cheshire East and C896 Cheshire West and Chester, C840 Durham renamed County Durham to reflect new unitary authority name; new lookup table 10MAY |
2009-06-16 | 3.1.3 | Valid entry typo edits to Vale of Glamorgan, Isle of Anglesey, Newry and Mourne. No change to function |
2009-05-05 | 3.1.2 | Field description - addition of unitary authority to make consistent with other fields |
2009-03-13 | 3.1.1 | New lookup table - 09 MAY and format amends, and new output codes with new valid domicile codes |
2008-07-26 | 2.2.1 | revised to account for null DOMICILE, amend UK code from GB to X, and to map '_826' codes in TEMP |
2008-01-26 | 2.1.1 | Amended spec for New Student Record and new lookup table – 08MAY. New output codes to reflect change in coding frame for DOMICILE |
2005-07-07 | 1.2.1 | New lookup table - May 2005 |
1994-01-01 | 1.5.1 | New lookup table - 07MAY |
1994-01-01 | 1.4.1 | New lookup table - 06MAY |
1994-01-01 | 1.3.1 | New lookup table - 05NOV |
1994-01-01 | 1.1.1 | Code created |
Contact Liaison by email or on +44 (0)1242 388 531.