Introduction

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!

Data Export

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 a scanned copy by email to postcode@afd.co.uk. If this form is approved, you will be exempted from the quarterly Data Extract Return procedure.

Installation

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.

Registration

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 0333 433 0712, Monday to Friday: 0900 – 1700 (except holidays).

De-Registration

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.

Technical Support

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:

World Wide Web

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.

HelpDesk

If you don’t yet have Internet access, our HelpDesk on 0333 433 0712 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.

Data & Data Updates

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.

Overview

General Overview

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:

Rapid Address Entry

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.

Telephone Caller Identification

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.

Address Lookup & Verification

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.

Searching for Addresses

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’.

Mailing List Building

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.

Nearest Feature

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.

Starting the Program

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.

Main Window

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.

Find Box & Lookup

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.

Tabs

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.

Results List

Address lookup and search results are displayed in the list. Click on a result to see more information on one of the Tabs.

Find Box & Lookup

Postcode Lookups

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.

Other Lookups

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:

EntryExample
Postcode onlyTN22 1QL
Postcode with delivery informationTops Tiles, TN22 1QL
 36,EN2 6LA
 Milas Nails,EN26LA
 Haart, en2 6la
NameDipak Patel
FamilyJohn+Janet Smith
OrganisationPizza Hut
PropertyMountain View Innovation Centre
Street Address157 Holdenhurst Road
Telephone No033 3433 0711

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.

Changes

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.

Lookups with Town, Locality or County

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.

EntryExample
NameDipak Patel,Bradford
FamilyJohn+Janet Smith,Birmingham
OrganisationBoots,Bradford
PropertyAbbey Mill, Hampshire
Street Address21 High Street, Bromley

Alias Localities

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.

Lookup & Search Control Codes

For even better results, and faster performance, Names & Numbers has a series of special control codes which help with lookups and searches:

CodeExamplePurpose
^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 | Stuart Smith‘OR’ – Used to look for either name.
$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.

Lookup Directives

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.

DirectiveExamplePurpose
N=N=David StreetForces lookup as a person’s name
O=O=David StreetForces lookup as an Organisation Name
P=P=Smith, BristolForces lookup as a Property Name
S=S=Smith, BristolForces lookup as a Street Address
L=L=AstonForces lookup as a Locality
T=T=BirminghamForces lookup as a Town

Examples List Window

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.

Order Results by Number

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.

List Surname First

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.

Drag and Drop

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.

Results

Using the Results List

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.

Auto Insert / DDE

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.

Search Quantity

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.

Edited Electoral Roll

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.

Search Tab

Using the Search Tab

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.

Type Ahead

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.

List Buttons

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.

Grid Reference Lookup

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.

Shortcuts

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.

Special Search Types

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.

Drag & Drop

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.

Skipping

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

Order Results by Number

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.

List Surname First

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.

Alias Localities

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.

Results Tab

Using the Results Tab

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:

CodeNo of Employees
A1
B2 To 5
C6 To 10
D11 To 25
E26 To 50
F51 To 100
G101 To 200
H201 To 500
I501+
(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.

Customising Fields Displayed

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.

Shortcuts

Field-Transfer

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.

Editable Results Fields

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.

More Tab

Using the More Tab

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:

FieldMeaning
General 
Mailsort CodeThe code is assigned by Royal Mail and used to sort mail for discounts.
TV RegionThe TV Region (ISBA Region – not TV Company) the postcode falls into
Postcode TypeIndicates 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.
GenderThis will be Male, Female or Unknown and indicates the Gender of the selected resident.
ResidencyThis indicates the number of years the selected resident has been on the electoral roll at this address.
UDPRNEach 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 BirthThis 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:

  1. 1 Male and 1 Female occupant with different surnames
  2. 1 Male and 1 Female occupant with the same surname (married couples)
  3. Mixed household
  4. More than 2 persons with the same surname (e.g. older families).
  5. 1 Male Occupant Only
  6. 1 Female Occupant Only
  7. More than 7 persons (e.g. old peoples home).
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:

  • Large User Organisation (Single Organisation on this postcode)
  • Small User Organisations (All the properties on this postcode are likely to be businesses)
  • Mostly Organisations (Most of the properties on this postcode are organisations)
  • Mixed (This postcode contains a mixture of business and residential addresses)
  • Mostly Residential (Most of the properties on this postcode are residential)
  • Residential (All the properties on this postcode are likely to be residential).
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:

  • Numbered (Only a property number needs to be captured)
  • Numbered and Named (This postcode contains a mixture of properties needing a property number and those needing a property name (including properties such as 16b)
  • Numbered and Named, Likelihood of Multiple Occupancy (This postcode contains a mixture of properties needing a property number and those needing a property name. Some of the properties on this postcode are likely to contain multiple occupants, e.g. flats).
  • Named (This postcode only contains properties needing a property name).
  • Non-Standard Address Format (This refers to addresses which do not have a street field at all, or have multiple street names on the same postcode. This also includes addresses with numbered localities (no street but a house number which goes in with the locality field). It is in-effect a warning to be careful in capturing the property information as it is not in one of the most common address formats).
  • PO Box (This postcode has a PO Box number)
  • No Property Information (Addresses on this postcode have no property information – i.e. capture an Organisation or Resident name only)

Please refer to Appendix L for more information regarding the Occupancy and Address Type indicators in Names & Numbers.

Geographical 
Grid East and NorthA 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 LongitudeThe 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

  • A1 – Urban major conurbation: OA falls within a built-up area with a population of 10,000 or more and is assigned to the ‘major conurbation’ settlement category. The wider surrounding area is less sparsely populated;
  • B1 – Urban minor conurbation: OA falls within a built-up area with a population of 10,000 or more and is assigned to the ‘minor conurbation’ settlement category. The wider surrounding area is less sparsely populated;
  • C1 – Urban city and town: OA falls within a built-up area with a population of 10,000 or more and is assigned to the ‘city and town’ settlement category. The wider surrounding area is less sparsely populated;
  • C2 – Urban city and town in a sparse setting: OA falls within a built-up area with a population of 10,000 or more and is assigned to the ‘city and town’ settlement category. The wider surrounding area is sparsely populated;
  • D1 – Rural town and fringe: OA is assigned to the ‘town and fringe’ settlement category. The wider surrounding area is less sparsely populated;
  • D2 – Rural town and fringe in a sparse setting: OA is assigned to the ‘town and fringe’ settlement category. The wider surrounding area is sparsely populated;
  • E1 – Rural village: OA is assigned to the ‘village’ settlement category. The wider surrounding area is less sparsely populated;
  • E2 – Rural village in a sparse setting: OA is assigned to the ‘village’ settlement category. The wider surrounding area is sparsely populated;
  • F1 – Rural hamlet and isolated dwellings: OA is assigned to the ‘hamlet and isolated dwelling’ settlement category. The wider surrounding area is less sparsely populated;
  • F2 – Rural hamlet and isolated dwellings in a sparse setting: OA is assigned to the ‘hamlet and isolated dwelling’ settlement category. The wider surrounding area is sparsely populated.

Scotland

  • S1 – Large Urban Area: Settlement of over 125,000 people
  • S2 – Other Urban Area: Settlement of 10,000 to 125,000 people
  • S3 – Accessible Small Town: Settlement of 3,000 to 10,000 people, within 30 minutes drive of a settlement of 10,000 or more
  • S4 – Remote Small Town: Settlement of 3,000 to 10,000 people, with a drive time of 30 to 60 minutes to a settlement of 10,000 or more
  • S5 – Very Remote Small Town: Settlement of 3,000 to 10,000 people, with a drive time of over 60 minutes to a settlement of 10,000 or more
  • S6 – Accessible Rural: Settlement of less than 3,000 people, within 30 minutes drive of a settlement of 10,000 or more
  • S7 – Remote Rural: Settlement of less than 3,000 people, with a drive time of 30 to 60 minutes to a settlement of 10,000 or more
  • S8 – Very Remote Rural: Settlement of less than 3,000 people, with a drive time of over 60 minutes to a settlement of 10,000 or more

Northern Ireland

  • A – Belfast Metropolitan Urban Area
  • B – Derry Urban Area
  • C – Large Town: 18,000 and under 75,000 people
  • D – Medium Town: 10,000 and under 18,000 people
  • E – Small Town: 4,500 and under 10,000 people
  • F – Intermediate Settlement: 2,250 and under 4,500 peopleG – Village: 1,000 and under 2,250 people
  • H – Small Village, Hamlet or Open Countryside: Less than 1,000 people
Urban/Rural NameThis provides a description that corresponds to the urban rural code.
Sub CountryIndicates if the postcode falls within the boundary of England, Wales, Scotland, Northern Ireland, Isle of Man, Jersey or Guernsey
Administrative 
Ward CodeCode identifying the electoral ward the postcode resides in
Ward NameThe name of the electoral ward the postcode resides in
Authority CodeGives 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)
AuthorityGives the name of the Local or Unitary Authority (which ever is relevant) this Postcode is contained in
EER CodeProvides the code of the European Electoral Region that this postcode falls into
EER NameProvides the name of the European Electoral Region that this postcode falls into
LEA CodeProvides the code of the Local Education Authority that this postcode falls into
LEA NameProvides the name of the Local Education Authority that this postcode falls into
Constituency CodeCode for the electoral Constituency the postcode falls into
ConstituencyThe electoral Constituency the postcode falls into
Devolved Constituency CodeCode for the Scottish Parliament Constituency the postcode falls into (where applicable)
Devolved Constituency NameName for the Scottish Parliament Constituency the postcode falls into (where applicable)
Health 
SHA Code

Strategic Health Authority Code. This is:

  • Strategic Health Authority (England)
  • Health Board (Scotland)
  • Health and Social Services Boards (Northern Ireland)
SHA NameStrategic Health Authority Name which corresponds to the NHS Code.
NHS Region CodeNational Health Service Region Code (Regional Office – applies to England only)
NHS Region National HealthService Region Name
CCG Code

Clinical Commissioning Groups Code. This is:

  • Clinical Commissioning Group (CCG) in England
  • Local Health Board (LHB) in Wales
  • Community Health Partnership (CHP) in Scotland
  • Local Commissioning Group (LCG) in Northern Ireland
  • Primary Healthcare Directorate (PHD) in the Isle of Man
CCG NameClinical Commissioning Groups Name which corresponds to the CCG Code.
Business 
Location TypeIndicates if this record refers to a Head Office, Branch or Single Site
Branch CountThe number of branches this organisation has
Group IDThe ID of the group allowing companies belonging to the same parent group to be identified
TurnoverThe modelled annual turnover for this business at this address
National SizeGives 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 SizeGives 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.
BusinessProvides a description of the business
SIC CodeProvides the Standard Industry Classification this business falls into (see Appendix C for a full list of codes).

Searching on More Tab Information

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.

Label Tab

Using the Label Tab

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.

Drag & Drop

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.

Map Tab

Using the Map Tab

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.

Detaching The Map

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.

Moving Around The Map

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).

Viewing Nearest Locations

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.

Finding Distances

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.

Zooming

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.

Transferring Map Images To Other Applications

Three methods are supplied for getting the Map images into other applications:

OLE Drag & Drop

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.

Windows Clipboard

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.

Developers Access

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.

Printing Maps

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.

Getting An Overview Of A Place’s Position In The British Isles

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.

Grid References

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.

Nearest Tab

Using the Nearest Tab

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.

New Database

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.

Opening an Existing Database

Access, Paradox, dBASE and FoxPro Tables

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:

  • * Postcode
  • DPS
  • Title
  • Organisation
  • Property
  • Street
  • Locality
  • Town
  • County
  • Km
  • Miles
  • Filter
  • Notes
  • * GridE
  • * GridN
  • Surname
  • Firstname
  • Initial
  • Phone
  • Fax
  • Email
  • WWW

*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.

ODBC Tables

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.

Adding Records

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.

Finding the ‘Nearest’

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.

Updating Records

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.

Deleting Records

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.

Filtering Records

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:

CodeAction
{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

Looking up Grid References

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.

Making Labels from Nearest 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.

Showing the Position of a Nearest Record

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.

Viewing Distances to One Decimal Place.

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.

Importing and Exporting Records

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:

  • ** Postcode
  • DPS
  • ** Title
  • Organisation
  • Property
  • Street
  • Locality
  • Town
  • County
  • Km
  • Miles
  • Filter
  • Notes
  • GridE
  • GridN
  • Surname
  • Firstname
  • Initial
  • Phone
  • Fax
  • Email
  • WWW

** must contain a value.

Censation Tab

Using the Censation Tab

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

Build Your Business With Censation®

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.

What is Censation?

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.

Reliability

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.

How does Censation work?

Every postcode is assigned one of 65 Group Codes. This four-character code identifies levels of affluence, life stage and additional distinctive information.

  1. Affluence The first letter in a Censation code indicates levels of affluence or deprivation:
  2. Life Stage The second letter in Censation code indicates life stage:

    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:

    • L – Many organisations mixed with low, transient population
    • M – Residential development with a high incoming population
    • N – Stable turnover of a high population with a few organisations
    • O – Stable turnover of population mixed with commercial development
    • P – Established high residential population

    For information on the codes allocated to postcodes not covered by the UK 2011 Census please see 4. below.

  3. Additional Information The last two digits of a Censation code highlight distinctive characteristics drawn from the underlying Census, Residential or Commercial data or from the lifestyle validation. A short additional description is put in descending order with the strongest or most likely attribute first. View Censation Codes with Additional Information Descriptions. Censation groups do not have names, rather they are expressed as codes with corresponding descriptive information. We have taken the view that to name groups may be a distraction causing us to prejudge a particular group. It is prudent to apply the codes to customer and prospect data, and let the data ‘talk back’ through the codes.View a supporting table with 18 different characteristics.
  4. Censation Label The Censation Label provides a handle for each Censation group for ease of identification and reference as names are often easier to quote and recall than a code. The label is not intended to be used in place of the affluence, lifestage or description which give a fuller description of the groups distinctive characteristics.
  5. Areas not covered by Censation Some (mainly commercial) areas of the UK cannot be classified because Census data is unavailable. However, the Censation system is built using other datasets such as current and historical residential and commercial data along with lifestyle validation. This means that an ‘unclassified code’ is provided as for these areas.

Profiling, Targeting, Locating and Communicating

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.

Data Protection

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.

Special License required for use by data bureaux, mailing houses etc

AFD licenses specifically exclude bureaux use. For bureaux licensing details please email sales@afd.co.uk.

Using Censation with AFD solutions

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

Additional Censation Information is included in appendices G, H, I and J of this Manual:

  • Appendix G – Censation Additional Info
  • Appendix H – Censation Detailed Tables
  • Appendix I – Censation Bar Charts
  • Appendix J – Censation Glossary

Drag & Drop

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.

The Postcode Robot

Introducing Robot Technology

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.

Enabling Robot

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.

Using Robot

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 ActionIf you type normal textIf you type a postcode in quiet modeIf you type a postcode with property information –
Robot’s ActionRobot 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 atB6 4ABRoyal Mail, B6 4AB
What you would see with Robot:Dear Sir, Following our meeting atSt Stephens Street, BIRMINGHAM, B4 6ABRoyal 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:

  • Act!
  • dBase
  • FileMaker Pro
  • Goldmine
  • Lotus 1-2-3
  • Lotus AmiPro
  • Lotus Approach
  • Lotus Organiser
  • Lotus WordPro
  • Maximizer
  • Microsoft Access
  • Microsoft Excel
  • Microsoft Word
  • Microsoft Works
  • Notepad
  • Outlook
  • Paradox
  • Quattro Pro
  • Sage
  • WinFax
  • WordPad
  • WordPerfect
  • Windows Address Book

Wildcards

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:

CodeAction
{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 Settings

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.

System Tray Icon

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.

Toggling Robot On/Off

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.

Setting Options

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.

Transferring Addresses

Transferring Addresses to Other Programs

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:

Robot

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.

Clipboard

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.

Drag & Drop

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.

Insert

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.

Insert and Robot Settings Wizard

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.

  • Show AFD Robot How – This is the simplest mode to configure AFD Postcode to work with your application. Simply ensure your application is ready to accept the address and then click the ‘Show AFD Robot How’ button. You will then be prompted to type a sample address into your application and AFD Robot will learn from you to ensure that this is the last time you have to manually type an address into your application.
  • Tell AFD Robot How – This mode will guide you through step-by-step to get your application working, you select your application and tell AFD Postcode the keystrokes needed to move between fields and the fields that you wish to Insert.
  • Advanced Setup – Should you have more advanced requirements, you can fully configure all the settings yourself using the Advanced Setup option – you may well find it easiest to teach or tell AFD Postcode how to insert the address first and then use Advanced Setup to modify the settings if required.

Show AFD Robot How

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.

Customising Fields

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:

  • Include all fields
  • Include the selected field(s) (from the ‘Available Fields’ List)
  • Remove the selected field(s) (from the ‘Fields To Use’ List)
  • Exclude all fields

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.

Completing the Process

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.

Tell AFD Robot How

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:

Step 1: Your Application

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.

Step 2: Application Options

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:

  • Wordprocessor / Envelope Label: This is an application like Microsoft Word or WordPerfect, were the address is entered down the page with each address line (e.g. Street, Locality, Town, etc.) on a new line. Or any application you are using to print a label for an envelope or the address portion of an envelope itself. The address is transferred down the label with each field on a new line.
  • Database / Form Entry: This refers to an application like Microsoft Access where fields in a table or form are used to enter the address. Or any application with separate boxes were you would enter each address field. TAB is used to move between the fields..
  • Spreadsheet: This is an application like Microsoft Excel or Lotus 1-2-3, were the address is entered in columns for each address field and TAB is used to move between the fields.

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.

Step 3: Fields To Transfer

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:

  • Include all fields
  • Include the selected field(s) (from the ‘Available Fields’ List)
  • Remove the selected field(s) (from the ‘Fields To Use’ List)
  • Exclude all fields
  • **Changing the Order that Fields are Inserted ** 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.
Completing the Wizard

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.

Insert and Robot Advanced Setup

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:

Selecting your Application

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.

Changing Field Mappings

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.

Before and After Keystrokes/Mouse Clicks

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.

Specifying Upper Case Fields

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.

Line Squeeze

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.

Additional Options

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:

Window Titles Associated with this Application

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.

Settings for the Selected Window Title

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:

  • 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. You can also change the # symbol to one more suitable for your application or convenient for you if desired.
  • Use Robot 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.
Settings for the Selected Application

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:

  • Split Fields at Commas for this application – This option is useful with fields that have been squeezed. It will separate fields which have comma’s in them (e.g. a dependant street like ‘Newhall Court, George Street’) onto two separate lines. You may prefer this for labels or for entry into your application. We don’t generally recommend this feature as it means your address will not be in such a consistent format (for example the second street in one address could be in the same place as a locality in another).
  • Use separate settings for Insert and Robot – If enabled this option will separate the settings for Insert and Robot for this application. Normally the settings that Postcode will use for both Insert and Robot are the same for the same application. However if you need to have differing settings for each one you can do this, simply by selecting this option. When you click OK and go back to the Advanced Setup screen you will then see an option at the bottom left of that screen to switch between the settings for Insert and Robot for the application. They will default to being the same but as you make changes to one it will not affect the other.
  • Enable Field Length Limits – This option is designed for applications with small field lengths. It allows you to specify the maximum length of each field you wish to Insert. If the field exceeds this length then Postcode will automatically use the most common abbreviations to try and reduce it’s length to minimise truncation of the field. When you enable this option and click OK to go back to the Advanced Setup screen you will see a Length box has been added to specify this length for each field. A value of 0 means the field will be unlimited in length, otherwise you can specify the number of characters that the field can take.
Default Application Settings

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.

Dynamic Data Exchange (DDE)

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.

Application Programming Interface (API)

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

 

Mailing Labels

Printing Mailing Labels

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.

Label Layout Options

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.

  • Page Height – The height of the page of labels – in millimeters.
  • Page Width – The width of the page of labels – in millimeters.
  • Page Top Margin – The distance between the top of the page, and the top of the first label – in millimeters.
  • Page Left Margin – The distance between the left hand side of the page, and the left hand side of the first label – in millimeters.
  • Label Columns – The number of columns of labels left-to-right across the page, Names & Numbers can print up to four columns of labels per page.
  • Label Rows – The number of rows of labels top-to-bottom down the page, Names & Numbers can print up to twelve rows of labels per page.
  • Label Width – The physical distance from the left hand side of one label, to the left hand side of the next one – ignoring any gap between the labels.
  • Label Depth – The physical distance from the top of one label, to the top of the next one – ignoring any gap between the labels.
  • Barcode Weight – If using Customer Barcoding, this factor, usually set between 1 – 9, allows you to adjust the thickness of the barcode stripes according to your own printer’s physical printing characteristics. Typical Settings are: Dot printer 1-3, Inkjet printer 3-6, Laser Printer 8-9. Your Royal Mail Account Manager should be able to provide technical specifications of the barcode, and print samples.
  • Setup – This button allows you to choose the Windows printer to print your labels to.
  • Font – The Font button allows you to select a suitable Windows typeface and font size for printing your labels. Remember to choose a size that will allow all of the address (and barcode if selected) to properly fit on your chosen labels.
  • Settings – The settings drop-down box displays a list of all the label settings you have set up. To use a different setting, simply click your chosen one. To create a new setting, simply type a new setting name in the box, then press the ‘Save’ button. In this way you can develop your own settings, based on an existing one.
  • Save – Saves the changes you have made to the current label settings.

Printing Options

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

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.

Switching to Compact View

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.

Looking Up Addresses

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.

Inserting Addresses

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.

Other Features

On Top

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.

Hot Key

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 (0333 433 0712) 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.

Appendices

Appendix A: Command Line Options

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 5TJLooks up ’37,AB31 5TJ’ immediately after loading
/Settings=WPSpecifies the Settings File to be loaded is ‘WP’
/Splash=NoSuppresses the display of the Splash Screen when loading
/Tab=1Sets 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

Appendix B: Keyboard Shortcuts

Shortcut KeyFunction
[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] + 1Switch to Search Tab
[Alt] + 2Switch to Results Tab
[Alt] + 3Switch to More Tab
[Alt] + 4Switch to Label Tab
[Alt] + 5Switch to Map Tab
[Alt] + 6Switch to Nearest Tab
[Alt] + 7Switch to Cameo Tab
[Alt] + BSwitch Barcode on/off
[Alt] + CClear Results List
[Alt] + DJump to Find Box
[Alt] + EActivate Edit menu
[Alt] + FActivate File menu
[Alt] + HActivate Help menu
[Alt] + IActivate Insert menu
[Alt] + LLookup using current Findbox contents
[Alt] + NActivate Nearest Menu
[Alt] + RPrint single mailing label
[Alt] + SSearch using the address data entered on the ‘Search’ tab
[Alt] + VActivate View menu
[Ctrl] + [Insert]Copy current field to Clipboard
[Shift] + [Insert]Paste current Clipboard contents to field
[Ctrl] + AAdd Nearest Records
[Ctrl] + CCopy current address to Clipboard
[Ctrl] + DView icon for DDE
[Ctrl] + EExport address as ASCII
[Ctrl] + FFilter Nearest Records
[Ctrl] + GSave current settings
[Ctrl] + KDelete Nearest Records
[Ctrl] + MToggle Distance Line
[Ctrl] + OOpen (use) a Settings set
[Ctrl] + PPrint Mailing Labels
[Ctrl] + QSet Search Quantity
[Ctrl] + RView or Alter Properties
[Ctrl] + SSave Currently Displayed Nearest Record
[Ctrl] + TSwitch ‘On Top’ mode on/off
[Ctrl] + XView Examples List
FunctionShortcut 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

Appendix C: Standard Industry Classifications

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
01000CROP AND ANIMAL PRODUCTION, HUNTING AND RELATED SERVICE ACTIVITIES
01100Growing of non-perennial crops
01110Growing of cereals (except rice), leguminous crops and oil seeds
01120Growing of rice
01130Growing of vegetables and melons, roots and tubers
01140Growing of sugar cane
01150Growing of tobacco
01160Growing of fibre crops
01190Growing of other non-perennial crops
01200Growing of perennial crops
01210Growing of grapes
01220Growing of tropical and subtropical fruits
01230Growing of citrus fruits
01240Growing of pome fruits and stone fruits
01250Growing of other tree and bush fruits and nuts
01260Growing of oleaginous fruits
01270Growing of beverage crops
01280Growing of spices, aromatic, drug and pharmaceutical crops
01290Growing of other perennial crops
01300Plant propagation
01300Plant propagation
01400Animal production
01410Raising of dairy cattle
01420Raising of other cattle and buffaloes
01430Raising of horses and other equines
01440Raising of camels and camelids
01450Raising of sheep and goats
01460Raising of swine/pigs
01470Raising of poultry
01490Raising of other animals
01500Mixed farming
01500Mixed farming
01600Support activities to agriculture and post-harvest crop activities
01610Support activities for crop production
01620Support activities for animal production
01621Farm animal boarding and care
01629Support activities for animal production (other than farm animal boarding and care) n.e.c.
01630Post-harvest crop activities
01640Seed processing for propagation
01700Hunting, trapping and related service activities
01700Hunting, trapping and related service activities
02000FORESTRY AND LOGGING
02100Silviculture and other forestry activities
02100Silviculture and other forestry activities
02200Logging
02200Logging
02300Gathering of wild growing non-wood products
02300Gathering of wild growing non-wood products
02400Support services to forestry
02400Support services to forestry
03000FISHING AND AQUACULTURE
03100Fishing
03110Marine fishing
03120Freshwater fishing
03200Aquaculture
03210Marine aquaculture
03220Freshwater aquaculture
MINING AND QUARRYING
05000MINING OF COAL AND LIGNITE
05100Mining of hard coal
05100Mining of hard coal
05101Mining of hard coal from deep coal mines (underground mining)
05102Mining of hard coal from open cast coal working (surface mining)
05200Mining of lignite
05200Mining of lignite
06000EXTRACTION OF CRUDE PETROLEUM AND NATURAL GAS
06100Extraction of crude petroleum
06100Extraction of crude petroleum
06200Extraction of natural gas
06200Extraction of natural gas
07000MINING OF METAL ORES
07100Mining of iron ores
07100Mining of iron ores
07200Mining of non-ferrous metal ores
07210Mining of uranium and thorium ores
07290Mining of other non-ferrous metal ores
08000OTHER MINING AND QUARRYING
08100Quarrying of stone, sand and clay
08110Quarrying of ornamental and building stone, limestone, gypsum, chalk and slate
08120Operation of gravel and sand pits; mining of clays and kaolin
08900Mining and quarrying n.e.c.
08910Mining of chemical and fertiliser minerals
08920Extraction of peat
08930Extraction of salt
08990Other mining and quarrying n.e.c.
09000MINING SUPPORT SERVICE ACTIVITIES
09100Support activities for petroleum and natural gas extraction
09100Support activities for petroleum and natural gas extraction
09900Support activities for other mining and quarrying
09900Support activities for other mining and quarrying
MANUFACTURING
10000MANUFACTURE OF FOOD PRODUCTS
10100Processing and preserving of meat and production of meat products
10110Processing and preserving of meat
10120Processing and preserving of poultry meat
10130Production of meat and poultry meat products
10200Processing and preserving of fish, crustaceans and molluscs
10200Processing and preserving of fish, crustaceans and molluscs
10300Processing and preserving of fruit and vegetables
10310Processing and preserving of potatoes
10320Manufacture of fruit and vegetable juice
10390Other processing and preserving of fruit and vegetables
10400Manufacture of vegetable and animal oils and fats
10410Manufacture of oils and fats
10420Manufacture of margarine and similar edible fats
10500Manufacture of dairy products
10510Operation of dairies and cheese making
10511Liquid milk and cream production
10512Butter and cheese production
10519Manufacture of milk products (other than liquid milk and cream, butter, cheese) n.e.c.
10520Manufacture of ice cream
10600Manufacture of grain mill products, starches and starch products
10610Manufacture of grain mill products
10611Grain milling
10612Manufacture of breakfast cereals and cereals-based foods
10620Manufacture of starches and starch products
10700Manufacture of bakery and farinaceous products
10710Manufacture of bread; manufacture of fresh pastry goods and cakes
10720Manufacture of rusks and biscuits; manufacture of preserved pastry goods and cakes
10730Manufacture of macaroni, noodles, couscous and similar farinaceous products
10800Manufacture of other food products
10810Manufacture of sugar
10820Manufacture of cocoa, chocolate and sugar confectionery
10821Manufacture of cocoa, and chocolate confectionery
10822Manufacture of sugar confectionery
10830Processing of tea and coffee
10831Tea processing
10832Production of coffee and coffee substitutes
10840Manufacture of condiments and seasonings
10850Manufacture of prepared meals and dishes
10860Manufacture of homogenised food preparations and dietetic food
10890Manufacture of other food products n.e.c.
10900Manufacture of prepared animal feeds
10910Manufacture of prepared feeds for farm animals
10920Manufacture of prepared pet foods
11000MANUFACTURE OF BEVERAGES
11000Manufacture of beverages
11010Distilling, rectifying and blending of spirits
11020Manufacture of wine from grape
11030Manufacture of cider and other fruit wines
11040Manufacture of other non-distilled fermented beverages
11050Manufacture of beer
11060Manufacture of malt
11070Manufacture of soft drinks; production of mineral waters and other bottled waters
12000MANUFACTURE OF TOBACCO PRODUCTS
12000Manufacture of tobacco products
12000Manufacture of tobacco products
13000MANUFACTURE OF TEXTILES
13100Preparation and spinning of textile fibres
13100Preparation and spinning of textile fibres
13200Weaving of textiles
13200Weaving of textiles
13300Finishing of textiles
13300Finishing of textiles
13900Manufacture of other textiles
13910Manufacture of knitted and crocheted fabrics
13920Manufacture of made-up textile articles, except apparel
13921Manufacture of soft furnishings
13922Manufacture of canvas goods, sacks etc.
13923Manufacture of household textiles (other than soft furnishings of 13.92/1)
13930Manufacture of carpets and rugs
13931Manufacture of woven or tufted carpets and rugs
13939Manufacture of carpets and rugs (other than woven or tufted) n.e.c.
13940Manufacture of cordage, rope, twine and netting
13950Manufacture of non-wovens and articles made from non-wovens, except apparel
13960Manufacture of other technical and industrial textiles
13990Manufacture of other textiles n.e.c.
14000MANUFACTURE OF WEARING APPAREL
14100Manufacture of wearing apparel, except fur apparel
14110Manufacture of leather clothes
14120Manufacture of workwear
14130Manufacture of other outerwear
14131Manufacture of men’s outerwear, other than leather clothes and workwear
14132Manufacture of women’s outerwear, other than leather clothes and workwear
14140Manufacture of underwear
14141Manufacture of men’s underwear
14142Manufacture of women’s underwear
14190Manufacture of other wearing apparel and accessories
14200Manufacture of articles of fur
14200Manufacture of articles of fur
14300Manufacture of knitted and crocheted apparel
14310Manufacture of knitted and crocheted hosiery
14390Manufacture of other knitted and crocheted apparel
15000MANUFACTURE OF LEATHER AND RELATED PRODUCTS
15100Tanning and dressing of leather; manufacture of luggage, handbags, saddlery and harness; dressing and dyeing of fur
15110Tanning and dressing of leather; dressing and dyeing of fur
15120Manufacture of luggage, handbags and the like, saddlery and harness
15200Manufacture of footwear
15200Manufacture of footwear
16000MANUFACTURE OF WOOD AND OF PRODUCTS OF WOOD AND CORK, EXCEPT FURNITURE; MANUFACTURE OF ARTICLES OF STRAW AND PLAITING MATERIALS
16100Sawmilling and planing of wood
16100Sawmilling and planing of wood
16200Manufacture of products of wood, cork, straw and plaiting materials
16210Manufacture of veneer sheets and wood-based panels
16220Manufacture of assembled parquet floors
16230Manufacture of other builders’ carpentry and joinery
16240Manufacture of wooden containers
16290Manufacture of other products of wood; manufacture of articles of cork, straw and plaiting materials
17000MANUFACTURE OF PAPER AND PAPER PRODUCTS
17100Manufacture of pulp, paper and paperboard
17110Manufacture of pulp
17120Manufacture of paper and paperboard
17200Manufacture of articles of paper and paperboard
17210Manufacture of corrugated paper and paperboard and of containers of paper and paperboard
17211Manufacture of corrugated paper and paperboard; manufacture of sacks and bags of paper
17219Manufacture of paper and paperboard containers other than sacks and bags
17220Manufacture of household and sanitary goods and of toilet requisites
17230Manufacture of paper stationery
17240Manufacture of wallpaper
17290Manufacture of other articles of paper and paperboard
18000PRINTING AND REPRODUCTION OF RECORDED MEDIA
18100Printing and service activities related to printing
18110Printing of newspapers
18120Other printing
18121Manufacture of printed labels
18129Printing (other than printing of newspapers and printing on labels and tags) n.e.c.
18130Pre-press and pre-media services
18140Binding and related services
18200Reproduction of recorded media
18200Reproduction of recorded media
18201Reproduction of sound recording
18202Reproduction of video recording
18203Reproduction of computer media
19000MANUFACTURE OF COKE AND REFINED PETROLEUM PRODUCTS
19100Manufacture of coke oven products
19100Manufacture of coke oven products
19200Manufacture of refined petroleum products
19200Manufacture of refined petroleum products
19201Mineral oil refining
19209Other treatment of petroleum products (excluding mineral oil refining/petrochemicals manufacture)
20000MANUFACTURE OF CHEMICALS AND CHEMICAL PRODUCTS
20100Manufacture of basic chemicals, fertilisers and nitrogen compounds, plastics and synthetic rubber in primary forms
20110Manufacture of industrial gases
20120Manufacture of dyes and pigments
20130Manufacture of other inorganic basic chemicals
20140Manufacture of other organic basic chemicals
20150Manufacture of fertilisers and nitrogen compounds
20160Manufacture of plastics in primary forms
20170Manufacture of synthetic rubber in primary forms
20200Manufacture of pesticides and other agrochemical products
20200Manufacture of pesticides and other agrochemical products
20300Manufacture of paints, varnishes and similar coatings, printing ink and mastics
20300Manufacture of paints, varnishes and similar coatings, printing ink and mastics
20301Manufacture of paints, varnishes and similar coatings, mastics and sealants
20302Manufacture of printing ink
20400Manufacture of soap and detergents, cleaning and polishing preparations, perfumes and toilet preparations
20410Manufacture of soap and detergents, cleaning and polishing preparations
20411Manufacture of soap and detergents
20412Manufacture of cleaning and polishing preparations
20420Manufacture of perfumes and toilet preparations
20500Manufacture of other chemical products
20510Manufacture of explosives
20520Manufacture of glues
20530Manufacture of essential oils
20590Manufacture of other chemical products n.e.c.
20600Manufacture of man-made fibres
20600Manufacture of man-made fibres
21000MANUFACTURE OF BASIC PHARMACEUTICAL PRODUCTS AND PHARMACEUTICAL PREPARATIONS
21100Manufacture of basic pharmaceutical products
21100Manufacture of basic pharmaceutical products
21200Manufacture of pharmaceutical preparations
21200Manufacture of pharmaceutical preparations
22000MANUFACTURE OF RUBBER AND PLASTIC PRODUCTS
22100Manufacture of rubber products
22110Manufacture of rubber tyres and tubes; retreading and rebuilding of rubber tyres
22190Manufacture of other rubber products
22200Manufacture of plastics products
22210Manufacture of plastic plates, sheets, tubes and profiles
22220Manufacture of plastic packing goods
22230Manufacture of builders’ ware of plastic
22290Manufacture of other plastic products
23000MANUFACTURE OF OTHER NON-METALLIC MINERAL PRODUCTS
23100Manufacture of glass and glass products
23110Manufacture of flat glass
23120Shaping and processing of flat glass
23130Manufacture of hollow glass
23140Manufacture of glass fibres
23190Manufacture and processing of other glass, including technical glassware
23200Manufacture of refractory products
23200Manufacture of refractory products
23300Manufacture of clay building materials
23310Manufacture of ceramic tiles and flags
23320Manufacture of bricks, tiles and construction products, in baked clay
23400Manufacture of other porcelain and ceramic products
23410Manufacture of ceramic household and ornamental articles
23420Manufacture of ceramic sanitary fixtures
23430Manufacture of ceramic insulators and insulating fittings
23440Manufacture of other technical ceramic products
23490Manufacture of other ceramic products
23500Manufacture of cement, lime and plaster
23510Manufacture of cement
23520Manufacture of lime and plaster
23600Manufacture of articles of concrete, cement and plaster
23610Manufacture of concrete products for construction purposes
23620Manufacture of plaster products for construction purposes
23630Manufacture of ready-mixed concrete
23640Manufacture of mortars
23650Manufacture of fibre cement
23690Manufacture of other articles of concrete, plaster and cement
23700Cutting, shaping and finishing of stone
23700Cutting, shaping and finishing of stone
23900Manufacture of abrasive products and non-metallic mineral products n.e.c.
23910Production of abrasive products
23990Manufacture of other non-metallic mineral products n.e.c.
24000MANUFACTURE OF BASIC METALS
24100Manufacture of basic iron and steel and of ferro-alloys
24100Manufacture of basic iron and steel and of ferro-alloys
24200Manufacture of tubes, pipes, hollow profiles and related fittings, of steel
24200Manufacture of tubes, pipes, hollow profiles and related fittings, of steel
24300Manufacture of other products of first processing of steel
24310Cold drawing of bars
24320Cold rolling of narrow strip
24330Cold forming or folding
24340Cold drawing of wire
24400Manufacture of basic precious and other non-ferrous metals
24410Precious metals production
24420Aluminium production
24430Lead, zinc and tin production
24440Copper production
24450Other non-ferrous metal production
24460Processing of nuclear fuel
24500Casting of metals
24510Casting of iron
24520Casting of steel
24530Casting of light metals
24540Casting of other non-ferrous metals
25000MANUFACTURE OF FABRICATED METAL PRODUCTS, EXCEPT MACHINERY AND EQUIPMENT
25100Manufacture of structural metal products
25110Manufacture of metal structures and parts of structures
25120Manufacture of doors and windows of metal
25200Manufacture of tanks, reservoirs and containers of metal
25210Manufacture of central heating radiators and boilers
25290Manufacture of other tanks, reservoirs and containers of metal
25300Manufacture of steam generators, except central heating hot water boilers
25300Manufacture of steam generators, except central heating hot water boilers
25400Manufacture of weapons and ammunition
25400Manufacture of weapons and ammunition
25500Forging, pressing, stamping and roll-forming of metal; powder metallurgy
25500Forging, pressing, stamping and roll-forming of metal; powder metallurgy
25600Treatment and coating of metals; machining
25610Treatment and coating of metals
25620Machining
25700Manufacture of cutlery, tools and general hardware
25710Manufacture of cutlery
25720Manufacture of locks and hinges
25730Manufacture of tools
25900Manufacture of other fabricated metal products
25910Manufacture of steel drums and similar containers
25920Manufacture of light metal packaging
25930Manufacture of wire products, chain and springs
25940Manufacture of fasteners and screw machine products
25990Manufacture of other fabricated metal products n.e.c.
26000MANUFACTURE OF COMPUTER, ELECTRONIC AND OPTICAL PRODUCTS
26100Manufacture of electronic components and boards
26110Manufacture of electronic components
26120Manufacture of loaded electronic boards
26200Manufacture of computers and peripheral equipment
26200Manufacture of computers and peripheral equipment
26300Manufacture of communication equipment
26300Manufacture of communication equipment
26301Manufacture of telegraph and telephone apparatus and equipment
26309Manufacture of communication equipment (other than telegraph and telephone apparatus and equipment)
26400Manufacture of consumer electronics
26400Manufacture of consumer electronics
26500Manufacture of instruments and appliances for measuring, testing and navigation; watches and clocks
26510Manufacture of instruments and appliances for measuring, testing and navigation
26511Manufacture of electronic instruments and appliances for measuring, testing, and navigation, except industrial process control equipment
26512Manufacture of electronic industrial process control equipment
26513Manufacture of non-electronic instruments and appliances for measuring, testing and navigation, except industrial process control equipment
26514Manufacture of non-electronic industrial process control equipment
26520Manufacture of watches and clocks
26600Manufacture of irradiation, electromedical and electrotherapeutic equipment
26600Manufacture of irradiation, electromedical and electrotherapeutic equipment
26700Manufacture of optical instruments and photographic equipment
26700Manufacture of optical instruments and photographic equipment
26701Manufacture of optical precision instruments
26702Manufacture of photographic and cinematographic equipment
26800Manufacture of magnetic and optical media
26800Manufacture of magnetic and optical media
27000MANUFACTURE OF ELECTRICAL EQUIPMENT
27100Manufacture of electric motors, generators, transformers and electricity distribution and control apparatus
27110Manufacture of electric motors, generators and transformers
27120Manufacture of electricity distribution and control apparatus
27200Manufacture of batteries and accumulators
27200Manufacture of batteries and accumulators
27300Manufacture of wiring and wiring devices
27310Manufacture of fibre optic cables
27320Manufacture of other electronic and electric wires and cables
27330Manufacture of wiring devices
27400Manufacture of electric lighting equipment
27400Manufacture of electric lighting equipment
27500Manufacture of domestic appliances
27510Manufacture of electric domestic appliances
27520Manufacture of non-electric domestic appliances
27900Manufacture of other electrical equipment
27900Manufacture of other electrical equipment
28000MANUFACTURE OF MACHINERY AND EQUIPMENT N.E.C.
28100Manufacture of general-purpose machinery
28110Manufacture of engines and turbines, except aircraft, vehicle and cycle engines
28120Manufacture of fluid power equipment
28130Manufacture of other pumps and compressors
28131Manufacture of pumps
28132Manufacture of compressors
28140Manufacture of other taps and valves
28150Manufacture of bearings, gears, gearing and driving elements
28200Manufacture of other general-purpose machinery
28210Manufacture of ovens, furnaces and furnace burners
28220Manufacture of lifting and handling equipment
28230Manufacture of office machinery and equipment (except computers and peripheral equipment)
28240Manufacture of power-driven hand tools
28250Manufacture of non-domestic cooling and ventilation equipment
28290Manufacture of other general-purpose machinery n.e.c.
28300Manufacture of agricultural and forestry machinery
28300Manufacture of agricultural and forestry machinery
28301Manufacture of agricultural tractors
28302Manufacture of agricultural and forestry machinery (other than agricultural tractors)
28400Manufacture of metal forming machinery and machine tools
28410Manufacture of metal forming machinery
28490Manufacture of other machine tools
28900Manufacture of other special-purpose machinery
28910Manufacture of machinery for metallurgy
28920Manufacture of machinery for mining, quarrying and construction
28921Manufacture of machinery for mining
28922Manufacture of earthmoving equipment
28923Manufacture of equipment for concrete crushing and screening roadworks
28930Manufacture of machinery for food, beverage and tobacco processing
28940Manufacture of machinery for textile, apparel and leather production
28950Manufacture of machinery for paper and paperboard production
28960Manufacture of plastics and rubber machinery
28990Manufacture of other special-purpose machinery n.e.c.
29000MANUFACTURE OF MOTOR VEHICLES, TRAILERS AND SEMI-TRAILERS
29100Manufacture of motor vehicles
29100Manufacture of motor vehicles
29200Manufacture of bodies (coachwork) for motor vehicles; manufacture of trailers and semi-trailers
29200Manufacture of bodies (coachwork) for motor vehicles; manufacture of trailers and semi-trailers
29201Manufacture of bodies (coachwork) for motor vehicles (except caravans)
29202Manufacture of trailers and semi-trailers
29203Manufacture of caravans
29300Manufacture of parts and accessories for motor vehicles
29310Manufacture of electrical and electronic equipment for motor vehicles
29320Manufacture of other parts and accessories for motor vehicles
30000MANUFACTURE OF OTHER TRANSPORT EQUIPMENT
30100Building of ships and boats
30110Building of ships and floating structures
30120Building of pleasure and sporting boats
30200Manufacture of railway locomotives and rolling stock
30200Manufacture of railway locomotives and rolling stock
30300Manufacture of air and spacecraft and related machinery
30300Manufacture of air and spacecraft and related machinery
30400Manufacture of military fighting vehicles
30400Manufacture of military fighting vehicles
30900Manufacture of transport equipment n.e.c.
30910Manufacture of motorcycles
30920Manufacture of bicycles and invalid carriages
30990Manufacture of other transport equipment n.e.c.
31000MANUFACTURE OF FURNITURE
31000Manufacture of furniture
31010Manufacture of office and shop furniture
31020Manufacture of kitchen furniture
31030Manufacture of mattresses
31090Manufacture of other furniture
32000OTHER MANUFACTURING
32100Manufacture of jewellery, bijouterie and related articles
32110Striking of coins
32120Manufacture of jewellery and related articles
32130Manufacture of imitation jewellery and related articles
32200Manufacture of musical instruments
32200Manufacture of musical instruments
32300Manufacture of sports goods
32300Manufacture of sports goods
32400Manufacture of games and toys
32400Manufacture of games and toys
32401Manufacture of professional and arcade games and toys
32409Manufacture of games and toys (other than professional and arcade games and toys) n.e.c.
32500Manufacture of medical and dental instruments and supplies
32500Manufacture of medical and dental instruments and supplies
32900Other manufacturing n.e.c.
32910Manufacture of brooms and brushes
32990Other manufacturing n.e.c.
33000REPAIR AND INSTALLATION OF MACHINERY AND EQUIPMENT
33100Repair of fabricated metal products, machinery and equipment
33110Repair of fabricated metal products
33120Repair of machinery
33130Repair of electronic and optical equipment
33140Repair of electrical equipment
33150Repair and maintenance of ships and boats
33160Repair and maintenance of aircraft and spacecraft
33170Repair and maintenance of other transport equipment
33190Repair of other equipment
33200Installation of industrial machinery and equipment
33200Installation of industrial machinery and equipment
ELECTRICITY, GAS, STEAM AND AIR CONDITIONING SUPPLY
35000ELECTRICITY, GAS, STEAM AND AIR CONDITIONING SUPPLY
35100Electric power generation, transmission and distribution
35110Production of electricity
35120Transmission of electricity
35130Distribution of electricity
35140Trade of electricity
35200Manufacture of gas; distribution of gaseous fuels through mains
35210Manufacture of gas
35220Distribution of gaseous fuels through mains
35230Trade of gas through mains
35300Steam and air conditioning supply
35300Steam and air conditioning supply
WATER SUPPLY; SEWERAGE, WASTE MANAGEMENT AND REMEDIATION ACTIVITIES
36000WATER COLLECTION, TREATMENT AND SUPPLY
36000Water collection, treatment and supply
36000Water collection, treatment and supply
37000SEWERAGE
37000Sewerage
37000Sewerage
38000WASTE COLLECTION, TREATMENT AND DISPOSAL ACTIVITIES; MATERIALS RECOVERY
38100Waste collection
38110Collection of non-hazardous waste
38120Collection of hazardous waste
38200Waste treatment and disposal
38210Treatment and disposal of non-hazardous waste
38220Treatment and disposal of hazardous waste
38300Materials recovery
38310Dismantling of wrecks
38320Recovery of sorted materials
39000REMEDIATION ACTIVITIES AND OTHER WASTE MANAGEMENT SERVICES.
39000Remediation activities and other waste management services
39000Remediation activities and other waste management services
CONSTRUCTION
41000CONSTRUCTION OF BUILDINGS
41100Development of building projects
41100Development of building projects
41200Construction of residential and non-residential buildings
41200Construction of residential and non-residential buildings
41201Construction of commercial buildings
41202Construction of domestic buildings
42000CIVIL ENGINEERING
42100Construction of roads and railways
42110Construction of roads and motorways
42120Construction of railways and underground railways
42130Construction of bridges and tunnels
42200Construction of utility projects
42210Construction of utility projects for fluids
42220Construction of utility projects for electricity and telecommunications
42900Construction of other civil engineering projects
42910Construction of water projects
42990Construction of other civil engineering projects n.e.c.
43000SPECIALISED CONSTRUCTION ACTIVITIES
43100Demolition and site preparation
43110Demolition
43120Site preparation
43130Test drilling and boring
43200Electrical, plumbing and other construction installation activities
43210Electrical installation
43220Plumbing, heat and air-conditioning installation
43290Other construction installation
43300Building completion and finishing
43310Plastering
43320Joinery installation
43330Floor and wall covering
43340Painting and glazing
43341Painting
43342Glazing
43390Other building completion and finishing
43900Other specialised construction activities
43910Roofing activities
43990Other specialised construction activities n.e.c.
43991Scaffold erection
43999Specialised construction activities (other than scaffold erection) n.e.c.
WHOLESALE AND RETAIL TRADE; REPAIR OF MOTOR VEHICLES AND MOTORCYCLES
45000WHOLESALE AND RETAIL TRADE AND REPAIR OF MOTOR VEHICLES AND MOTORCYCLES
45100Sale of motor vehicles
45110Sale of cars and light motor vehicles
45111Sale of new cars and light motor vehicles
45112Sale of used cars and light motor vehicles
45190Sale of other motor vehicles
45200Maintenance and repair of motor vehicles
45200Maintenance and repair of motor vehicles
45300Sale of motor vehicle parts and accessories
45310Wholesale trade of motor vehicle parts and accessories
45320Retail trade of motor vehicle parts and accessories
45400Sale, maintenance and repair of motorcycles and related parts and accessories
45400Sale, maintenance and repair of motorcycles and related parts and accessories
46000WHOLESALE TRADE, EXCEPT OF MOTOR VEHICLES AND MOTORCYCLES
46100Wholesale on a fee or contract basis
46110Agents involved in the sale of agricultural raw materials, live animals, textile raw materials and semi-finished goods
46120Agents involved in the sale of fuels, ores, metals and industrial chemicals
46130Agents involved in the sale of timber and building materials
46140Agents involved in the sale of machinery, industrial equipment, ships and aircraft
46150Agents involved in the sale of furniture, household goods, hardware and ironmongery
46160Agents involved in the sale of textiles, clothing, fur, footwear and leather goods
46170Agents involved in the sale of food, beverages and tobacco
46180Agents specialised in the sale of other particular products
46190Agents involved in the sale of a variety of goods
46200Wholesale of agricultural raw materials and live animals
46210Wholesale of grain, unmanufactured tobacco, seeds and animal feeds
46220Wholesale of flowers and plants
46230Wholesale of live animals
46240Wholesale of hides, skins and leather
46300Wholesale of food, beverages and tobacco
46310Wholesale of fruit and vegetables
46320Wholesale of meat and meat products
46330Wholesale of dairy products, eggs and edible oils and fats
46340Wholesale of beverages
46341Wholesale of fruit and vegetable juices, mineral waters and soft drinks
46342Wholesale of wine, beer, spirits and other alcoholic beverages
46350Wholesale of tobacco products
46360Wholesale of sugar and chocolate and sugar confectionery
46370Wholesale of coffee, tea, cocoa and spices
46380Wholesale of other food, including fish, crustaceans and molluscs
46390Non-specialised wholesale of food, beverages and tobacco
46400Wholesale of household goods
46410Wholesale of textiles
46420Wholesale of clothing and footwear
46430Wholesale of electrical household appliances
46431Wholesale of gramophone records, audio tapes, compact discs and video tapes and of the equipment on which these are played
46439Wholesale 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.
46440Wholesale of china and glassware and cleaning materials
46450Wholesale of perfume and cosmetics
46460Wholesale of pharmaceutical goods
46470Wholesale of furniture, carpets and lighting equipment
46480Wholesale of watches and jewellery
46490Wholesale of other household goods
46491Wholesale of musical instruments
46499Wholesale of household goods (other than musical instruments) n.e.c.
46500Wholesale of information and communication equipment
46510Wholesale of computers, computer peripheral equipment and software
46520Wholesale of electronic and telecommunications equipment and parts
46600Wholesale of other machinery, equipment and supplies
46610Wholesale of agricultural machinery, equipment and supplies
46620Wholesale of machine tools
46630Wholesale of mining, construction and civil engineering machinery
46640Wholesale of machinery for the textile industry and of sewing and knitting machines
46650Wholesale of office furniture
46660Wholesale of other office machinery and equipment
46690Wholesale of other machinery and equipment
46700Other specialised wholesale
46710Wholesale of solid, liquid and gaseous fuels and related products
46711Wholesale of petroleum and petroleum products
46719Wholesale of fuels and related products (other than petroleum and petroleum products)
46720Wholesale of metals and metal ores
46730Wholesale of wood, construction materials and sanitary equipment
46740Wholesale of hardware, plumbing and heating equipment and supplies
46750Wholesale of chemical products
46760Wholesale of other intermediate products
46770Wholesale of waste and scrap
46900Non-specialised wholesale trade
46900Non-specialised wholesale trade
47000RETAIL TRADE, EXCEPT OF MOTOR VEHICLES AND MOTORCYCLES
47100Retail sale in non-specialised stores
47110Retail sale in non-specialised stores with food, beverages or tobacco predominating
47190Other retail sale in non-specialised stores
47200Retail sale of food, beverages and tobacco in specialised stores
47210Retail sale of fruit and vegetables in specialised stores
47220Retail sale of meat and meat products in specialised stores
47230Retail sale of fish, crustaceans and molluscs in specialised stores
47240Retail sale of bread, cakes, flour confectionery and sugar confectionery in specialised stores
47250Retail sale of beverages in specialised stores
47260Retail sale of tobacco products in specialised stores
47290Other retail sale of food in specialised stores
47300Retail sale of automotive fuel in specialised stores
47300Retail sale of automotive fuel in specialised stores
47400Retail sale of information and communication equipment in specialised stores
47410Retail sale of computers, peripheral units and software in specialised stores
47420Retail sale of telecommunications equipment in specialised stores
47421Retail sale of mobile telephones in specialised stores
47429Retail sale of telecommunications equipment (other than mobile telephones) n.e.c., in specialised stores
47430Retail sale of audio and video equipment in specialised stores
47500Retail sale of other household equipment in specialised stores
47510Retail sale of textiles in specialised stores
47520Retail sale of hardware, paints and glass in specialised stores
47530Retail sale of carpets, rugs, wall and floor coverings in specialised stores
47540Retail sale of electrical household appliances in specialised stores
47590Retail sale of furniture, lighting equipment and other household articles in specialised stores
47591Retail sale of musical instruments and scores in specialised stores
47599Retail sale of furniture, lighting equipment and other household articles (other than musical instruments) n.e.c., in specialised stores
47600Retail sale of cultural and recreation goods in specialised stores
47610Retail sale of books in specialised stores
47620Retail sale of newspapers and stationery in specialised stores
47630Retail sale of music and video recordings in specialised stores
47640Retail sale of sporting equipment in specialised stores
47650Retail sale of games and toys in specialised stores
47700Retail sale of other goods in specialised stores
47710Retail sale of clothing in specialised stores
47720Retail sale of footwear and leather goods in specialised stores
47721Retail sale of footwear in specialised stores
47722Retail sale of leather goods in specialised stores
47730Dispensing chemist in specialised stores
47740Retail sale of medical and orthopaedic goods in specialised stores
47741Retail sale of hearing aids in specialised stores
47749Retail sale of medical and orthopaedic goods (other than hearing aids) n.e.c., in specialised stores
47750Retail sale of cosmetic and toilet articles in specialised stores
47760Retail sale of flowers, plants, seeds, fertilisers, pet animals and pet food in specialised stores
47770Retail sale of watches and jewellery in specialised stores
47780Other retail sale of new goods in specialised stores
47781Retail sale in commercial art galleries
47782Retail sale by opticians
47789Other retail sale of new goods in specialised stores (other than by opticians or commercial art galleries), n.e.c
47790Retail sale of second-hand goods in stores
47791Retail sale of antiques including antique books, in stores
47799Retail sale of second-hand goods (other than antiques and antique books) in stores
47800Retail sale via stalls and markets
47810Retail sale via stalls and markets of food, beverages and tobacco products
47820Retail sale via stalls and markets of textiles, clothing and footwear
47890Retail sale via stalls and markets of other goods
47900Retail trade not in stores, stalls or markets
47910Retail sale via mail order houses or via Internet
47990Other retail sale not in stores, stalls or markets
TRANSPORTATION AND STORAGE
49000LAND TRANSPORT AND TRANSPORT VIA PIPELINES
49100Passenger rail transport, interurban
49100Passenger rail transport, interurban
49200Freight rail transport
49200Freight rail transport
49300Other passenger land transport
49310Urban and suburban passenger land transport
49311Urban, suburban or metropolitan area passenger railway transportation by underground, metro and similar systems
49319Urban, suburban or metropolitan area passenger land transport other than railway transportation by underground, metro and similar systems
49320Taxi operation
49390Other passenger land transport n.e.c.
49400Freight transport by road and removal services
49410Freight transport by road
49420Removal services
49500Transport via pipeline
49500Transport via pipeline
50000WATER TRANSPORT
50100Sea and coastal passenger water transport
50100Sea and coastal passenger water transport
50200Sea and coastal freight water transport
50200Sea and coastal freight water transport
50300Inland passenger water transport
50300Inland passenger water transport
50400Inland freight water transport
50400Inland freight water transport
51000AIR TRANSPORT
51100Passenger air transport
51100Passenger air transport
51101Scheduled passenger air transport
51102Non-scheduled passenger air transport
51200Freight air transport and space transport
51210Freight air transport
51220Space transport
52000WAREHOUSING AND SUPPORT ACTIVITIES FOR TRANSPORTATION
52100Warehousing and storage
52100Warehousing and storage
52101Operation of warehousing and storage facilities for water transport activities of division 50
52102Operation of warehousing and storage facilities for air transport activities of division 51
52103Operation of warehousing and storage facilities for land transport activities of division 49
52200Support activities for transportation
52210Service activities incidental to land transportation
52211Operation of rail freight terminals
52212Operation of rail passenger facilities at railway stations
52213Operation of bus and coach passenger facilities at bus and coach stations
52219Other 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)
52220Service activities incidental to water transportation
52230Service activities incidental to air transportation
52240Cargo handling
52241Cargo handling for water transport activities of division 50
52242Cargo handling for air transport activities of division 51
52243Cargo handling for land transport activities of division 49
52290Other transportation support activities
53000POSTAL AND COURIER ACTIVITIES
53100Postal activities under universal service obligation
53100Postal activities under universal service obligation
53200Other postal and courier activities
53200Other postal and courier activities
53201Licensed Carriers
53202Unlicensed Carriers
ACCOMMODATION AND FOOD SERVICE ACTIVITIES
55000ACCOMMODATION
55100Hotels and similar accommodation
55100Hotels and similar accommodation
55200Holiday and other short-stay accommodation
55200Holiday and other short-stay accommodation
55201Holiday centres and villages
55202Youth hostels
55209Other holiday and other short-stay accommodation (not including holiday centres and villages or youth hostels) n.e.c.
55300Camping grounds, recreational vehicle parks and trailer parks
55300Camping grounds, recreational vehicle parks and trailer parks
55900Other accommodation
55900Other accommodation
56000FOOD AND BEVERAGE SERVICE ACTIVITIES
56100Restaurants and mobile food service activities
56100Restaurants and mobile food service activities
56101Licensed restaurants
56102Unlicensed restaurants and cafes
56103Take away food shops and mobile food stands
56200Event catering and other food service activities
56210Event catering activities
56290Other food service activities
56300Beverage serving activities
56300Beverage serving activities
56301Licensed clubs
56302Public houses and bars
INFORMATION AND COMMUNICATION
58000PUBLISHING ACTIVITIES
58100Publishing of books, periodicals and other publishing activities
58110Book publishing
58120Publishing of directories and mailing lists
58130Publishing of newspapers
58140Publishing of journals and periodicals
58141Publishing of learned journals
58142Publishing of consumer, business and professional journals and periodicals
58190Other publishing activities
58200Software publishing
58210Publishing of computer games
58290Other software publishing
59000MOTION PICTURE, VIDEO AND TELEVISION PROGRAMME PRODUCTION, SOUND RECORDING AND MUSIC PUBLISHING ACTIVITIES
59100Motion picture, video and television programme activities
59110Motion picture, video and television programme production activities
59111Motion picture production activities
59112Video production activities
59113Television programme production activities
59120Motion picture, video and television programme post-production activities
59130Motion picture, video and television programme distribution activities
59131Motion picture distribution activities
59132Video distribution activities
59133Television programme distribution activities
59140Motion picture projection activities
59200Sound recording and music publishing activities
59200Sound recording and music publishing activities
60000PROGRAMMING AND BROADCASTING ACTIVITIES
60100Radio broadcasting
60100Radio broadcasting
60200Television programming and broadcasting activities
60200Television programming and broadcasting activities
61000TELECOMMUNICATIONS
61100Wired telecommunications activities
61100Wired telecommunications activities
61200Wireless telecommunications activities
61200Wireless telecommunications activities
61300Satellite telecommunications activities
61300Satellite telecommunications activities
61900Other telecommunications activities
61900Other telecommunications activities
62000COMPUTER PROGRAMMING, CONSULTANCY AND RELATED ACTIVITIES
62000Computer programming, consultancy and related activities
62010Computer programming activities
62011Ready-made interactive leisure and entertainment software development
62012Business and domestic software development
62020Computer consultancy activities
62030Computer facilities management activities
62090Other information technology and computer service activities
63000INFORMATION SERVICE ACTIVITIES
63100Data processing, hosting and related activities; web portals
63110Data processing, hosting and related activities
63120Web portals
63900Other information service activities
63910News agency activities
63990Other information service activities n.e.c.
FINANCIAL AND INSURANCE ACTIVITIES
64000FINANCIAL SERVICE ACTIVITIES, EXCEPT INSURANCE AND PENSION FUNDING
64100Monetary intermediation
64110Central banking
64190Other monetary intermediation
64191Banks
64192Building societies
64200Activities of holding companies
64200Activities of holding companies
64201Activities of agricultural holding companies
64202Activities of production holding companies
64203Activities of construction holding companies
64204Activities of distribution holding companies
64205Activities of financial services holding companies
64209Activities of other holding companies (not including agricultural, production, construction, distribution and financial services holding companies) n.e.c.
64300Trusts, funds and similar financial entities
64300Trusts, funds and similar financial entities
64301Activities of investment trusts
64302Activities of unit trusts
64303Activities of venture and development capital companies
64304Activities of open-ended investment companies
64305Activities of property unit trusts
64306Activities of real estate investment trusts
64900Other financial service activities, except insurance and pension funding
64910Financial leasing
64920Other credit granting
64921Credit granting by non-deposit taking finance houses and other specialist consumer credit grantors
64922Activities of mortgage finance companies
64929Other 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.
64990Other financial service activities, except insurance and pension funding, n.e.c.
64991Security dealing on own account
64992Factoring
64999Other financial service activities, except insurance and pension funding, (not including security dealing on own account and factoring) n.e.c.
65000INSURANCE, REINSURANCE AND PENSION FUNDING, EXCEPT COMPULSORY SOCIAL SECURITY
65100Insurance
65110Life insurance
65120Non-life insurance
65200Reinsurance
65200Reinsurance
65201Life reinsurance
65202Non-life reinsurance
65300Pension funding
65300Pension funding
66000ACTIVITIES AUXILIARY TO FINANCIAL SERVICES AND INSURANCE ACTIVITIES
66100Activities auxiliary to financial services, except insurance and pension funding
66110Administration of financial markets
66120Security and commodity contracts brokerage
66190Other activities auxiliary to financial services, except insurance and pension funding
66200Activities auxiliary to insurance and pension funding
66210Risk and damage evaluation
66220Activities of insurance agents and brokers
66290Other activities auxiliary to insurance and pension funding
66300Fund management activities
66300Fund management activities
REAL ESTATE ACTIVITIES
68000REAL ESTATE ACTIVITIES
68100Buying and selling of own real estate
68100Buying and selling of own real estate
68200Renting and operating of own or leased real estate
68200Renting and operating of own or leased real estate
68201Renting and operating of Housing Association real estate
68202Letting and operating of conference and exhibition centres
68209Letting and operating of own or leased real estate (other than Housing Association real estate and conference and exhibition services) n.e.c.
68300Real estate activities on a fee or contract basis
68310Real estate agencies
68320Management of real estate on a fee or contract basis
PROFESSIONAL, SCIENTIFIC AND TECHNICAL ACTIVITIES
69000LEGAL AND ACCOUNTING ACTIVITIES
69100Legal activities
69100Legal activities
69101Barristers at law
69102Solicitors
69109Activities of patent and copyright agents; other legal activities (other than those of barristers and solicitors) n.e.c.
69200Accounting, bookkeeping and auditing activities; tax consultancy
69200Accounting, bookkeeping and auditing activities; tax consultancy
69201Accounting, and auditing activities
69202Bookkeeping activities
69203Tax consultancy
70000ACTIVITIES OF HEAD OFFICES; MANAGEMENT CONSULTANCY ACTIVITIES
70100Activities of head offices
70100Activities of head offices
70200Management consultancy activities
70210Public relations and communication activities
70220Business and other management consultancy activities
70221Financial management
70229Management consultancy activities (other than financial management)
71000ARCHITECTURAL AND ENGINEERING ACTIVITIES; TECHNICAL TESTING AND ANALYSIS
71100Architectural and engineering activities and related technical consultancy
71110Architectural activities
71111Architectural activities
71112Urban planning and landscape architectural activities
71120Engineering activities and related technical consultancy
71121Engineering design activities for industrial process and production
71122Engineering related scientific and technical consulting activities
71129Other engineering activities (not including engineering design for industrial process and production or engineering related scientific and technical consulting activities)
71200Technical testing and analysis
71200Technical testing and analysis
72000SCIENTIFIC RESEARCH AND DEVELOPMENT
72100Research and experimental development on natural sciences and engineering
72110Research and experimental development on biotechnology
72190Other research and experimental development on natural sciences and engineering
72200Research and experimental development on social sciences and humanities
72200Research and experimental development on social sciences and humanities
73000ADVERTISING AND MARKET RESEARCH
73100Advertising
73110Advertising agencies
73120Media representation
73200Market research and public opinion polling
73200Market research and public opinion polling
74000OTHER PROFESSIONAL, SCIENTIFIC AND TECHNICAL ACTIVITIES
74100Specialised design activities
74100Specialised design activities
74200Photographic activities
74200Photographic activities
74201Portrait photographic activities
74202Other specialist photography (not including portrait photography)
74203Film processing
74209Other photographic activities (not including portrait and other specialist photography and film processing) n.e.c.
74300Translation and interpretation activities
74300Translation and interpretation activities
74900Other professional, scientific and technical activities n.e.c.
74900Other professional, scientific and technical activities n.e.c.
74901Environmental consulting activities
74902Quantity surveying activities
74909Other professional, scientific and technical activities (not including environmental consultancy or quantity surveying) n.e.c.
75000VETERINARY ACTIVITIES
75000Veterinary activities
75000Veterinary activities
ADMINISTRATIVE AND SUPPORT SERVICE ACTIVITIES
77000RENTAL AND LEASING ACTIVITIES
77100Renting and leasing of motor vehicles
77110Renting and leasing of cars and light motor vehicles
77120Renting and leasing of trucks
77200Renting and leasing of personal and household goods
77210Renting and leasing of recreational and sports goods
77220Renting of video tapes and disks
77290Renting and leasing of other personal and household goods
77291Renting and leasing of media entertainment equipment
77299Renting and leasing of other personal and household goods (other than media entertainment equipment)
77300Renting and leasing of other machinery, equipment and tangible goods
77310Renting and leasing of agricultural machinery and equipment
77320Renting and leasing of construction and civil engineering machinery and equipment
77330Renting and leasing of office machinery and equipment (including computers)
77340Renting and leasing of water transport equipment
77341Renting and leasing of passenger water transport equipment
77342Renting and leasing of freight water transport equipment
77350Renting and leasing of air transport equipment
77351Renting and leasing of passenger air transport equipment
77352Renting and leasing of freight air transport equipment
77390Renting and leasing of other machinery, equipment and tangible goods n.e.c.
77400Leasing of intellectual property and similar products, except copyrighted works
77400Leasing of intellectual property and similar products, except copyrighted works
78000EMPLOYMENT ACTIVITIES
78100Activities of employment placement agencies
78100Activities of employment placement agencies
78101Motion picture, television and other theatrical casting
78109Activities of employment placement agencies (other than motion picture, television and other theatrical casting) n.e.c.
78200Temporary employment agency activities
78200Temporary employment agency activities
78300Other human resources provision
78300Other human resources provision
79000TRAVEL AGENCY, TOUR OPERATOR AND OTHER RESERVATION SERVICE AND RELATED ACTIVITIES
79100Travel agency and tour operator activities
79110Travel agency activities
79120Tour operator activities
79900Other reservation service and related activities
79900Other reservation service and related activities
79901Activities of tourist guides
79909Other reservation service activities (not including activities of tourist guides)
80000SECURITY AND INVESTIGATION ACTIVITIES
80100Private security activities
80100Private security activities
80200Security systems service activities
80200Security systems service activities
80300Investigation activities
80300Investigation activities
81000SERVICES TO BUILDINGS AND LANDSCAPE ACTIVITIES
81100Combined facilities support activities
81100Combined facilities support activities
81200Cleaning activities
81210General cleaning of buildings
81220Other building and industrial cleaning activities
81221Window cleaning services
81222Specialised cleaning services
81223Furnace and chimney cleaning services
81229Building and industrial cleaning activities (other than window cleaning, specialised cleaning and furnace and chimney cleaning services) n.e.c.
81290Other cleaning activities
81291Disinfecting and extermination services
81299Cleaning services (other than disinfecting and extermination services) n.e.c.
81300Landscape service activities
81300Landscape service activities
82000OFFICE ADMINISTRATIVE, OFFICE SUPPORT AND OTHER BUSINESS SUPPORT ACTIVITIES
82100Office administrative and support activities
82110Combined office administrative service activities
82190Photocopying, document preparation and other specialised office support activities
82200Activities of call centres
82200Activities of call centres
82300Organisation of conventions and trade shows
82300Organisation of conventions and trade shows
82301Activities of exhibition and fair organizers
82302Activities of conference organizers
82900Business support service activities n.e.c.
82910Activities of collection agencies and credit bureaus
82911Activities of collection agencies
82912Activities of credit bureaus
82920Packaging activities
82990Other business support service activities n.e.c.
PUBLIC ADMINISTRATION AND DEFENCE; COMPULSORY SOCIAL SECURITY
84000PUBLIC ADMINISTRATION AND DEFENCE; COMPULSORY SOCIAL SECURITY
84100Administration of the State and the economic and social policy of the community
84110General public administration activities
84120Regulation of the activities of providing health care, education, cultural services and other social services, excluding social security
84130Regulation of and contribution to more efficient operation of businesses
84200Provision of services to the community as a whole
84210Foreign affairs
84220Defence activities
84230Justice and judicial activities
84240Public order and safety activities
84250Fire service activities
84300Compulsory social security activities
84300Compulsory social security activities
EDUCATION
85000EDUCATION
85100Pre-primary education
85100Pre-primary education
85200Primary education
85200Primary education
85300Secondary education
85310General secondary education
85320Technical and vocational secondary education
85400Higher education
85410Post-secondary non-tertiary education
85420Tertiary education
85421First-degree level higher education
85422Post-graduate level higher education
85500Other education
85510Sports and recreation education
85520Cultural education
85530Driving school activities
85590Other education n.e.c.
85600Educational support activities
85600Educational support activities
HUMAN HEALTH AND SOCIAL WORK ACTIVITIES
86000HUMAN HEALTH ACTIVITIES
86100Hospital activities
86100Hospital activities
86101Hospital activities
86102Medical nursing home activities
86200Medical and dental practice activities
86210General medical practice activities
86220Specialist medical practice activities
86230Dental practice activities
86900Other human health activities
86900Other human health activities
87000RESIDENTIAL CARE ACTIVITIES
87100Residential nursing care activities
87100Residential nursing care activities
87200Residential care activities for learning disabilities, mental health and substance abuse
87200Residential care activities for learning disabilities, mental health and substance abuse
87300Residential care activities for the elderly and disabled
87300Residential care activities for the elderly and disabled
87900Other residential care activities
87900Other residential care activities
88000SOCIAL WORK ACTIVITIES WITHOUT ACCOMMODATION
88100Social work activities without accommodation for the elderly and disabled
88100Social work activities without accommodation for the elderly and disabled
88900Other social work activities without accommodation
88910Child day-care activities
88990Other social work activities without accommodation n.e.c.
ARTS, ENTERTAINMENT AND RECREATION
90000CREATIVE, ARTS AND ENTERTAINMENT ACTIVITIES
90000Creative, arts and entertainment activities
90010Performing arts
90020Support activities to performing arts
90030Artistic creation
90040Operation of arts facilities
91000LIBRARIES, ARCHIVES, MUSEUMS AND OTHER CULTURAL ACTIVITIES
91000Libraries, archives, museums and other cultural activities
91010Library and archive activities
91011Library activities
91012Archive activities
91020Museum activities
91030Operation of historical sites and buildings and similar visitor attractions
91040Botanical and zoological gardens and nature reserve activities
92000GAMBLING AND BETTING ACTIVITIES
92000Gambling and betting activities
92000Gambling and betting activities
93000SPORTS ACTIVITIES AND AMUSEMENT AND RECREATION ACTIVITIES
93100Sports activities
93110Operation of sports facilities
93120Activities of sport clubs
93130Fitness facilities
93190Other sports activities
93191Activities of racehorse owners
93199Other sports activities (not including activities of racehorse owners) n.e.c.
93200Amusement and recreation activities
93210Activities of amusement parks and theme parks
93290Other amusement and recreation activities
OTHER SERVICE ACTIVITIES
94000ACTIVITIES OF MEMBERSHIP ORGANISATIONS
94100Activities of business, employers and professional membership organisations
94110Activities of business and employers membership organisations
94120Activities of professional membership organisations
94200Activities of trade unions
94200Activities of trade unions
94900Activities of other membership organisations
94910Activities of religious organisations
94920Activities of political organisations
94990Activities of other membership organisations n.e.c.
95000REPAIR OF COMPUTERS AND PERSONAL AND HOUSEHOLD GOODS
95100Repair of computers and communication equipment
95110Repair of computers and peripheral equipment
95120Repair of communication equipment
95200Repair of personal and household goods
95210Repair of consumer electronics
95220Repair of household appliances and home and garden equipment
95230Repair of footwear and leather goods
95240Repair of furniture and home furnishings
95250Repair of watches, clocks and jewellery
95290Repair of other personal and household goods
96000OTHER PERSONAL SERVICE ACTIVITIES
96000Other personal service activities
96010Washing and (dry-)cleaning of textile and fur products
96020Hairdressing and other beauty treatment
96030Funeral and related activities
96040Physical well-being activities
96090Other personal service activities n.e.c.
ACTIVITIES OF HOUSEHOLDS AS EMPLOYERS; UNDIFFERENTIATED GOODS-AND SERVICES-PRODUCING ACTIVITIES OF HOUSEHOLDS FOR OWN USE
97000ACTIVITIES OF HOUSEHOLDS AS EMPLOYERS OF DOMESTIC PERSONNEL
97000Activities of households as employers of domestic personnel
97000Activities of households as employers of domestic personnel
98000UNDIFFERENTIATED GOODS- AND SERVICES-PRODUCING ACTIVITIES OF PRIVATE HOUSEHOLDS FOR OWN USE
98100Undifferentiated goods-producing activities of private households for own use
98100Undifferentiated goods-producing activities of private households for own use
98200Undifferentiated service-producing activities of private households for own use
98200Undifferentiated service-producing activities of private households for own use
ACTIVITIES OF EXTRATERRITORIAL ORGANISATIONS AND BODIES
99000ACTIVITIES OF EXTRATERRITORIAL ORGANISATIONS AND BODIES
99000Activities of extraterritorial organisations and bodies
99000Activities of extraterritorial organisations and bodies

Appendix D: Grid References in AFD Products

Grid References

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)).

Background to Data

England, Wales and Scotland

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

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.

Isle of Man, Channel Islands and other postcodes where Grid References are not available (e.g. PO Boxes)

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.

Latitude & Longitude

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.

Appendix E: End User Licence Agreement

See https://www.afd.co.uk/eula

Appendix F: Re-registration Form

See re-registration form

Appendix G: County Options

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:

  • Postal Counties
  • Abbreviated Postal Counties
  • Postal including Optional Counties
  • Abbreviated Postal Counties including Optional Counties
  • Traditional Counties
  • Administrative Counties

Appendix H: Censation Additional Info

The following table shows the full descriptions for each of the Censation codes.

CodeAffluenceLife StageAdditional InfoLabel
AW01WealthyYoung familiesMany Christians, Professionals with High incomes, commercially activeEclectic Tastes
AW07WealthyYoung familiesEmployed in full education and finance, active online but protective of identity, some Christian and ruralFully online
AW09WealthyYoung familiesPublic servants with above average income, some christians and rural locationsProgressive Families
AX02WealthyOlder familiesAbove average incomes, with tradional backgrounds and high levels of responsibilityBusiness Leaders
AX03WealthyOlder familiesSuburban neighbourhoods with many social grade AB, commercially activeLeafy Avenues
AX05WealthyOlder familiesTraditional outlook with high qualifications and social grade ABInstinctive conservative
AX06WealthyOlder familiesWell above average incomes, in established neighbourhodds, but engaging with the internetThoughtful Progress
AX10WealthyOlder familiesEstablished affluent families, who want privacy with many different Religions and backgroundsGlobal Perspective
AY04WealthyEmpty nests and seniorsManagers and senior officials with high incomes, engaged with commerce and the internetSettled Influence
AY08WealthyEmpty nests and seniorsProfessional and senior managers with a wide range of cultural interestsStyle and Music
BV20ProsperousYoung singlesHighly qualified young people looking to establish themselves and settle downPreparing the Nest
BW11ProsperousYoung familiesHigh incomes, with many Christians, employed in finance and business servicesCultured Engagement
BW18ProsperousYoung familiesSuburban families with young children and high aspirations for commercial successSporting Ambitions
BX15ProsperousOlder familiesBuying their own homes, and preparing for children to leave homeParents Taxi
BY12ProsperousEmpty nests and seniorsEstablished focus on buying home, DIY, home improvements and the gardenHome and Garden
BY13ProsperousEmpty nests and seniorsMixed set of interests, able to do new things now children are becoming independentConsidering Change
BY14ProsperousEmpty nests and seniorsMixed interests, but many with local interests and higher than average incomesConsiderate Participants
BY16ProsperousEmpty nests and seniorsMany retired christians, in suburban settings, with little commercial activityContented Enjoyment
BY17ProsperousEmpty nests and seniorsMany rural locations, employment in agriculture and support for local charitiesCountry Cottage
BY19ProsperousEmpty nests and seniorsSome christians with employment in education and the professionsTraditional Community
BY21ProsperousEmpty nests and seniorsRange of interests with a typical income but much expectation about commercial activityDriven to Get On
CV29ComfortableYoung singlesLots of different activities, with plenty of uptake of technology and online activityPrudent Technologists
CV30ComfortableYoung singlesHighly qualified workers, with some professionals, and interests in Lesiure, clothing and appliancesLiving to the Full
CV31ComfortableYoung singlesMany students, and interests in music, lesiure and eventsFestival Participants
CW26ComfortableYoung familiesHindus and muslims, many employed in the transport sector with some office and shop staffGlobal Reach
CW28ComfortableYoung familiesWide range of interests, particularly charities and family, many manual workers in the retail sectorEmpathetic Supporter
CX22ComfortableOlder familiesMany factory and manual workers in manufacturing and retail. Buying their own houses, some on average incomesSalt of the earth
CX27ComfortableOlder familiesBuying their own home, some in a rural setting, with interests in the local communityAttentive partner
CY23ComfortableEmpty nests and seniorsRetired with a range of interests in semi-detached houses with moderate commercial activity, some with no qualificationsHouse Proud
CY24ComfortableEmpty nests and seniorsRetired with a range of interests, some moderate commercial activity, with some high qualificationsSocial Enthusiast
CY25ComfortableEmpty nests and seniorsRetired with mixed interests with skilled trades and experience in agriculture. Relatively High commercial activity with some intermediate qualificationsHandy skills
DV36StrivingYoung singlesLiving in rented accomodation, working in hotels, business and health services. Sometimes support charitiesFocused Students
DW32StrivingYoung familiesLiving in smaller houses. Manual workers in manufacturing and retailLooking for New Ideas
DW33StrivingYoung familiesTradional outlook with some Christians, working in retail and transport with little commercial activityConscientious worker
DW41StrivingYoung familiesSupport staff employed in manufacturing and retail, on low incomes, with an eclectic range of interestsKeeping Fit
DX34StrivingOlder familiesNo professed religion, with low levels of qualifications. Manual workers reading popular newspapersIndustrious providers
DX39StrivingOlder familiesEmployed in manufacturing, construction and retail as support staff. Many read middle of the road newspapers with a conservative outlookMaking Ends Meet
DX40StrivingOlder familiesEmployed in manufacturing, construction and retail. Have no qualifications and read popular newspapers, but engage with social mediaAspiring Technologists
DX42StrivingOlder familiesVery low incomes – either unemployed or in the hotel trade, but sometimes support charitiesOld-school companions
DY35StrivingEmpty nests and seniorsRetired with mixed interests, many with no religious affiliation who sometimes support charitiesCareful beginners
DY37StrivingEmpty nests and seniorsRetired without qualifications, with experience in manufacturing. Some support charities some of the timeHome Builders
DY38StrivingEmpty nests and seniorsMany retired without qualifications, read popular newspapers, some on low incomesWorking hard
EV46StrugglingYoung singlesSome on low incomes, living in rented accomodation with no religious affiliation, with aspirations for commercial activityBettering themselves
EW44StrugglingYoung familiesMany with no-religious affiliation in social and private rented accommodation, who sometimes support charitiesMeticulous care
EW45StrugglingYoung familiesMixed interests, living in rented accomdation and reading popular newspapersStarting Out
EW50StrugglingYoung familiesSocial renting of smaller flats & houses, very low incomes, with little commercial activityFirm foundations
EX49StrugglingOlder familiesSocial renting of flats & smaller houses, read popular newspapers and little commercial or internet activityDedicated Parents
EY43StrugglingEmpty nests and seniorsRetired, social grade E, with no qualifications. Reading popular newspapers, value privacy with little commercial activityResolute spirit
EY47StrugglingEmpty nests and seniorsRetired with little religious affiliation and no qualifications previously in process support and elementary occupations, some in social and private rentingDiligent Supporters
EY48StrugglingEmpty nests and seniorsSocial grade E, retired with experience of personal health services. Engaged with commercial activityPersistent enquirers
EY51StrugglingEmpty nests and seniorsSocial grade E, retired with experience of elementary occupations in health. Many Muslim and HinduDetermined Survivors
EY52StrugglingEmpty nests and seniorsSocial grade E, retired with experience of elementary occupations in manufacturing. Little commercial and online activityProud Technophobes
NL61Not ClassifiedMany organisations mixed with low, transient populationConsumer commercial centres and offices. Much of this segment arises from business related sources, plus some unidentified residential propertiesUnclassified

Appendix I: Censation Detailed Tables

CodePercentage of UK Population (Postcode Level Censation)Percentage of Adults Over 18 (Individual Level Censation)Percentage of Occupied Households (Household Level Censation)Urban- Rural ScoreRecent New Build ScoreRecent House Sales ScoreRecent Sale Price ScoreAnnual Rate of House Price Increase ScoreAnnual Rate of House Sale
AW011.210.270.21531514
AW070.751.451.11552515
AW090.90.690.58535523
AX020.920.370.31451544
AX032.020.460.29534532
AX051.372.261.59535542
AX061.351.751.38423542
AX101.840.280.27115453
AY041.761.041.52324554
AY081.630.911.19455515
BV201.41.841.56454415
BW111.960.820.66541413
BW181.941.781.48542435
BX151.546.525.02522432
BY121.011.181.83434443
BY131.581.251.9454415
BY141.240.040.05214553
BY160.660.060.1112434
BY171.430.060.05512433
BY190.990.150.23314443
BY210.890.320.46444315
CV290.61.021.11325221
CV300.991.971.85343354
CV311.041.291.17355315
CW261.911.41.09125321
CW282.735.674.84451325
CX228.2613.5310.42342331
CX276.131.31.06433322
CY235.065.89.17243333
CY243.711.792.78233453
CY253.240.430.61112333
DV361.753.633.4331254
DW320.641.110.96551254
DW330.861.020.81335244
DW410.782.191.82351355
DX341.755.213.97314241
DX391.822.692.13323222
DX402.431.491.11442212
DX422.070.610.53433213
DY352.573.575.59251224
DY374.111.822.85222222
DY381.810.260.4111222
EV461.793.153.24241124
EW441.280.630.53211155
EW450.761.591.33245155
EW500.70.660.54112141
EX492.25.554.38223141
EY432.351.262.05122121
EY472.372.684.44143121
EY483.241.392.26221132
EY511.551.651.61113141
EY521.110.110.17111131

Appendix J: Censation Bar Charts

Income

Tenure

Economic Activity

Industry Sector

Occupation

Social Grade

Age

Adult Marital Status

Dependant Children

Religion

Qualifications

Population Characteristics

Newspaper Readership

Charity Support

Appendix K: Censation Glossary

  
Accommodation & food servicesAccommodation and food service activities
Active: Full-time studentEconomically active: Full-time student
Active: Self-employedEconomically active: Self-employed
Active: UnemployedEconomically active: Unemployed
Administrative servicesAdministrative and support service activities
AffluenceAn estimate of the relative material comfort experienced within different neighbourhoods of the UK based upon a combination of variables from the 2011 UK Census
CensusA questionnaire distributed to the whole UK population once every decade, the last one was in 2011
ChristianIndicates that a relatively high proportion of a postcode indicated that their religion was Christian in a voluntary question in the latest UK Census
ComfortableThe central band on the affluence scale derived from the Census data
CommercialIndicates the presence of a high proportion of business and public organisations within a postcode
ConsumerPredominantly businesses that deal directly with the public, e.g. shops, banks, pubs etc.
Converted flatFlat, maisonette or apartment: Part of a converted or shared house (including bed-sits)
Detached houseWhole house or bungalow: Detached
DistinctiveWhere 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 conElectricity, gas, steam and air conditioning supply
Elementary (occupation)Unskilled jobs, e.g. security guards
Employee: Full-timeEconomically active: Employee: Full-time
Employee: Part-timeEconomically active: Employee: Part-time
Empty NestsAdult couples aged over 45, who have no children.
EstablishedThe average length of residency within a postcode is over 6 years.
ExcessA significantly higher proportion of a characteristic when that proportion is large across the whole of the UK.
Flat In a commercial buildingFlat, maisonette or apartment: In a commercial building
Frequently6+ times per year
GeodemographicThe description of different characteristics about people based upon the location where they live.
HighUsually more than 8 times per year
HinduIndicates that a relatively high proportion of a postcode indicated that their religion was Hindu in a voluntary question in the latest UK Census.
HouseholdA group of people living within one building and accessed through a single main door.
Household SpaceAny accommodation occupied by an individual household or, if unoccupied, available for an individual household.
Human health and social workHuman health and social work activities
In-conclusiveInformation about the segment does not differentiate significantly between different characteristics
In employmentEconomically active: In employment
Inactive: Long-term sick or disabledEconomically inactive: Long-term sick or disabled
Inactive: Looking after home or familyEconomically inactive: Looking after home or family
Inactive: OtherEconomically inactive: Other
Inactive: RetiredEconomically inactive: Retired
Inactive: StudentEconomically inactive: Student (including full-time students)
Life StageIndicates the distinctive characteristics of a postcode according to their age and household make-up
Life StyleIndications of the different ways that people participate with society and people around them.
Mail OrderIndicates 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.
ManyIndicates that a characteristic for a Censation segment is one of the 10% most distinctive for that variable
MuslimIndicates 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 householdsHousehold spaces with no usual residents
Normally occupied householdsHousehold spaces with at least one usual resident
Occasionally1 – 3 times per year.
Older FamiliesAdult couples, with children aged over 11.
Personal ServicesJobs that include support for private individuals, these can include health, social services and leisure.
Professional & scientific activitiesProfessional, scientific and technical activities
Process SupportLow skilled jobs particularly those that support production lines etc.
ProsperousThe next to highest band on the affluence scale derived from the 2011 Census data
Public AdministrationPredominantly local and national government offices
Public administration & defencePublic administration and defence; compulsory social security
Public SectorA grouping of business sectors including Public Administration, Health and Education.
Purpose-built flatsFlat, maisonette or apartment: Purpose-built block of flats or tenement
Qualification: Level 1Entry level vocational training: e.g. Skills for Life or Foundational Diploma or GCSEs graded D & E
Qualification: Level 2Established Vocational Training: e.g. Higher Diploma plus GCSEs graded A* to C
Qualification: Level 3Detailed Vocational Training: e.g. Advanced Diploma plus A/AS levels
Qualification: Level 4Further Vocational Training plus any University level courses
RankIf the clusters are sorted according to a selected variable then this number indicates the position in the list.
ResidentialIndicates that a postcode has predominantly private residences within it.
Residential ServicesThese services are often intermingled with private residences and can include Petrol Stations, Newsagents, Small grocers, Hairdressers etc.
ReligionThe 2011 Census included a voluntary question asking each respondent their religion, if they chose to, they ticked their choice from those available.
Semi-detached houseWhole house or bungalow: Semi-detached
SeniorsAdults aged over 65, often living alone
SikhIndicates that a relatively high proportion of a postcode indicated that their religion was Sikh in a voluntary question in the latest UK Census.
Social GradeA grouping of the population derived by the Market Research Society and used within Advertising and Marketing
SOHOSmall office and home office businesses
SomeIndicates that this characteristic is distinctive for that group although it doesn’t fall into the top 10% for this variable.
Sometimes4 – 5 times per year
StableIndicates that the average length of residency in a postcode is between 3 and 6 years.
StrivingThe next to lowest band on the affluence scale derived from the 2011 Census data
Student at their non 
term-time addressSchoolchild or full-time student aged 4 and over at their non term-time address
StrugglingThe lowest band on the affluence scale derived from the 2011 Census data
Temporary structureCaravan or other mobile or temporary structure
TenureIndicates the type of contract that a respondent holds for their place of residence.
Terraced houseWhole house or bungalow: Terraced (including end-terrace)
TransientIndicates that the average length of residency within a postcode is below 3 years
TurnoverThe rate at which people move in and out of a postcode.
VariablesDifferent descriptions of the characteristics of people within a postcode.
Water supply & sewerageWater supply; sewerage, waste management and remediation activities
WealthyThe highest band on the affluence scale derived from the 2011 Census data
Wholesale and retail tradeWholesale and retail trade; repair of motor vehicles and motor cycles
Young FamiliesAdults living as a couple with children aged less than 11 years old.
Young SinglesAdults aged less than 45, who are living alone.

Appendix L: Occupancy and Address Type Indicators

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:

1. Large User Organisation

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'.
2. Small User Organisation

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.
3. Mostly Organisations

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.
4. Mixed

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.
5. Mostly Residential

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.
6. Residential

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:

1. Numbered

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
2. Numbered and Named

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.
3. Numbered and Named, Likelihood of Multiple Occupancy

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.
4. Named

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.
5. Non-Standard Address Format

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.
6. PO Box

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 Birmingham
7. No Property Information

When 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.

Appendix M: Royal Mail Terms

See www.afd.co.uk/rmterms

mailLink mailLink

We are here to help

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.