AFD Names & Numbers is a comprehensive address resource, covering the whole of the British Isles – including The Isle of Man and Channel Islands as well as the United Kingdom. It contains approximately 45.8 million delivery addresses including about 2.3 million organisations and 33.6 million residents.
It can speed up the entry of address information into other programs, look up addresses, (even if only badly spelled fragments are known) and provide a wealth of additional information linked to the postcode – like grid references, NHS and Ward Codes, delivery point suffix (DPS) and Mailsort codes.
Even more powerfully, Names & Numbers can look up addresses from almost any fragment of name, address, SIC Code, Business description and size, Grid Reference or Ward & NHS information (or geodemographic classification)- even if you’re not sure of the spelling.
For maximum benefit, AFD Names & Numbers can be easily linked into other programs. In Windows, the stand-alone Names & Numbers program can be used for simple look-ups, sophisticated searches, or to insert data to other programs. It can also use Drag & Drop or Dynamic Data Exchange to send addresses to other programs, or you can use our powerful Dynamic Link Libraries if your application has a suitable programming language. AFD Names & Numbers also includes ROBOT® technology which allows integration of Names & Numbers into other applications with no programming required and we don’t even need to recognise your application! Simply type the postcode and AFD Names & Numbers does the rest and brings back the full address with or without prompting!
Names & Numbers includes an optional data export facility which can be used for direct marketing purposes. Should you wish to use this facility you are required under clause 21 of your End User License Agreement to complete and return a Names & Numbers Data Extract Return form each quarter. This form will be sent to you by AFD. Each unique record exported from the program or mailing label printed constitues one extraction and must be included on the form.
You are also required to contact the Mailing Preference Service and Telephone Preference Service to check and eliminate address records for any person who does not wish to receive direct mail.
We realise that many of our customers only use Names & Numbers for address management purposes such as address verification or rapid addressing and not the extraction of data or printing of labels.
If you will never extract data, please complete a Data Extract Exemption Request form. Please print the body of the suggested text onto your company letterhead, have it signed by an Authorised Signatory of your organisation and return it by FAX to 01624 817695. If this form is approved, you will be exempted from the quarterly Data Extract Return procedure.
Download our evaluation installer here.
Names & Numbers is installed automatically by the installation program and all files are placed in the correct folders. Some information from your License Certificate will be required during installation, so you are advised to have this to hand:
Place the Names & Numbers CD-ROM in your drive then from the Task Bar, select Start – Run, then type d:\nnsetup and click OK
… where ‘d:’ is the drive letter of your CD-Rom drive – usually D:
Follow the instructions and provide the information requested by the installation program.
The installation will create menu entries for Names & Numbers. These will include entries or icons for Names & Numbers, the Welcome program, and for various help and information documents and program examples.
The evaluation version of the program provides all the functionality of the full product with no limitations apart from containing fictional data.
On new installations, Names & Numbers will operate in a special mode, giving full access to data, for about two weeks. To register and fully activate your copy of the program, run the Names & Numbers ‘Welcome’ program.
The evaluation version of the program contains a set of fictitious data, and does not require registration.
A copy of the ‘AFD Welcome’ program is supplied to simplify the process of Registration and Activation of your program license. To register your copy of Names & Numbers, you will also need the information printed on the ‘License Certificate’ supplied with your program.
To register, run the ‘AFD Welcome’ program:
From the Task Bar select Start – Programs – AFD Names & Numbers – Welcome
Select your required registration method and follow the instructions on screen to activate your software
If you need personal assistance with the registration process, you may call our HelpDesk on 01624 811712, Monday to Friday: 0900 – 1700 (except holidays).
If you require to move your AFD Names & Numbers Licence from one machine to another or if you will be upgrading a machine and will be replacing your hard drive, you should first de-register the license from that machine and transfer it back to our server. At which point you will be able to register AFD Names & Numbers on that other machine instead, and so transfer your license.
To do this, run the Welcome program (as described in the Registration section) and click the ‘De-Activate’ button to transfer the license back. You can then register it on the new machine as described in the Registration section.
Please note that in the case of wiping a hard disk drive you must de-register before you erase your registration information by wiping that hard disk drive.
If you have problems de-registering, or do not have Internet Access then please follow our manual procedure by submitting a Re-registration form.
Making sure that our customers get the best from our products is important to us – so long as you have a current licensed copy of an AFD product, we’re here to help:
This major resource provides 24 hour, direct access to all AFD’s technical resources. If you have a question, need program examples or require a skilled Postcode dealer to help with your system, start by visiting our web site at: www.afd.co.uk or email your request to support@afd.co.uk.
If you don’t yet have Internet access, our HelpDesk on 01624 811712 will help ensure that your copy of the program is installed and functioning correctly. The HelpDesk is manned Monday – Friday 9am – 5pm (except holidays). Ensure that you are next to your computer, which is switched on prior to calling.
These services provide free, unlimited support about all aspects of using the postcode product range. Whilst we will endeavour to help with general advice, we cannot assist with questions or problems that are not related to your use of an AFD Product – nor can we resolve hardware or network errors. You should refer these questions to your System Manager.
Address data is constantly changing as a result of property redevelopment, residents & business moves, and the increasing trend towards the automation of mail delivery. Some parts of Names & Numbers data is especially volatile – people and businesses are obviously subject to more rapid change (house or office moves, coming of age, deaths etc) than are the premises themselves. Telephone number data also changes very rapidly.
You should therefore use data provided by Names & Numbers with sensible caution – and satisfy yourself that details are suitable for the purpose you require. Some of the data sources – like the official Electoral Roll – from which Names & Numbers is assembled, is only fully updated on an annual cycle. It may therefore be many months before a change is reflected in our product, though the most important changes – like gone-aways and mortality – are updated quarterly along with postcode changes. Business data is fully updated each quarter.
To ensure that you get the maximum benefit from your investment in AFD Names & Numbers, you should therefore ensure that the data you are using is as up-to-date as possible. AFD have invested in state-of-the-art technology to provide you with the best possible address data within our programs.
Four data updates are issued each year – usually in February, May, August and November.
Names & Numbers is a very powerful address lookup system, and there are many different ways to harness it. Typically, Names & Numbers can help in the following ways:
By entering a Postcode and a small part of a name or address, Names & Numbers can complete a full address – saving over 80% of keystrokes. With Robot technology you can do this automatically from right within your application.
By capturing the Caller Line Identity (CLI) data available from many modern telephone systems – or by typing in a known telephone number, Names & Numbers can identify most of its known businesses and many residents too – completing full addresses from little or no typing. By helping verify caller details, some organisations may also help cut down fraud.
Most names, addresses and phone numbers can be found using a single, simple entry box – and Names & Numbers will work out what you are requesting and deliver the results. This means that tiny fragments of information can be converted into names and addresses with the minimum of effort.
Names & Numbers has powerful and sophisticated extended searching facilities that can track down even very difficult or mis-spelled names or addresses. Search tools include ‘Sounds Like’, ‘Spelled Like’, and ‘Family’ searches – as well as allowing the use of ‘Wildcards’.
Names & Numbers can search using a wide range of parameters – including Name or Address elements, geographical distances and industry SIC codes or Business Descriptions. Searches can then be exported for use in databases, ready for mail merge, or simply printed as mailing labels.
Names & Numbers has an inbuilt “Nearest” feature allowing you to create and maintain lists of branch offices, regional centres or contacts, then quickly determine which contact point is linearly nearest the postcode you enter.
Make sure that you place your order so that each optional data update is sent to you as soon as it is prepared – or join the POP scheme so that all costs of Data Licenses, Program and Data Updates are covered in one modest monthly standing order payment.
From the Task Bar, select Start – Programs – AFD Names & Numbers – Names & Numbers
Names & Numbers will display an information splash screen, then the Names & Numbers Main Window will be loaded. If you have used any Command Line Options, these may have customised the way in which Names & Numbers will load.
Most Names & Numbers operations take place from the Main Window, and the method of operating the program will be familiar to Windows users, as the controls conform to Windows standards.
The Main Window consists of the following parts:
Use the menu to store and retrieve settings, print labels, change editing and viewing options, insert addresses into other programs, use advanced features of the Cameo or Nearest Facility – or use the on-line Help system.
Most rapid address entry or address lookups can be carried out from this single box – enter your request and if it includes a postcode it will be looked up automatically. For complex lookup’s click the Lookup Button.
Seven Tabs allow you to enter more complex search requests – or view address data in different ways. Note that data will only appear on the Cameo tab if the optional CAMEO data license is in use.
Address lookup and search results are displayed in the list. Click on a result to see more information on one of the Tabs.
At the ‘Find’ box you may enter a simple lookup request, yet powerful search facilities are available to you – so most address lookups can be done here.
Enter your lookup request, then click the Lookup button – use the shortcut key [Alt]+L – or simply press [Enter]. If your lookup request includes a postcode this is detected, and AFD Names & Numbers will automatically carry out a lookup for you without the need to click Lookup.
Note that only the Lookup Button can be used with the Find Box – the Search Button is used with other searches on the Search Tab (see below).
For the fastest results, with minimum typing, enter a postcode, with some information – such as a name or building which makes it unique.
Clicking on the down arrow to the right of the Lookup box allows you to select any of your last 25 Lookups. After selecting one make any modifications necessary, and then click on the Lookup button.
Where you are not sure of the postcode, Names & Numbers can easily find addresses from other delivery information – including Name, Organisation Name, Property, Street Address and Telephone Number:
Valid entries include:
| Entry | Example |
|---|---|
| Postcode only | TN22 1QL |
| Postcode with delivery information | Tops Tiles, TN22 1QL |
| 36,EN2 6LA | |
| Milas Nails,EN26LA | |
| Haart, en2 6la | |
| Name | Dipak Patel |
| Family | John+Janet Smith |
| Organisation | Pizza Hut |
| Property | Mountain View Innovation Centre |
| Street Address | 157 Holdenhurst Road |
| Telephone No | 01624 811711 |
Click the Lookup Button or press the [Enter] key and Names & Numbers will look up the request you’ve entered. You will see from the examples above, that Names & Numbers is quite tolerant of how spaces are used and whether capital or lower case letters are used.
Names & Numbers will detect postcodes or phone numbers which have been re-coded and will convert them to their replacement postcode or phone number before looking up and displaying the results.
For many address lookups, especially for common names or addresses, it will help to provide slightly more information, by including a comma, then (in order of preference) Post Town, Locality or County. It is not necessary to give this information when looking up telephone numbers.
| Entry | Example |
|---|---|
| Name | Dipak Patel,Bradford |
| Family | John+Janet Smith,Birmingham |
| Organisation | Boots,Bradford |
| Property | Abbey Mill, Hampshire |
| Street Address | 21 High Street, Bromley |
Names & Numbers contains support for alias localities. These are localities which are not part of the postal address but may be given as part of an address and so can be used to help find addresses were the postcode is unknown. For example a lookup of “Clay Lane, Gilbertstone’ will find Clay Lane in Birmingham which is in the Gilbertstone locality. Gilbertstone itself is not part of the correct address. It should be noted that these localities are only known to sector level, and so some address may be returned which are not in the locality searched for. As these alias localities are not part of the correct postal address and the correct one for a particular address is not known they cannot be included as part of the address returned, however you can view all the localities in the same sector as the selected address by switching on the ‘Alias Localities’ option from the Names & Numbers ‘View’ menu.
For even better results, and faster performance, Names & Numbers has a series of special control codes which help with lookups and searches:
| Code | Example | Purpose |
|---|---|---|
| ^ | Aysha Khan^ | Use this at the end of a lookup or search parameter to stop the display of longer words which begin with your search parameter. |
| + | John+Janet | ‘AND’ – Used in First Name or Surname to look for both names at one postcode (ie family search). |
| Steven | ||
| $ | John $Davies | ‘SOUNDS LIKE’ – used when spelling is uncertain. |
| ~ | John B~rown | ‘SPELLED LIKE’ – used when spelling is uncertain or to get around typographic errors in Electoral Roll data – even if the error makes the word sound different. Note: speed is significantly improved if the ~ is placed after the first letter of the word you are searching. |
| ? | John Pe?ers?n | ‘WILDCARD’ used to replace any single character in a word when spelling is uncertain – or different spellings occur. |
| * | D*RIC*T | ‘WILDCARD’ used to replace any number of characters in a word when spelling is uncertain – or different spellings occur. |
Names & Numbers is able to interpret most lookup requests correctly – and deliver the information you require without any special help. Some address information may, however, be ambiguous – and present in several different parts of addresses. To assist in these cases – and to speed up many lookups where Names & Numbers would otherwise have to find the address you are looking for by trial-and-error – a series of directive codes is provided.
| Directive | Example | Purpose |
|---|---|---|
| N= | N=David Street | Forces lookup as a person’s name |
| O= | O=David Street | Forces lookup as an Organisation Name |
| P= | P=Smith, Bristol | Forces lookup as a Property Name |
| S= | S=Smith, Bristol | Forces lookup as a Street Address |
| L= | L=Aston | Forces lookup as a Locality |
| T= | T=Birmingham | Forces lookup as a Town |
The above examples, along with several others, are available from a special Examples List window, which displays when Names & Numbers is first run – or is available from the View menu (or by pressing [Ctrl]+X). To try out any example in the list, simply double-click it.
The examples help illustrate the types of lookups available in Names & Numbers – including most of the examples quoted in this section of the manual.
Please note that the evaluation version of Names & Numbers contains a different Examples List from that shown here, which contains examples taken from the fictitious data supplied.
The ‘Order Results by Number’ option on the Edit Menu will order the results in the list box in order of house number within each postcode. Using this option can make it easier to find a particular property. With this option switched off, items are returned in DPS (Delivery Point Suffix) order instead.
The Edit menu offers an option to ‘List Surname First’. This alters the way that the Results List handles the names of individuals – and can be useful when looking up address elements rather than surnames. When the option is switched ‘On’, a check-mark is displayed on the menu, and the Results List shows the surname of individuals before the Title, First Name and Initial.
You can drag text from other Windows programs – like Microsoft Word – and drop it onto the Find Box. Names & Numbers will automatically Lookup the text you dropped – which can be in any of the formats supported by the Find Box.
When Names & Numbers finds results for your lookup or search, it places them in the Results List at the bottom of the Main Window. Simply click an entry in the Results List to see full details of the record on the Results Tab.
Double-Clicking a result in the Results List can automatically Insert an address or (if View Icon for DDE is check-marked) pass the address through DDE to another program.
Please note: In order for Auto-Insert to operate, it will be necessary for the first Insert to have been carried out from the Insert menu so that the target program for other Insert actions is established.
Lookups and Searches are limited to a set number of results. You can change this limit from the Edit – Search Quantity menu (or press [Ctrl]+Q). The search quantity is limited only by available memory.
Postcode-only lookups are not constrained by the search quantity.
To cancel a Lookup, Search or the display of a Lookup List, simply click the Cancel button or press the [Esc] key. Note that Names & Numbers can only respond to a cancel instruction once its initialisation of the Lookup or Search action is completed – this may take a few seconds.
Records displayed in the results list with an asterisk to the right of the postcode are included on the Edited Electoral Roll. This means that they can be used for marketing. In accordance with the terms of the End User Licence Agreement records which are not on the Edited Electoral Roll cannot be used for marketing but can be used for other purposes. This does not affect Organisations which may be used for any purpose and are never present on that roll.
When you select such records the text ‘Edited Roll Record’ is displayed on the top line of the Results tab. You can also exclude non-edited roll records from lookup’s and searches by selecting the ‘Names on Edited Roll Only’ option from the Datasets tab prior to carrying out your search.
Although Names & Numbers can find most addresses using the Find Box and Lookup button, there are times when a more complex search is required – or where you wish to search on other fields. These are available on the Search Tab (shortcut key [Alt]+1).
You may enter as many search parameters as you wish – and they will be used in combination – but beware! Most problems in finding addresses result from giving TOO MUCH information rather than too little. Try to use no more than two or three parameters until you are confident with the process.
When you have entered your Search request, click the Search Button or use the shortcut key [Alt]+S.
Please note: The Lookup Button and the shortcut key [Alt]+L only work with the Find Box – and cannot be used with Searches from the Search Tab, More Tab, Map Tab or Cameo Tab.
Names & Numbers includes a type ahead feature for the street, locality, town and county fields (other fields are not included as they have too many possible values for this feature to be useful). This allows you to start typing your search criteria, e.g. ‘LON’ in the Town field and Names & Numbers will automatically complete the first matching field value which starts with the letters you have already specified. Type-ahead starts after you have typed the first three letters and with every subsequent letter you type Names & Numbers will update it’s selection. You can therefore search or move to your next field when the suggestion is correct without having to type the field in full. If you press the delete key Names & Numbers will delete the rest of it’s selection and you can continue entering the field details without the use of the type-ahead feature.
The type ahead feature can be toggled on and off from the Edit menu.
Most fields on the Search tab also have a List button (with three dots ‘…’ on them). These buttons will display a List window with available results for the search parameter currently entered in that field. For example: if in the Surname field, the entry is ‘PETERS?N^’, the list box would show two possible results – ‘PETERSEN’ and ‘PETERSON’.
Listbox for Surname ‘PETERS?N^’
Click an entry in the List to transfer one of these results back to the Surname box – or double click it to force an immediate search (which will be used in combination with any entries in other fields on the search tab).
Note: The SIC Code list displays SIC codes for which at least one business record exists in Names & Numbers. Where a SIC code has no corresponding business record in Names & Numbers it is not displayed.
Names & Numbers can easily lookup addresses within a set linear distance of a grid-reference point. To do this, you must supply at least three pieces of information – the Grid Easting, Northing, and a radial distance. Since few people will know a Grid Easting and Northing, the Lookup button (‘…’) next to Grid East can look up a postcode and return its Grid Easting and Northing (if any) to the Search Tab – so that you can then simply add a radial range in either kilometers or miles. Looking up a Grid Reference
Grid References can be used with other search parameters – eg to find, say, all accountants within 20 kilometers of your office! To make this type of search even easier, you can use the Map Tab to draw a circle around the area you wish to search (see below).
If a Grid Reference Easting & Northing is specified on the Search Tab, Names & Numbers will return the Linear distance from the reference point for each address record in the search.
Grid references are not available for some postcodes- especially PO boxes which are not geographic delivery points. No Grid references are currently available for Isle of Man or Channel Islands postcodes but in view of their small geographical area, nominal figures have been supplied for the Grid References to enable these to be plotted – and linear distances calculated.
You can also manually enter a grid reference or latitude and longitude values on the Search tab. Please note that grid references used must be on the British (not Irish) grid and latitude and longitude values must be in decimal format.
Clear All ([Alt]+C) Click the Clear button at the base of the Main Window to clear all Search Fields, and any results – use Field-Clear (below) to clear just one or two fields.
Field-Clear To clear any individual field on the Search Tab, click the descriptive label to its left – eg to clear the ‘Surname’ field, click the letters of the word ‘Surname’ just to its left.
Note – in the case of Grid References and/or Distances, any Field Clear will clear Grid East, Grid North, Km & Miles as all are inter-dependent.
Enter the text you wish to search in the relevant Search text box, then click on the descriptive label to its left with the RIGHT mouse button to change the type of search. As you keep clicking, Names & Numbers cycles through the special search codes for you in the following order:
Code Action
(No Code) Starts With .....
$ Sounds Like .....
~ Spelled Like .....
* Ends With .....
*..... * Contains .....
As you select each of these, they will be shown in the message bar at the base of the window.
To move text from one field to another – without re-typing it – hold down one of the [Shift] keys (usually marked with a hollow arrow pointing upwards). Then click and hold down the left mouse button on the field you wish to move (drag) text FROM – the cursor will turn into the shape of a hand with a pencil – now move to the field you wish to place the text in (keeping the mouse button down). Finally, release the mouse button to drop the text in the new field.
You can also drag text from other Windows programs – like Microsoft Word – and drop it into the fields on the Search Tab.
The Edit menu offers several Skip Options. This suppresses the display of more than one record within each postcode, sector, outcode or area and can dramatically reduce the number of records to be examined in some types of Lookup or Search.
A ‘Postcode Sector’ is defined by the number just after the space in a postcode – thus ‘AB10 6’ is one sector ‘AB10 7’ the next.
An ‘Outcode’ is the part of the Postcode before the space – eg ‘AB10’
A ‘Postcode Area’ is the whole area covered by the same letters – eg ‘AB’ – thus a search for the organisation ‘Post Office’, with ‘Skip to Next Postcode Area’ in use, would show only 1 Post Office in the ‘AB’ postcode area – the next one to show would be in the ‘AL’ postcode area
The ‘Order Results by Number’ option on the Edit Menu will order the results in the list box in order of house number within each postcode. Using this option can make it easier to find a particular property. With this option switched off, items are returned in DPS (Delivery Point Suffix) order instead.
The Edit menu offers an option to ‘List Surname First’. This alters the way that the Results List handles the names of individuals – and can be useful when searching on address elements rather than surnames. When the option is switched ‘On’, a check-mark is displayed on the menu, and the Results List shows the surname of individuals before the Title, First Name and Initial.
Names & Numbers contains support for alias localities. These are localities which are not part of the postal address but may be given as part of an address and so can be used to help find addresses were the postcode is unknown. These can be included in a search by placing the locality name in the Locality search field. For example placing ‘Clay Lane’ in the Street field and ‘Gilbertstone’ in the locality field will find all addresses on the Street Clay Lane in Birmingham which is in the Gilbertstone locality. Gilbertstone itself is not part of the correct address. It should be noted that these localities are only known to sector level, and so some address may be returned which are not in the locality searched for. As these alias localities are not part of the correct PAF address and the correct one for a particular address is not known they cannot be included as part of the address returned, however you can view all the localities in the same sector as the selected address by switching on the ‘Alias Localities’ option from the Names & Numbers ‘View’ menu.
This tab is used to display the key parts of an address record found by Postcode. It can be selected by clicking the tab – or use the [Alt]+2 keyboard shortcut.
Use the Edit menu “Editable Results” option if you wish to be able to change the data on the results tab before inserting it into other applications. This menu setting is stored with the current settings file. If “Editable Results” is not checked, you cannot enter a new search request in the Results Tab. In this case if you type in any of the Results Tab boxes you will be returned to the appropriate box on the Search Tab.
The Size field gives an indication of the number of employees of the organisation. The codes given refer to the following:
| Code | No of Employees |
|---|---|
| A | 1 |
| B | 2 To 5 |
| C | 6 To 10 |
| D | 11 To 25 |
| E | 26 To 50 |
| F | 51 To 100 |
| G | 101 To 200 |
| H | 201 To 500 |
| I | 501+ |
| (Blank) | Unknown |
The county field displayed can be altered using the options on the Edit Menu. See Appendix G for more information regarding county options.
The final four fields containing non-address information (Grid East and North, Latitude and Longitude, Distance and Mailsort) above can be customized to display any fields from the More Tab that you may wish to display. This allows you to easily view the information that you are interested in alongside the address. Simple click the down arrow to the right of the field name and you will be given a list of fields to choose from. For full details of each field, refer to the More Tab documentation.
To transfer any address field from the Results Tab to the equivalent field on the Search Tab, simply, click the descriptive label to its left – e.g. to transfer a ‘Surname’ , click the letters of the word ‘Surname’.
You can drag text from the individual fields of the Results Tab and drop it into other Windows programs – like Microsoft Word.
Hold down one of the [Shift] keys (usually marked with a hollow arrow pointing upwards). Then click and hold down the left mouse button on the field you wish to move (drag) text FROM – the cursor will turn into a drag icon. Now move to the program you wish to place the text in (keeping the mouse button down). Finally, release the mouse button to drop the text in the new field.
It is possible to edit the data returned in the results field prior to insertion into your target application. Although this is not recommended it is available by using the Edit Menu Item “Editable Results”. By clicking this menu item you switch on editable results for the results tab and you can edit any field on that tab. If you set this feature to on it will remain on until you switch it off.
This tab is used to display the additional information provided by Postcode. It can be selected by clicking the tab – or use the [Alt]+3 keyboard shortcut.
These fields are grouped into Tabs to organise the available data. If you have commonly used data items that you wish to see alongside the address you can configure Names & Numbers to display up to four of these fields on the Results Tab.
This tab includes the following data:
| Field | Meaning |
|---|---|
| General | |
| Mailsort Code | The code is assigned by Royal Mail and used to sort mail for discounts. |
| TV Region | The TV Region (ISBA Region – not TV Company) the postcode falls into |
| Postcode Type | Indicates if this is a large or small user postcode. A large user postcode always contains a single organisation, a small user postcode is normally shared between a number of organisations and/or residential properties. |
| Gender | This will be Male, Female or Unknown and indicates the Gender of the selected resident. |
| Residency | This indicates the number of years the selected resident has been on the electoral roll at this address. |
| UDPRN | Each delivery point (letterbox) has a unique identifier assigned to it by Royal Mail if it has been matched to the Royal Mail Postcode Address File. Sometimes address details change, for example the postcode may change as the result of a recoding, or the building may be renamed, etc. The UDPRN for an address should stay constant when these changes occur. You should note that some records may not have a UDPRN value if they refer to addresses which are not found on PAF. |
| Date of Birth | This provides the date of birth for new attainers on the electoral roll, this covers most of those in the last 12 years. |
| Composition | This describes the household composition of the selected address. It can have any of the following values:
|
| Occupancy | This gives an indication of the type of occupants of properties found on the selected postcode. The possible values for this are as follows:
|
| AFD Just Built ™ | This provides an indication that a property is likely to be a new build. It contains the date that the property came onto AFD Names & Numbers. This number is expressed in the form YYYYMMDD, e.g. 20080614 means it was introduced On 14th June 2008. |
| Address Type | This gives an indication of the type of property level data you will need to capture to have the full address for properties on the selected postcode. The possible values for this are as follows:
Please refer to Appendix L for more information regarding the Occupancy and Address Type indicators in Names & Numbers. |
| Geographical | |
| Grid East and North | A 10 digit grid reference relating to the location of the postcode on the National Grid, or the Irish Grid for postcodes in Northern Ireland (starting BT). These are to a resolution of 100m. Please refer to Appendix D for more information regarding Grid References in Names & Numbers. |
| Latitude and Longitude | The corresponding latitude and longitude values for the given Grid Easting and Northing for this postcode. These are based on the WGS84 standard. |
| Distance (in Km and Miles) | When a proximity search has been carried out around a specified grid reference, this field provides the straight line distance between the grid reference of the selected postcode and that of the grid reference searched for. |
| Urban/Rural Code | This is a code assigned to the output area for this postcode which indicates if it is in an area of mainly urban or rural properties and how sparsely populated those area’s are. Note that different codes are used for England & Wales, Scotland and Northern Ireland. The Scottish codes are prefixed with an ‘S’ to distinguish them from those for England & Wales as they are both numeric. The possible codes are as follows: England & Wales
Scotland
Northern Ireland
|
| Urban/Rural Name | This provides a description that corresponds to the urban rural code. |
| Sub Country | Indicates if the postcode falls within the boundary of England, Wales, Scotland, Northern Ireland, Isle of Man, Jersey or Guernsey |
| Administrative | |
| Ward Code | Code identifying the electoral ward the postcode resides in |
| Ward Name | The name of the electoral ward the postcode resides in |
| Authority Code | Gives the code of the Local or Unitary Authority (which ever is relevant) this Postcode is contained in (Same as the start of the Ward Code) |
| Authority | Gives the name of the Local or Unitary Authority (which ever is relevant) this Postcode is contained in |
| EER Code | Provides the code of the European Electoral Region that this postcode falls into |
| EER Name | Provides the name of the European Electoral Region that this postcode falls into |
| LEA Code | Provides the code of the Local Education Authority that this postcode falls into |
| LEA Name | Provides the name of the Local Education Authority that this postcode falls into |
| Constituency Code | Code for the electoral Constituency the postcode falls into |
| Constituency | The electoral Constituency the postcode falls into |
| Devolved Constituency Code | Code for the Scottish Parliament Constituency the postcode falls into (where applicable) |
| Devolved Constituency Name | Name for the Scottish Parliament Constituency the postcode falls into (where applicable) |
| Health | |
| SHA Code | Strategic Health Authority Code. This is:
|
| SHA Name | Strategic Health Authority Name which corresponds to the NHS Code. |
| NHS Region Code | National Health Service Region Code (Regional Office – applies to England only) |
| NHS Region National Health | Service Region Name |
| CCG Code | Clinical Commissioning Groups Code. This is:
|
| CCG Name | Clinical Commissioning Groups Name which corresponds to the CCG Code. |
| Business | |
| Location Type | Indicates if this record refers to a Head Office, Branch or Single Site |
| Branch Count | The number of branches this organisation has |
| Group ID | The ID of the group allowing companies belonging to the same parent group to be identified |
| Turnover | The modelled annual turnover for this business at this address |
| National Size | Gives an indication of the number of employees of the organisation at national level. See the Results Tab documentation page for a table of employee bands. |
| Branch Size | Gives an indication of the number of employees of this branch of the organisation. See the Results Tab documentation page for a table of employee bands. |
| Business | Provides a description of the business |
| SIC Code | Provides the Standard Industry Classification this business falls into (see Appendix C for a full list of codes). |
All the fields on the this tab can also be used as part of a search (alone or in conjunction with the Search Tab). To include one of the Additional Information fields, simply enter the information, and click the check-box next to the field (or fields) you wish to use in searches.
This Tab (shortcut [Alt]+4) is used to display the selected address record in the form of an address label – ready to print with a barcode if you wish. You may even customise or add details to the label before printing and can drag the address and/or barcode to other Windows programs from this Tab.
Examples of label layouts are provided – use the drop-down combo box to choose a suitable format. You may adjust these, then use the Save button to store your changes – or add your own.
To create a new label layout, simply type a new name in the combo box, and then click the Save button. Tuning the label print to your own printer and labels or envelopes may require a bit of trial-and-error.
You may need to adjust the Bar Weight to suit your own printer. Typically, a 600 DPI laser will require a Bar Weight of 9, whilst the Smart Label printer requires a bar weight of 3.
Note that this Tab is designed for printing individual labels or envelopes – to print labels for larger selections of addresses – see the section on Printing Mailing Labels.
The Label Tab is also used to provide a quick way of dragging addresses and barcodes to other Windows programs – like Microsoft Word.
To drag a barcode or address, simply hold down a [Shift] key, then click and hold down the LEFT mouse button on either the barcode or the address box of the label tab. A ‘dragging’ mouse cursor will appear. Keep the mouse button down whilst dragging onto the target program (like Word), then release the mouse button to drop a copy of the barcode or address into that program.
Please note: The barcode is a graphics image – and you should ensure that your target program is able to receive and use graphical data, before dragging it there. The Royal Mail barcode is subject to a fairly strict specification of size and layout, but has been tested with Microsoft Word and a suitable printer. You should ensure that your target program and printer is set up to print the barcode to this specification.
The Map Tab (keyboard shortcut [Alt]+5) is used to display the approximate location of an address record on a 1:200,000 scale map for British, Channel Isles and Isle of Man addresses and a 1:500,000 scale map for Northern Irish addresses.
A postcode can be displayed on the on-screen map by clicking on the entry in the Results List underneath the Map Tab. The map will move with the location of that address at it’s centre.
Options are available from the ‘Map’ menu which is also accessible by right clicking on the map image.
Selecting ‘Detach’ from the ‘Map’ menu will open the Map in a separate resizable window, allowing a larger area of the map to be displayed at any one time (the UK outline map will be displayed on the Map tab). Selecting ‘Detach’ again will reattach it to the main window. All the functions available for the map on the main form also apply to the map when displayed in a detached window.
Simply holding down the left mouse button over the map image while dragging the mouse around, allows you to move around the map, the address selected will continue to be marked on the map itself, while it is visible. (Providing ‘Move or Crop’ is selected from the Map menu). You can only move around the map when you are viewing it full size (1:1).
Nearest locations from your Nearest database (see the Nearest tab) are displayed on the map as blue square boxes with a cross head through them. Moving your mouse over one of those locations will display a tool tip next to it showing it’s name. If you prefer not to see these locations displayed then deselect the ‘Display Nearest Locations’ option from the Map menu. Nearest distances are the linear distance between the two points so viewing the Nearest locations on the Map can help spot if the second nearest location might actually be quicker to get to when driving.
By default the Distance displayed underneath the map image on the Map tab is the distance from the point over which the mouse is placed to the selected address. To find the distance from any points visible on the map, or to draw out a series of lines to find a non-straight line distance to a location (e.g. following roads etc.) select the ‘Distance Measuring Line’ from the Map menu.
With this simply click the point at which you want the line to start and then click each subsequent point to measure out the distance. The accumulating distance is displayed below the Map image.
To finish drawing a line un-check the ‘Distance Measuring Line’ option from the Map menu or use the shortcut [Ctrl]+M. (Selecting it again will start a new line). Double-click on the Map to clear the line.
To return to the original mode in which you can move around the map, simply re-select ‘Move or Crop’ from the Map menu.
If you wish to view more detail on the map at one time, at the expense of seeing the detail you can select different view levels from the ‘Map’ menu. Zoom Levels 1:1 through to 1:5 are available. When the Map is not at it’s full size (1:1), the move function is not available due to the additional processing overheads needed to process the larger quantity of data.
Three methods are supplied for getting the Map images into other applications:
Simply hold down shift and the left mouse button and drag the map to any OLE Drag & Drop (bitmap image) supporting application such as Microsoft Word, Paint Shop Pro etc. The image is transferred as is displayed, so if you want the map zoomed out/in you can do this before transferring it and you can determine it’s size by detaching the window and resizing it as desired.
Select ‘Copy Map Image’ from the ‘Map’ menu to copy the currently displayed Map image to the clipboard ready to paste into any other Windows clipboard supporting (bitmap format). As with OLE Drag & Drop the image is transferred as it is displayed.
Programmers can get the data for Map images for a specified Grid Reference directly into their applications by using the AFD Utility DLL. See the API documentation for more details.
Please Note: You are licensed to use maps for each license of an AFD product you have on the desktop. You may not transfer map images to any third party or use them on the Internet. To gain licenses / access to data for other uses please contact Bartholomew directly on 01242 258 134 and mention AFD.
You can print maps to any printer setup in Windows using AFD Postcode Plus. Maps are printed in a standard format consisting of the address selected, a local map and a larger zoomed out map of the surrounding area. They are printed formatted for printing on A4 size paper in Portrait using the label settings from the Label tab. For more advanced printing use the methods above to transfer the image to another application for printing.
If you wish to see the location of a place on a miniature map of the British Isles, simply turn the detailed map off (Uncheck ‘Detailed Map’ from the ‘Map’ menu).
You can measure approximate distances using this map by using the distance line tool on this map.
No Grid References are available for postcodes in the Isle of Man (IM), Jersey (JE), or Guernsey (GY). Some other postcodes, such as PO Boxes, also do not have grid references available for them.
To allow these addresses to be shown on the Map, where no grid reference is available, Postcode Plus will use the grid reference for the centre of the locality or town that the address is in to allow it’s approximate position to be shown on the Map. These approximate values can also be used from Insert if selected from the Grid Reference options in Properties from the File menu. They are also accessible through the Utility DLL for developers.
See also the Appendix on Grid References.
The Nearest Tab (keyboard shortcut [Alt]+6) allows you to create and maintain lists of branch offices, regional centres or contacts, then quickly determine which contact point is nearest the postcode you enter into the main window.
The Nearest facility uses the Grid References supplied as part of Names & Numbers data, to calculate the approximate linear distances between postcodes.
Please note: Most major expanses of water, mountain ranges, and other obstacles are taken account of to help ensure that the closest address is shown first. However, in some cases because of local road layouts or geography the ‘Nearest’ address may not be the easiest or most practical to reach – so others further down the ranked list may be more appropriate.
To use Nearest you must first either create a New Database or Select an existing one – see below.
If you wish to create a new database to start building a nearest list from scratch then select ‘New Database’ from the ‘Nearest’ menu. This will create a new Microsoft Access database ready for adding records.
If you wish to use a non-ODBC database that you created before or one built up using another program choose ‘Open Database’ from the ‘Nearest’ menu. This will prompt you to select the database that you wish to use.
For Access databases you will also be prompted to select the table you wish to use if more than one exists in your chosen database file.
Nearest will use the following fields if they exist in the selected database table:
*must exist in the table and must contain a value.
All fields must be of type ‘Text’ or equivalent.
For System Managers who have special requirements in linking or customising existing databases with the Postcode Nearest facility, our Help Desk will be pleased to provide further information.
If you wish to open a connection to an ODBC data source to which you have set up a Data Source Name (DSN) choose ‘Open ODBC Connection’ from the Nearest menu. You will be prompted to enter the DSN, authentication details (if required), and the SQL Query String to connect to the table.
Fields will be used in the same way as described in the above section.
To add records to the Nearest table simply use the Search tab to search for the records you require. Select those you wish to add to the Nearest database and then select ‘Add Records’ from the ‘Nearest’ menu to add them (or use the shortcut key [Ctrl] + A). Alternatively, if you wish to add all the records in the results list to the nearest database use the ‘Add All Records’ menu item.
To find the nearest record to a postcode, enter the postcode in the ‘Lookup’ box and press the ENTER key. Results will be ranked in order of distance away from your postcode. The ‘Display Miles’ and ‘Display Kilometres’ options in the ‘Nearest’ menu can be used to determine the units used for the distance displayed in the results.
To update a record in the Nearest database, simply select the record from the list under the Nearest tab and then type into the fields on the tab itself. Once you are happy with your changes select ‘Save Record’ from the ‘Nearest’ menu ([Ctrl]+ S) to save your changes to the database.
System Managers may disable the update facilities.
If you wish to remove records from the Nearest database, simply select the records you wish to delete from the list under the Nearest tab and then select ‘Delete Selected Records’ ([Ctrl]+K) from the ‘Nearest’ menu.
System Managers may disable the delete facility.
The Filter field of a database, if present, allows you to assign a value to each record for grouping. By selecting the ‘Filter’ option from the ‘Nearest’ menu ([CTRL]+F) you can enter a pattern to apply to the filter field to display only records matching that Filter.
For example, in a database of supermarkets with a filter field containing values such as “Groceries, Petrol, Clothing” a Filter field of “Petrol” will return only those stores which include a Petrol Station.
Advanced users may use various wildcard characters, character lists, and character ranges to test only part of the filter:
| Code | Action |
|---|---|
| {None} | All Nearest Records |
| ? | Any Character |
| * | Zero or more characters |
| # | Any single digit (0-9) |
| [charlist] | Any single character in charlist |
| [!charlist] | Any single character not in charlist |
If you are using an external database, have imported records without Grid References, or have some incorrect Grid References they will need to be populated from the Names & Numbers data. To do this select the records in the nearest list that require Grid References and select ‘Lookup Grid References’ from the ‘Nearest’ menu. You will be prompted for action if an existing Grid Reference is found for any of the records.
To use the Label feature with a Nearest Record, simply select the Nearest record you would like a label for and then select ‘Transfer To Label Tab’ from the ‘Nearest’ menu, to transfer the record to the Label Tab.
To use the Map feature to view the position of a Nearest Record, simply select the Nearest record you would like to view on the map and then select ‘Transfer To Map Tab’ from the ‘Nearest’ menu, to transfer the record to the Map tab.
If you have several outlets in close proximity and need to be able to distinguish between them you can select to have Nearest distances displayed down to an accuracy of one decimal place. This can be done by selecting the ‘Show Decimal Place’ option from the Nearest menu.
Records can be imported from or exported to comma delimited text files.
To use this facility, simply select the ‘Import Records’ or ‘Export Records’ on the ‘Nearest’ menu -you will be prompted for a filename in both cases. The ‘Export’ option only exports the selected records. ‘Import’ imports all records in the supplied file.
Please note: whether the files have been imported or exported they must have all the fields below in the order they appear below:
** must contain a value.
This tab is used to display the Censation® data. It can be selected by clicking the tab – or use the [Alt]+7 keyboard shortcut. The Censation Tab
How can you gain new insights about your customers and prospects to help you focus on those most likely to build your business?
How can you find patterns of success and repeat them? How can you reduce marketing to people who are unlikely to buy?
Censation® will help you answer these questions… and many more.
Censation® is a geodemographic classification system that assigns one of 52 group codes to most UK postcode. The code system uses the latest Census data, which is the most complete and comprehensive survey of the UK population. The code system is built from careful analysis of over 600 variables. These include information about where people live, how affluent or deprived they are and what ‘life stage’ they are in. It also includes data about housing, employment and education. All this data is analysed together with residential and commercial data and validated further using a leading life-style dataset.
Further ‘unclassified’ codes are allocated to postcodes for which census data is unavailable. These mainly describe the make up of commercial areas.
The Censation geodemographic system is built to reflect the reality in the underlying census and residential data and seeks to minimise assumptions about that data. This means that it can be used across a broad range of organisations (public, charity, commercial) and with lower quantities of data.
It is important to understand that a Censation group code simply highlights the fact that when compared with the rest of the UK, people living within a particular postcode are more likely to have the characteristics described by the Censation group code. The key to using this information sensibly is to start a sentence which says “If I were looking for people with X characteristics I would be more likely to find them within the postcodes which have been assigned Y Censation Code.”
A postcode with a Censation code AW01 (Wealthy, Young Families) may well contain some households who are not wealthy, young families – however, the code signifies that if you are looking for wealthy, young families you are more likely to find them here than elsewhere.
A glossary explaining important terms is provided in Appendix J.
Censation is built for AFD by leading UK marketing statistics company Data Talk using world-class statistical techniques. Insights from the use of Censation can help provide a focus for sales and marketing activity and to the provision and location of services where success and take up are most likely. Conversely using Censation can help avoid spending money where success is less likely.
Every postcode is assigned one of 65 Group Codes. This four-character code identifies levels of affluence, life stage and additional distinctive information.
Postcodes that cannot be classified using Census data because it is not available have been classified using residential and commercial data into a further five categories:
For information on the codes allocated to postcodes not covered by the UK 2011 Census please see 4. below.
Censation can be used to provoke penetrating questions and important discussions that lead to new or clearer insights and more confidence in decision-making. These insights can help to shape and style communication in a way more likely to be relevant to the target audience. For retail, charity and local government, options and priorities for locating stores and services can be more readily assessed.
Perhaps the most obvious application is to append the codes to existing customer databases and to look for consistent patterns. Our API provides direct programmable access to the Censation data making it easy to use Censation codes in your own application – see the API Documentation for details. Are you particularly successful with customers that fall into certain Censation group codes? Why not look for these codes within your prospect data? Did you expect a different result? How will that affect your future sales and marketing communication and strategy?
Alternatively, you may be wanting to target existing customers with additional offers, to do this you can compare the codes for those customers that have made multiple purchases with those that have only made a single purchase. This can highlight those customers more likely to make a further purchase. To find out which customers are likely to stay loyal, long-term customers, you could compare the codes for those who haven’t purchased in the last twelve months, with those that have.
Censation codes can also be applied in ‘live’ situations. In a call centre, scripts and offers can be adjusted to be more likely to appeal to a caller – based on their postcode and Censation code. Universities can attract applications from targeted social backgrounds by using the codes to communicate words and styles more likely to be relevant and accessible.
The Censation codes are produced at ‘output area’ level which is then related to postcodes. An output area consists of roughly 150 people and ensures that it is not possible to identify individual characteristics.
AFD licenses specifically exclude bureaux use. For bureaux licensing details please email sales@afd.co.uk.
Censation codes can be appended to your address records during address capture and used ‘live’ to help communicate in more relevant ways with customers and prospects. In addition codes can be appended to your prospect and customer databases and address lists using the application programmers interface.
Alternatively, purchase an AFD Refiner license. Refiner is an intuitive and powerful batch and interactive address cleansing system which will append Censation codes to address records while you are cleaning them or in a separate appending process.
AFD Names & Numbers provides a powerful way to select and export names and addresses based on Censation code. Selections can be further refined using length of residency, household composition and geographic location (i.e. Town or radial distance).
Additional Censation Information is included in appendices G, H, I and J of this Manual:
You can drag text from the individual fields of the Censation Tab and drop it into other Windows programs – like Microsoft Word.
Hold down one of the [Shift] keys (usually marked with a hollow arrow pointing upwards). Then click and hold down the left mouse button on the field you wish to move (drag) text FROM – the cursor will turn into a dragging icon. Now move to the program you wish to place the text in (keeping the mouse button down). Finally, release the mouse button to drop the text in the new field.
AFD Postcode contains AFD ROBOT technology which will automatically detect the typing of a postcode in most Windows applications, and convert it into a street address.
Postcode allows you to enable or disable Robot entirely – but you can also choose, separately for each application you use, whether to enable Robot at all – and if so, whether to operate normally or in “Quiet” mode.
In “Normal” mode, when Robot detects that you have typed a postcode it will show a window, and allow you to choose whether to insert the address, for the postcode you typed, into your application. If Robot doesn’t recognise your application then you will be prompted to teach Robot how to enter an address – the last time you will need to type an address manually.
In “Quiet” mode Robot will only prompt you if the postcode you typed may indicate more than one address. Most postcodes only have one street address associated with them – in which case Quiet mode allows Robot to operate entirely invisibly and automatically. A number of postcodes have more than one street address – and Robot must ask you which of the possible street addresses to use. The most extreme case, HD7 5UZ, has a choice of 7 different forms of the street address for one postcode.
Robot also supports a “Fast Find” mode where it can search for addresses in the same way as the ‘Find’ field on the main Postcode window by typing a sequence such as #Commercial Street, Birmingham# into your application. Alternatively if you are not using quiet mode and type any known postcode (e.g. B1 1RR) into your application you can then use Fast Find direct from the Robot window to find the address you require.
When Names & Numbers is first installed, Robot is enabled. To turn this feature off across all applications, simply de-select the ‘Enable Postcode Robot’ option on the General tab from the Names & Numbers Main Window’s File – Properties menu option (or shortcut [CTRL]+R).
You can also choose if the System Tray Icon is displayed from here. The “Prompt user to setup Robot with new applications” option enables Robot to automatic detect postcodes entered in unrecognised applications and prompt you to show Robot how to enter an address so that you will never have to enter the address manually in that application again. If you do not wish to use this mode then you can switch this option off from here.
The Startup options ‘Normal’, ‘Compact’, ‘Minimised’, and ‘Robot Only’ allow you to specify how Names & Numbers starts. If you mainly use the Robot you may wish for Names & Numbers to be minimised, so you can easily bring it up when required, or to simply have the Robot on it’s own running – you can Restore Names & Numbers from the Robot System Tray icon is needed.
Robot is the simplest way to get a complete address into your application – Start AFD Names & Numbers, switch to the program you wish to insert the address into and type in a postcode. Robot will prompt you to check that you really do wish to add the address allowing you to select the Name or Organisation you require and, on clicking Insert, inserts the address for you – right back into the application you’re using! If the address is not as expected you can enter another postcode or fast find into the ‘Find’ box and click Lookup to find the right address.
For example:
| Your Action | If you type normal text | If you type a postcode in quiet mode | If you type a postcode with property information – |
|---|---|---|---|
| Robot’s Action | Robot ignores what you typed – and the text appears just as you typed it. | Robot detects the postcode – and converts it into an address. | Robot detects the postcode – and converts it into an address – placing the organisation or property information into the address. |
| What you would see without Robot: | Dear Sir, Following our meeting at | B6 4AB | Royal Mail, B6 4AB |
| What you would see with Robot: | Dear Sir, Following our meeting at | St Stephens Street, BIRMINGHAM, B4 6AB | Royal Mail, Central Aston Delivery Office, St Stephens Street, BIRMINGHAM, B6 4AB |
To use the Fast Find mode simply type a search such as #Commercial Street,Birmingham# into your application and Robot will operate in the same way as shown above.
When you install AFD Names & Numbers, settings for the following applications are installed automatically – and you will normally find that Robot works just as you require without any changes or configuration at all:
When you enter Name, organisation, or property information comma separated before the Postcode, Names & Numbers will look for anything starting with the text that you enter. You can use the following wildcards to help further narrow down/widen this matching:
| Code | Action |
|---|---|
| {None} | All Nearest Records |
| ? | Any Character |
| * | Zero or more characters |
| # | Any single digit (0-9) |
| ^ | Must end here |
| [charlist] | Any single character in charlist |
| [!charlist] | Any single character not in charlist |
Robot is fully configurable and it is easy to modify the way it behaves for an application already supported – or to create new settings for other applications.
The behaviour of Robot is controlled by associating a group of settings with your application. For most common applications Robot will work without any additional configuration. If Robot detects a postcode has been typed into an application that it does not recognise then you will be prompted to teach Robot how to type an example address so that it can learn from you and therefore complete the address automatically in the future.
You can check the ‘Don’t ask me about this window again’ option if you do not want Robot to prompt you about this window when you type a postcode in again – e.g. if you do not wish to use Robot with that window. For more information on the process of teaching Robot how to insert the address see the Show AFD Robot How section of this manual.
Alternatively, you can provide settings to tell Robot how the address information is passed to your application (e.g. order of fields, keystrokes to send between fields). For full details of this, please refer to the Tell AFD Robot How section of this manual.
For more advanced configuration, please also see the Insert and Robot Advanced Setup section.
By default Postcode displays a System Tray icon for Robot (near the clock at the bottom right of your screen. This indicates if Robot is enabled and gives you quick access to disable the Robot or configure it’s options.
Clicking the icon will toggle Robot On and Off (enable and disable it). You will see a green circle when it is on (as shown above) and this will change to red when it is off.
By right clicking the icon you will be presented with a small pop-up menu allowing you to enable/disable the Robot, remove the icon from the Sys Tray (see Enabling Robot for how to re-instate the icon from the Postcode main screen), or Restore/Hide the main form is you wish to toggle between using the Robot alone. You can also gain quick access to the properties and settings for Robot which are described above.
Looking Up and Searching for addresses is only useful if the data can be easily transferred to other programs – like word processors, spreadsheets or databases. Postcode offers a choice of powerful ways to transfer data easily to almost any Windows program where it will be used:
This is the simplest way to transfer an address to your program, as you simply type a postcode into almost any Windows application, Robot does the rest. See Using The Robot for more details.
One of the most basic ways to transfer data is to use the Windows Clipboard.
Simply find the address you require, select it from the Results List, then select the Edit menu Copy option (shortcut key [Ctrl]+C). The selected address is copied to the clipboard, using the current settings and it is then available for pasting into your chosen program.
Move to your chosen application, then paste the address into position. Pasting will usually be carried out in your application by using an Edit menu Paste option (shortcut key [Ctrl]+V) – but consult your application’s documentation for further details.
Although this method requires almost no setting up – and may well be all you need for simple word-processing – there are more powerful methods of transferring addresses, which give you much more control of the process – including the format of the address.
The format of the address placed on the Clipboard can be adjusted using many of the Insert Settings, and Line Squeeze features- see below.
The Label Tab provides a quick way of dragging addresses and barcodes to other Windows programs – like Microsoft Word.
To drag a barcode or address, simply hold down a [Shift] key, then click and hold down the LEFT mouse button on either the barcode or the address box of the Label Tab. Keep the mouse button down whilst dragging onto the target program (like Word), then release the mouse button to drop a copy of the barcode or address into that program.
Please note: The Barcode is a graphical image and you should ensure that your target program is able to receive and use graphical data, before dragging it there. The Royal Mail barcode is subject to a fairly strict specification of size and layout. You should ensure that your target program is set up to print the barcode to this specification.
Postcode can pass address information to almost any Windows programs by simulating the typing of keystrokes into that program. You have full control over the order in which fields are typed into your program, and Postcode includes a very powerful keystroke ‘macro’ language which enables Postcode to control everything that happens during Insert – including the precise position of where each field will be typed.
A special Insert menu is provided to carry out the insert process, and when Postcode starts up, it examines all the other programs currently running, and provides an entry in this menu for each one, along with a menu hot key 1-9 and A-Z.
If your application was started after Postcode was loaded, it will be necessary to refresh the Insert menu by selecting Insert Refresh (shortcut key [F5]). Note that it would be unhelpful to type addresses into some types of Windows programs (eg Windows Explorer!) – and Postcode tries to ignore many of these.
To Insert an address, first select it from the Results List, then choose the target program from the Insert menu – and the address will be typed in according to the current Postcode settings.
Use the Edit menu “Editable Results” option if you wish to be able to change data other than adding property and organisation on the Results Tab before inserting it into other applications. This menu setting is stored with the current settings file. If “Editable Results” is not checked, you cannot enter a new search request in the Results Tab. In this case if you type in any of the Results Tab boxes you will be returned to the appropriate box on the Search Tab.
Once you have carried out the first Insert, Postcode remembers your target program, and makes a new entry at the top of the Insert menu – with a shortcut key [F2]. This means that future addresses can be inserted into this program simply by selecting an address, then pressing [F2].
For even faster Insert of addresses, once the first Insert has been completed, simply double-click an address in the Results List (this feature is not available if DDE is in use – see below).
The behaviour of Postcode during Insert is controlled by settings for each application. Please see the section below that describes how to use the Wizard to configure Insert for your application.
When Postcode is first installed, it should Insert into most common programs – like Word or Excel – correctly. Postcode has a very powerful keystroke ‘macro’ language, which can be made to control your target program, and the precise position of where the data will be typed.
To configure an application to work with Postcode, select the ‘Insert / Robot Setup’ option from the File menu.
When you select this option you will be presented with a fictitious address which you should type into your application exactly as it is shown.
Please note that you should use the keyboard wherever possible to move between fields as this is the most reliable. If you wish to ensure that Robot moves to the first field for you then you should use any shortcut to move to that field before typing the first field. Robot will also record any mouse clicks you use, so if you are unable to use the keyboard to move to a field and your application does not have a scrollable window you can use the mouse if needed. You should click the ‘Done’ button as soon as you have completed entering the address to ensure that keystrokes unrelated to the address are not picked up. If you do not wish to use a field, e.g. county, then simply don’t type it. If you make a mistake, clear out the address in your application and click the ‘Start Again’ button to start again.
Should you wish to customise the field list, e.g. to add the Mailsort code field, then simply click the ‘Customise Field List’ button you will then be presented with the following dialog to select the fields to transfer:
Under the ‘Available Fields’ caption there are options to view the Standard or Special fields. This changes the list displayed below. You can mix and match these fields by adding fields from either one to the ‘Fields To Use’ list. The standard fields are the normal Postcode fields including the current County option. The special fields are more advanced fields including the raw PAF style dependant thoroughfare and thoroughfare fields (this is the street split into two fields if there are two street names in the address), etc., the rest of the county field types, and the outcode and incode portions of the postcode (the part before and after the space respectively). These are useful for applications that store addresses in such formats.
You can easily transfer fields to and from the ‘Fields To Use’ list by using the arrow buttons between the two lists. These are used as follows:
To change the order that fields are inserted into your application, simply select a field and use the up and down arrows to the right of the ‘Fields To Use’ fields list to move the selected field up or down the list. Repeat this until you have positioned all fields in the order that you wish them to be inserted. You can also simply type them in a different order when typing the address in your application and Postcode will automatically re-order them for you.
Once you have typed the address and clicked the Done button, you will be presented with the following final options to complete the setup:
Robot needs to know what to do in the case that an address has gaps missing, e.g. an address which does not have a locality present. In most cases you will leave this as the default ‘Leave blank lines’ setting. However, in some cases you may wish to remove the blank lines, by moving the each address field up to fill the gaps, e.g. with a Word Processor. You might alternatively wish to only remove blank lines between a range of fields such as the Street down to the Town, but you have a fixed Postcode field so you always want that to remain in the same place.
Once you are happy with this you can click the Finish button and your setting will be saved and you can now use Insert and Robot with your application. Simply type a postcode into your application to see it work! If the result isn’t as expected you can re-run the Wizard to set it up again.
Once you select to ‘Tell AFD Robot How’, you can use the Back and Next buttons on each screen to go through the setup process.
The steps of the wizard are as follows:
Here you select the window title of your application. This is used by Postcode to identify the application so that both Insert and Robot can use these settings when asked to insert into your application. The window title is the text that appears in the main blue window title bar of your application. This text should always be in the window title, and so should not necessarily be the complete title. For example, you might find Word has a title bar of ‘Document 1 – Microsoft Word’, however when you save your file it could, for example, change to ‘MyDoc.doc – Microsoft Word’. Therefore by setting the Application Window Title to ‘Microsoft Word’ you will ensure that Postcode can always recognise your application. If your application is running when you run the Wizard you should find your application title is listed in the drop down list box provided. Postcode will attempt to remove known document titles leaving only the application name, however if it has not you should alter the title yourself.
The options provided below allow you to specify a name for your application if desired. Normally you can leave the first option to ‘Use the application window title above to identify these settings’ as the Application Window Title will be the name of the application. However in some cases the windows title text might be obscure so you might prefer to choose to enter a more friendly application name. This name doesn’t affect the Insert or Robot process itself, however it might be useful to specify a name for the application so that you will easily recognise it should you need to manually alter settings with the advanced setup.
From this screen you can configure a number of different options for your application:
The options given are as follows:
Your application is most like a… This enables the Wizard to work out the most likely set of options for your application, making the subsequent steps of the wizard easier. You simply take the application type that most closely matches your application. If none of these are that close, then just take the one which seems closest, as you can always customise the setup anyway to match your application. The application categories supplied are as follows:
Keystrokes to move between each field or line in your application
This setting specifies the keystrokes to be used to move between fields in your application. The default will be dependant on the type of application you selected as being most like the one you are setting up now. In most cases this won’t need to be changed.
To change or enter keystrokes in either text box you can make use of Postcode’s powerful keyboard Macro language. Simply click the button labelled ‘…’ to the right of the appropriate text box to be presented with an easy to use dialogue for specifying the keystrokes:
Clicking on any item in the list of possible keystrokes will add the selected item to the keystrokes to use text box. You can also type any normal keyboard key, for example letters, numbers in that box yourself. When you have entered the relevant keystroke’s you can press OK to update the text field in the Wizard.
If you need to press a key with the Alt, Ctrl or Shift keys also pressed down you can check the boxes for this in the Wizard dialog, or alternatively you can select the symbols for this from the end of the keystrokes list on the keystrokes dialogue to apply them to the following keystroke.
To specify repeating keys, use the form {key number}. You must put a space between key and number. For example, {LEFT 4} means press the Left Arrow key 4 times; {TAB 3} means press the Tab key 3 times.
If you need more complex settings, such as different keystrokes between different fields, or need to use a mouse click because no key shortcut is available to move to a particular field, then this can be altered from the Advanced Setup once you have completed the Wizard.
** Use with Robot** This specifies if your application is going to be used with Robot or not. Regardless of this setting, your settings will work with Insert, which is where you lookup the address in Postcode, select it and then select the application from the Insert menu to insert the address (or press F2 to insert into the last used application again). Robot functionality allows you to type the postcode directly into your application and then insert the full address without having to use Postcode directly first. This option is enabled by default, if you have no need for Robot functionality or if you are entering postcodes in your application and not wanting Robot triggered when you do so then you can opt not to use Robot with your application.
Use with Robot Fast Find This specifies if your application is going to to be used with Robot Fast Find or not. Robot Fast Find enables you to enter address details to be looked up directly from your application when you do not have the postcode. For example typing #Commercial Street, Birmingham# into your application will give you the four postcodes for that address to choose from. You can then choose the correct one and insert it into your application. Please note that as Postcode does not contain property data there is no way of knowing which postcode is the correct one for your address, but if it could help choose between possibilities where a postcode is hard to read on a handwritten note, and some streets do only have a single postcode. You can also lookup a postcode this way, e.g. #B1 1AA#, which could be useful should you need to enter postcodes without looking them up sometimes so the normal robot functionality is not suitable for you. In that case you can say no to ‘Use with Robot’ but yes to ‘Use with Robot Fast Find’ – that way Robot would only be triggered when you enter the postcode surrounded by the # symbol.
Use without prompting where possible Normally when you type a Postcode in your application, Robot will prompt you before inserting the address back into your application. However, if you would prefer Robot to do this automatically wherever possible, you can select this option and you will only be prompted if there is more than one possible street address for the postcode you enter.
How many fields or lines are there for address entry? This specifies how many fields (boxes) or lines there are for address entry into your application. If you are inserting into a
word processor, an envelope label, or other free text application you should leave this as unlimited unless the address has to fit into a certain number of fields. If you have enough fields to cover all lines of the address that you will be inserting, then again it can be left as unlimited. Should you have a limited number of lines for address entry, for example because you are inserting into an existing application or database that you can’t modify to fit the address, then specifying this will enable Postcode to ensure the address fits in the number of fields that your application has.
On this screen you can specify the fields that you wish to be inserted into your application when you use Insert or Robot. The default fields are those from Street through to Postcode, the address data provided by Postcode. If you specified less than 5 fields for address entry on the previous screen, the Postal County will not be included as it is not a required address field. You can add and remove any fields you require and if you have specified that you have less fields then you have mapped Postcode will attempt to fit them all in. You may wish to map Organisation and Property if your application has those fields as while Postcode does not contain that data you can enter it in Postcode yourself of comma separate it with the postcode with Robot (e.g. entering AFD Software Ltd,IM7 2DZ).
Standard/Special Fields Under the ‘Available Fields’ caption there are options to view the Standard or Special fields. This changes the list displayed below. You can mix and match these fields by adding fields from either one to the ‘Fields To Use’ list. The standard fields are the normal Postcode fields including the current County option. The special fields are more advanced fields including the raw PAF style dependant thoroughfare and thoroughfare fields (this is the street split into two fields if there are two street names in the address), etc., the rest of the county field types, and the outcode and incode portions of the postcode (the part before and after the space respectively). These are useful for applications that store addresses in such formats.
Transferring fields to/from the ‘Fields To Use’ List You can easily transfer fields to and from the ‘Fields To Use’ list by using the arrow buttons between the two lists. These are used as follows:
After the fields to transfer stage you will be informed that you have completed the setup of the application and Postcode is ready to store your settings for your application. Clicking on the Finish button will save your settings and you can now start to use Postcode with your application using Insert (select your application from the Insert menu once you have located the address to insert in Postcode), or Robot (type the postcode directly into your application).
Should you wish to review any of your settings before saving them, use the Back button to navigate back through the previous Wizard screens.
If you need to modify the settings for your application, or you find it doesn’t quite work as you require it to, then simply select ‘Insert / Robot Settings’ from the File menu again, but this time select ‘Advanced Setup’ to modify your settings. Full details of the Advanced Setup is given in the section below.
For speed of setup, it is recommended that the Insert and Robot Wizard is used first to configure an application for use with the Insert and Robot features of Postcode. If you need to change anything with your settings or you have more advanced requirements, either due to how you wish the address to be inserted or because of the way the application is laid out, you can then use the Advanced Setup to modify your settings accordingly and use more advanced features that the Wizard may not include. You can also setup an application for scratch if desired using the Advanced Setup.
To configure an application to work with Postcode using the Advanced Setup elect the ‘Insert / Robot Setup’ option from the File menu. Then on the first Wizard screen select the ‘Advanced Setup’ button. The Advanced Setup screen will then appear:
The first thing to do is to select the application settings that you wish to modify. At the top left of this screen the ‘Application’ drop-down lists all the application settings present. You can use this to select the application you wish to modify. If you wish to add a New application without using the Wizard you can use the ‘New’ button to do this. The ‘Remove’ button can be used to delete a setting if required. If you do select the New button the following dialogue will appear:
Here you select the window title of your application. This is used by Postcode to identify the application so that both Insert and Robot can use these settings when asked to insert into your application. The window title is the text that appears in the main blue window title bar of your application. This text should always be in the window title, and so should not necessarily be the complete title. For example, you might find Word has a title bar of ‘Document 1 – Microsoft Word’, however when you save your file it could, for example, change to ‘MyDoc.doc – Microsoft Word’. Therefore by setting the Application Window Title to ‘Microsoft Word’ you will ensure that Postcode can always recognise your application. If your application is running when you press the New button you should find your application title is listed in the drop down list box provided. Postcode will attempt to remove known document titles leaving only the application name, however if it has not you should alter the title yourself.
The options provided below allow you to specify a name for your application if desired. Normally you can leave the first option to ‘Use the application window title above to identify these settings’ as the Application Window Title will be the name of the application. However in some cases the windows title text might be obscure so you might prefer to choose to enter a more friendly application name. This name doesn’t affect the Insert or Robot process itself, however it might be useful to specify a name for the application so that you will easily recognise it when altering the application settings.
The last item allows you to select existing settings to use as a starting point. You can choose not to use any (select, ‘(None)’, the first item from the drop down list), but it is usually easier to use something as a starting point rather than starting from a blank set of settings. You should therefore use one from the most similar application listed.
Field Mappings are shown in the light yellow boxes under the heading ‘Fields’. You can drag and drop fields from the ‘Postcode Fields’ list on the right to this list. Items can also be dragged off the list back to the ‘Postcode Fields’ list if you wish to remove them. Multiple Postcode fields can be dragged to a single Field in your application if required.
Above the Postcode Field’s List you will see there are options to display Standard or Special fields. This option changes the list displayed below. You can mix and match these fields by adding fields from either one to the ‘Fields To Use’ list. The standard fields are the normal Postcode fields including the current County option. The special fields are more advanced fields including the raw PAF style dependant thoroughfare and thoroughfare fields (this is the street split into two fields if there are two street names in the address), etc., the rest of the county field types, and the outcode and incode portions of the postcode (the part before and after the space respectively). These are useful for applications that store addresses in such formats.
To the left and right of each field respectively, you can specify the keystrokes that are required before and/or after the Field has been entered into the application. If a keyboard shortcut or keystroke is not available to move a particular field, you can also configure AFD Postcode to use a mouse click instead as long as the window is not scrollable – e.g. a website where the position to click might vary. Prior to the first field you may wish to enter any Before keystrokes or a mouse click that is needed to take you to the first field in the application to start inserting from,. This is especially useful if the application may not be in the correct field when Insert is used or if the postcode is not going to be entered in the first address field with Robot.
The keystrokes are specified using our fully flexible macro language. To easily select keystrokes to use for this, click the ‘…’ button next to the Before or After field you are entering keystrokes for. The following dialog will then be displayed:
Clicking on any item in the list of possible keystrokes will add the selected item to the keystrokes to use text box. You can also type any normal keyboard key, for example letters, numbers in that box yourself. When you have entered the relevant keystroke’s you can press OK to update the text field on the Advanced Setup screen.
If you need to press a key with the Alt, Ctrl or Shift keys also pressed down you can select the symbols for this from the end of the keystrokes list on the keystrokes dialogue to apply them to the keystroke following the symbol.
To specify repeating keys, use the form {key number}. You must put a space between key and number. For example, {LEFT 4} means press the Left Arrow key 4 times; {TAB 3} means press the Tab key 3 times.
Should you need to use a mouse click instead, simply select the ‘Mouse Click’ option:
From here you can click the ‘Set A New Position’ button and then click in the field in your application that you wish to move to and AFD Postcode will record this for you. It is advisable to click in the middle of the field rather then near the edge.
For most address fields (but not for data expected always in capital letters – like Postcodes), Postcode will attempt to provide properly capitalised fields.
If you prefer for one or more fields to be inserted only in Capital Letters, check the Case check box to the right of the After keystrokes box for the field(s) that you wish to Insert that field in upper case. A Royal Mail approved address prints the Town field in this format – though many typists prefer not to use this format when typing letters.
The ‘Line Squeeze’ option at the top of the dialogue applies to all fields mapped. If this option is enabled, Postcode will not insert any blank lines in the address (i.e. not even the Before or After keystrokes will be used). This is useful for inserting the address for things such as labels where blank lines aren’t desirable. For formatted address entry, e.g. into a database, it is better not to use this functionality as address consistency can be more important.
Should you wish to squeeze groups of fields, for example you have a fixed Town and Postcode field but you wish to squeeze together the fields above that, then you can check the ‘Squeeze’ option to the left of the yellow field mappings text field for the consecutive fields that you wish to squeeze together. However many fields are mapped in the space to the right of those in the Squeeze group will be inserted into the number of fields that have Squeeze checked.
More advanced settings to allow complete flexibility over the way Insert and Robot work which you may require can be found by pressing the ‘Additional Options’ button at the top right of the Advanced Setup screen. This will present you with the following dialogue:
Normally only a single window title will be associated with an Application. This is the one you specified when you added the application using the Wizard or the New button on the Advanced Setup screen. In some cases however, such as that shown above which is the WP setting used for multiple word processors, you may wish to have multiple window titles associated with a single application setting. These can be added by using the ‘Add’ button from this screen. The Edit and Remove buttons also allow you to Edit and Remove window titles as required.
These settings allow you to specify options for each window title associated with this application. Where there is only one window title these are the application settings, however when multiple titles exist such as that shown above, you can specify differing settings for each title if desired. The settings given here are as follows:
These settings cover the whole application, regardless of if multiple window titles are selected. They are advanced options that you may wish to use to customise the way Postcode inserts data into your application. The settings given here are as follows:
These settings do not affect the application settings currently being modified, but tell Postcode what to use if no settings has been specified for a particular application that is used, they are also the settings used for determining display options in Postcode itself where needed. You can select the Default settings from the drop-down here. You can also specify if these settings will be used as the default for Inserting, if this is not enabled then Postcode will not Insert into any application that does not have settings specified for it. The setting to use the default when using Robot Fast Find also allows Robot Fast Find to be used with any application by using these default settings.
Postcode can pass information to and from another Windows program through Dynamic Data Exchange – even if the application has no programming or ‘macro’ language. Before DDE can operate properly, you must tell Postcode about the program you wish to have a DDE ‘conversation’ with – using the DDE Tab on the Postcode Property window.
To set the DDE Properties, launch the Postcode Properties window from the File menu Properties option (shortcut key [Ctrl]+R).
The first two settings – Application and Topic tell Postcode about the program you wish to establish a DDE conversation with – and the information should be provided in the documentation of that program. You will see that when Postcode is installed, it is set up for use with Symantec’s ACT v3 contact manager program.
Postcode offers 12 fields of data available for a DDE conversation – and these are listed in the list box. For each field which you require, select the field, check-mark the ‘Enable for DDE’ checkbox, and provide the DDE ‘Item Name’ for that field.
Note: The ‘Item Name’ is the name recognised by your program for the Postcode field – e.g. the ‘Postcode’ field may be known as ‘ZipCode’ to your program and your program’s documentation should provide the ‘Item Name’ for you.
Once you have established the DDE settings, you can start a DDE conversation by loading your program, then selecting the View menu Icon for DDE option (shortcut key [Ctrl]+D). This launches a special icon-sized Postcode DDE window, which can be positioned so that it appears to be a tool-bar button on your chosen DDE program. To move the button, click and hold down the RIGHT mouse button, then drag the DDE Icon into position before releasing the mouse button. Postcode will remember this position the next time the DDE Icon is used.
The Postcode Plus DDE Icon – use it like a toolbar button!
To read data FROM your chosen program, simply enter the data in the required fields within that program, then click the DDE Icon with the LEFT mouse button. Postcode will examine the data provided by your program and look up the address for you. For more complex searches, consider using ‘Cut & Paste’ or ‘Drag & Drop’ to instruct Postcode what you wish to search for.
Once Postcode has listed results of a Lookup or Search (whether the data was ‘collected’ from your program using DDE or typed directly into Postcode), you can transfer an address back to your program by double-clicking its entry in the Results List. Using this technique along with your program’s Insert New Record facility will also allow you to transfer many addresses from Postcode to your program, and so build up a mailing list.
You can also use Iconised DDE Mode from the View menu, which works by taking the postcode or search you entered (Please Note: you will need to enter a $ in the postcode field of your application to specify a reverse search) and silently inserting back the first address record into the fields configured for DDE.
Full access to all the data within Postcode is available to programmers through the API. This means that for developers – and even for users of programs like Microsoft Access, etc, postcode lookups can be entirely automatic and invisible.
Using the API will require programming ability – but AFD supply fully working examples (with free source code showing how this can be done) in a variety of popular programming languages – like Microsoft Access, Visual Basic, Delphi and C/C++.
For more details, see the section on the Postcode API
Names & Numbers can also print mailing labels or envelopes for addresses in your Results List. Choose the File menu ‘Print Multiple Labels’ option (shortcut [Ctrl]+P) to launch the Print Labels window.
Your attention is drawn to the Data Extract license fee payable for any mailing labels printed for or on behalf of an organisation covered by a Names & Numbers end-user license.
This part of the window defines the physical layout of each ‘page’ of mailing labels. The right hand side of the window displays a visual representation of how the label sheet is made up – in terms of the number of columns and rows of labels on each page.
You should take care to ensure that you choose labels suitable for all the information to be printed on them – or data and pages may spill-over. If you intend to print Customer Barcodes, these will generally require deeper mailing labels than would otherwise be the case.
You should be aware that the final settings will be influenced by the printer’s own limitations and ‘built in’ margins, by the actual label stock, and by the Windows Printer driver you are using.
Setting up mailing labels therefore usually involves measuring the physical sheet of labels and entering these values into Names & Numbers, then using the Test button, and making minor adjustments to the settings on a trial-and-error basis until a satisfactory result is obtained.
To print a Test Page or the actual Mailing Labels, choose the label settings (see above), then use the Printing Options panel.
Town in Capitals – Royal Mail prefers the Post Town to be printed in CAPITAL LETTERS – which greatly assists mail sorting. Suppress County – It is not necessary to print the postal county if your address contains a postcode. This option instructs Names & Numbers to omit the county from labels, whenever a postcode is present. This saves space on the labels – and is a useful way of helping prevent spill-over of text on labels, especially when Customer Barcodes are used. CBC Barcode – This check-box allows you to optionally switch on Customer Barcode printing. Remember that you will need deeper mailing labels if you are using barcodes! Print at start of each label – This text box allows you to enter text which should be used at the beginning of each label. It is typically used when printing mailing labels for organisations, so that each label can carry the job title of the intended recipient of the mailing – like ‘The Computer Manager’ or ‘The Financial Controller’. Print All, First or Selected Records – Choose whether all the records in the Results list, the first record for each household (ie sharing the same delivery point suffix (DPS)) or just the records you have manually selected from the Results List should be printed. To select records from the Results List manually, use the [Ctrl] key plus the left mouse button to choose multiple records randomly from the list. Cancel – The Cancel button will be enabled during label print runs. If you wish to stop the run, simply click this button. It is not available at other times. Test – The Test button prints a single sheet of labels, using the current settings to help you ensure the settings are correct. Print – Starts the printing of your chosen type of labels – according to the current settings.
To close the Label Printing window, click the close box on the window or press [Alt] + [F4].
Compact View provides a small window to enable you to use the standard lookup facility of Names & Numbers and insert addresses all from a window with a small footprint on your desktop – leaving you with plenty of space on your screen to work with another application at the same time. Addresses can be edited once inserted into your target application if required.
To switch to Compact View, select Compact from the View menu (or press [Ctrl]+W).
To return to Normal View (i.e. the standard Names & Numbers screen size) press [Ctrl]+W whilst in Compact View or click the Close button.
If you’d like Compact View to remain on top of all other applications then select ‘On Top’ ([Ctrl]+T) from the Names & Numbers View Menu before switching to Compact View.
To lookup an address simply type the postcode or search (e.g. Commercial Street, Birmingham) into the Find box just as you would in Normal View. Postcodes will be looked up automatically as you type them. For other lookups press the ‘Enter’ key or click the ‘Lookup’ button once you have completed typing your lookup.
If you’d like to change the county option, or other options that relate to how the address is returned or displayed then set this up from the Normal View.
Pressing the Insert button or pressing F2 will insert the address currently displayed into the default application using the settings file specified by the chosen association for that application, or the settings file currently open where no association for that application exists. Settings can be changed from Normal View. The default application will be the last application you inserted into.
If you have not inserted into an application then you will be presented with a pop-up menu from which to insert the application from. If you wish to change the application that Compact Mode inserts into then right click the Insert button and the pop-up list will be displayed for you to select an application from. This list is the same as that displayed on the Insert menu of the Normal View.
If you prefer Postcode to float ‘On Top’ of other Windows programs – even when you are not working directly in Postcode, select the View menu On Top option (shortcut key [Ctrl]+T). Postcode will display a check-mark next to this option whilst it is in use.
Postcode allows a shortcut key to be used to quickly access the Postcode application. To configure or view the currently assigned Hotkey setting, select the File menu Properties option. ([Crtl]+R)
Enabling the Hotkey allows Postcode to be activated on pressing the configured Hotkey even if it is not already running.
Care should be taken in ensuring the Hotkey is assigned to a key combination that will not conflict with shortcut keys used by other applications (for example [Ctrl]+P is often used as a shortcut to print so if you assign [Ctrl]+P then you won’t be able to use that shortcut key to print from applications).
Please note WinKey refers to the Windows Key on your keyboard.
With printable characters, simply press the key in the ‘Key’ box to use that key with Postcode, for non-printable characters such as F1, Insert, Print Screen etc. enter the code in curly brackets as shown in the following table:
Backspace {BS} Enter/Return {ENTER} Page Up {PGUP} Page Down {PGDN} Home {HOME} End {END} Left Arrow {LEFT} Right Arrow {RIGHT} Up Arrow {UP} Down Arrow {DOWN} F# (Function Keys){F#} Insert {INSERT} Left Menu Key {LMENU} Right Menu Key {RMENU}
The Hotkey is fully configurable and can be configured to be used with any keyboard key.
Please note: Some have been omitted because they would cause problems with Windows.
However any key on any keyboard can be used, email support@afd.co.uk, or phone the AFD Support Team (01624 811712) if you need help setting up the Hotkey.
Names & Numbers contains grid references for most Postcodes in PAF (Some postcodes, such as PO Boxes as they are non-geographical, do not have Grid References). Also displayed is the latitude and longitude values corresponding to these grid references. This is in WGS84 format which is most commonly used by GPS units. You can change the options for how these grid references and latitude and longitude values are displayed from the Properties screen, accessible from by selecting Properties from the File menu.
Here you can choose how grid references are displayed. By default British grid references are used for British postcodes and Irish Grids for Irish Postcodes. However in some cases you might wish to standardise on one or the other, for example when comparing linear distances between them so you can select to always use either GB (British) or NI (Irish) grid references.
Also available is the option to use an approximation for the locality or town an address is located in when a grid reference is not available. This is of course a lot less precise in the case where a grid reference is not available for the postcode itself, but may be more useful than a blank grid reference for uses such as finding distances, locating an address on the Map etc.
These grid reference options are made use of on the Results tab and the Map tab and taken account of in Inserting addresses as well. However it should be noted that the Nearest function always uses GB Grid references for consistency across the whole UK in determining distances.
For the latitude and longitude display and for inserting these values you can choose if you wish to use the decimal or degrees, minutes and seconds display. Generally the decimal display is more useful for entering into other programs etc, but the degrees display is more easily readable.
For more information about Grid References see the Grid References Appendix.
Export
Names & Numbers can export address data ready for use in word-processors for mail-merge or for import into spreadsheets and databases.
Your attention is drawn to the Data Extract license fee payable for any data extracted for use on a computer system covered by a Names & Numbers end-user license. It is not permissible to extract data for any other purpose.
Select the File menu Export option (shortcut key [Ctrl]+E), and choose a suitable file name. Export files are stored as ‘Quoted Comma Separated ASCII’ text files – which can be easily read by most word-processors, spreadsheets and database programs.
Exporting Addresses
The following Export options are available:
Append Records if File Exists This option is useful if you wish to build up a file based on a number of different searches in Names & Numbers. By default, if you select the same filename as an existing file Names & Numbers will overwrite that file with your new results. However, if this option is checked then the results exported will instead be added to the end of the existing file.
Remove Blank Address Lines This feature is similar to Names & Numbers Insert Settings Line Squeeze option – in that it will remove blank lines from addresses as they are stored. This will be useful for creating export files to be used in word-processors, but would not be required if your file is to be imported into a database – where the position of the address fields would be important.
Settings This option is useful when you wish to export special fields, such as the building number separate from the other address information or need the data in some particular format and order for whatever reason. Rather than the default ‘All Fields’ setting you can select any of the Insert/Robot settings stored in Names & Numbers. The fields specified in that setting set will be used (ignoring the Before and After keystrokes). To add a new setting specifically for export simply add a settings set for an arbitrary application and then select that set from here. For information regarding how to setup an Insert or Robot settings set please refer to the Insert section of this manual.
Export All, First or Selected Records Choose whether all the records in the Results List, the first record for each household (ie sharing the same delivery point suffix (DPS)) or just the records you have manually selected from the Results List should be exported.
To select records from the Results List manually, use the [Ctrl] key plus the left mouse button to choose multiple records randomly from the list.
The following entries can be added as part of the ‘Target’ or ‘Command Line’ when launching Names & Numbers, allowing you to specify your preferences for a particular use of the program:
| /Lookup=37,AB31 5TJ | Looks up ’37,AB31 5TJ’ immediately after loading |
| /Settings=WP | Specifies the Settings File to be loaded is ‘WP’ |
| /Splash=No | Suppresses the display of the Splash Screen when loading |
| /Tab=1 | Sets Tab 1 (the Search Tab) to be displayed after loading |
These commands can executed from the Start Menu, Run by typing something similar to the text below into the the
Run box:
c:\afdpcnn\afdpcnn.exe /Lookup 37,AB31 5TJ /Settings=WP /Splash=No /Tab=1
| Shortcut Key | Function |
|---|---|
| [Alt] + [F4] | Close Names & Numbers |
| [Esc] | Cancel Lookup, List or Search |
| [F1] | Help |
| [F2] | Insert current address into target application |
| [F5] | Refresh Insert Menu |
| [Alt] + 1 | Switch to Search Tab |
| [Alt] + 2 | Switch to Results Tab |
| [Alt] + 3 | Switch to More Tab |
| [Alt] + 4 | Switch to Label Tab |
| [Alt] + 5 | Switch to Map Tab |
| [Alt] + 6 | Switch to Nearest Tab |
| [Alt] + 7 | Switch to Cameo Tab |
| [Alt] + B | Switch Barcode on/off |
| [Alt] + C | Clear Results List |
| [Alt] + D | Jump to Find Box |
| [Alt] + E | Activate Edit menu |
| [Alt] + F | Activate File menu |
| [Alt] + H | Activate Help menu |
| [Alt] + I | Activate Insert menu |
| [Alt] + L | Lookup using current Findbox contents |
| [Alt] + N | Activate Nearest Menu |
| [Alt] + R | Print single mailing label |
| [Alt] + S | Search using the address data entered on the ‘Search’ tab |
| [Alt] + V | Activate View menu |
| [Ctrl] + [Insert] | Copy current field to Clipboard |
| [Shift] + [Insert] | Paste current Clipboard contents to field |
| [Ctrl] + A | Add Nearest Records |
| [Ctrl] + C | Copy current address to Clipboard |
| [Ctrl] + D | View icon for DDE |
| [Ctrl] + E | Export address as ASCII |
| [Ctrl] + F | Filter Nearest Records |
| [Ctrl] + G | Save current settings |
| [Ctrl] + K | Delete Nearest Records |
| [Ctrl] + M | Toggle Distance Line |
| [Ctrl] + O | Open (use) a Settings set |
| [Ctrl] + P | Print Mailing Labels |
| [Ctrl] + Q | Set Search Quantity |
| [Ctrl] + R | View or Alter Properties |
| [Ctrl] + S | Save Currently Displayed Nearest Record |
| [Ctrl] + T | Switch ‘On Top’ mode on/off |
| [Ctrl] + X | View Examples List |
| Function | Shortcut Key |
|---|---|
| Add Nearest Records | [Ctrl] + A |
| Barcode: switch on/off | [Alt] + B |
| Cameo Tab | [Alt] + 7 |
| Cancel Lookup, List, or Search | [Esc] |
| Copy current address to Clipboard | [Ctrl] + C |
| Copy current field to Clipboard | [Ctrl] + [Insert] |
| Clear Results List | [Alt] + C |
| Close Names & Numbers | [Alt] + [F4] |
| DDE: view Icon for | [Ctrl] + D |
| Delete Nearest Records | [Ctrl] + K |
| Edit menu | [Alt] + E |
| Examples List | [Ctrl] + X |
| Export addresses as ASCII | [Ctrl] + E |
| File menu | [Alt] + F |
| Filter Nearest Records | [Ctrl] + F |
| Find Box – jump to | [Alt] + D |
| Help | [F1] |
| Help menu | [Alt] + H |
| Insert current address into target application | [F2] |
| Insert menu | [Alt] + I |
| Label Tab | [Alt] + 4 |
| Lookup using current Findbox contents | [Alt] + L |
| Map Tab | [Alt] + 5 |
| More Tab | [Alt] + 3 |
| Nearest Menu | [Alt] + N |
| Nearest Tab | [Alt] + 6 |
| On Top Mode: switch on/off | [Ctrl] + T |
| Open (use) a Settings set | [Ctrl] + O |
| Paste current Clipboard contents to field | [Shift] + [Insert] |
| Print mailing labels (multi) | [Ctrl] + P |
| Print mailing labels (single) | [Alt] + R |
| Properties – view or alter | [Ctrl] + R |
| Quantity to Search | [Ctrl] + Q |
| Refresh Insert menu | [F5] |
| Results Tab | [Alt] + 2 |
| Save a Settings set | [Ctrl] + G |
| Save Currently Displayed Nearest Record | [Ctrl] + S |
| Search using current Search Settings | [Alt] + S |
| Search Tab | [Alt] + 1 |
| Toggle Distance Line | [Ctrl] + M |
| View menu | [Alt] + V |
Note: The table below contains a complete list of SIC 2007 codes and descriptions. Please note, only SIC Codes which have at least one corresponding business record appear in the AFD Names & Numbers product.
| AGRICULTURE, FORESTRY AND FISHING | |
| 01000 | CROP AND ANIMAL PRODUCTION, HUNTING AND RELATED SERVICE ACTIVITIES |
| 01100 | Growing of non-perennial crops |
| 01110 | Growing of cereals (except rice), leguminous crops and oil seeds |
| 01120 | Growing of rice |
| 01130 | Growing of vegetables and melons, roots and tubers |
| 01140 | Growing of sugar cane |
| 01150 | Growing of tobacco |
| 01160 | Growing of fibre crops |
| 01190 | Growing of other non-perennial crops |
| 01200 | Growing of perennial crops |
| 01210 | Growing of grapes |
| 01220 | Growing of tropical and subtropical fruits |
| 01230 | Growing of citrus fruits |
| 01240 | Growing of pome fruits and stone fruits |
| 01250 | Growing of other tree and bush fruits and nuts |
| 01260 | Growing of oleaginous fruits |
| 01270 | Growing of beverage crops |
| 01280 | Growing of spices, aromatic, drug and pharmaceutical crops |
| 01290 | Growing of other perennial crops |
| 01300 | Plant propagation |
| 01300 | Plant propagation |
| 01400 | Animal production |
| 01410 | Raising of dairy cattle |
| 01420 | Raising of other cattle and buffaloes |
| 01430 | Raising of horses and other equines |
| 01440 | Raising of camels and camelids |
| 01450 | Raising of sheep and goats |
| 01460 | Raising of swine/pigs |
| 01470 | Raising of poultry |
| 01490 | Raising of other animals |
| 01500 | Mixed farming |
| 01500 | Mixed farming |
| 01600 | Support activities to agriculture and post-harvest crop activities |
| 01610 | Support activities for crop production |
| 01620 | Support activities for animal production |
| 01621 | Farm animal boarding and care |
| 01629 | Support activities for animal production (other than farm animal boarding and care) n.e.c. |
| 01630 | Post-harvest crop activities |
| 01640 | Seed processing for propagation |
| 01700 | Hunting, trapping and related service activities |
| 01700 | Hunting, trapping and related service activities |
| 02000 | FORESTRY AND LOGGING |
| 02100 | Silviculture and other forestry activities |
| 02100 | Silviculture and other forestry activities |
| 02200 | Logging |
| 02200 | Logging |
| 02300 | Gathering of wild growing non-wood products |
| 02300 | Gathering of wild growing non-wood products |
| 02400 | Support services to forestry |
| 02400 | Support services to forestry |
| 03000 | FISHING AND AQUACULTURE |
| 03100 | Fishing |
| 03110 | Marine fishing |
| 03120 | Freshwater fishing |
| 03200 | Aquaculture |
| 03210 | Marine aquaculture |
| 03220 | Freshwater aquaculture |
| MINING AND QUARRYING | |
| 05000 | MINING OF COAL AND LIGNITE |
| 05100 | Mining of hard coal |
| 05100 | Mining of hard coal |
| 05101 | Mining of hard coal from deep coal mines (underground mining) |
| 05102 | Mining of hard coal from open cast coal working (surface mining) |
| 05200 | Mining of lignite |
| 05200 | Mining of lignite |
| 06000 | EXTRACTION OF CRUDE PETROLEUM AND NATURAL GAS |
| 06100 | Extraction of crude petroleum |
| 06100 | Extraction of crude petroleum |
| 06200 | Extraction of natural gas |
| 06200 | Extraction of natural gas |
| 07000 | MINING OF METAL ORES |
| 07100 | Mining of iron ores |
| 07100 | Mining of iron ores |
| 07200 | Mining of non-ferrous metal ores |
| 07210 | Mining of uranium and thorium ores |
| 07290 | Mining of other non-ferrous metal ores |
| 08000 | OTHER MINING AND QUARRYING |
| 08100 | Quarrying of stone, sand and clay |
| 08110 | Quarrying of ornamental and building stone, limestone, gypsum, chalk and slate |
| 08120 | Operation of gravel and sand pits; mining of clays and kaolin |
| 08900 | Mining and quarrying n.e.c. |
| 08910 | Mining of chemical and fertiliser minerals |
| 08920 | Extraction of peat |
| 08930 | Extraction of salt |
| 08990 | Other mining and quarrying n.e.c. |
| 09000 | MINING SUPPORT SERVICE ACTIVITIES |
| 09100 | Support activities for petroleum and natural gas extraction |
| 09100 | Support activities for petroleum and natural gas extraction |
| 09900 | Support activities for other mining and quarrying |
| 09900 | Support activities for other mining and quarrying |
| MANUFACTURING | |
| 10000 | MANUFACTURE OF FOOD PRODUCTS |
| 10100 | Processing and preserving of meat and production of meat products |
| 10110 | Processing and preserving of meat |
| 10120 | Processing and preserving of poultry meat |
| 10130 | Production of meat and poultry meat products |
| 10200 | Processing and preserving of fish, crustaceans and molluscs |
| 10200 | Processing and preserving of fish, crustaceans and molluscs |
| 10300 | Processing and preserving of fruit and vegetables |
| 10310 | Processing and preserving of potatoes |
| 10320 | Manufacture of fruit and vegetable juice |
| 10390 | Other processing and preserving of fruit and vegetables |
| 10400 | Manufacture of vegetable and animal oils and fats |
| 10410 | Manufacture of oils and fats |
| 10420 | Manufacture of margarine and similar edible fats |
| 10500 | Manufacture of dairy products |
| 10510 | Operation of dairies and cheese making |
| 10511 | Liquid milk and cream production |
| 10512 | Butter and cheese production |
| 10519 | Manufacture of milk products (other than liquid milk and cream, butter, cheese) n.e.c. |
| 10520 | Manufacture of ice cream |
| 10600 | Manufacture of grain mill products, starches and starch products |
| 10610 | Manufacture of grain mill products |
| 10611 | Grain milling |
| 10612 | Manufacture of breakfast cereals and cereals-based foods |
| 10620 | Manufacture of starches and starch products |
| 10700 | Manufacture of bakery and farinaceous products |
| 10710 | Manufacture of bread; manufacture of fresh pastry goods and cakes |
| 10720 | Manufacture of rusks and biscuits; manufacture of preserved pastry goods and cakes |
| 10730 | Manufacture of macaroni, noodles, couscous and similar farinaceous products |
| 10800 | Manufacture of other food products |
| 10810 | Manufacture of sugar |
| 10820 | Manufacture of cocoa, chocolate and sugar confectionery |
| 10821 | Manufacture of cocoa, and chocolate confectionery |
| 10822 | Manufacture of sugar confectionery |
| 10830 | Processing of tea and coffee |
| 10831 | Tea processing |
| 10832 | Production of coffee and coffee substitutes |
| 10840 | Manufacture of condiments and seasonings |
| 10850 | Manufacture of prepared meals and dishes |
| 10860 | Manufacture of homogenised food preparations and dietetic food |
| 10890 | Manufacture of other food products n.e.c. |
| 10900 | Manufacture of prepared animal feeds |
| 10910 | Manufacture of prepared feeds for farm animals |
| 10920 | Manufacture of prepared pet foods |
| 11000 | MANUFACTURE OF BEVERAGES |
| 11000 | Manufacture of beverages |
| 11010 | Distilling, rectifying and blending of spirits |
| 11020 | Manufacture of wine from grape |
| 11030 | Manufacture of cider and other fruit wines |
| 11040 | Manufacture of other non-distilled fermented beverages |
| 11050 | Manufacture of beer |
| 11060 | Manufacture of malt |
| 11070 | Manufacture of soft drinks; production of mineral waters and other bottled waters |
| 12000 | MANUFACTURE OF TOBACCO PRODUCTS |
| 12000 | Manufacture of tobacco products |
| 12000 | Manufacture of tobacco products |
| 13000 | MANUFACTURE OF TEXTILES |
| 13100 | Preparation and spinning of textile fibres |
| 13100 | Preparation and spinning of textile fibres |
| 13200 | Weaving of textiles |
| 13200 | Weaving of textiles |
| 13300 | Finishing of textiles |
| 13300 | Finishing of textiles |
| 13900 | Manufacture of other textiles |
| 13910 | Manufacture of knitted and crocheted fabrics |
| 13920 | Manufacture of made-up textile articles, except apparel |
| 13921 | Manufacture of soft furnishings |
| 13922 | Manufacture of canvas goods, sacks etc. |
| 13923 | Manufacture of household textiles (other than soft furnishings of 13.92/1) |
| 13930 | Manufacture of carpets and rugs |
| 13931 | Manufacture of woven or tufted carpets and rugs |
| 13939 | Manufacture of carpets and rugs (other than woven or tufted) n.e.c. |
| 13940 | Manufacture of cordage, rope, twine and netting |
| 13950 | Manufacture of non-wovens and articles made from non-wovens, except apparel |
| 13960 | Manufacture of other technical and industrial textiles |
| 13990 | Manufacture of other textiles n.e.c. |
| 14000 | MANUFACTURE OF WEARING APPAREL |
| 14100 | Manufacture of wearing apparel, except fur apparel |
| 14110 | Manufacture of leather clothes |
| 14120 | Manufacture of workwear |
| 14130 | Manufacture of other outerwear |
| 14131 | Manufacture of men’s outerwear, other than leather clothes and workwear |
| 14132 | Manufacture of women’s outerwear, other than leather clothes and workwear |
| 14140 | Manufacture of underwear |
| 14141 | Manufacture of men’s underwear |
| 14142 | Manufacture of women’s underwear |
| 14190 | Manufacture of other wearing apparel and accessories |
| 14200 | Manufacture of articles of fur |
| 14200 | Manufacture of articles of fur |
| 14300 | Manufacture of knitted and crocheted apparel |
| 14310 | Manufacture of knitted and crocheted hosiery |
| 14390 | Manufacture of other knitted and crocheted apparel |
| 15000 | MANUFACTURE OF LEATHER AND RELATED PRODUCTS |
| 15100 | Tanning and dressing of leather; manufacture of luggage, handbags, saddlery and harness; dressing and dyeing of fur |
| 15110 | Tanning and dressing of leather; dressing and dyeing of fur |
| 15120 | Manufacture of luggage, handbags and the like, saddlery and harness |
| 15200 | Manufacture of footwear |
| 15200 | Manufacture of footwear |
| 16000 | MANUFACTURE OF WOOD AND OF PRODUCTS OF WOOD AND CORK, EXCEPT FURNITURE; MANUFACTURE OF ARTICLES OF STRAW AND PLAITING MATERIALS |
| 16100 | Sawmilling and planing of wood |
| 16100 | Sawmilling and planing of wood |
| 16200 | Manufacture of products of wood, cork, straw and plaiting materials |
| 16210 | Manufacture of veneer sheets and wood-based panels |
| 16220 | Manufacture of assembled parquet floors |
| 16230 | Manufacture of other builders’ carpentry and joinery |
| 16240 | Manufacture of wooden containers |
| 16290 | Manufacture of other products of wood; manufacture of articles of cork, straw and plaiting materials |
| 17000 | MANUFACTURE OF PAPER AND PAPER PRODUCTS |
| 17100 | Manufacture of pulp, paper and paperboard |
| 17110 | Manufacture of pulp |
| 17120 | Manufacture of paper and paperboard |
| 17200 | Manufacture of articles of paper and paperboard |
| 17210 | Manufacture of corrugated paper and paperboard and of containers of paper and paperboard |
| 17211 | Manufacture of corrugated paper and paperboard; manufacture of sacks and bags of paper |
| 17219 | Manufacture of paper and paperboard containers other than sacks and bags |
| 17220 | Manufacture of household and sanitary goods and of toilet requisites |
| 17230 | Manufacture of paper stationery |
| 17240 | Manufacture of wallpaper |
| 17290 | Manufacture of other articles of paper and paperboard |
| 18000 | PRINTING AND REPRODUCTION OF RECORDED MEDIA |
| 18100 | Printing and service activities related to printing |
| 18110 | Printing of newspapers |
| 18120 | Other printing |
| 18121 | Manufacture of printed labels |
| 18129 | Printing (other than printing of newspapers and printing on labels and tags) n.e.c. |
| 18130 | Pre-press and pre-media services |
| 18140 | Binding and related services |
| 18200 | Reproduction of recorded media |
| 18200 | Reproduction of recorded media |
| 18201 | Reproduction of sound recording |
| 18202 | Reproduction of video recording |
| 18203 | Reproduction of computer media |
| 19000 | MANUFACTURE OF COKE AND REFINED PETROLEUM PRODUCTS |
| 19100 | Manufacture of coke oven products |
| 19100 | Manufacture of coke oven products |
| 19200 | Manufacture of refined petroleum products |
| 19200 | Manufacture of refined petroleum products |
| 19201 | Mineral oil refining |
| 19209 | Other treatment of petroleum products (excluding mineral oil refining/petrochemicals manufacture) |
| 20000 | MANUFACTURE OF CHEMICALS AND CHEMICAL PRODUCTS |
| 20100 | Manufacture of basic chemicals, fertilisers and nitrogen compounds, plastics and synthetic rubber in primary forms |
| 20110 | Manufacture of industrial gases |
| 20120 | Manufacture of dyes and pigments |
| 20130 | Manufacture of other inorganic basic chemicals |
| 20140 | Manufacture of other organic basic chemicals |
| 20150 | Manufacture of fertilisers and nitrogen compounds |
| 20160 | Manufacture of plastics in primary forms |
| 20170 | Manufacture of synthetic rubber in primary forms |
| 20200 | Manufacture of pesticides and other agrochemical products |
| 20200 | Manufacture of pesticides and other agrochemical products |
| 20300 | Manufacture of paints, varnishes and similar coatings, printing ink and mastics |
| 20300 | Manufacture of paints, varnishes and similar coatings, printing ink and mastics |
| 20301 | Manufacture of paints, varnishes and similar coatings, mastics and sealants |
| 20302 | Manufacture of printing ink |
| 20400 | Manufacture of soap and detergents, cleaning and polishing preparations, perfumes and toilet preparations |
| 20410 | Manufacture of soap and detergents, cleaning and polishing preparations |
| 20411 | Manufacture of soap and detergents |
| 20412 | Manufacture of cleaning and polishing preparations |
| 20420 | Manufacture of perfumes and toilet preparations |
| 20500 | Manufacture of other chemical products |
| 20510 | Manufacture of explosives |
| 20520 | Manufacture of glues |
| 20530 | Manufacture of essential oils |
| 20590 | Manufacture of other chemical products n.e.c. |
| 20600 | Manufacture of man-made fibres |
| 20600 | Manufacture of man-made fibres |
| 21000 | MANUFACTURE OF BASIC PHARMACEUTICAL PRODUCTS AND PHARMACEUTICAL PREPARATIONS |
| 21100 | Manufacture of basic pharmaceutical products |
| 21100 | Manufacture of basic pharmaceutical products |
| 21200 | Manufacture of pharmaceutical preparations |
| 21200 | Manufacture of pharmaceutical preparations |
| 22000 | MANUFACTURE OF RUBBER AND PLASTIC PRODUCTS |
| 22100 | Manufacture of rubber products |
| 22110 | Manufacture of rubber tyres and tubes; retreading and rebuilding of rubber tyres |
| 22190 | Manufacture of other rubber products |
| 22200 | Manufacture of plastics products |
| 22210 | Manufacture of plastic plates, sheets, tubes and profiles |
| 22220 | Manufacture of plastic packing goods |
| 22230 | Manufacture of builders’ ware of plastic |
| 22290 | Manufacture of other plastic products |
| 23000 | MANUFACTURE OF OTHER NON-METALLIC MINERAL PRODUCTS |
| 23100 | Manufacture of glass and glass products |
| 23110 | Manufacture of flat glass |
| 23120 | Shaping and processing of flat glass |
| 23130 | Manufacture of hollow glass |
| 23140 | Manufacture of glass fibres |
| 23190 | Manufacture and processing of other glass, including technical glassware |
| 23200 | Manufacture of refractory products |
| 23200 | Manufacture of refractory products |
| 23300 | Manufacture of clay building materials |
| 23310 | Manufacture of ceramic tiles and flags |
| 23320 | Manufacture of bricks, tiles and construction products, in baked clay |
| 23400 | Manufacture of other porcelain and ceramic products |
| 23410 | Manufacture of ceramic household and ornamental articles |
| 23420 | Manufacture of ceramic sanitary fixtures |
| 23430 | Manufacture of ceramic insulators and insulating fittings |
| 23440 | Manufacture of other technical ceramic products |
| 23490 | Manufacture of other ceramic products |
| 23500 | Manufacture of cement, lime and plaster |
| 23510 | Manufacture of cement |
| 23520 | Manufacture of lime and plaster |
| 23600 | Manufacture of articles of concrete, cement and plaster |
| 23610 | Manufacture of concrete products for construction purposes |
| 23620 | Manufacture of plaster products for construction purposes |
| 23630 | Manufacture of ready-mixed concrete |
| 23640 | Manufacture of mortars |
| 23650 | Manufacture of fibre cement |
| 23690 | Manufacture of other articles of concrete, plaster and cement |
| 23700 | Cutting, shaping and finishing of stone |
| 23700 | Cutting, shaping and finishing of stone |
| 23900 | Manufacture of abrasive products and non-metallic mineral products n.e.c. |
| 23910 | Production of abrasive products |
| 23990 | Manufacture of other non-metallic mineral products n.e.c. |
| 24000 | MANUFACTURE OF BASIC METALS |
| 24100 | Manufacture of basic iron and steel and of ferro-alloys |
| 24100 | Manufacture of basic iron and steel and of ferro-alloys |
| 24200 | Manufacture of tubes, pipes, hollow profiles and related fittings, of steel |
| 24200 | Manufacture of tubes, pipes, hollow profiles and related fittings, of steel |
| 24300 | Manufacture of other products of first processing of steel |
| 24310 | Cold drawing of bars |
| 24320 | Cold rolling of narrow strip |
| 24330 | Cold forming or folding |
| 24340 | Cold drawing of wire |
| 24400 | Manufacture of basic precious and other non-ferrous metals |
| 24410 | Precious metals production |
| 24420 | Aluminium production |
| 24430 | Lead, zinc and tin production |
| 24440 | Copper production |
| 24450 | Other non-ferrous metal production |
| 24460 | Processing of nuclear fuel |
| 24500 | Casting of metals |
| 24510 | Casting of iron |
| 24520 | Casting of steel |
| 24530 | Casting of light metals |
| 24540 | Casting of other non-ferrous metals |
| 25000 | MANUFACTURE OF FABRICATED METAL PRODUCTS, EXCEPT MACHINERY AND EQUIPMENT |
| 25100 | Manufacture of structural metal products |
| 25110 | Manufacture of metal structures and parts of structures |
| 25120 | Manufacture of doors and windows of metal |
| 25200 | Manufacture of tanks, reservoirs and containers of metal |
| 25210 | Manufacture of central heating radiators and boilers |
| 25290 | Manufacture of other tanks, reservoirs and containers of metal |
| 25300 | Manufacture of steam generators, except central heating hot water boilers |
| 25300 | Manufacture of steam generators, except central heating hot water boilers |
| 25400 | Manufacture of weapons and ammunition |
| 25400 | Manufacture of weapons and ammunition |
| 25500 | Forging, pressing, stamping and roll-forming of metal; powder metallurgy |
| 25500 | Forging, pressing, stamping and roll-forming of metal; powder metallurgy |
| 25600 | Treatment and coating of metals; machining |
| 25610 | Treatment and coating of metals |
| 25620 | Machining |
| 25700 | Manufacture of cutlery, tools and general hardware |
| 25710 | Manufacture of cutlery |
| 25720 | Manufacture of locks and hinges |
| 25730 | Manufacture of tools |
| 25900 | Manufacture of other fabricated metal products |
| 25910 | Manufacture of steel drums and similar containers |
| 25920 | Manufacture of light metal packaging |
| 25930 | Manufacture of wire products, chain and springs |
| 25940 | Manufacture of fasteners and screw machine products |
| 25990 | Manufacture of other fabricated metal products n.e.c. |
| 26000 | MANUFACTURE OF COMPUTER, ELECTRONIC AND OPTICAL PRODUCTS |
| 26100 | Manufacture of electronic components and boards |
| 26110 | Manufacture of electronic components |
| 26120 | Manufacture of loaded electronic boards |
| 26200 | Manufacture of computers and peripheral equipment |
| 26200 | Manufacture of computers and peripheral equipment |
| 26300 | Manufacture of communication equipment |
| 26300 | Manufacture of communication equipment |
| 26301 | Manufacture of telegraph and telephone apparatus and equipment |
| 26309 | Manufacture of communication equipment (other than telegraph and telephone apparatus and equipment) |
| 26400 | Manufacture of consumer electronics |
| 26400 | Manufacture of consumer electronics |
| 26500 | Manufacture of instruments and appliances for measuring, testing and navigation; watches and clocks |
| 26510 | Manufacture of instruments and appliances for measuring, testing and navigation |
| 26511 | Manufacture of electronic instruments and appliances for measuring, testing, and navigation, except industrial process control equipment |
| 26512 | Manufacture of electronic industrial process control equipment |
| 26513 | Manufacture of non-electronic instruments and appliances for measuring, testing and navigation, except industrial process control equipment |
| 26514 | Manufacture of non-electronic industrial process control equipment |
| 26520 | Manufacture of watches and clocks |
| 26600 | Manufacture of irradiation, electromedical and electrotherapeutic equipment |
| 26600 | Manufacture of irradiation, electromedical and electrotherapeutic equipment |
| 26700 | Manufacture of optical instruments and photographic equipment |
| 26700 | Manufacture of optical instruments and photographic equipment |
| 26701 | Manufacture of optical precision instruments |
| 26702 | Manufacture of photographic and cinematographic equipment |
| 26800 | Manufacture of magnetic and optical media |
| 26800 | Manufacture of magnetic and optical media |
| 27000 | MANUFACTURE OF ELECTRICAL EQUIPMENT |
| 27100 | Manufacture of electric motors, generators, transformers and electricity distribution and control apparatus |
| 27110 | Manufacture of electric motors, generators and transformers |
| 27120 | Manufacture of electricity distribution and control apparatus |
| 27200 | Manufacture of batteries and accumulators |
| 27200 | Manufacture of batteries and accumulators |
| 27300 | Manufacture of wiring and wiring devices |
| 27310 | Manufacture of fibre optic cables |
| 27320 | Manufacture of other electronic and electric wires and cables |
| 27330 | Manufacture of wiring devices |
| 27400 | Manufacture of electric lighting equipment |
| 27400 | Manufacture of electric lighting equipment |
| 27500 | Manufacture of domestic appliances |
| 27510 | Manufacture of electric domestic appliances |
| 27520 | Manufacture of non-electric domestic appliances |
| 27900 | Manufacture of other electrical equipment |
| 27900 | Manufacture of other electrical equipment |
| 28000 | MANUFACTURE OF MACHINERY AND EQUIPMENT N.E.C. |
| 28100 | Manufacture of general-purpose machinery |
| 28110 | Manufacture of engines and turbines, except aircraft, vehicle and cycle engines |
| 28120 | Manufacture of fluid power equipment |
| 28130 | Manufacture of other pumps and compressors |
| 28131 | Manufacture of pumps |
| 28132 | Manufacture of compressors |
| 28140 | Manufacture of other taps and valves |
| 28150 | Manufacture of bearings, gears, gearing and driving elements |
| 28200 | Manufacture of other general-purpose machinery |
| 28210 | Manufacture of ovens, furnaces and furnace burners |
| 28220 | Manufacture of lifting and handling equipment |
| 28230 | Manufacture of office machinery and equipment (except computers and peripheral equipment) |
| 28240 | Manufacture of power-driven hand tools |
| 28250 | Manufacture of non-domestic cooling and ventilation equipment |
| 28290 | Manufacture of other general-purpose machinery n.e.c. |
| 28300 | Manufacture of agricultural and forestry machinery |
| 28300 | Manufacture of agricultural and forestry machinery |
| 28301 | Manufacture of agricultural tractors |
| 28302 | Manufacture of agricultural and forestry machinery (other than agricultural tractors) |
| 28400 | Manufacture of metal forming machinery and machine tools |
| 28410 | Manufacture of metal forming machinery |
| 28490 | Manufacture of other machine tools |
| 28900 | Manufacture of other special-purpose machinery |
| 28910 | Manufacture of machinery for metallurgy |
| 28920 | Manufacture of machinery for mining, quarrying and construction |
| 28921 | Manufacture of machinery for mining |
| 28922 | Manufacture of earthmoving equipment |
| 28923 | Manufacture of equipment for concrete crushing and screening roadworks |
| 28930 | Manufacture of machinery for food, beverage and tobacco processing |
| 28940 | Manufacture of machinery for textile, apparel and leather production |
| 28950 | Manufacture of machinery for paper and paperboard production |
| 28960 | Manufacture of plastics and rubber machinery |
| 28990 | Manufacture of other special-purpose machinery n.e.c. |
| 29000 | MANUFACTURE OF MOTOR VEHICLES, TRAILERS AND SEMI-TRAILERS |
| 29100 | Manufacture of motor vehicles |
| 29100 | Manufacture of motor vehicles |
| 29200 | Manufacture of bodies (coachwork) for motor vehicles; manufacture of trailers and semi-trailers |
| 29200 | Manufacture of bodies (coachwork) for motor vehicles; manufacture of trailers and semi-trailers |
| 29201 | Manufacture of bodies (coachwork) for motor vehicles (except caravans) |
| 29202 | Manufacture of trailers and semi-trailers |
| 29203 | Manufacture of caravans |
| 29300 | Manufacture of parts and accessories for motor vehicles |
| 29310 | Manufacture of electrical and electronic equipment for motor vehicles |
| 29320 | Manufacture of other parts and accessories for motor vehicles |
| 30000 | MANUFACTURE OF OTHER TRANSPORT EQUIPMENT |
| 30100 | Building of ships and boats |
| 30110 | Building of ships and floating structures |
| 30120 | Building of pleasure and sporting boats |
| 30200 | Manufacture of railway locomotives and rolling stock |
| 30200 | Manufacture of railway locomotives and rolling stock |
| 30300 | Manufacture of air and spacecraft and related machinery |
| 30300 | Manufacture of air and spacecraft and related machinery |
| 30400 | Manufacture of military fighting vehicles |
| 30400 | Manufacture of military fighting vehicles |
| 30900 | Manufacture of transport equipment n.e.c. |
| 30910 | Manufacture of motorcycles |
| 30920 | Manufacture of bicycles and invalid carriages |
| 30990 | Manufacture of other transport equipment n.e.c. |
| 31000 | MANUFACTURE OF FURNITURE |
| 31000 | Manufacture of furniture |
| 31010 | Manufacture of office and shop furniture |
| 31020 | Manufacture of kitchen furniture |
| 31030 | Manufacture of mattresses |
| 31090 | Manufacture of other furniture |
| 32000 | OTHER MANUFACTURING |
| 32100 | Manufacture of jewellery, bijouterie and related articles |
| 32110 | Striking of coins |
| 32120 | Manufacture of jewellery and related articles |
| 32130 | Manufacture of imitation jewellery and related articles |
| 32200 | Manufacture of musical instruments |
| 32200 | Manufacture of musical instruments |
| 32300 | Manufacture of sports goods |
| 32300 | Manufacture of sports goods |
| 32400 | Manufacture of games and toys |
| 32400 | Manufacture of games and toys |
| 32401 | Manufacture of professional and arcade games and toys |
| 32409 | Manufacture of games and toys (other than professional and arcade games and toys) n.e.c. |
| 32500 | Manufacture of medical and dental instruments and supplies |
| 32500 | Manufacture of medical and dental instruments and supplies |
| 32900 | Other manufacturing n.e.c. |
| 32910 | Manufacture of brooms and brushes |
| 32990 | Other manufacturing n.e.c. |
| 33000 | REPAIR AND INSTALLATION OF MACHINERY AND EQUIPMENT |
| 33100 | Repair of fabricated metal products, machinery and equipment |
| 33110 | Repair of fabricated metal products |
| 33120 | Repair of machinery |
| 33130 | Repair of electronic and optical equipment |
| 33140 | Repair of electrical equipment |
| 33150 | Repair and maintenance of ships and boats |
| 33160 | Repair and maintenance of aircraft and spacecraft |
| 33170 | Repair and maintenance of other transport equipment |
| 33190 | Repair of other equipment |
| 33200 | Installation of industrial machinery and equipment |
| 33200 | Installation of industrial machinery and equipment |
| ELECTRICITY, GAS, STEAM AND AIR CONDITIONING SUPPLY | |
| 35000 | ELECTRICITY, GAS, STEAM AND AIR CONDITIONING SUPPLY |
| 35100 | Electric power generation, transmission and distribution |
| 35110 | Production of electricity |
| 35120 | Transmission of electricity |
| 35130 | Distribution of electricity |
| 35140 | Trade of electricity |
| 35200 | Manufacture of gas; distribution of gaseous fuels through mains |
| 35210 | Manufacture of gas |
| 35220 | Distribution of gaseous fuels through mains |
| 35230 | Trade of gas through mains |
| 35300 | Steam and air conditioning supply |
| 35300 | Steam and air conditioning supply |
| WATER SUPPLY; SEWERAGE, WASTE MANAGEMENT AND REMEDIATION ACTIVITIES | |
| 36000 | WATER COLLECTION, TREATMENT AND SUPPLY |
| 36000 | Water collection, treatment and supply |
| 36000 | Water collection, treatment and supply |
| 37000 | SEWERAGE |
| 37000 | Sewerage |
| 37000 | Sewerage |
| 38000 | WASTE COLLECTION, TREATMENT AND DISPOSAL ACTIVITIES; MATERIALS RECOVERY |
| 38100 | Waste collection |
| 38110 | Collection of non-hazardous waste |
| 38120 | Collection of hazardous waste |
| 38200 | Waste treatment and disposal |
| 38210 | Treatment and disposal of non-hazardous waste |
| 38220 | Treatment and disposal of hazardous waste |
| 38300 | Materials recovery |
| 38310 | Dismantling of wrecks |
| 38320 | Recovery of sorted materials |
| 39000 | REMEDIATION ACTIVITIES AND OTHER WASTE MANAGEMENT SERVICES. |
| 39000 | Remediation activities and other waste management services |
| 39000 | Remediation activities and other waste management services |
| CONSTRUCTION | |
| 41000 | CONSTRUCTION OF BUILDINGS |
| 41100 | Development of building projects |
| 41100 | Development of building projects |
| 41200 | Construction of residential and non-residential buildings |
| 41200 | Construction of residential and non-residential buildings |
| 41201 | Construction of commercial buildings |
| 41202 | Construction of domestic buildings |
| 42000 | CIVIL ENGINEERING |
| 42100 | Construction of roads and railways |
| 42110 | Construction of roads and motorways |
| 42120 | Construction of railways and underground railways |
| 42130 | Construction of bridges and tunnels |
| 42200 | Construction of utility projects |
| 42210 | Construction of utility projects for fluids |
| 42220 | Construction of utility projects for electricity and telecommunications |
| 42900 | Construction of other civil engineering projects |
| 42910 | Construction of water projects |
| 42990 | Construction of other civil engineering projects n.e.c. |
| 43000 | SPECIALISED CONSTRUCTION ACTIVITIES |
| 43100 | Demolition and site preparation |
| 43110 | Demolition |
| 43120 | Site preparation |
| 43130 | Test drilling and boring |
| 43200 | Electrical, plumbing and other construction installation activities |
| 43210 | Electrical installation |
| 43220 | Plumbing, heat and air-conditioning installation |
| 43290 | Other construction installation |
| 43300 | Building completion and finishing |
| 43310 | Plastering |
| 43320 | Joinery installation |
| 43330 | Floor and wall covering |
| 43340 | Painting and glazing |
| 43341 | Painting |
| 43342 | Glazing |
| 43390 | Other building completion and finishing |
| 43900 | Other specialised construction activities |
| 43910 | Roofing activities |
| 43990 | Other specialised construction activities n.e.c. |
| 43991 | Scaffold erection |
| 43999 | Specialised construction activities (other than scaffold erection) n.e.c. |
| WHOLESALE AND RETAIL TRADE; REPAIR OF MOTOR VEHICLES AND MOTORCYCLES | |
| 45000 | WHOLESALE AND RETAIL TRADE AND REPAIR OF MOTOR VEHICLES AND MOTORCYCLES |
| 45100 | Sale of motor vehicles |
| 45110 | Sale of cars and light motor vehicles |
| 45111 | Sale of new cars and light motor vehicles |
| 45112 | Sale of used cars and light motor vehicles |
| 45190 | Sale of other motor vehicles |
| 45200 | Maintenance and repair of motor vehicles |
| 45200 | Maintenance and repair of motor vehicles |
| 45300 | Sale of motor vehicle parts and accessories |
| 45310 | Wholesale trade of motor vehicle parts and accessories |
| 45320 | Retail trade of motor vehicle parts and accessories |
| 45400 | Sale, maintenance and repair of motorcycles and related parts and accessories |
| 45400 | Sale, maintenance and repair of motorcycles and related parts and accessories |
| 46000 | WHOLESALE TRADE, EXCEPT OF MOTOR VEHICLES AND MOTORCYCLES |
| 46100 | Wholesale on a fee or contract basis |
| 46110 | Agents involved in the sale of agricultural raw materials, live animals, textile raw materials and semi-finished goods |
| 46120 | Agents involved in the sale of fuels, ores, metals and industrial chemicals |
| 46130 | Agents involved in the sale of timber and building materials |
| 46140 | Agents involved in the sale of machinery, industrial equipment, ships and aircraft |
| 46150 | Agents involved in the sale of furniture, household goods, hardware and ironmongery |
| 46160 | Agents involved in the sale of textiles, clothing, fur, footwear and leather goods |
| 46170 | Agents involved in the sale of food, beverages and tobacco |
| 46180 | Agents specialised in the sale of other particular products |
| 46190 | Agents involved in the sale of a variety of goods |
| 46200 | Wholesale of agricultural raw materials and live animals |
| 46210 | Wholesale of grain, unmanufactured tobacco, seeds and animal feeds |
| 46220 | Wholesale of flowers and plants |
| 46230 | Wholesale of live animals |
| 46240 | Wholesale of hides, skins and leather |
| 46300 | Wholesale of food, beverages and tobacco |
| 46310 | Wholesale of fruit and vegetables |
| 46320 | Wholesale of meat and meat products |
| 46330 | Wholesale of dairy products, eggs and edible oils and fats |
| 46340 | Wholesale of beverages |
| 46341 | Wholesale of fruit and vegetable juices, mineral waters and soft drinks |
| 46342 | Wholesale of wine, beer, spirits and other alcoholic beverages |
| 46350 | Wholesale of tobacco products |
| 46360 | Wholesale of sugar and chocolate and sugar confectionery |
| 46370 | Wholesale of coffee, tea, cocoa and spices |
| 46380 | Wholesale of other food, including fish, crustaceans and molluscs |
| 46390 | Non-specialised wholesale of food, beverages and tobacco |
| 46400 | Wholesale of household goods |
| 46410 | Wholesale of textiles |
| 46420 | Wholesale of clothing and footwear |
| 46430 | Wholesale of electrical household appliances |
| 46431 | Wholesale of gramophone records, audio tapes, compact discs and video tapes and of the equipment on which these are played |
| 46439 | Wholesale of radio and television goods and of electrical household appliances (other than of gramophone records, audio tapes, compact discs and video tapes and the equipment on which these are played) n.e.c. |
| 46440 | Wholesale of china and glassware and cleaning materials |
| 46450 | Wholesale of perfume and cosmetics |
| 46460 | Wholesale of pharmaceutical goods |
| 46470 | Wholesale of furniture, carpets and lighting equipment |
| 46480 | Wholesale of watches and jewellery |
| 46490 | Wholesale of other household goods |
| 46491 | Wholesale of musical instruments |
| 46499 | Wholesale of household goods (other than musical instruments) n.e.c. |
| 46500 | Wholesale of information and communication equipment |
| 46510 | Wholesale of computers, computer peripheral equipment and software |
| 46520 | Wholesale of electronic and telecommunications equipment and parts |
| 46600 | Wholesale of other machinery, equipment and supplies |
| 46610 | Wholesale of agricultural machinery, equipment and supplies |
| 46620 | Wholesale of machine tools |
| 46630 | Wholesale of mining, construction and civil engineering machinery |
| 46640 | Wholesale of machinery for the textile industry and of sewing and knitting machines |
| 46650 | Wholesale of office furniture |
| 46660 | Wholesale of other office machinery and equipment |
| 46690 | Wholesale of other machinery and equipment |
| 46700 | Other specialised wholesale |
| 46710 | Wholesale of solid, liquid and gaseous fuels and related products |
| 46711 | Wholesale of petroleum and petroleum products |
| 46719 | Wholesale of fuels and related products (other than petroleum and petroleum products) |
| 46720 | Wholesale of metals and metal ores |
| 46730 | Wholesale of wood, construction materials and sanitary equipment |
| 46740 | Wholesale of hardware, plumbing and heating equipment and supplies |
| 46750 | Wholesale of chemical products |
| 46760 | Wholesale of other intermediate products |
| 46770 | Wholesale of waste and scrap |
| 46900 | Non-specialised wholesale trade |
| 46900 | Non-specialised wholesale trade |
| 47000 | RETAIL TRADE, EXCEPT OF MOTOR VEHICLES AND MOTORCYCLES |
| 47100 | Retail sale in non-specialised stores |
| 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating |
| 47190 | Other retail sale in non-specialised stores |
| 47200 | Retail sale of food, beverages and tobacco in specialised stores |
| 47210 | Retail sale of fruit and vegetables in specialised stores |
| 47220 | Retail sale of meat and meat products in specialised stores |
| 47230 | Retail sale of fish, crustaceans and molluscs in specialised stores |
| 47240 | Retail sale of bread, cakes, flour confectionery and sugar confectionery in specialised stores |
| 47250 | Retail sale of beverages in specialised stores |
| 47260 | Retail sale of tobacco products in specialised stores |
| 47290 | Other retail sale of food in specialised stores |
| 47300 | Retail sale of automotive fuel in specialised stores |
| 47300 | Retail sale of automotive fuel in specialised stores |
| 47400 | Retail sale of information and communication equipment in specialised stores |
| 47410 | Retail sale of computers, peripheral units and software in specialised stores |
| 47420 | Retail sale of telecommunications equipment in specialised stores |
| 47421 | Retail sale of mobile telephones in specialised stores |
| 47429 | Retail sale of telecommunications equipment (other than mobile telephones) n.e.c., in specialised stores |
| 47430 | Retail sale of audio and video equipment in specialised stores |
| 47500 | Retail sale of other household equipment in specialised stores |
| 47510 | Retail sale of textiles in specialised stores |
| 47520 | Retail sale of hardware, paints and glass in specialised stores |
| 47530 | Retail sale of carpets, rugs, wall and floor coverings in specialised stores |
| 47540 | Retail sale of electrical household appliances in specialised stores |
| 47590 | Retail sale of furniture, lighting equipment and other household articles in specialised stores |
| 47591 | Retail sale of musical instruments and scores in specialised stores |
| 47599 | Retail sale of furniture, lighting equipment and other household articles (other than musical instruments) n.e.c., in specialised stores |
| 47600 | Retail sale of cultural and recreation goods in specialised stores |
| 47610 | Retail sale of books in specialised stores |
| 47620 | Retail sale of newspapers and stationery in specialised stores |
| 47630 | Retail sale of music and video recordings in specialised stores |
| 47640 | Retail sale of sporting equipment in specialised stores |
| 47650 | Retail sale of games and toys in specialised stores |
| 47700 | Retail sale of other goods in specialised stores |
| 47710 | Retail sale of clothing in specialised stores |
| 47720 | Retail sale of footwear and leather goods in specialised stores |
| 47721 | Retail sale of footwear in specialised stores |
| 47722 | Retail sale of leather goods in specialised stores |
| 47730 | Dispensing chemist in specialised stores |
| 47740 | Retail sale of medical and orthopaedic goods in specialised stores |
| 47741 | Retail sale of hearing aids in specialised stores |
| 47749 | Retail sale of medical and orthopaedic goods (other than hearing aids) n.e.c., in specialised stores |
| 47750 | Retail sale of cosmetic and toilet articles in specialised stores |
| 47760 | Retail sale of flowers, plants, seeds, fertilisers, pet animals and pet food in specialised stores |
| 47770 | Retail sale of watches and jewellery in specialised stores |
| 47780 | Other retail sale of new goods in specialised stores |
| 47781 | Retail sale in commercial art galleries |
| 47782 | Retail sale by opticians |
| 47789 | Other retail sale of new goods in specialised stores (other than by opticians or commercial art galleries), n.e.c |
| 47790 | Retail sale of second-hand goods in stores |
| 47791 | Retail sale of antiques including antique books, in stores |
| 47799 | Retail sale of second-hand goods (other than antiques and antique books) in stores |
| 47800 | Retail sale via stalls and markets |
| 47810 | Retail sale via stalls and markets of food, beverages and tobacco products |
| 47820 | Retail sale via stalls and markets of textiles, clothing and footwear |
| 47890 | Retail sale via stalls and markets of other goods |
| 47900 | Retail trade not in stores, stalls or markets |
| 47910 | Retail sale via mail order houses or via Internet |
| 47990 | Other retail sale not in stores, stalls or markets |
| TRANSPORTATION AND STORAGE | |
| 49000 | LAND TRANSPORT AND TRANSPORT VIA PIPELINES |
| 49100 | Passenger rail transport, interurban |
| 49100 | Passenger rail transport, interurban |
| 49200 | Freight rail transport |
| 49200 | Freight rail transport |
| 49300 | Other passenger land transport |
| 49310 | Urban and suburban passenger land transport |
| 49311 | Urban, suburban or metropolitan area passenger railway transportation by underground, metro and similar systems |
| 49319 | Urban, suburban or metropolitan area passenger land transport other than railway transportation by underground, metro and similar systems |
| 49320 | Taxi operation |
| 49390 | Other passenger land transport n.e.c. |
| 49400 | Freight transport by road and removal services |
| 49410 | Freight transport by road |
| 49420 | Removal services |
| 49500 | Transport via pipeline |
| 49500 | Transport via pipeline |
| 50000 | WATER TRANSPORT |
| 50100 | Sea and coastal passenger water transport |
| 50100 | Sea and coastal passenger water transport |
| 50200 | Sea and coastal freight water transport |
| 50200 | Sea and coastal freight water transport |
| 50300 | Inland passenger water transport |
| 50300 | Inland passenger water transport |
| 50400 | Inland freight water transport |
| 50400 | Inland freight water transport |
| 51000 | AIR TRANSPORT |
| 51100 | Passenger air transport |
| 51100 | Passenger air transport |
| 51101 | Scheduled passenger air transport |
| 51102 | Non-scheduled passenger air transport |
| 51200 | Freight air transport and space transport |
| 51210 | Freight air transport |
| 51220 | Space transport |
| 52000 | WAREHOUSING AND SUPPORT ACTIVITIES FOR TRANSPORTATION |
| 52100 | Warehousing and storage |
| 52100 | Warehousing and storage |
| 52101 | Operation of warehousing and storage facilities for water transport activities of division 50 |
| 52102 | Operation of warehousing and storage facilities for air transport activities of division 51 |
| 52103 | Operation of warehousing and storage facilities for land transport activities of division 49 |
| 52200 | Support activities for transportation |
| 52210 | Service activities incidental to land transportation |
| 52211 | Operation of rail freight terminals |
| 52212 | Operation of rail passenger facilities at railway stations |
| 52213 | Operation of bus and coach passenger facilities at bus and coach stations |
| 52219 | Other service activities incidental to land transportation, n.e.c. (not including operation of rail freight terminals, passenger facilities at railway stations or passenger facilities at bus and coach stations) |
| 52220 | Service activities incidental to water transportation |
| 52230 | Service activities incidental to air transportation |
| 52240 | Cargo handling |
| 52241 | Cargo handling for water transport activities of division 50 |
| 52242 | Cargo handling for air transport activities of division 51 |
| 52243 | Cargo handling for land transport activities of division 49 |
| 52290 | Other transportation support activities |
| 53000 | POSTAL AND COURIER ACTIVITIES |
| 53100 | Postal activities under universal service obligation |
| 53100 | Postal activities under universal service obligation |
| 53200 | Other postal and courier activities |
| 53200 | Other postal and courier activities |
| 53201 | Licensed Carriers |
| 53202 | Unlicensed Carriers |
| ACCOMMODATION AND FOOD SERVICE ACTIVITIES | |
| 55000 | ACCOMMODATION |
| 55100 | Hotels and similar accommodation |
| 55100 | Hotels and similar accommodation |
| 55200 | Holiday and other short-stay accommodation |
| 55200 | Holiday and other short-stay accommodation |
| 55201 | Holiday centres and villages |
| 55202 | Youth hostels |
| 55209 | Other holiday and other short-stay accommodation (not including holiday centres and villages or youth hostels) n.e.c. |
| 55300 | Camping grounds, recreational vehicle parks and trailer parks |
| 55300 | Camping grounds, recreational vehicle parks and trailer parks |
| 55900 | Other accommodation |
| 55900 | Other accommodation |
| 56000 | FOOD AND BEVERAGE SERVICE ACTIVITIES |
| 56100 | Restaurants and mobile food service activities |
| 56100 | Restaurants and mobile food service activities |
| 56101 | Licensed restaurants |
| 56102 | Unlicensed restaurants and cafes |
| 56103 | Take away food shops and mobile food stands |
| 56200 | Event catering and other food service activities |
| 56210 | Event catering activities |
| 56290 | Other food service activities |
| 56300 | Beverage serving activities |
| 56300 | Beverage serving activities |
| 56301 | Licensed clubs |
| 56302 | Public houses and bars |
| INFORMATION AND COMMUNICATION | |
| 58000 | PUBLISHING ACTIVITIES |
| 58100 | Publishing of books, periodicals and other publishing activities |
| 58110 | Book publishing |
| 58120 | Publishing of directories and mailing lists |
| 58130 | Publishing of newspapers |
| 58140 | Publishing of journals and periodicals |
| 58141 | Publishing of learned journals |
| 58142 | Publishing of consumer, business and professional journals and periodicals |
| 58190 | Other publishing activities |
| 58200 | Software publishing |
| 58210 | Publishing of computer games |
| 58290 | Other software publishing |
| 59000 | MOTION PICTURE, VIDEO AND TELEVISION PROGRAMME PRODUCTION, SOUND RECORDING AND MUSIC PUBLISHING ACTIVITIES |
| 59100 | Motion picture, video and television programme activities |
| 59110 | Motion picture, video and television programme production activities |
| 59111 | Motion picture production activities |
| 59112 | Video production activities |
| 59113 | Television programme production activities |
| 59120 | Motion picture, video and television programme post-production activities |
| 59130 | Motion picture, video and television programme distribution activities |
| 59131 | Motion picture distribution activities |
| 59132 | Video distribution activities |
| 59133 | Television programme distribution activities |
| 59140 | Motion picture projection activities |
| 59200 | Sound recording and music publishing activities |
| 59200 | Sound recording and music publishing activities |
| 60000 | PROGRAMMING AND BROADCASTING ACTIVITIES |
| 60100 | Radio broadcasting |
| 60100 | Radio broadcasting |
| 60200 | Television programming and broadcasting activities |
| 60200 | Television programming and broadcasting activities |
| 61000 | TELECOMMUNICATIONS |
| 61100 | Wired telecommunications activities |
| 61100 | Wired telecommunications activities |
| 61200 | Wireless telecommunications activities |
| 61200 | Wireless telecommunications activities |
| 61300 | Satellite telecommunications activities |
| 61300 | Satellite telecommunications activities |
| 61900 | Other telecommunications activities |
| 61900 | Other telecommunications activities |
| 62000 | COMPUTER PROGRAMMING, CONSULTANCY AND RELATED ACTIVITIES |
| 62000 | Computer programming, consultancy and related activities |
| 62010 | Computer programming activities |
| 62011 | Ready-made interactive leisure and entertainment software development |
| 62012 | Business and domestic software development |
| 62020 | Computer consultancy activities |
| 62030 | Computer facilities management activities |
| 62090 | Other information technology and computer service activities |
| 63000 | INFORMATION SERVICE ACTIVITIES |
| 63100 | Data processing, hosting and related activities; web portals |
| 63110 | Data processing, hosting and related activities |
| 63120 | Web portals |
| 63900 | Other information service activities |
| 63910 | News agency activities |
| 63990 | Other information service activities n.e.c. |
| FINANCIAL AND INSURANCE ACTIVITIES | |
| 64000 | FINANCIAL SERVICE ACTIVITIES, EXCEPT INSURANCE AND PENSION FUNDING |
| 64100 | Monetary intermediation |
| 64110 | Central banking |
| 64190 | Other monetary intermediation |
| 64191 | Banks |
| 64192 | Building societies |
| 64200 | Activities of holding companies |
| 64200 | Activities of holding companies |
| 64201 | Activities of agricultural holding companies |
| 64202 | Activities of production holding companies |
| 64203 | Activities of construction holding companies |
| 64204 | Activities of distribution holding companies |
| 64205 | Activities of financial services holding companies |
| 64209 | Activities of other holding companies (not including agricultural, production, construction, distribution and financial services holding companies) n.e.c. |
| 64300 | Trusts, funds and similar financial entities |
| 64300 | Trusts, funds and similar financial entities |
| 64301 | Activities of investment trusts |
| 64302 | Activities of unit trusts |
| 64303 | Activities of venture and development capital companies |
| 64304 | Activities of open-ended investment companies |
| 64305 | Activities of property unit trusts |
| 64306 | Activities of real estate investment trusts |
| 64900 | Other financial service activities, except insurance and pension funding |
| 64910 | Financial leasing |
| 64920 | Other credit granting |
| 64921 | Credit granting by non-deposit taking finance houses and other specialist consumer credit grantors |
| 64922 | Activities of mortgage finance companies |
| 64929 | Other credit granting (not including credit granting by non-deposit taking finance houses and other specialist consumer credit grantors and activities of mortgage finance companies) n.e.c. |
| 64990 | Other financial service activities, except insurance and pension funding, n.e.c. |
| 64991 | Security dealing on own account |
| 64992 | Factoring |
| 64999 | Other financial service activities, except insurance and pension funding, (not including security dealing on own account and factoring) n.e.c. |
| 65000 | INSURANCE, REINSURANCE AND PENSION FUNDING, EXCEPT COMPULSORY SOCIAL SECURITY |
| 65100 | Insurance |
| 65110 | Life insurance |
| 65120 | Non-life insurance |
| 65200 | Reinsurance |
| 65200 | Reinsurance |
| 65201 | Life reinsurance |
| 65202 | Non-life reinsurance |
| 65300 | Pension funding |
| 65300 | Pension funding |
| 66000 | ACTIVITIES AUXILIARY TO FINANCIAL SERVICES AND INSURANCE ACTIVITIES |
| 66100 | Activities auxiliary to financial services, except insurance and pension funding |
| 66110 | Administration of financial markets |
| 66120 | Security and commodity contracts brokerage |
| 66190 | Other activities auxiliary to financial services, except insurance and pension funding |
| 66200 | Activities auxiliary to insurance and pension funding |
| 66210 | Risk and damage evaluation |
| 66220 | Activities of insurance agents and brokers |
| 66290 | Other activities auxiliary to insurance and pension funding |
| 66300 | Fund management activities |
| 66300 | Fund management activities |
| REAL ESTATE ACTIVITIES | |
| 68000 | REAL ESTATE ACTIVITIES |
| 68100 | Buying and selling of own real estate |
| 68100 | Buying and selling of own real estate |
| 68200 | Renting and operating of own or leased real estate |
| 68200 | Renting and operating of own or leased real estate |
| 68201 | Renting and operating of Housing Association real estate |
| 68202 | Letting and operating of conference and exhibition centres |
| 68209 | Letting and operating of own or leased real estate (other than Housing Association real estate and conference and exhibition services) n.e.c. |
| 68300 | Real estate activities on a fee or contract basis |
| 68310 | Real estate agencies |
| 68320 | Management of real estate on a fee or contract basis |
| PROFESSIONAL, SCIENTIFIC AND TECHNICAL ACTIVITIES | |
| 69000 | LEGAL AND ACCOUNTING ACTIVITIES |
| 69100 | Legal activities |
| 69100 | Legal activities |
| 69101 | Barristers at law |
| 69102 | Solicitors |
| 69109 | Activities of patent and copyright agents; other legal activities (other than those of barristers and solicitors) n.e.c. |
| 69200 | Accounting, bookkeeping and auditing activities; tax consultancy |
| 69200 | Accounting, bookkeeping and auditing activities; tax consultancy |
| 69201 | Accounting, and auditing activities |
| 69202 | Bookkeeping activities |
| 69203 | Tax consultancy |
| 70000 | ACTIVITIES OF HEAD OFFICES; MANAGEMENT CONSULTANCY ACTIVITIES |
| 70100 | Activities of head offices |
| 70100 | Activities of head offices |
| 70200 | Management consultancy activities |
| 70210 | Public relations and communication activities |
| 70220 | Business and other management consultancy activities |
| 70221 | Financial management |
| 70229 | Management consultancy activities (other than financial management) |
| 71000 | ARCHITECTURAL AND ENGINEERING ACTIVITIES; TECHNICAL TESTING AND ANALYSIS |
| 71100 | Architectural and engineering activities and related technical consultancy |
| 71110 | Architectural activities |
| 71111 | Architectural activities |
| 71112 | Urban planning and landscape architectural activities |
| 71120 | Engineering activities and related technical consultancy |
| 71121 | Engineering design activities for industrial process and production |
| 71122 | Engineering related scientific and technical consulting activities |
| 71129 | Other engineering activities (not including engineering design for industrial process and production or engineering related scientific and technical consulting activities) |
| 71200 | Technical testing and analysis |
| 71200 | Technical testing and analysis |
| 72000 | SCIENTIFIC RESEARCH AND DEVELOPMENT |
| 72100 | Research and experimental development on natural sciences and engineering |
| 72110 | Research and experimental development on biotechnology |
| 72190 | Other research and experimental development on natural sciences and engineering |
| 72200 | Research and experimental development on social sciences and humanities |
| 72200 | Research and experimental development on social sciences and humanities |
| 73000 | ADVERTISING AND MARKET RESEARCH |
| 73100 | Advertising |
| 73110 | Advertising agencies |
| 73120 | Media representation |
| 73200 | Market research and public opinion polling |
| 73200 | Market research and public opinion polling |
| 74000 | OTHER PROFESSIONAL, SCIENTIFIC AND TECHNICAL ACTIVITIES |
| 74100 | Specialised design activities |
| 74100 | Specialised design activities |
| 74200 | Photographic activities |
| 74200 | Photographic activities |
| 74201 | Portrait photographic activities |
| 74202 | Other specialist photography (not including portrait photography) |
| 74203 | Film processing |
| 74209 | Other photographic activities (not including portrait and other specialist photography and film processing) n.e.c. |
| 74300 | Translation and interpretation activities |
| 74300 | Translation and interpretation activities |
| 74900 | Other professional, scientific and technical activities n.e.c. |
| 74900 | Other professional, scientific and technical activities n.e.c. |
| 74901 | Environmental consulting activities |
| 74902 | Quantity surveying activities |
| 74909 | Other professional, scientific and technical activities (not including environmental consultancy or quantity surveying) n.e.c. |
| 75000 | VETERINARY ACTIVITIES |
| 75000 | Veterinary activities |
| 75000 | Veterinary activities |
| ADMINISTRATIVE AND SUPPORT SERVICE ACTIVITIES | |
| 77000 | RENTAL AND LEASING ACTIVITIES |
| 77100 | Renting and leasing of motor vehicles |
| 77110 | Renting and leasing of cars and light motor vehicles |
| 77120 | Renting and leasing of trucks |
| 77200 | Renting and leasing of personal and household goods |
| 77210 | Renting and leasing of recreational and sports goods |
| 77220 | Renting of video tapes and disks |
| 77290 | Renting and leasing of other personal and household goods |
| 77291 | Renting and leasing of media entertainment equipment |
| 77299 | Renting and leasing of other personal and household goods (other than media entertainment equipment) |
| 77300 | Renting and leasing of other machinery, equipment and tangible goods |
| 77310 | Renting and leasing of agricultural machinery and equipment |
| 77320 | Renting and leasing of construction and civil engineering machinery and equipment |
| 77330 | Renting and leasing of office machinery and equipment (including computers) |
| 77340 | Renting and leasing of water transport equipment |
| 77341 | Renting and leasing of passenger water transport equipment |
| 77342 | Renting and leasing of freight water transport equipment |
| 77350 | Renting and leasing of air transport equipment |
| 77351 | Renting and leasing of passenger air transport equipment |
| 77352 | Renting and leasing of freight air transport equipment |
| 77390 | Renting and leasing of other machinery, equipment and tangible goods n.e.c. |
| 77400 | Leasing of intellectual property and similar products, except copyrighted works |
| 77400 | Leasing of intellectual property and similar products, except copyrighted works |
| 78000 | EMPLOYMENT ACTIVITIES |
| 78100 | Activities of employment placement agencies |
| 78100 | Activities of employment placement agencies |
| 78101 | Motion picture, television and other theatrical casting |
| 78109 | Activities of employment placement agencies (other than motion picture, television and other theatrical casting) n.e.c. |
| 78200 | Temporary employment agency activities |
| 78200 | Temporary employment agency activities |
| 78300 | Other human resources provision |
| 78300 | Other human resources provision |
| 79000 | TRAVEL AGENCY, TOUR OPERATOR AND OTHER RESERVATION SERVICE AND RELATED ACTIVITIES |
| 79100 | Travel agency and tour operator activities |
| 79110 | Travel agency activities |
| 79120 | Tour operator activities |
| 79900 | Other reservation service and related activities |
| 79900 | Other reservation service and related activities |
| 79901 | Activities of tourist guides |
| 79909 | Other reservation service activities (not including activities of tourist guides) |
| 80000 | SECURITY AND INVESTIGATION ACTIVITIES |
| 80100 | Private security activities |
| 80100 | Private security activities |
| 80200 | Security systems service activities |
| 80200 | Security systems service activities |
| 80300 | Investigation activities |
| 80300 | Investigation activities |
| 81000 | SERVICES TO BUILDINGS AND LANDSCAPE ACTIVITIES |
| 81100 | Combined facilities support activities |
| 81100 | Combined facilities support activities |
| 81200 | Cleaning activities |
| 81210 | General cleaning of buildings |
| 81220 | Other building and industrial cleaning activities |
| 81221 | Window cleaning services |
| 81222 | Specialised cleaning services |
| 81223 | Furnace and chimney cleaning services |
| 81229 | Building and industrial cleaning activities (other than window cleaning, specialised cleaning and furnace and chimney cleaning services) n.e.c. |
| 81290 | Other cleaning activities |
| 81291 | Disinfecting and extermination services |
| 81299 | Cleaning services (other than disinfecting and extermination services) n.e.c. |
| 81300 | Landscape service activities |
| 81300 | Landscape service activities |
| 82000 | OFFICE ADMINISTRATIVE, OFFICE SUPPORT AND OTHER BUSINESS SUPPORT ACTIVITIES |
| 82100 | Office administrative and support activities |
| 82110 | Combined office administrative service activities |
| 82190 | Photocopying, document preparation and other specialised office support activities |
| 82200 | Activities of call centres |
| 82200 | Activities of call centres |
| 82300 | Organisation of conventions and trade shows |
| 82300 | Organisation of conventions and trade shows |
| 82301 | Activities of exhibition and fair organizers |
| 82302 | Activities of conference organizers |
| 82900 | Business support service activities n.e.c. |
| 82910 | Activities of collection agencies and credit bureaus |
| 82911 | Activities of collection agencies |
| 82912 | Activities of credit bureaus |
| 82920 | Packaging activities |
| 82990 | Other business support service activities n.e.c. |
| PUBLIC ADMINISTRATION AND DEFENCE; COMPULSORY SOCIAL SECURITY | |
| 84000 | PUBLIC ADMINISTRATION AND DEFENCE; COMPULSORY SOCIAL SECURITY |
| 84100 | Administration of the State and the economic and social policy of the community |
| 84110 | General public administration activities |
| 84120 | Regulation of the activities of providing health care, education, cultural services and other social services, excluding social security |
| 84130 | Regulation of and contribution to more efficient operation of businesses |
| 84200 | Provision of services to the community as a whole |
| 84210 | Foreign affairs |
| 84220 | Defence activities |
| 84230 | Justice and judicial activities |
| 84240 | Public order and safety activities |
| 84250 | Fire service activities |
| 84300 | Compulsory social security activities |
| 84300 | Compulsory social security activities |
| EDUCATION | |
| 85000 | EDUCATION |
| 85100 | Pre-primary education |
| 85100 | Pre-primary education |
| 85200 | Primary education |
| 85200 | Primary education |
| 85300 | Secondary education |
| 85310 | General secondary education |
| 85320 | Technical and vocational secondary education |
| 85400 | Higher education |
| 85410 | Post-secondary non-tertiary education |
| 85420 | Tertiary education |
| 85421 | First-degree level higher education |
| 85422 | Post-graduate level higher education |
| 85500 | Other education |
| 85510 | Sports and recreation education |
| 85520 | Cultural education |
| 85530 | Driving school activities |
| 85590 | Other education n.e.c. |
| 85600 | Educational support activities |
| 85600 | Educational support activities |
| HUMAN HEALTH AND SOCIAL WORK ACTIVITIES | |
| 86000 | HUMAN HEALTH ACTIVITIES |
| 86100 | Hospital activities |
| 86100 | Hospital activities |
| 86101 | Hospital activities |
| 86102 | Medical nursing home activities |
| 86200 | Medical and dental practice activities |
| 86210 | General medical practice activities |
| 86220 | Specialist medical practice activities |
| 86230 | Dental practice activities |
| 86900 | Other human health activities |
| 86900 | Other human health activities |
| 87000 | RESIDENTIAL CARE ACTIVITIES |
| 87100 | Residential nursing care activities |
| 87100 | Residential nursing care activities |
| 87200 | Residential care activities for learning disabilities, mental health and substance abuse |
| 87200 | Residential care activities for learning disabilities, mental health and substance abuse |
| 87300 | Residential care activities for the elderly and disabled |
| 87300 | Residential care activities for the elderly and disabled |
| 87900 | Other residential care activities |
| 87900 | Other residential care activities |
| 88000 | SOCIAL WORK ACTIVITIES WITHOUT ACCOMMODATION |
| 88100 | Social work activities without accommodation for the elderly and disabled |
| 88100 | Social work activities without accommodation for the elderly and disabled |
| 88900 | Other social work activities without accommodation |
| 88910 | Child day-care activities |
| 88990 | Other social work activities without accommodation n.e.c. |
| ARTS, ENTERTAINMENT AND RECREATION | |
| 90000 | CREATIVE, ARTS AND ENTERTAINMENT ACTIVITIES |
| 90000 | Creative, arts and entertainment activities |
| 90010 | Performing arts |
| 90020 | Support activities to performing arts |
| 90030 | Artistic creation |
| 90040 | Operation of arts facilities |
| 91000 | LIBRARIES, ARCHIVES, MUSEUMS AND OTHER CULTURAL ACTIVITIES |
| 91000 | Libraries, archives, museums and other cultural activities |
| 91010 | Library and archive activities |
| 91011 | Library activities |
| 91012 | Archive activities |
| 91020 | Museum activities |
| 91030 | Operation of historical sites and buildings and similar visitor attractions |
| 91040 | Botanical and zoological gardens and nature reserve activities |
| 92000 | GAMBLING AND BETTING ACTIVITIES |
| 92000 | Gambling and betting activities |
| 92000 | Gambling and betting activities |
| 93000 | SPORTS ACTIVITIES AND AMUSEMENT AND RECREATION ACTIVITIES |
| 93100 | Sports activities |
| 93110 | Operation of sports facilities |
| 93120 | Activities of sport clubs |
| 93130 | Fitness facilities |
| 93190 | Other sports activities |
| 93191 | Activities of racehorse owners |
| 93199 | Other sports activities (not including activities of racehorse owners) n.e.c. |
| 93200 | Amusement and recreation activities |
| 93210 | Activities of amusement parks and theme parks |
| 93290 | Other amusement and recreation activities |
| OTHER SERVICE ACTIVITIES | |
| 94000 | ACTIVITIES OF MEMBERSHIP ORGANISATIONS |
| 94100 | Activities of business, employers and professional membership organisations |
| 94110 | Activities of business and employers membership organisations |
| 94120 | Activities of professional membership organisations |
| 94200 | Activities of trade unions |
| 94200 | Activities of trade unions |
| 94900 | Activities of other membership organisations |
| 94910 | Activities of religious organisations |
| 94920 | Activities of political organisations |
| 94990 | Activities of other membership organisations n.e.c. |
| 95000 | REPAIR OF COMPUTERS AND PERSONAL AND HOUSEHOLD GOODS |
| 95100 | Repair of computers and communication equipment |
| 95110 | Repair of computers and peripheral equipment |
| 95120 | Repair of communication equipment |
| 95200 | Repair of personal and household goods |
| 95210 | Repair of consumer electronics |
| 95220 | Repair of household appliances and home and garden equipment |
| 95230 | Repair of footwear and leather goods |
| 95240 | Repair of furniture and home furnishings |
| 95250 | Repair of watches, clocks and jewellery |
| 95290 | Repair of other personal and household goods |
| 96000 | OTHER PERSONAL SERVICE ACTIVITIES |
| 96000 | Other personal service activities |
| 96010 | Washing and (dry-)cleaning of textile and fur products |
| 96020 | Hairdressing and other beauty treatment |
| 96030 | Funeral and related activities |
| 96040 | Physical well-being activities |
| 96090 | Other personal service activities n.e.c. |
| ACTIVITIES OF HOUSEHOLDS AS EMPLOYERS; UNDIFFERENTIATED GOODS-AND SERVICES-PRODUCING ACTIVITIES OF HOUSEHOLDS FOR OWN USE | |
| 97000 | ACTIVITIES OF HOUSEHOLDS AS EMPLOYERS OF DOMESTIC PERSONNEL |
| 97000 | Activities of households as employers of domestic personnel |
| 97000 | Activities of households as employers of domestic personnel |
| 98000 | UNDIFFERENTIATED GOODS- AND SERVICES-PRODUCING ACTIVITIES OF PRIVATE HOUSEHOLDS FOR OWN USE |
| 98100 | Undifferentiated goods-producing activities of private households for own use |
| 98100 | Undifferentiated goods-producing activities of private households for own use |
| 98200 | Undifferentiated service-producing activities of private households for own use |
| 98200 | Undifferentiated service-producing activities of private households for own use |
| ACTIVITIES OF EXTRATERRITORIAL ORGANISATIONS AND BODIES | |
| 99000 | ACTIVITIES OF EXTRATERRITORIAL ORGANISATIONS AND BODIES |
| 99000 | Activities of extraterritorial organisations and bodies |
| 99000 | Activities of extraterritorial organisations and bodies |
Grid Reference data is primarily sourced from Ordnance Survey for distance calculations, nearest calculations and data / location analysis. It is made up of a six digit Easting and a six digit Northing. This reference relates the location of the Postcode to the National Grid (or Irish Grid for Northern Ireland Postcodes (start with BT)).
The largest units of the National Grid are 500km squares, each designated by a prefix letter – the first letter to be quoted in the National Grid reference.
The 500km squares are then broken down into twenty five – 100km squares; these are also designated by a prefix letter – the second letter of the grid reference.
Within the 100km square, each smaller grid square (at 10km, 1 km, or 100m side) is designated by the distance of its South-West corner from the West (Eastings) and South (Northings) margins, respectively, of the 100km square in which it lies.
To enable these distances, or co-ordinates, to be easily found, their values are printed in the map margins against the grid lines concerned. These provide the numbers – two, four or six digits – which identify each particular grid square.
EXAMPLE
e = easting n = northing
S K 1 2
e n
shows a point 10,000m East and 20,000m North of the South West corner of the SK square.
S K 1 3 5 2 4 6
e e e n n n
Shows a point 13,500m East and 24,600m North of the South West corner of the SK square.
A point or feature, within one of the smallest grid squares, can be indicated still more closely by estimating the tenths of the appropriate grid square.
When giving a National Grid reference, for any point, the distance Eastwards (Eastings) is always given before the distance Northwards (Northings).
Northern Ireland is covered by the Irish Grid System, which contains a single alpha character to represent each 100km square. There are 5 such 100km squares covering Northern Ireland using the letters: C D G H J.
This, however, makes the distance difficult, so AFD products automatically convert the Irish grid system to British system to allow distances / nearest to be correctly calculated. You can opt to convert all grid references to use the British or Irish Grid systems to provide consistency across the whole UK and these options are available in the front-end and developers can gain access to these conversions through the Common API.
No Grid References are available for these postcodes but to enable them to be used with the Map and Nearest facilities of AFD Products, grid references for the centre of the locality/town have been hard coded. PO Boxes are non-geographic (being located in the Post Office) hence having no grid reference. You can also opt to use these locality/town hard coded values generally in the Front-end and they are accessible through the Common API for developers. In large cities these approximations can be quite far out as the values given are for the centre of that city and not the postcode you selected. However this may be more useful than no grid reference at all to assist in distance calculations or locating somewhere on the map.
To enable these Grid References to be used with GPS systems and other tools requiring latitude and longitude values AFD Products provide a conversion to latitude and longitude values for a grid reference which is displayed in the front end and can be inserted into your application. Developer’s can gain access to these conversions through the Common API. The latitude and longitude values given are based on the WGS84 standard – the one in most common usage with GPS systems. The conversions used are accurate to within 5 metres (the worst case scenario at locations with most distortion). But remember that a grid references at postcode level may cover a wide area especially in rural areas.
See https://www.afd.co.uk/eula
The Royal Mail no longer use the “County” for the delivery of mail – indeed, they have removed County Data from the Postcode Address File on which many AFD products are based. Although County may be included on mail, AFD products and examples are set to omit county data when first installed. It is strongly recommended that for mailing purposes, County data be omitted.
Nevertheless, many organisations use counties for their own regional structures so AFD Products allow you to choose whether these are displayed (from the Edit menu), and gives you a range of county types to choose from:
The following table shows the full descriptions for each of the Censation codes.
| Code | Affluence | Life Stage | Additional Info | Label |
|---|---|---|---|---|
| AW01 | Wealthy | Young families | Many Christians, Professionals with High incomes, commercially active | Eclectic Tastes |
| AW07 | Wealthy | Young families | Employed in full education and finance, active online but protective of identity, some Christian and rural | Fully online |
| AW09 | Wealthy | Young families | Public servants with above average income, some christians and rural locations | Progressive Families |
| AX02 | Wealthy | Older families | Above average incomes, with tradional backgrounds and high levels of responsibility | Business Leaders |
| AX03 | Wealthy | Older families | Suburban neighbourhoods with many social grade AB, commercially active | Leafy Avenues |
| AX05 | Wealthy | Older families | Traditional outlook with high qualifications and social grade AB | Instinctive conservative |
| AX06 | Wealthy | Older families | Well above average incomes, in established neighbourhodds, but engaging with the internet | Thoughtful Progress |
| AX10 | Wealthy | Older families | Established affluent families, who want privacy with many different Religions and backgrounds | Global Perspective |
| AY04 | Wealthy | Empty nests and seniors | Managers and senior officials with high incomes, engaged with commerce and the internet | Settled Influence |
| AY08 | Wealthy | Empty nests and seniors | Professional and senior managers with a wide range of cultural interests | Style and Music |
| BV20 | Prosperous | Young singles | Highly qualified young people looking to establish themselves and settle down | Preparing the Nest |
| BW11 | Prosperous | Young families | High incomes, with many Christians, employed in finance and business services | Cultured Engagement |
| BW18 | Prosperous | Young families | Suburban families with young children and high aspirations for commercial success | Sporting Ambitions |
| BX15 | Prosperous | Older families | Buying their own homes, and preparing for children to leave home | Parents Taxi |
| BY12 | Prosperous | Empty nests and seniors | Established focus on buying home, DIY, home improvements and the garden | Home and Garden |
| BY13 | Prosperous | Empty nests and seniors | Mixed set of interests, able to do new things now children are becoming independent | Considering Change |
| BY14 | Prosperous | Empty nests and seniors | Mixed interests, but many with local interests and higher than average incomes | Considerate Participants |
| BY16 | Prosperous | Empty nests and seniors | Many retired christians, in suburban settings, with little commercial activity | Contented Enjoyment |
| BY17 | Prosperous | Empty nests and seniors | Many rural locations, employment in agriculture and support for local charities | Country Cottage |
| BY19 | Prosperous | Empty nests and seniors | Some christians with employment in education and the professions | Traditional Community |
| BY21 | Prosperous | Empty nests and seniors | Range of interests with a typical income but much expectation about commercial activity | Driven to Get On |
| CV29 | Comfortable | Young singles | Lots of different activities, with plenty of uptake of technology and online activity | Prudent Technologists |
| CV30 | Comfortable | Young singles | Highly qualified workers, with some professionals, and interests in Lesiure, clothing and appliances | Living to the Full |
| CV31 | Comfortable | Young singles | Many students, and interests in music, lesiure and events | Festival Participants |
| CW26 | Comfortable | Young families | Hindus and muslims, many employed in the transport sector with some office and shop staff | Global Reach |
| CW28 | Comfortable | Young families | Wide range of interests, particularly charities and family, many manual workers in the retail sector | Empathetic Supporter |
| CX22 | Comfortable | Older families | Many factory and manual workers in manufacturing and retail. Buying their own houses, some on average incomes | Salt of the earth |
| CX27 | Comfortable | Older families | Buying their own home, some in a rural setting, with interests in the local community | Attentive partner |
| CY23 | Comfortable | Empty nests and seniors | Retired with a range of interests in semi-detached houses with moderate commercial activity, some with no qualifications | House Proud |
| CY24 | Comfortable | Empty nests and seniors | Retired with a range of interests, some moderate commercial activity, with some high qualifications | Social Enthusiast |
| CY25 | Comfortable | Empty nests and seniors | Retired with mixed interests with skilled trades and experience in agriculture. Relatively High commercial activity with some intermediate qualifications | Handy skills |
| DV36 | Striving | Young singles | Living in rented accomodation, working in hotels, business and health services. Sometimes support charities | Focused Students |
| DW32 | Striving | Young families | Living in smaller houses. Manual workers in manufacturing and retail | Looking for New Ideas |
| DW33 | Striving | Young families | Tradional outlook with some Christians, working in retail and transport with little commercial activity | Conscientious worker |
| DW41 | Striving | Young families | Support staff employed in manufacturing and retail, on low incomes, with an eclectic range of interests | Keeping Fit |
| DX34 | Striving | Older families | No professed religion, with low levels of qualifications. Manual workers reading popular newspapers | Industrious providers |
| DX39 | Striving | Older families | Employed in manufacturing, construction and retail as support staff. Many read middle of the road newspapers with a conservative outlook | Making Ends Meet |
| DX40 | Striving | Older families | Employed in manufacturing, construction and retail. Have no qualifications and read popular newspapers, but engage with social media | Aspiring Technologists |
| DX42 | Striving | Older families | Very low incomes – either unemployed or in the hotel trade, but sometimes support charities | Old-school companions |
| DY35 | Striving | Empty nests and seniors | Retired with mixed interests, many with no religious affiliation who sometimes support charities | Careful beginners |
| DY37 | Striving | Empty nests and seniors | Retired without qualifications, with experience in manufacturing. Some support charities some of the time | Home Builders |
| DY38 | Striving | Empty nests and seniors | Many retired without qualifications, read popular newspapers, some on low incomes | Working hard |
| EV46 | Struggling | Young singles | Some on low incomes, living in rented accomodation with no religious affiliation, with aspirations for commercial activity | Bettering themselves |
| EW44 | Struggling | Young families | Many with no-religious affiliation in social and private rented accommodation, who sometimes support charities | Meticulous care |
| EW45 | Struggling | Young families | Mixed interests, living in rented accomdation and reading popular newspapers | Starting Out |
| EW50 | Struggling | Young families | Social renting of smaller flats & houses, very low incomes, with little commercial activity | Firm foundations |
| EX49 | Struggling | Older families | Social renting of flats & smaller houses, read popular newspapers and little commercial or internet activity | Dedicated Parents |
| EY43 | Struggling | Empty nests and seniors | Retired, social grade E, with no qualifications. Reading popular newspapers, value privacy with little commercial activity | Resolute spirit |
| EY47 | Struggling | Empty nests and seniors | Retired with little religious affiliation and no qualifications previously in process support and elementary occupations, some in social and private renting | Diligent Supporters |
| EY48 | Struggling | Empty nests and seniors | Social grade E, retired with experience of personal health services. Engaged with commercial activity | Persistent enquirers |
| EY51 | Struggling | Empty nests and seniors | Social grade E, retired with experience of elementary occupations in health. Many Muslim and Hindu | Determined Survivors |
| EY52 | Struggling | Empty nests and seniors | Social grade E, retired with experience of elementary occupations in manufacturing. Little commercial and online activity | Proud Technophobes |
| NL61 | Not Classified | Many organisations mixed with low, transient population | Consumer commercial centres and offices. Much of this segment arises from business related sources, plus some unidentified residential properties | Unclassified |
| Code | Percentage of UK Population (Postcode Level Censation) | Percentage of Adults Over 18 (Individual Level Censation) | Percentage of Occupied Households (Household Level Censation) | Urban- Rural Score | Recent New Build Score | Recent House Sales Score | Recent Sale Price Score | Annual Rate of House Price Increase Score | Annual Rate of House Sale |
|---|---|---|---|---|---|---|---|---|---|
| AW01 | 1.21 | 0.27 | 0.21 | 5 | 3 | 1 | 5 | 1 | 4 |
| AW07 | 0.75 | 1.45 | 1.11 | 5 | 5 | 2 | 5 | 1 | 5 |
| AW09 | 0.9 | 0.69 | 0.58 | 5 | 3 | 5 | 5 | 2 | 3 |
| AX02 | 0.92 | 0.37 | 0.31 | 4 | 5 | 1 | 5 | 4 | 4 |
| AX03 | 2.02 | 0.46 | 0.29 | 5 | 3 | 4 | 5 | 3 | 2 |
| AX05 | 1.37 | 2.26 | 1.59 | 5 | 3 | 5 | 5 | 4 | 2 |
| AX06 | 1.35 | 1.75 | 1.38 | 4 | 2 | 3 | 5 | 4 | 2 |
| AX10 | 1.84 | 0.28 | 0.27 | 1 | 1 | 5 | 4 | 5 | 3 |
| AY04 | 1.76 | 1.04 | 1.52 | 3 | 2 | 4 | 5 | 5 | 4 |
| AY08 | 1.63 | 0.91 | 1.19 | 4 | 5 | 5 | 5 | 1 | 5 |
| BV20 | 1.4 | 1.84 | 1.56 | 4 | 5 | 4 | 4 | 1 | 5 |
| BW11 | 1.96 | 0.82 | 0.66 | 5 | 4 | 1 | 4 | 1 | 3 |
| BW18 | 1.94 | 1.78 | 1.48 | 5 | 4 | 2 | 4 | 3 | 5 |
| BX15 | 1.54 | 6.52 | 5.02 | 5 | 2 | 2 | 4 | 3 | 2 |
| BY12 | 1.01 | 1.18 | 1.83 | 4 | 3 | 4 | 4 | 4 | 3 |
| BY13 | 1.58 | 1.25 | 1.9 | 4 | 5 | 4 | 4 | 1 | 5 |
| BY14 | 1.24 | 0.04 | 0.05 | 2 | 1 | 4 | 5 | 5 | 3 |
| BY16 | 0.66 | 0.06 | 0.1 | 1 | 1 | 2 | 4 | 3 | 4 |
| BY17 | 1.43 | 0.06 | 0.05 | 5 | 1 | 2 | 4 | 3 | 3 |
| BY19 | 0.99 | 0.15 | 0.23 | 3 | 1 | 4 | 4 | 4 | 3 |
| BY21 | 0.89 | 0.32 | 0.46 | 4 | 4 | 4 | 3 | 1 | 5 |
| CV29 | 0.6 | 1.02 | 1.11 | 3 | 2 | 5 | 2 | 2 | 1 |
| CV30 | 0.99 | 1.97 | 1.85 | 3 | 4 | 3 | 3 | 5 | 4 |
| CV31 | 1.04 | 1.29 | 1.17 | 3 | 5 | 5 | 3 | 1 | 5 |
| CW26 | 1.91 | 1.4 | 1.09 | 1 | 2 | 5 | 3 | 2 | 1 |
| CW28 | 2.73 | 5.67 | 4.84 | 4 | 5 | 1 | 3 | 2 | 5 |
| CX22 | 8.26 | 13.53 | 10.42 | 3 | 4 | 2 | 3 | 3 | 1 |
| CX27 | 6.13 | 1.3 | 1.06 | 4 | 3 | 3 | 3 | 2 | 2 |
| CY23 | 5.06 | 5.8 | 9.17 | 2 | 4 | 3 | 3 | 3 | 3 |
| CY24 | 3.71 | 1.79 | 2.78 | 2 | 3 | 3 | 4 | 5 | 3 |
| CY25 | 3.24 | 0.43 | 0.61 | 1 | 1 | 2 | 3 | 3 | 3 |
| DV36 | 1.75 | 3.63 | 3.4 | 3 | 3 | 1 | 2 | 5 | 4 |
| DW32 | 0.64 | 1.11 | 0.96 | 5 | 5 | 1 | 2 | 5 | 4 |
| DW33 | 0.86 | 1.02 | 0.81 | 3 | 3 | 5 | 2 | 4 | 4 |
| DW41 | 0.78 | 2.19 | 1.82 | 3 | 5 | 1 | 3 | 5 | 5 |
| DX34 | 1.75 | 5.21 | 3.97 | 3 | 1 | 4 | 2 | 4 | 1 |
| DX39 | 1.82 | 2.69 | 2.13 | 3 | 2 | 3 | 2 | 2 | 2 |
| DX40 | 2.43 | 1.49 | 1.11 | 4 | 4 | 2 | 2 | 1 | 2 |
| DX42 | 2.07 | 0.61 | 0.53 | 4 | 3 | 3 | 2 | 1 | 3 |
| DY35 | 2.57 | 3.57 | 5.59 | 2 | 5 | 1 | 2 | 2 | 4 |
| DY37 | 4.11 | 1.82 | 2.85 | 2 | 2 | 2 | 2 | 2 | 2 |
| DY38 | 1.81 | 0.26 | 0.4 | 1 | 1 | 1 | 2 | 2 | 2 |
| EV46 | 1.79 | 3.15 | 3.24 | 2 | 4 | 1 | 1 | 2 | 4 |
| EW44 | 1.28 | 0.63 | 0.53 | 2 | 1 | 1 | 1 | 5 | 5 |
| EW45 | 0.76 | 1.59 | 1.33 | 2 | 4 | 5 | 1 | 5 | 5 |
| EW50 | 0.7 | 0.66 | 0.54 | 1 | 1 | 2 | 1 | 4 | 1 |
| EX49 | 2.2 | 5.55 | 4.38 | 2 | 2 | 3 | 1 | 4 | 1 |
| EY43 | 2.35 | 1.26 | 2.05 | 1 | 2 | 2 | 1 | 2 | 1 |
| EY47 | 2.37 | 2.68 | 4.44 | 1 | 4 | 3 | 1 | 2 | 1 |
| EY48 | 3.24 | 1.39 | 2.26 | 2 | 2 | 1 | 1 | 3 | 2 |
| EY51 | 1.55 | 1.65 | 1.61 | 1 | 1 | 3 | 1 | 4 | 1 |
| EY52 | 1.11 | 0.11 | 0.17 | 1 | 1 | 1 | 1 | 3 | 1 |
| Accommodation & food services | Accommodation and food service activities |
| Active: Full-time student | Economically active: Full-time student |
| Active: Self-employed | Economically active: Self-employed |
| Active: Unemployed | Economically active: Unemployed |
| Administrative services | Administrative and support service activities |
| Affluence | An estimate of the relative material comfort experienced within different neighbourhoods of the UK based upon a combination of variables from the 2011 UK Census |
| Census | A questionnaire distributed to the whole UK population once every decade, the last one was in 2011 |
| Christian | Indicates that a relatively high proportion of a postcode indicated that their religion was Christian in a voluntary question in the latest UK Census |
| Comfortable | The central band on the affluence scale derived from the Census data |
| Commercial | Indicates the presence of a high proportion of business and public organisations within a postcode |
| Consumer | Predominantly businesses that deal directly with the public, e.g. shops, banks, pubs etc. |
| Converted flat | Flat, maisonette or apartment: Part of a converted or shared house (including bed-sits) |
| Detached house | Whole house or bungalow: Detached |
| Distinctive | Where the proportion of a factor within a postcode is substantially larger than the proportion found within the UK as a whole. |
| Electricity, gas, steam & air con | Electricity, gas, steam and air conditioning supply |
| Elementary (occupation) | Unskilled jobs, e.g. security guards |
| Employee: Full-time | Economically active: Employee: Full-time |
| Employee: Part-time | Economically active: Employee: Part-time |
| Empty Nests | Adult couples aged over 45, who have no children. |
| Established | The average length of residency within a postcode is over 6 years. |
| Excess | A significantly higher proportion of a characteristic when that proportion is large across the whole of the UK. |
| Flat In a commercial building | Flat, maisonette or apartment: In a commercial building |
| Frequently | 6+ times per year |
| Geodemographic | The description of different characteristics about people based upon the location where they live. |
| High | Usually more than 8 times per year |
| Hindu | Indicates that a relatively high proportion of a postcode indicated that their religion was Hindu in a voluntary question in the latest UK Census. |
| Household | A group of people living within one building and accessed through a single main door. |
| Household Space | Any accommodation occupied by an individual household or, if unoccupied, available for an individual household. |
| Human health and social work | Human health and social work activities |
| In-conclusive | Information about the segment does not differentiate significantly between different characteristics |
| In employment | Economically active: In employment |
| Inactive: Long-term sick or disabled | Economically inactive: Long-term sick or disabled |
| Inactive: Looking after home or family | Economically inactive: Looking after home or family |
| Inactive: Other | Economically inactive: Other |
| Inactive: Retired | Economically inactive: Retired |
| Inactive: Student | Economically inactive: Student (including full-time students) |
| Life Stage | Indicates the distinctive characteristics of a postcode according to their age and household make-up |
| Life Style | Indications of the different ways that people participate with society and people around them. |
| Mail Order | Indicates how likely respondents are to make purchases through the use of magazines, catalogues etc. where the product is not seen directly, but sent by mail after it has been ordered. |
| Many | Indicates that a characteristic for a Censation segment is one of the 10% most distinctive for that variable |
| Muslim | Indicates that a relatively high proportion of a postcode indicated that their religion was Muslim in a voluntary question in the latest UK Census. |
| Normally empty households | Household spaces with no usual residents |
| Normally occupied households | Household spaces with at least one usual resident |
| Occasionally | 1 – 3 times per year. |
| Older Families | Adult couples, with children aged over 11. |
| Personal Services | Jobs that include support for private individuals, these can include health, social services and leisure. |
| Professional & scientific activities | Professional, scientific and technical activities |
| Process Support | Low skilled jobs particularly those that support production lines etc. |
| Prosperous | The next to highest band on the affluence scale derived from the 2011 Census data |
| Public Administration | Predominantly local and national government offices |
| Public administration & defence | Public administration and defence; compulsory social security |
| Public Sector | A grouping of business sectors including Public Administration, Health and Education. |
| Purpose-built flats | Flat, maisonette or apartment: Purpose-built block of flats or tenement |
| Qualification: Level 1 | Entry level vocational training: e.g. Skills for Life or Foundational Diploma or GCSEs graded D & E |
| Qualification: Level 2 | Established Vocational Training: e.g. Higher Diploma plus GCSEs graded A* to C |
| Qualification: Level 3 | Detailed Vocational Training: e.g. Advanced Diploma plus A/AS levels |
| Qualification: Level 4 | Further Vocational Training plus any University level courses |
| Rank | If the clusters are sorted according to a selected variable then this number indicates the position in the list. |
| Residential | Indicates that a postcode has predominantly private residences within it. |
| Residential Services | These services are often intermingled with private residences and can include Petrol Stations, Newsagents, Small grocers, Hairdressers etc. |
| Religion | The 2011 Census included a voluntary question asking each respondent their religion, if they chose to, they ticked their choice from those available. |
| Semi-detached house | Whole house or bungalow: Semi-detached |
| Seniors | Adults aged over 65, often living alone |
| Sikh | Indicates that a relatively high proportion of a postcode indicated that their religion was Sikh in a voluntary question in the latest UK Census. |
| Social Grade | A grouping of the population derived by the Market Research Society and used within Advertising and Marketing |
| SOHO | Small office and home office businesses |
| Some | Indicates that this characteristic is distinctive for that group although it doesn’t fall into the top 10% for this variable. |
| Sometimes | 4 – 5 times per year |
| Stable | Indicates that the average length of residency in a postcode is between 3 and 6 years. |
| Striving | The next to lowest band on the affluence scale derived from the 2011 Census data |
| Student at their non | |
| term-time address | Schoolchild or full-time student aged 4 and over at their non term-time address |
| Struggling | The lowest band on the affluence scale derived from the 2011 Census data |
| Temporary structure | Caravan or other mobile or temporary structure |
| Tenure | Indicates the type of contract that a respondent holds for their place of residence. |
| Terraced house | Whole house or bungalow: Terraced (including end-terrace) |
| Transient | Indicates that the average length of residency within a postcode is below 3 years |
| Turnover | The rate at which people move in and out of a postcode. |
| Variables | Different descriptions of the characteristics of people within a postcode. |
| Water supply & sewerage | Water supply; sewerage, waste management and remediation activities |
| Wealthy | The highest band on the affluence scale derived from the 2011 Census data |
| Wholesale and retail trade | Wholesale and retail trade; repair of motor vehicles and motor cycles |
| Young Families | Adults living as a couple with children aged less than 11 years old. |
| Young Singles | Adults aged less than 45, who are living alone. |
The occupancy indicator gives an indication of the type of occupants of properties on the selected postcode. It can be helpful in determining whether a given postcode is more likely to relate to a business or private residence, or if a given address is more likely to be in a more industrial or town centre type of setting or in a residential street. You should note that there is always the possibility of an address not being present on PAF, or an incorrect postcode being given. This means that you may be given business or residential details which contradict this field, so it should be used as a guide as to what to expect rather than being treated as authoritative. The types returned are as follows:
This indicates that this is a business postcode which is not shared between different delivery points (letterboxes). The organisation is a large user of Royal Mail deliveries. No private residences should share this postcode and the Royal Mail Postcode Address File will only contain one business entry at this postcode. This can include PO Box addresses which always have a single postcode allocated to them.
Examples:
B6 4AA Used by the organisation 'Royal Mail' only.
B2 2UE PO Box postcode. Used by the organisation 'Official Receiver Aftercare Team'.
All the properties on this postcode are likely to be businesses (i.e. not private addresses). There may well be multiple businesses and buildings sharing this same postcode.
Examples:
B2 5EP Used by multiple organisations such as 'Toni & Guy', 'Slaters', and 'Jack Wills'.
B6 4HL Contains the Organisation 'Pizza Hut Delivery & Collection' only. In this case there is only a single organisation residing on this postcode but it is not a large user postcode and there is always the possibility that other properties could be added to the same postcode in the future.
Most of the addresses on this postcode are businesses. However residential addresses are also present.
Examples:
B5 5SL Contains mostly organisations such as 'Top Draw Graphic Design Associates Ltd', 'F G H Security', etc. but also contains a few residential properties such as a Flat.
B15 3AA Contains a large number of business addresses, but also contains a number of residential properties too.
This postcode contains a mixture of both business and residential addresses with no one type of address in a significant majority.
Examples:
B15 3TR Contains quite a number of both businesses and residential addresses
B17 9QH Again contains a number of both business and residential addresses, neither is dominant on this postcode.
Most of the addresses on this postcode are residential. However business addresses are also present.
Examples:
B9 5XF Contains mostly residential addresses, however a construction company, opticians and restaurant are also present.
B14 5LY Contains residential addresses with the sole exception of a corner shop.
All the properties on this postcode are likely to be residential addresses.
Examples:
B5 7PY Contains residential addresses only.
B1 1FW Contains residential addresses, all of which are apartments.
The address type indicator gives an indication of the type of property level data you will need to capture to have the full delivery address for properties on the selected postcode. It can be helpful in determining the necessary additional property information you will need to capture to complete the full deliverable address. You should note that there is always the possibility of an address not being present on PAF, or an incorrect postcode being given. This means that you may be given property details which contradict this field, so it should be used as a guide as to what to expect rather than being treated as authoritative. The types returned are as follows:
This indicates that all addresses on this postcode consist purely of a number. So the only information that needs to be captured for a complete address (in addition to the street address returned by Postcode), is the house number. It should be noted that some people may give out and wish to use a house name instead, despite that not being their official address as held by Royal Mail.
Examples:
B6 5BL Contains numbered houses only on Clifton Road in Aston, Birmingham.
B11 3QL Also contains numbered houses only in Sunningdale Road, Birmingham
This indicates that a mixture of addresses exist on this postcode, some needing a house number and some needing a property name. There can also be those that require both or include alphanumeric numbering such as 16b. More care therefore has to be taken in capturing the property details than with a purely numbered or named postcode.
Examples:
B75 6LN Contains multiple addresses, some numbered houses and a named hotel & golf club.
B3 3LP Contains some addresses with a house number only, some with both a house number and property name, and one with a property name only.
This category is the same as that above (Numbered and Named), except that the address details indicate that it is likely that some or all of the addresses on this postcode are multiple occupancy (such as a flat).
Examples:
B1 1BA Contains flats in Holloway Circus in Birmingham.
B20 3PR Consists mainly of numbered properties, however some flats are also present.
All the properties on this postcode have a house or building name, not a number. You are therefore normally expecting to capture a name rather than a number when capturing addresses on this postcode.
Examples:
B6 4AA Contains a single address with the property name 'Birmingham Mail Centre' only.
B1 1TT Contains twenty-six addresses each with a property name and no house number present.
This refers to postcodes where one or more addresses is not in a common address format. It is therefore important with this address type to carefully check and enter the property details. This includes addresses which do not have a street field at all, or have multiple street names on the same postcode. It also includes addresses with numbered localities (no street but a house number which goes in with the locality field).
Examples:
B3 3DQ Address simply has an organisation name, property and town. No other property or street level information is present.
B13 9JD Some properties on this postcode have a dependant street in the street field giving, 'Fernside Gardens, Yardley Wood Road', while others only have 'Yardley Wood Road'. You therefore need to check you have selected the appropriate street level record in Postcode before adding property information.
This refers to postcodes that have a PO Box number rather than property details to capture. The PO Box number is included in Postcode and so only the business or individual name needs to be captured in this case.
Examples:
B2 5HX This is PO Box 5566 for 'Stratten Consultancy' in Birmingham.
B16 6XW This is PO Box 18541 for 'Brainy Bar Ltd' in BirminghamWhen this indicator is present, the address or addresses on this postcode do not have any property information present. So in this case you are only required to capture an organisation or resident name to complete a fully deliverable address.
Examples:
B1 2UN This is 'Hydrapower Dynamics Ltd' on St. Marks Street in Birmingham. No other property information is present in the fully deliverable address.
B29 5AA This contains addresses for 'Lodge Hill Cemetery' and 'Lodge Hill Cemetery, The Caretaker', both on Weoley Park Road in Birmingham. Again no other property information is present.
We serve thousands of organisations and a network of hundreds of partners across multiple industry sectors, enabling them to have full confidence in their contact data.