Introduction & Istallation

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 26.5 million delivery addresses including about 1.7 million organisations and 44 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.

Names & Numbers TraceMASTER allows lookup's and searches across multiple Data Sets covering data collected in 2002 right through to the current year.

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 (Patent GB 2369699) 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 it by FAX to 01624 817695. If this form is approved, you will be exempted from the quarterly Data Extract Return procedure.

All AFD Postcode programs are subject to an End User License Agreement. The programs and data provided by Names & Numbers are copyright and protected by the 1988 Copyright, Designs and Patents Act in the United Kingdom and by the Berne convention and other International Copyright treaties.

You are permitted to install and use components of AFD Names & Numbers ('Names & Numbers') only on the number of computers, terminals, workstations or screens for which a license is held, although the larger data elements of the system may be installed on a file server for central access if a multi-user license is held. You may additionally make one copy of the program master disks for back-up purposes, but no other copies are permitted, for whatever reason.

Evaluation versions of Names & Numbers and the associated sample data, are nevertheless copyright material. You may make and distribute copies of the evaluation version and its sample data, but these copies must be complete and unaltered. You may NOT use the sample data provided for any purpose other than to assist in evaluating the usefulness of Names & Numbers.

Data within Names & Numbers is the copyright of AFD Computers and other data suppliers. You may access and use this data only as part of the Names & Numbers system, to provide address data for a bona-fide address-based application. Data Exports and mailing labels printed from Names & Numbers is still covered by the End User License Agreement and copyright. A fee is payable for any data extract or label run, but no fee is payable for the first 100,000 records.

You may not extract, reverse-engineer or re-distribute data or programs provided under any circumstances whatsoever.

The Names & Numbers data license is renewable annually and renewal fees include a fresh set of data, program update and free technical support for the year. Intermediate data updates are available quarterly at nominal cost, or you may subscribe to the POP scheme and cover all costs of using Names & Numbers including program and data updates, data licenses and technical support under a single monthly standing order payment.

Installation

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 01624 811712, 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 Postcode 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: http://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 01624 811712 will help ensure that your copy of the program is installed and functioning correctly. The HelpDesk is manned Monday - Friday 0900 - 1700 (except holidays). Ensure that you are next to your computer, which is switched on and in Windows prior to calling.

These services provide free, unlimited support about all aspects of using the AFD Postcode product range. Whilst we will endeavour to help with general advice, we cannot assist with questions or problems which 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:

Entry Example
Postcode only TN22 1QL
Postcode with delivery information Tops Tiles, TN22 1QL
36,EN2 6LA
Singletons,EN26LA
Haart, en2 6la
Name Dipak Patel
Family John+Janet Smith
Organisation Pizza Hut
Property Tolsons Mill
Street Address 157 Holdenhurst Road
Telephone No 01624 811711

Click the Lookup Button or press the [Enter] key and Names & Numbers will look up the request you've entered. You will see from the examples above, that Names & Numbers is quite tolerant of how spaces are used and whether capital or lower case letters are used.

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.

Entry Example
Name Dipak Patel,Bradford
Family John+Janet Smith,Birmingham
Organisation Boots,Bradford
Property Abbey Mill, Hampshire
Street Address 21 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:

Code Example Purpose
^ Aysha Khan^ Use this at the end of a lookup or search parameter to stop the display of longer words which begin with your search parameter.
+ John+Janet 'AND' - Used in First Name or Surname to look for both names at one postcode (ie family search).
Steven
$ John $Davies 'SOUNDS LIKE' - used when spelling is uncertain.
~ John B~rown 'SPELLED LIKE' - used when spelling is uncertain or to get around typographic errors in Electoral Roll data - even if the error makes the word sound different. Note: speed is significantly improved if the ~ is placed after the first letter of the word you are searching.
? John Pe?ers?n 'WILDCARD' used to replace any single character in a word when spelling is uncertain - or different spellings occur.
* D*RIC*T 'WILDCARD' used to replace any number of characters in a word when spelling is uncertain - or different spellings occur.

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.

Directive Example Purpose
N= N=David Street Forces lookup as a person's name
O= O=David Street Forces lookup as an Organisation Name
P= P=Smith, Bristol Forces lookup as a Property Name
S= S=Smith, Bristol Forces lookup as a Street Address
L= L=Aston Forces lookup as a Locality
T= T=Birmingham Forces lookup as a Town

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 List

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.

AFD Software. Address, Postcode and Bank solutions. Home Products News Evaluate Purchase Support Partners Contact - Names & Numbers Manual

Results Tab

Using the Results Tab

This tab is used to display the key parts of an address record found by Names & Numbers. It can be selected by clicking the tab - or use the [Alt]+2 keyboard shortcut.

Use the Edit menu "Editable Results" option if you wish to be able to change the data on the results tab before inserting it into other applications. This menu setting is stored with the current settings file. If "Editable Results" is not checked, you cannot enter a new search request in the Results Tab. In this case if you type in any of the Results Tab boxes you will be returned to the appropriate box on the Search Tab.

The Size field gives an indication of the number of employees of the organisation. The codes given refer to the following:

Code No of Employees
A 1
B 2 To 5
C 6 To 10
D 11 To 25
E 26 To 50
F 51 To 100
G 101 To 200
H 201 To 500
I 501+
(Blank) Unknown

The county field displayed can be altered using the options on the Edit Menu. See Appendix G for more information regarding county options.

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

###Drag & Drop

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 less-commonly used Additional Information provided by Names & Numbers. It can be selected by clicking the tab - or use the [Alt]+3 keyboard shortcut.

These fields are grouped into Tabs to organise the available data. If you have commonly used data items that you wish to see alongside the address you can configure Names & Numbers to display up to four of these fields on the Results Tab.

This tab includes the following data:

Field Meaning
General
Mailsort Code The code is assigned by Royal Mail and used to sort mail for discounts.
TV Region The TV Region (ISBA Region - not TV Company) the postcode falls into
Postcode Type Indicates if this is a large or small user postcode. A large user postcode always contains a single organisation, a small user postcode is normally shared between a number of organisations and/or residential properties.
Gender This will be Male, Female or Unknown and indicates the Gender of the selected resident.
Residency This indicates the number of years the selected resident has been on the electoral roll at this address.
UDPRN Each delivery point (letterbox) has a unique identifier assigned to it by Royal Mail if it has been matched to the Royal Mail Postcode Address File. Sometimes address details change, for example the postcode may change as the result of a recoding, or the building may be renamed, etc. The UDPRN for an address should stay constant when these changes occur. You should note that some records may not have a UDPRN value if they refer to addresses which are not found on PAF.
Date of Birth This provides the date of birth for new attainers on the electoral roll, this covers most of those in the last 12 years.
Composition This describes the household composition of the selected address. It can have any of the following values:

  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 North A 10 digit grid reference relating to the location of the postcode on the National Grid, or the Irish Grid for postcodes in Northern Ireland (starting BT). These are to a resolution of 100m. Please refer to Appendix D for more information regarding Grid References in Names & Numbers.
    Latitude and Longitude The corresponding latitude and longitude values for the given Grid Easting and Northing for this postcode. These are based on the WGS84 standard.
    Distance (in Km and Miles) When a proximity search has been carried out around a specified grid reference, this field provides the straight line distance between the grid reference of the selected postcode and that of the grid reference searched for.
    Urban/Rural Code This is a code assigned to the output area for this postcode which indicates if it is in an area of mainly urban or rural properties and how sparsely populated those area's are. Note that different codes are used for England & Wales, Scotland and Northern Ireland. The Scottish codes are prefixed with an 'S' to distinguish them from those for England & Wales as they are both numeric. The possible codes are as follows:

    England & Wales
    • 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 Name This provides a description that corresponds to the urban rural code.
    Sub Country Indicates if the postcode falls within the boundary of England, Wales, Scotland, Northern Ireland, Isle of Man, Jersey or Guernsey
    Administrative
    Ward Code Code identifying the electoral ward the postcode resides in
    Ward Name The name of the electoral ward the postcode resides in
    Authority Code Gives the code of the Local or Unitary Authority (which ever is relevant) this Postcode is contained in (Same as the start of the Ward Code)
    Authority Gives the name of the Local or Unitary Authority (which ever is relevant) this Postcode is contained in
    EER Code Provides the code of the European Electoral Region that this postcode falls into
    EER Name Provides the name of the European Electoral Region that this postcode falls into
    LEA Code Provides the code of the Local Education Authority that this postcode falls into
    LEA Name Provides the name of the Local Education Authority that this postcode falls into
    Constituency Code Code for the electoral Constituency the postcode falls into
    Constituency The electoral Constituency the postcode falls into
    Devolved Constituency Code Code for the Scottish Parliament Constituency the postcode falls into (where applicable)
    Devolved Constituency Name Name for the Scottish Parliament Constituency the postcode falls into (where applicable)
    Health
    SHA Code Strategic Health Authority Code. This is:
    • Strategic Health Authority (England)
    • Health Board (Scotland)
    • Health and Social Services Boards (Northern Ireland)
    SHA Name Strategic Health Authority Name which corresponds to the NHS Code.
    NHS Region Code National Health Service Region Code (Regional Office - applies to England only)
    NHS Region National Health Service Region Name
    CCG Code Clinical Commissioning Groups Code. This is:
    • 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 Name Clinical Commissioning Groups Name which corresponds to the CCG Code.
    Business
    Location Type Indicates if this record refers to a Head Office, Branch or Single Site
    Branch Count The number of branches this organisation has
    Group ID The ID of the group allowing companies belonging to the same parent group to be identified
    Modelled Turnover The modelled annual turnover for this business at this address
    National Size Gives an indication of the number of employees of the organisation at national level. See the Results Tab documentation page for a table of employee bands.
    Branch Size Gives an indication of the number of employees of this branch of the organisation. See the Results Tab documentation page for a table of employee bands.
    Business Provides a description of the business
    SIC Code Provides the Standard Industry Classification this business falls into (see Appendix C for a full list of codes).

    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.

    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 on order of distance away from your postcode. The 'Display Miles' and 'Display Kilometers' options in the 'Nearest' menu can be used to determine the units used for the distance displayed for 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 or use the shortcut [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' from the 'Nearest' menu or use the keyboard shortcut [Ctrl]+K.

    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.

    To allow multiple groupings various wildcard characters, character lists, and character ranges are available to test only part of the filter:

    Code Action
    {None} All Nearest Records
    ? Any Character
    * Zero or more characters
    # Any single digit (0-9)
    [charlist] Any single character in charlist
    [!charlist] Any single character not in charlist

    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 Label' 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.

    Nearest locations are also displayed on the map as blue boxes containing a crosshair if the 'Display Nearest Locations' option is checked on the Map menu.

    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.

    Please note that the Council Tax field is an additional dataset that contains the council tax band for most residential properties in England and Wales. For information regarding Council Tax data or to purchase the dataset please email sales@afd.co.uk or call 01624 811711.

    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.

    An 'unclassified' code is 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:

    For further explanation of groups beginning with an affluence code 'N' please see 4. below.

    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:

    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.

    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 a set of 'unclassified codes' is provided as a sensible guide for these areas.

    View the Censation Codes together with affluence, life stage and additional descriptions for areas not covered by UK Census 2011 data

    6. Using Censation with AFD Names & Numbers

    Names & Numbers Censation codes or their constituent parts (affluence, life stage and additional information) may be selected and used as search criteria. List buttons alongside each Censation field display a list of the options available.

    Censation selections may be combined with other Names & Numbers search criteria or selections from the search and more tabs. These provide users with the ability to select sophisticated combinations of criteria including gender, length of residency and radial distance searching.

    The resulting lists may be exported for use under the terms of the End User License Agreement. You should read the Data Export section of this manual and the license agreement prior to using this function.

    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.

    You can also 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.

    Additional Censation Information

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

    • Appendix H - Censation Additional Info
    • Appendix I - Censation Detailed Tables
    • Appendix J - Censation Bar Charts
    • Appendix K - 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.

    Tracemaster

    Using Multiple DataSets

    AFD Names & Numbers TraceMaster customers can search across multiple Names & Numbers Data Sets. To do this, simply select the required Data Sets from the Data Sets Tab ([Alt]+8 keyboard shortcut) and use the Find or Search facilities.

    With TraceMaster instead of having a single list displaying the results, there is a tabbed Results list, allowing you to select the Data Set you wish to see the results for, and from which you can select the result to display.

    The Datasets Tab The Years displayed is the year that the data was released (i.e. the year after it was collected).

    The results list boxes displayed on screen are colour-coded to make it clear which year is being displayed. The colour can be customised by right clicking on the year that you wish to change it for.

    If you wish to search for a particular surname or person within a linear distance of there selected address - e.g. if you find them at one address in the Current Dataset, but have no results for previous data sets and wish to see if they have moved from a house within 30 miles, you can use the 'Distance Search' menu item from the 'Search Tools' menu. Selecting this will bring up the following dialog from which you can specify your options:

    You can optionally choose to include the First Name in your search and the distance to search. The 'Clear Existing Search Parameters First' option, clears the Search form before commencing the search. If you have specified further search parameters on the Search Tab that you wish to use for this search as well then you should clear this option.

    Finding Neighbours

    To find a selected person's neighbours, simply select the person required from the results list and select the 'Find Postcode Neighbours' or 'Find Street Neighbours' option from the Search Tools menu, each person living at the same Postcode or Street will then be displayed in the results lists. Using the Postcode option will normally yield less results than street, but as neighbours may cross postcode boundaries those living next door might not be returned. It should be noted that it is not possible to be absolutely sure who the direct neighbours of an address are as the numbering schemes and street layouts vary immensely in the UK.

    Using The Selection List Box

    The final list box, after the 2003 Data Set, is marked Selection and this is provided to enable the user to add addresses from different Data Sets to a single list box for ease of viewing and comparision. Items can be selected and displayed from this List Box as with the individual list boxes. To add an item simply select the ''Add To Selection' Item from the Search Tools menu after selecting an address/addresses to add. The list box is cleared when the 'Clear' button is clicked.

    Displaying Residents

    If you have a list of results, for example of several John Smiths, and you would like to see a list of all the residents living at that address, simply right click the result in the appropriate list box and a pop-up list box will display all the residents of that household. You can also view the list by selecting the 'Display All Residents' item on the Search Tools menu.

    Hiding Non-Movers / Movers

    Following a search you can opt to narrow down the results to only those residents who have not moved or who have moved (left or joined the electoral roll at that address or had there address changed) by selecting the Hide Non Movers' or 'Hide Movers' menu options on the 'Search Tools' menu. This will filter the results lists accordingly. You can toggle these options to quickly view the full list or filtered lists in turn.

    The Postcode Robot

    ROBOT Technology is protected by Patent No GB2369699.

    Introducing Robot Technology

    AFD Names & Numbers contains AFD Robot® technology (Patent GB 2369699) which will automatically detect the typing of a postcode in most Windows applications, and convert it into a full address (including name and organisation details if required).

    Names & Numbers 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 from the available people & organisation addresses on that postcode to select whether to insert an address, for the postcode you typed, into your application

    In "Quiet" mode Robot will only prompt you if the postcode you typed may indicate more than one address at street level. 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. If you type property information comma separated with the postcode (e.g. AFD Software Ltd, IM7 2DZ) then Robot will attempt to match the full postal address to DPS level.

    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 Plus 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. B6 4AA) 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 Action If you type normal text If you type a postcode in quiet mode If you type a postcode with property information -
    Robot's Action Robot ignores what you typed - and the text appears just as you typed it. Robot detects the postcode - and converts it into an address. Robot detects the postcode - and converts it into an address - placing the organisation or property information into the address.
    What you would see without Robot: Dear Sir, Following our meeting at B6 4AB Royal Mail, B6 4AB
    What you would see with Robot: Dear Sir, Following our meeting at St Stephens Street, BIRMINGHAM, B4 6AB Royal Mail, Central Aston Delivery Office, St Stephens Street, BIRMINGHAM, B6 4AB

    To use the Fast Find mode simply type a search such as #Commercial Street,Birmingham# into your application and Robot will operate in the same way as shown above.

    When you install AFD Names & Numbers, settings for the following applications are installed automatically - and you will normally find that Robot works just as you require without any changes or configuration at all:

    • 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:

    Code Action
    {None} All Nearest Records
    ? Any Character
    * Zero or more characters
    # Any single digit (0-9)
    ^ Must end here
    [charlist] Any single character in charlist
    [!charlist] Any single character not in charlist

    Robot 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 Names & Numbers 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 Names & Numbers 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 Address 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. Names & Numbers 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 easiest 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 program, then paste the address into position. Pasting will usually be carried out in your programs by using an Edit menu Paste option (shortcut key [Ctrl]+V) - but consult your program'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, Line Squeeze and Initials Only settings - see Insert Settings 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.

    Note that 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. You should ensure that your target program is set up to print the barcode to this specification.

    Insert

    Names & Numbers 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 Names & Numbers includes a very powerful keystroke 'macro' language which enables Names & Numbers 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 Names & Numbers 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 Names & Numbers 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 - and Names & Numbers 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 Names & Numbers settings.

    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.

    Once you have carried out the first Insert, Names & Numbers 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 Names & Numbers 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 Names & Numbers is first installed, it should Insert into most common programs - like Word or Excel - correctly. Names & Numbers 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 Names & Numbers, 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:

    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.

    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.

    Standard Fields take care of the many anomalies and inconsistencies of raw PAF data. We recommend that you use these fields for mapping wherever possible. When using Special Fields map all or none of the fields from Building Number through to Dependant Locality and do not mix and match with the Property, Street and Locality fields from the 'Standard' list. To mix these fields will cause some addresses to be trashed. This is because the standard fields not only concatenate many numbers with the street but also sometimes move the property or concatenate to the locality field as appropriate.

    Address elements not provided on the Special Fields list are excluded because they are identical to those on the Standard Fields list, e.g. the Town field is never reformatted. If you need to map the building number separately but only have a single property field you can drag both the sub building and building fields to the same field in your database and they will be concatenated together as appropriate.

    You should note that the Organisation field in this list is different to that on the Standard fields list. In the standard fields list Organisation appears concatenated with the Department (when present), here the Organisation field is separated out from the Department. Similarly the Street field on the standard list is concatenated with the dependant street (where present), here they are separated.

    For example, if your database has standard address fields from Organisation through to Postcode, but has a separate Number field you would make the following mappings:

    Database Field Field Type Field Name to Map
    Organisation Standard Organisation
    Property Special Sub Building, Building
    Number Special Building Number
    Street Special Dependant Thoroughfare, Thoroughfare
    Locality Special Dbl-Dep. Locality, Dependant Locality
    Town Standard Town
    Postcode Standard Postcode

    You can choose to enter fields such as the dependant thoroughfare and thoroughfare together in one field if desired when you type the sample address by entering them both with a comma separator.

    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 Names & Numbers 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 Names & Numbers 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. Names & Numbers 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 the Names & Numbers 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, 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 Names & Numbers, 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 Names & Numbers 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 all the addresses on Commercial Street in Birmingham to choose from. You can then choose the correct one and insert it into your application. 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 Wordprocessor, 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 Names & Numbers 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 Full Name through to Postcode, the address data provided by Names & Numbers. If you specified less than 7 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 Plus will attempt to fit them all in.

    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 Names & Numbers 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 'In 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 Names & Numbers 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 Names & Numbers with your application using Insert (select your application from the Insert menu once you have located the address to insert in Names & Numbers), 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 Names & Numbers. 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 Names & Numbers 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 Settings 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 Names & Numbers 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 Names & Numbers 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. Names & Numbers 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 'Fields' list on the right to this list. Items can also be dragged off the list back to the 'Fields' list if you wish to remove them. Multiple fields can be dragged to a single Field in your application if required.

    Above the 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 Names & Numbers 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 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 Plus 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 that are 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:

    Specifying Upper Case Fields

    For most address fields (but not for data expected always in capital letters - like Postcodes), Names & Numbers 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, Names & Numbers 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 Names & Numbers 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 Names & Numbers, 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 Names & Numbers 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 all addresses on that street to choose from. You can then choose the correct one and insert it into your application. 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 Names & Numbers 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 Names & Numbers 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 Names & Numbers 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.

    Use Initials Only

    This option specifies that when the Full Name is inserted or displayed on a mailing label that the firstname will be initialised. For example you will see 'Mr J C Bloggs' instead of 'Mr Joe C Bloggs'.

    Default Application Settings

    These settings do not affect the application settings currently being modified, but tell Names & Numbers 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 Names & Numbers 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 Names & Numbers 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)

    Names & Numbers 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 Names & Numbers about the program you wish to have a DDE 'conversation' with - using the DDE Tab on the Names & Numbers Property window.

    To set the DDE Properties, launch the Names & Numbers Properties window from the File menu Properties option (shortcut key [Ctrl]+R).

    The first two settings - Application and Topic tell Names & Numbers about the program you wish to establish a DDE conversation with - and the information should be provided in the documentation of that program. (When installed, Names & Numbers is set up for use with Symantec's ACT v3 contact manager program).

    Names & Numbers offers 35 fields of data available for a DDE conversation - and these are listed in the Fields 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. The 'Item Name' is the name recognised by your program for the Names & Numbers field - eg the Names & Numbers 'Postcode' field may be known as 'ZipCode' to your program. Your program's documentation should provide the 'Item Name' for you.

    DDE settings are retained automatically by Names & Numbers - but they are also effected by the status of the 'Initials Only' setting specified in the Insert Settings and the 'County Type' setting of the Edit menu.

    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 Names & Numbers 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. Names & Numbers will remember this position the next time the DDE Icon is used.

    The Names & Numbers 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. Names & Numbers 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 Names & Numbers what you wish to search for.

    Once Names & Numbers has listed found results of a Lookup or Search (whether the data was 'collected' from your program using DDE or typed directly into Names & Numbers), 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 Names & Numbers to your program, and so build up a mailing list.

    Full access to all the data within Names & Numbers is available to programmers through the Names & Numbers DLLs. This means that for developers - and even for users of programs like Microsoft Access, etc, name and address lookup can be entirely automatic and invisible.

    Using the DLLs will require some 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 Names & Numbers 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 Names & Numbers to float 'On Top' of other Windows programs - even when you are not working directly in Names & Numbers, select the View menu On Top option (shortcut key [Ctrl]+T). Names & Numbers will display a check-mark next to this option whilst it is in use.

    Hot Key

    Names & Numbers allows a shortcut key to be used to quickly access the Names & Numbers application. To configure or view the currently assigned Hotkey setting, select the File menu Properties option. ([Crtl]+R)

    Enabling the Hotkey allows Names & Numbers to be launched on pressing the configured Hotkey even if it is not already running.

    Care should be taken in ensuring the Hotkey is assigned to a key combination that will not conflict with shortcut keys used by other applications (for example [Ctrl]+P is often used as a shortcut to print so if you assign [Ctrl]+P then you won't be able to use that shortcut key to print from applications).

    Please note WinKey refers to the Windows Key on your keyboard.

    With printable characters, simply press the key in the 'Key' box to use that key with Postcode, for non-printable characters such as F1, Insert, Print Screen etc. enter the code in curly brackets as shown in the following table:

    Backspace {BS} Enter/Return {ENTER} Page Up {PGUP} Page Down {PGDN} Home {HOME} End {END} Left Arrow {LEFT} Right Arrow {RIGHT} Up Arrow {UP} Down Arrow {DOWN} F# (Function Keys){F#} Insert {INSERT} Left Menu Key {LMENU} Right Menu Key {RMENU}

    The Hotkey is fully configurable and can be configured to be used with any keyboard key.

    Please note: Some have been omitted because they would cause problems with Windows.

    However any key on any keyboard can be used, email support@afd.co.uk, or phone the AFD Support Team (01624 811712) if you need help setting up the Hotkey.

    Grid References

    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 5TJ Looks up '37,AB31 5TJ' immediately after loading
    /Settings=WP Specifies the Settings File to be loaded is 'WP'
    /Splash=No Suppresses the display of the Splash Screen when loading
    /Tab=1 Sets Tab 1 (the Search Tab) to be displayed after loading

    These commands can executed from the Start Menu, Run by typing something similar to the text below into the the

    Run box:

    c:\afdpcnn\afdpcnn.exe  /Lookup 37,AB31 5TJ   /Settings=WP  /Splash=No  /Tab=1
    

    Appendix B: Keyboard Shortcuts

    Shortcut Key Function
    [Alt] + [F4] Close Names & Numbers
    [Esc] Cancel Lookup, List or Search
    [F1] Help
    [F2] Insert current address into target application
    [F5] Refresh Insert Menu
    [Alt] + 1 Switch to Search Tab
    [Alt] + 2 Switch to Results Tab
    [Alt] + 3 Switch to More Tab
    [Alt] + 4 Switch to Label Tab
    [Alt] + 5 Switch to Map Tab
    [Alt] + 6 Switch to Nearest Tab
    [Alt] + 7 Switch to Cameo Tab
    [Alt] + B Switch Barcode on/off
    [Alt] + C Clear Results List
    [Alt] + D Jump to Find Box
    [Alt] + E Activate Edit menu
    [Alt] + F Activate File menu
    [Alt] + H Activate Help menu
    [Alt] + I Activate Insert menu
    [Alt] + L Lookup using current Findbox contents
    [Alt] + N Activate Nearest Menu
    [Alt] + R Print single mailing label
    [Alt] + S Search using the address data entered on the 'Search' tab
    [Alt] + V Activate View menu
    [Ctrl] + [Insert] Copy current field to Clipboard
    [Shift] + [Insert] Paste current Clipboard contents to field
    [Ctrl] + A Add Nearest Records
    [Ctrl] + C Copy current address to Clipboard
    [Ctrl] + D View icon for DDE
    [Ctrl] + E Export address as ASCII
    [Ctrl] + F Filter Nearest Records
    [Ctrl] + G Save current settings
    [Ctrl] + K Delete Nearest Records
    [Ctrl] + M Toggle Distance Line
    [Ctrl] + O Open (use) a Settings set
    [Ctrl] + P Print Mailing Labels
    [Ctrl] + Q Set Search Quantity
    [Ctrl] + R View or Alter Properties
    [Ctrl] + S Save Currently Displayed Nearest Record
    [Ctrl] + T Switch 'On Top' mode on/off
    [Ctrl] + X View Examples List
    Function Shortcut Key
    Add Nearest Records [Ctrl] + A
    Barcode: switch on/off [Alt] + B
    Cameo Tab [Alt] + 7
    Cancel Lookup, List, or Search [Esc]
    Copy current address to Clipboard [Ctrl] + C
    Copy current field to Clipboard [Ctrl] + [Insert]
    Clear Results List [Alt] + C
    Close Names & Numbers [Alt] + [F4]
    DDE: view Icon for [Ctrl] + D
    Delete Nearest Records [Ctrl] + K
    Edit menu [Alt] + E
    Examples List [Ctrl] + X
    Export addresses as ASCII [Ctrl] + E
    File menu [Alt] + F
    Filter Nearest Records [Ctrl] + F
    Find Box - jump to [Alt] + D
    Help [F1]
    Help menu [Alt] + H
    Insert current address into target application [F2]
    Insert menu [Alt] + I
    Label Tab [Alt] + 4
    Lookup using current Findbox contents [Alt] + L
    Map Tab [Alt] + 5
    More Tab [Alt] + 3
    Nearest Menu [Alt] + N
    Nearest Tab [Alt] + 6
    On Top Mode: switch on/off [Ctrl] + T
    Open (use) a Settings set [Ctrl] + O
    Paste current Clipboard contents to field [Shift] + [Insert]
    Print mailing labels (multi) [Ctrl] + P
    Print mailing labels (single) [Alt] + R
    Properties - view or alter [Ctrl] + R
    Quantity to Search [Ctrl] + Q
    Refresh Insert menu [F5]
    Results Tab [Alt] + 2
    Save a Settings set [Ctrl] + G
    Save Currently Displayed Nearest Record [Ctrl] + S
    Search using current Search Settings [Alt] + S
    Search Tab [Alt] + 1
    Toggle Distance Line [Ctrl] + M
    View menu [Alt] + V

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

    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

    Download

    LICENSE AGREEMENT

    IMPORTANT! This agreement, together with the documents referred to in it, sets out the terms and conditions (the “Agreement”) which govern your use of the Product as defined below. It constitutes the entire agreement between the parties and supersedes all prior verbal and written discussion, agreements, understandings, representations, conditions and all other communications between the parties in relation to this matter.

    Please read the Agreement carefully before entering the Site or subscribing to or making use of the Product. You may wish to retain this Agreement for your future reference.

    The Product is not sold; it is licensed. The Product is and remains the property of AFD Software Ltd (“the Company”) or other third parties and is protected by copyright laws and international copyright treaties.

    By in any way installing, copying or otherwise using the Product or any part thereof, you agree to be bound by the terms of this Agreement. If you do not agree to the terms of this Agreement, do not install or otherwise and in any way use the Product or any part thereof but return it to your supplier within fifteen (15) days for a full refund.

    1. DEFINITIONS

      • In this Agreement the following words and expressions shall have the following meanings:

      • “Annual License Renewal” means the latest version of the Product or any part of it;

      • “Annual License Renewal Fee” means the annual license renewal fee (if any) payable by you pursuant to clause 3.1 as published by the Company in respect to the Product from time to time;

      • “Authorised User” shall mean any individual who is employed or engaged under contract as part of your staff, whether on a temporary, permanent, or visiting basis and whom you wish to authorise to have access to the Product or any part thereof;

      • “Bureau Services” shall mean all services operated by the Licensee in respect of the processing of information or data which is owned or controlled by another person, company, organisation or body, including (without limitation) companies in the same group as the Licensee or any other associated organisation.

      • “Computer” means any computer, terminal or workstation owned or used by you;

      • “Effective Date” means the date of commencement of this License as printed on the License Certificate;

      • “First Year Data License Fee” means the data license fee (if any) payable by you pursuant to clause 3.1 as published by the Company in respect to the Product from time to time;

      • “Initial License Period” means the period of twelve months from the Effective Date or such other period as may be notified by the Company to you in the License Certificate or Appendix to this Agreement or otherwise;

      • “Insolvency” means in respect a Licensee the presentation of a petition for winding-up, bankruptcy, or administration or the convening of a meeting for the purpose of considering the same, the convening by the Licensee of a meeting of its creditors, or the appointment of a trustee, receiver, administrative receiver or similar officer in respect of all or any part of the business and assets of the Licensee;

      • “Intellectual Property” means the text, graphics, images and other material, and the organisation thereof and trademarks, software, copyrights, patents, trade secrets, processes and methods, know-how and other intellectual property rights embodied in or incorporated in the Product, and any tangible copies and expressions thereof;

      • “License” means the license granted to you pursuant to this Agreement and the License Certificate;

      • “License Certificate” means the certificate sent or to be sent by the Company to you granting a license to you to use the Product in accordance with this Agreement and references in this Agreement to the “Agreement ” shall include the License Certificate;

      • “Licensed Computers” means the number of Computers on which the Product may be accessed pursuant to this Agreement as set out in the License Certificate;

      • “License Period” means the Initial License Period and thereafter whilst this Agreement is continuing;

      • “Monthly Fee” means the fee payable by you pursuant to clause 3.3 as published by the Company in respect to the Product from time to time;

      • “Network” means any electronic communication between two or more computer terminals linked together through computer software and/or telecommunication satellite cable or broadcasting services or through any other medium now known or hereinafter invented;

      • “Person” means any person, firm, company, institution, organisation or other legal entity throughout the world;

      • “Product” means the product(s) Licensed by the Company pursuant to this Agreement as set out on the License Certificate(s) and shall include all computer software, the data supplied with it, any associated media, electronic documentation and printed materials and if applicable any Site;

      • “Product Update” means an updated version of the Product or any part of it;

      • “Program License Fee” means the fee (if any) payable by you pursuant to clause 3.1 as published by the Company in respect to the Product from time to time;

      • “Site” means any website supporting the Product;

      • “you” or “your” means the Licensee under this Agreement as stated on the License Certificate.

    2. GRANT OF LICENSE

      2.1 The Company hereby grants to you the non-exclusive right for the License Period to install one copy of the Product on the Licensed Computers only on the terms and subject to the conditions set out in this Agreement and (if the License Certificate so states) the Royal Mail Terms which (if applicable) may be obtained from or viewed at the website address given on the License Certificate. The Product may not be accessed and used or shared between or in any way accessed and used from, either on or off Network, any Computers, other than the Licensed Computers irrespective of whether such access or use is concurrent.

      2.2 If you intend to install, use or access the Product on or from more than the number of Licensed Computers or to share the Product between or in any way access it from, either on or off Network, more than the Licensed Computers then separate License Agreement(s) relating to the number of such other Computers intended to carry the Product or any part thereof must first be entered into with the Company.

      2.3 The Company shall be entitled to sell or grant Licenses of the Product or any part thereof to any Person and nothing herein contained shall prevent the Company from compiling contributing to, publishing, marketing or licensing any other product in any way similar to the Product.

      2.4 You shall have the right to load and store the Product on the Licensed Computers only and subject to the provisions of this Agreement to give access from the Licensed Computers to the Product only to Authorised Users.

    3. LICENSE FEES

      3.1 In consideration of the License granted to you under this Agreement you shall, pay to the Company on receipt of the invoice in respect thereto the Program License Fee, the First Year Data License Fee and on each Annual License Renewal the Annual License Renewal Fee(s) in each case at the Company’s prevailing price for such fees in respect of the Product from time to time.

      3.2 If elected by you prior to the commencement of this Agreement instead of the payments set out in clause 3.1 above you may in consideration of the License granted to you under this Agreement pay the Monthly Fee to the Company and you shall sign and effect a Direct Debit/Standing Order in such form as the Company may require for the amounts payable by you in respect of the Monthly Fee from time to time.

      3.3 All fees (save for the Monthly Fee, which is stated inclusive of Value Added Tax) payable pursuant to this Agreement are stated by the Company exclusive of Value Added Tax which, if payable, shall be paid by you on presentation of an appropriate VAT invoice.

      3.4 If you default in making payment of any sum payable by you pursuant to this Agreement then the Company shall be entitled (without prejudice to any other right or remedy it may have) to charge you interest on the outstanding sums at the rate of 2% per annum above Barclays Bank Plc’s base rate in force from time to time from the date the payment became due until actual payment is made (irrespective of whether the date of payment is before or after any judgement or award is made).

      3.5 If you default in making payment of any sum payable by you pursuant to this Agreement then the Company shall also be entitled to deny you access to The Product until outstanding fees have been paid in full, and shall not be responsible for any loss or damage you may suffer in consequence. It is expressly agreed that you will continue to remain bound by all the obligations of this Agreement during the period that access to The Product is so denied, including notice periods, annual License Renewals and further fees payable.

      3.6 The Company may increase any fees payable pursuant to this Agreement at any time after having provided you with three calendar months notice thereof prior to any such increase.

    4. YOUR OBLIGATIONS

      You shall not:

      • (i) transfer the Product from the Computer it was originally installed on or load it on to any other Computer without having made a prior written request of the Company for permission to do so which permission may be refused in the Company’s absolute discretion;

      • (ii) reverse engineer, decompile or disassemble the Product in any way;

      • (iii) separate the component parts of the Product for use on more than one Computer;

      • (iv) retain or make any copies of the Product other than the Product as provided to you by the Company pursuant to the terms of this Agreement and for a copy to be used for back-up purposes only;

      • (v) extract Postcode Address File Data or AFD Data from the Product other than as part of the bona fide address management task you undertake or unless the prior consent of the Company has been obtained in writing display the Product on the internet or elsewhere or make it available to anyone other than an Authorised User;

      • (vi) without prejudice to the generality of the foregoing, do anything with the Product which is in breach of or otherwise inconsistent with the moral rights of the Company;

      • (vii) post or transmit through the Product or the Site any material which violates or infringes in any way upon the rights of others, which is unlawful, threatening, abusive, defamatory, invasive of privacy or publicity rights, vulgar, obscene, profane or otherwise objectionable, which encourages conduct that would constitute a criminal offence, give rise to civil liability or otherwise violate any law, or which, without the Company’s express prior approval, contains advertising or any solicitation with respect to products or Products; or take any action which the Company in its absolute discretion considers will restrict or inhibits any other Person from using or enjoying the Product.

    5. PRODUCT UPDATES, RENEWALS AND SUPPORT

      5.1 If you have not elected to pay the Monthly Fee the Company shall provide you with quarterly Product Updates for the duration of this Agreement only at your specific request and at the prevailing cost for such Product Updates. It is an express condition of this Agreement that, if you have not elected to pay the Monthly Fee, you will in any event obtain an Annual License Renewal from the Company no less frequently than once in every calendar year whilst this Agreement is continuing (or such other frequency as may be notified to you by the Company in the License Certificate or otherwise) at the prevailing price for such Annual License Renewal at the time of such purchase.

      5.2 If you have elected to pay the Monthly Fee you will be sent Product Updates as and when available.

      5.3 Any Product support requested by you will be provided free of charge during normal working hours of 9am-5pm Monday - Friday (excluding holidays) by either Internet Electronic Mail (e-mail), World Wide Web (www) publications and documentation or telephone. Any further or subsequent Product support is chargeable at a fee agreed by you and the Company from time to time.

      5.4 Any supplemental software provided by the Company to you as part of or in the course of despatching and providing Product support or in providing Product Updates or Annual License Renewals shall be provided to you at one address only (being the address set out in the License Certificate) and shall be considered part of the Product and the installation or use thereof will be subject to the terms and conditions of this Agreement.

    6. ACCESS TO THE PRODUCT

      6.1 This clause 6 shall apply where access to the Product and any Site is by means of HTML requests across the internet.

      6.2 If you have not received a serial number and password from the Company after subscribing to the Product, you may not use the Site. You agree that you will not at any time disclose, transfer or permit any other person to use your serial number and password. You are responsible for taking all reasonable steps to ensure that no unauthorised person shall have access to your serial number and password. It is your sole responsibility to:

      (i) control the dissemination and use of serial number and password;

      (ii) authorise, monitor and control access to and use of your account and serial number and password; and

      (iii) promptly notify the Company of any need to reset or deactivate your serial number and password.

      The Company reserves the right to freeze or terminate accounts that do not conform to these requirements.

    7. DURATION OF AGREEMENT

      7.1 This Agreement shall commence on the Effective Date and shall remain in effect for the Initial License Period and thereafter unless terminated in accordance with this Agreement. In the event this Agreement is not renewed this Agreement shall terminate at the end of the Initial License Period or the relevant anniversary of it.

      7.2 At the end of the Initial License Period and at each anniversary of the Effective Date this Agreement shall automatically renew for 12 months unless you shall previously have given written notice, to the Company at least one month but not more than three months prior to the expiration of the Initial License Period or each subsequent anniversary of the Effective Date of your intention not to renew the Agreement.

      7.3 The Company shall have the right to immediately terminate this Agreement in the event of any conduct by you which the Company, in its sole discretion, considers to be unacceptable, or pursuant to clause 8 below or in the event of your breach of this Agreement or your Insolvency.

      7.4 In the event this Agreement shall terminate for any reason whatsoever you shall return the Product to the Company and you shall also delete or cause to be deleted the Product from any and all computer-readable versions and shall provide the Company with a certificate attesting to such deletion.

    8. DISCONTINUATION OF PRODUCT

      8.1 The Company shall have the right at any time, without notice, to change, suspend, discontinue, withhold or refuse access to any aspect or feature of the Product or the Site, including, but not limited to, content, hours of availability and equipment and software needed for access or use. The Company may also impose limits on certain features and Products or restrict your access to parts or the entire Product or Site without notice or liability on its part.

      8.2 The Company reserves the right at any time to withdraw the Product or any part thereof or terminate this Agreement if the Company ceases, for whatever reason, or no longer retains the right to License the Product or any part thereof, or if, in the Company’s sole discretion and on reasonable grounds believes that the Product or any part thereof contains any material which infringes copyright or is defamatory, obscene, unlawful, or otherwise objectionable. The Company will in event of such withdrawal give written notice to you and you shall, on receipt of such notice, immediately comply with any of the Company’s reasonable instructions with respect to such withdrawn Product.

      8.3 Should the Company permanently or for a continuous period of seven days or more withdraw the Product or the Site or terminate this Agreement pursuant to clauses 8.1 or 8.2, a refund of any of the fees paid pursuant to this Agreement will be refunded pro rata to you.

      8.4 The Company may at its sole discretion at any time and without warning withdraw from you or withhold the Product to you or terminate this Agreement if your activities are considered by the Company in its absolute discretion to be inappropriate or unlawful.

    9. MARKETING

      The Company may wish to identify you in its marketing materials as a subscriber or licensee of the Product. Your use of the Product indicates our permission for the Company to use your personal data in this manner unless you notify the Company otherwise, in writing, within five business days of the date of the License Certificate.

    10. VARIATION OF TERMS OF AGREEMENT AND INFORMATION

      The Company shall have the right at any time to change or modify the terms of this Agreement and the terms and conditions applicable to your use of the Product, or any part thereof, or to impose new conditions, including, but not limited to, changing fees and charges for use. Such changes, modifications, additions or deletions shall be effective immediately upon the Company giving notice thereof (save where otherwise specifically provided in this Agreement), which may be given by means including, but not limited to, posting on the Site, or by electronic or conventional mail, or by any other means by which you obtain notice thereof. Your continued use of the Product or the Site after such notice shall be deemed to constitute acceptance of such changes, modifications or additions.

    11. PRIVACY POLICY AND PUBLIC COMMUNICATIONS

      You acknowledge and agree that any communications made to or by means of any portion of the Site are public. You acknowledge that:

      • (i) you have no expectation of privacy in any communication; and

      • (ii) no confidential, fiduciary, contractually implied or other relationship is created between you and the Company by reason of your transmitting a communication to any area of the Site or through the Product.

    12. INTELLECTUAL PROPERTY AND OWNERSHIP

      12.1 The Product is the property of the Company or the subject of a license to the Company and is protected by copyright and other intellectual property laws. It is expressly understood and agreed that all of the Intellectual Property is and will continue to be the exclusive property of the Company and/or its suppliers and/or its associated companies or entities. By using the Product and accessing the Intellectual Property, you agree that you will not take any action inconsistent with the Company’s or its suppliers’ or associated companies or entities’ ownership rights and that you will abide by the copyright law and all other applicable international laws in general and the laws of England in specific with respect to such Intellectual Property. Details of the copyright to which the Product is subject is set out on the License Certificate.

      12.2 You shall take all necessary measures to safeguard the Intellectual Property and proprietary rights of the Company and its suppliers and associated companies and entities in the Product and without prejudice to the generality of the foregoing shall ensure that:

      • (i) each and every part of the Product used by you or any Authorised User in accordance with the License shall be clearly identified as being an extract of the Product;

      • (ii) you will keep the License Certificate confidential and divulge it only to Authorised Users;

      • (iii) you use your best efforts to ensure that Authorised Users abide by the terms and conditions of this Agreement and in particular but without limitation do not reproduce, redistribute, retransmit, publish or republish or otherwise commercially or in any other way exploit the Product save only as permitted under the terms of this Agreement;

      • (iv) you monitor compliance by each Authorised User with the terms of this Agreement and immediately on becoming aware of any unauthorised use by an Authorised User of the Product or any part thereof or other breach of this Agreement take all reasonable steps both to ensure that such Authorised User ceases such activity and to prevent any recurrence of it including where necessary by terminating that Authorised User’s access to the Product or any part thereof;

      • (v) you use your best efforts to ensure that only Authorised Users are permitted access to and use of the Product;

      • (vi) you maintain all copyright notices relating to the Product on all copies of or on any part of the Product held under your control; and

      • (vii) comply with all applicable law as it relates to the use or access of the Product.

      12.3 Unless expressly agreed by the Company you shall not:

      • (i) alter, modify, delete, conceal, obscure, remove or otherwise tamper with the trade marks, trade names, numbers, copyright or other proprietary legends or designations of origin or other means of identification notices or disclaimers used on or in relation to the Product from time to time;

      • (ii) do, or authorise any Authorised User or other Person to do any act which would or might invalidate or be inconsistent with any Intellectual Property of the Company in the Product and shall not omit or authorise any third party to omit or do any act which by its omission would have that effect or character.

    13. USE OF CONTENT, COPYRIGHT AND LICENSE TO DOWNLOAD MATERIAL

      The Company owns the copyright or has had Licensed to it all Intellectual Property, and unauthorised copying of any Intellectual Property is prohibited. Subject to this Agreement, the Company grants to you, whilst your subscription to the Product subsists, a limited License to download the Product, data files, installation software, example and instruction pages and web building templates for the sole purpose of enabling you to make use of the Product in accordance with this Agreement and where applicable have access to the Site. No other licensing rights are granted.

    14. WARRANTIES

      14.1 The Company warrants that it has the right to license the rights granted to you under this Agreement and that the Product will perform substantially in accordance with the description of the Product provided to you for a period of 90 days from the date of receipt of the Product by you. No other warranties are given by the Company.

      14.2 The Company’s (and its agents, employees, suppliers’ and/or any other third party associated with or in the employ of the Company) total liability under this Agreement, if any, will be limited to the equivalent of one month’s fees paid up by you for the Product.

      14.3 The warranties set out in this clause 14 are in lieu of all warranties, conditions, terms, undertakings, and obligations implied by statute, common law, custom, trade usage, course of dealing, or otherwise, all of which are hereby excluded to the fullest extent permitted by law.

    15. CUSTOMER ACKNOWLEDGEMENTS

      YOU EXPRESSLY AGREE THAT:

      • (i) use of the Product and the Site is at your sole risk. The Company does not warrant that Product or the Site will be uninterrupted or error free;

      • (ii) although the Company has attempted to provide accurate information on the Product or Site to you, the Company does not assume any responsibility for, or make any representation with respect to the accuracy or completeness of such information. You acknowledge that You are relying on your own judgement and skill to determine the suitability of the Product and its License or Site and its License for Your purposes and do not rely on any advice or recommendation that the Company may have provided to you;

      • (iii) the Product or Site is provided “AS IS,” and the Company expressly disclaims any implied or expressed warranties or conditions of any kind (except for the warranty provided in clause 14 above), including warranties of merchantability, fitness for a particular purpose or non-infringement of intellectual property relating to such Product;

      • (iv) you specifically acknowledge that the Company is and will not be liable for any defamatory, offensive or illegal conduct by you or other third party as it relates to the Site and the Product;

      • (v) the Company and its associated companies and entities, suppliers and agents shall not be liable for any infection by any virus or damage to any computer that results from the use, access to the Product or the Site or downloads of any Intellectual Property therefrom;

      • (vi) the Company shall not be liable or responsible for any loss or damage caused in whole or in part by the occurrence of any contingency beyond the control of the Company, including but not limited to fires, civil unrest, riots, rebellions, accidents, explosions, interruptions or imperfections in telephone cables or computer systems, network or internet disruptions, electrical disturbances, power failures, satellite malfunctions or interruptions, floods, storms or any similar act or act of God;

      • (vii) in no event shall the Company its associated companies and entities, suppliers or agents be liable for any damages whatsoever, including (without limitation, special, indirect, consequential or accidental damages, including, without limitation, damages resulting from the use or reliance on the information presented, loss of profits or revenues or cost of replacement of goods save as provided in clause 14 above;

      • (viii) compliance with data protection laws applying in any jurisdiction where the Product is used by you or otherwise applying to you shall be your sole responsibility and you hereby warrant to the Company that you have and will comply with all such data protection laws in connection with your use of the Product;

      • (ix) you will provide the Company with all information reasonably requested by it within 7 days of a request by the Company requesting such information and on request provide facilities to the Company during business hours to inspect at your premises any records, documents and Computers in each case for the purpose only of ensuring your compliance with the terms of this Agreement;

      • (x) the Royal Mail Terms shall form part of this Agreement if it is stated in the License Certificate to so apply; and

      • (xi) the License shall be governed by this Agreement which shall apply irrespective of whether you have provided in any order or otherwise for any other terms and conditions to apply to this License, such other terms and conditions being of no effect;

      • (xii) you hereby appoint the Company to act as your exclusive agent in the extraction, preparation, indexing, compression and delivery of all Data to be used within the Product or Site.

    16. SEVERABILITY

      If any part of this Agreement is determined by any competent authority to be invalid, unlawful or unenforceable to any extent, it shall to that extent be severed from the remainder of the Agreement, which shall continue to be valid and enforceable.

    17. INDEMNIFICATION

      You agree to defend, indemnify and hold harmless the Company, its associated companies and entities, its suppliers and their respective officers, and agents and/or any other third party associated with or in the employ of the Company or such other Person from and against all claims and expenses, including legal fees, arising out of your use of the Product and the Site or any use made of your account with the Company.

    18. TRANSFER

      You may only transfer, assign sub-License or otherwise deal with the License granted under this Agreement if you have obtained the Company’s express written consent which may be refused in the absolute discretion of the Company. The Company may transfer or assign this agreement in its absolute discretion.

    19. APPLICABLE LAWS

      19.1 The terms of this Agreement are governed by English Law.

      19.2 You agree to the exclusive jurisdiction of the English courts in relation to any dispute, which may arise under this Agreement.

    20. CONFIDENTIALITY

      You shall during the term of this Agreement and thereafter keep and procure that your employees, contractors and agents keep secret and confidential all business, technical and commercial information concerning the Company and the Products that you have received or obtained as a result of the entering into of this Agreement save for information which is trivial or obvious or which enters into the public domain other than as a result of a breach of this clause.

    21. ADDITIONAL PROVISIONS APPLICABLE TO NAMES & NUMBERS AND TRACEMASTER PRODUCTS

      21.1 It is a further condition of this Agreement that you agree that:

      • (i) it is your responsibility to contact the Mailing Preference Service (MPS), the Telephone Preference Service (TPS) and the Corporate Telephone Preference Service (CTPS) (which are updated approximately every 28 days) to check and eliminate any records obtained from the Product before using such records for marketing, research or survey purposes;

      • (ii) no records obtained directly from the Product shall be used for marketing, research or survey purposes unless they are records including an Organisation Name, or are shown in The Product to be included in the “Edited Electoral Roll”.

      • (iii) you will follow the following codes of practice when contacting people by telephone using records obtained from the Product:

        • (a) never call a person who has registered with the TPS or an Organisation registered with the CTPS;

        • (b) always identify yourself clearly;

        • (c) never withhold your own Caller Line Identity;

        • (d) never adopt a menacing or annoying manner;

        • (e) remain polite, respectful and never use profanities or bad language;

        • (f) immediately end a call when requested to do so;

        • (g) always respect a request not to be contacted again;

        • (h) never telephone during unsocial hours (i.e never call a private residence before 10a.m (11a.m at weekends or holidays) or after 10p.m.)

      • (iv) never use any telephone numbers from the Product for sending SMS (“Text”) messages as part of any mass-marketing activity.

      21.2 The Mailing Preference Service can be contacted at DMA House, 70 Margaret Street, London, W1W 8SS; telephone 020 7291 3310 or http://www.mpsonline.org.uk and the Telephone Preference Service and Corporate Telephone Preference Service can be contacted at DMA House, 70 Margaret Street, London, W1W 8SS; telephone 020 7291 3320 or http://www.tpsonline.org.uk.

      21.3 In addition to the fees payable pursuant to clause 3 of this Agreement you shall:

      • (i) pay to the Company a Data Extract License Fee of £20 +VAT for each thousand (or part thereof) residential address records extracted from the Product after the first 100,000 residential address records have been extracted within a single license year. For the purpose of this clause a “residential address record” is a record of one person at one delivery point

      • (ii) pay to the Company a Data Extract License Fee of £120 + VAT for each thousand (or part thereof) organisation address records extracted from the Product after the first 10,000 organisation address records have been extracted within a single license year. For the purpose of this clause an “organisation address record” is a record containing data in the ‘organisation’, ‘Sic’ or ‘Classification’ fields at one delivery point.

      • (iii) submit a quarterly return to the Company detailing the records which have been extracted by you in the previous quarter in the format requested by the Company from time to time. The returns shall be submitted to the Company by the 15th April, 15th July, 15th October and 15th January in each year in respect of the 3 month period ending on the last day of the previous month.

      • (iv) Not export more than 50,000 organisation or 500,000 residential address records within a single license year without first seeking and receiving written authorisation from The Company

      21.4 Non-return of quarterly Data Extract Return

      • (i) In the event of non-return of a quarterly Data Extract Return, the Licensee agrees to pay a late return penalty of £250 which shall be invoiced by the Company and payable within 14 days of the invoice date. Should the Licensee continue to fail to observe the terms and conditions of Data Extracts from the Product, the Company may terminate this Agreement forthwith pursuant to clause 7 above, with no refund of any fees paid.

      • (ii) Where the Company has reason to believe that Organisation data extracts have exceeded 10,000 records or that residential data extracts have exceeded 100,000 records it reserves the right to make an estimate of extracted records which have exceeded these amounts and invoice the Licensee according to the provisions in 21.3 i and 21.3 ii.

      21.5 The Product shall not be used in any automated process for extraction or addition of data from the Product into other databases or computer records.

    22. ADDITIONAL PROVISIONS APPLICABLE TO CENSATION CENSUS-BASED AND OTHER NATIONAL STATISTICS DATA

      22.1 Censation contains Census output which is Crown copyright and is reproduced with permission of the controller of HMSO and the Queen’s printer for Scotland

      22.2 The Census output contained in Censation incorporates safeguards against the possible identification of any particular person or household. You shall not use such output to attempt to obtain or derive information relating specifically to an individual or household, nor claim to have obtained or derived such information.

      22.3 You shall not operate any Bureau Services that make use of data or information from Censation.

      22.4 Parliamentary Constituency and other National Statistics data is sourced from National Statistics. Crown copyright material is reproduced with the permission of the Controller of HMSO.

    23. ADDITIONAL PROVISIONS APPLICABLE TO MAP DATA

      23.1 The Map Data supplied with AFD Postcode products is copyright of Collins Bartholomew Ltd

      23.2 All screen images derived or generated from the data should incorporate the following acknowledgements:

      • Digital Map Data © Collins Bartholomew Ltd (year)

      • “year” shall be the year in which The Product was purchased or most recently renewed.

      23.3 Hard copy prints from the map data up to and including A4 size are permitted under the terms of this agreement. Hard copy output for resale or distribution to third parties may not be produced by you without the written permission of Collins Bartholomew. All hard copy output produced from the data should incorporate the following acknowledgements:

      • Digital Map Data © Collins Bartholomew Ltd (year)

      • “year” shall be the year in which The Product was purchased or most recently renewed

    24. ADDITIONAL PROVISIONS APPLICABLE TO BANKFINDER

      24.1 Your right to use the Extended ISCD data provided with BankFinder is limited to use in connection with the UK Bacs scheme, Faster Payments scheme, CHAPS Sterling scheme and Cheque and Credit Clearing scheme.

      24.2 You acknowledge that all property rights including but not limited to Intellectual Property rights in the Sorting Code, Sorting Code Data, and the Extended ISCD, that form a part of BankFinder, are owned by UK Payments.

      24.3 You shall update BankFinder data at least monthly.

      24.4 All property rights in the Irish Bank sort code and validation data supplied with AFD BankFinder are the property of IPSO and/or its member banks, and that title shall not pass to you under any circumstances.

      24.5 You shall not grant any license or otherwise permit any third party to use the Irish Validation Data or the Product.

      24.6 You shall procure that only those employees and information technology contractors who have a need to know are given access to the Irish Validation Data supplied; and so that each such employee and contractor shall be advised that the Irish Validation Data is the property of IPSO and/or the Banks, and further is required to be kept confidential. You shall procure that the Irish Validation Data is kept confidential by such employees and contractors.

      24.7 You shall not reverse engineer, publish or cause to be distributed the modulus rules used in validation.

      24.8 You shall not publish or cause to be distributed a paper directory of Validation Data or Sort Code Data, and whether in competition with IPSO’s publication entitled “Sort Code Book” or otherwise.

    25. ADDITIONAL PROVISIONS APPLICABLE TO GRID REFERENCE DATA

      25.1 The Product contains Ordnance Survey data © Crown copyright and database right 2016.

      25.2 The Product contains Royal Mail data © Royal Mail copyright and database right 2016.

    ROYAL MAIL TERMS

    Please refer to the Royal Mail Terms.

    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.

    Code Affluence Life Stage Additional Info Label
    AW01 Wealthy Young families Many Christians, Professionals with High incomes, commercially active Eclectic Tastes
    AW07 Wealthy Young families Employed in full education and finance, active online but protective of identity, some Christian and rural Fully online
    AW09 Wealthy Young families Public servants with above average income, some christians and rural locations Progressive Families
    AX02 Wealthy Older families Above average incomes, with tradional backgrounds and high levels of responsibility Business Leaders
    AX03 Wealthy Older families Suburban neighbourhoods with many social grade AB, commercially active Leafy Avenues
    AX05 Wealthy Older families Traditional outlook with high qualifications and social grade AB Instinctive conservative
    AX06 Wealthy Older families Well above average incomes, in established neighbourhodds, but engaging with the internet Thoughtful Progress
    AX10 Wealthy Older families Established affluent families, who want privacy with many different Religions and backgrounds Global Perspective
    AY04 Wealthy Empty nests and seniors Managers and senior officials with high incomes, engaged with commerce and the internet Settled Influence
    AY08 Wealthy Empty nests and seniors Professional and senior managers with a wide range of cultural interests Style and Music
    BV20 Prosperous Young singles Highly qualified young people looking to establish themselves and settle down Preparing the Nest
    BW11 Prosperous Young families High incomes, with many Christians, employed in finance and business services Cultured Engagement
    BW18 Prosperous Young families Suburban families with young children and high aspirations for commercial success Sporting Ambitions
    BX15 Prosperous Older families Buying their own homes, and preparing for children to leave home Parents Taxi
    BY12 Prosperous Empty nests and seniors Established focus on buying home, DIY, home improvements and the garden Home and Garden
    BY13 Prosperous Empty nests and seniors Mixed set of interests, able to do new things now children are becoming independent Considering Change
    BY14 Prosperous Empty nests and seniors Mixed interests, but many with local interests and higher than average incomes Considerate Participants
    BY16 Prosperous Empty nests and seniors Many retired christians, in suburban settings, with little commercial activity Contented Enjoyment
    BY17 Prosperous Empty nests and seniors Many rural locations, employment in agriculture and support for local charities Country Cottage
    BY19 Prosperous Empty nests and seniors Some christians with employment in education and the professions Traditional Community
    BY21 Prosperous Empty nests and seniors Range of interests with a typical income but much expectation about commercial activity Driven to Get On
    CV29 Comfortable Young singles Lots of different activities, with plenty of uptake of technology and online activity Prudent Technologists
    CV30 Comfortable Young singles Highly qualified workers, with some professionals, and interests in Lesiure, clothing and appliances Living to the Full
    CV31 Comfortable Young singles Many students, and interests in music, lesiure and events Festival Participants
    CW26 Comfortable Young families Hindus and muslims, many employed in the transport sector with some office and shop staff Global Reach
    CW28 Comfortable Young families Wide range of interests, particularly charities and family, many manual workers in the retail sector Empathetic Supporter
    CX22 Comfortable Older families Many factory and manual workers in manufacturing and retail. Buying their own houses, some on average incomes Salt of the earth
    CX27 Comfortable Older families Buying their own home, some in a rural setting, with interests in the local community Attentive partner
    CY23 Comfortable Empty nests and seniors Retired with a range of interests in semi-detached houses with moderate commercial activity, some with no qualifications House Proud
    CY24 Comfortable Empty nests and seniors Retired with a range of interests, some moderate commercial activity, with some high qualifications Social Enthusiast
    CY25 Comfortable Empty nests and seniors Retired with mixed interests with skilled trades and experience in agriculture. Relatively High commercial activity with some intermediate qualifications Handy skills
    DV36 Striving Young singles Living in rented accomodation, working in hotels, business and health services. Sometimes support charities Focused Students
    DW32 Striving Young families Living in smaller houses. Manual workers in manufacturing and retail Looking for New Ideas
    DW33 Striving Young families Tradional outlook with some Christians, working in retail and transport with little commercial activity Conscientious worker
    DW41 Striving Young families Support staff employed in manufacturing and retail, on low incomes, with an eclectic range of interests Keeping Fit
    DX34 Striving Older families No professed religion, with low levels of qualifications. Manual workers reading popular newspapers Industrious providers
    DX39 Striving Older families Employed in manufacturing, construction and retail as support staff. Many read middle of the road newspapers with a conservative outlook Making Ends Meet
    DX40 Striving Older families Employed in manufacturing, construction and retail. Have no qualifications and read popular newspapers, but engage with social media Aspiring Technologists
    DX42 Striving Older families Very low incomes - either unemployed or in the hotel trade, but sometimes support charities Old-school companions
    DY35 Striving Empty nests and seniors Retired with mixed interests, many with no religious affiliation who sometimes support charities Careful beginners
    DY37 Striving Empty nests and seniors Retired without qualifications, with experience in manufacturing. Some support charities some of the time Home Builders
    DY38 Striving Empty nests and seniors Many retired without qualifications, read popular newspapers, some on low incomes Working hard
    EV46 Struggling Young singles Some on low incomes, living in rented accomodation with no religious affiliation, with aspirations for commercial activity Bettering themselves
    EW44 Struggling Young families Many with no-religious affiliation in social and private rented accommodation, who sometimes support charities Meticulous care
    EW45 Struggling Young families Mixed interests, living in rented accomdation and reading popular newspapers Starting Out
    EW50 Struggling Young families Social renting of smaller flats & houses, very low incomes, with little commercial activity Firm foundations
    EX49 Struggling Older families Social renting of flats & smaller houses, read popular newspapers and little commercial or internet activity Dedicated Parents
    EY43 Struggling Empty nests and seniors Retired, social grade E, with no qualifications. Reading popular newspapers, value privacy with little commercial activity Resolute spirit
    EY47 Struggling Empty nests and seniors Retired with little religious affiliation and no qualifications previously in process support and elementary occupations, some in social and private renting Diligent Supporters
    EY48 Struggling Empty nests and seniors Social grade E, retired with experience of personal health services. Engaged with commercial activity Persistent enquirers
    EY51 Struggling Empty nests and seniors Social grade E, retired with experience of elementary occupations in health. Many Muslim and Hindu Determined Survivors
    EY52 Struggling Empty nests and seniors Social grade E, retired with experience of elementary occupations in manufacturing. Little commercial and online activity Proud Technophobes
    NL61 Not Classified Many organisations mixed with low, transient population Consumer commercial centres and offices. Much of this segment arises from business related sources, plus some unidentified residential properties Unclassified

    Appendix I: Censation Detailed Tables

    Code Percentage
    of UK
    Population
    (Postcode Level
    Censation)
    Percentage
    of Adults
    Over 18
    (Individual Level
    Censation)
    Percentage
    of Occupied
    Households
    (Household Level
    Censation)
    Urban- 
    Rural
    Score
    Recent
    New Build
    Score
    Recent
    House Sales
    Score
    Recent
    Sale Price
    Score
    Annual Rate of
    House Price
    Increase Score
    Annual Rate of
    House Sale
           

    (See codes in the tables below for a description of each score number)

    AW01 1.21 0.27 0.21 5 3 1 5 1 4
    AW07 0.75 1.45 1.11 5 5 2 5 1 5
    AW09 0.90 0.69 0.58 5 3 5 5 2 3
    AX02 0.92 0.37 0.31 4 5 1 5 4 4
    AX03 2.02 0.46 0.29 5 3 4 5 3 2
    AX05 1.37 2.26 1.59 5 3 5 5 4 2
    AX06 1.35 1.75 1.38 4 2 3 5 4 2
    AX10 1.84 0.28 0.27 1 1 5 4 5 3
    AY04 1.76 1.04 1.52 3 2 4 5 5 4
    AY08 1.63 0.91 1.19 4 5 5 5 1 5
    BV20 1.40 1.84 1.56 4 5 4 4 1 5
    BW11 1.96 0.82 0.66 5 4 1 4 1 3
    BW18 1.94 1.78 1.48 5 4 2 4 3 5
    BX15 1.54 6.52 5.02 5 2 2 4 3 2
    BY12 1.01 1.18 1.83 4 3 4 4 4 3
    BY13 1.58 1.25 1.90 4 5 4 4 1 5
    BY14 1.24 0.04 0.05 2 1 4 5 5 3
    BY16 0.66 0.06 0.10 1 1 2 4 3 4
    BY17 1.43 0.06 0.05 5 1 2 4 3 3
    BY19 0.99 0.15 0.23 3 1 4 4 4 3
    BY21 0.89 0.32 0.46 4 4 4 3 1 5
    CV29 0.60 1.02 1.11 3 2 5 2 2 1
    CV30 0.99 1.97 1.85 3 4 3 3 5 4
    CV31 1.04 1.29 1.17 3 5 5 3 1 5
    CW26 1.91 1.40 1.09 1 2 5 3 2 1
    CW28 2.73 5.67 4.84 4 5 1 3 2 5
    CX22 8.26 13.53 10.42 3 4 2 3 3 1
    CX27 6.13 1.30 1.06 4 3 3 3 2 2
    CY23 5.06 5.80 9.17 2 4 3 3 3 3
    CY24 3.71 1.79 2.78 2 3 3 4 5 3
    CY25 3.24 0.43 0.61 1 1 2 3 3 3
    DV36 1.75 3.63 3.40 3 3 1 2 5 4
    DW32 0.64 1.11 0.96 5 5 1 2 5 4
    DW33 0.86 1.02 0.81 3 3 5 2 4 4
    DW41 0.78 2.19 1.82 3 5 1 3 5 5
    DX34 1.75 5.21 3.97 3 1 4 2 4 1
    DX39 1.82 2.69 2.13 3 2 3 2 2 2
    DX40 2.43 1.49 1.11 4 4 2 2 1 2
    DX42 2.07 0.61 0.53 4 3 3 2 1 3
    DY35 2.57 3.57 5.59 2 5 1 2 2 4
    DY37 4.11 1.82 2.85 2 2 2 2 2 2
    DY38 1.81 0.26 0.40 1 1 1 2 2 2
    EV46 1.79 3.15 3.24 2 4 1 1 2 4
    EW44 1.28 0.63 0.53 2 1 1 1 5 5
    EW45 0.76 1.59 1.33 2 4 5 1 5 5
    EW50 0.70 0.66 0.54 1 1 2 1 4 1
    EX49 2.20 5.55 4.38 2 2 3 1 4 1
    EY43 2.35 1.26 2.05 1 2 2 1 2 1
    EY47 2.37 2.68 4.44 1 4 3 1 2 1
    EY48 3.24 1.39 2.26 2 2 1 1 3 2
    EY51 1.55 1.65 1.61 1 1 3 1 4 1
    EY52 1.11 0.11 0.17 1 1 1 1 3 1
     
    Urban - Rural Score Proportion of Postcodes
    within Rural areas
           Recent New
    Build Score
    Rate of New Build Registrations
    Mar 2012 to Feb 2013
           Recent House
    Sales Score
    Rate of House Sales
    Mar 2012 to Feb 2013
    1 Less than 7% 1 Less than 3.5% 1 Less than 7.7%
    2 Over 7% and less than 17% 2 Over 3.5% and less than 6% 2 Over 7.7% and less than 8.0%
    3 Over 17% and less than 27% 3 Over 6% and less than 9.3% 3 Over 8.0% and less than 8.5%
    4 Over 27% and less than 43% 4 Over 9.3% and less than 15% 4 Over 8.5% and less than 9.5%
    5 Over 43% 5 Over 15% 5 Over 9.5%
     
    House Sale
    Price Score
    Average House Sale Price
    Mar 2012 to Feb 2013
           House Price
    Increase Score
    Change in Average House Price, between 2007 and 2012        Rate of Change of House Sales Score Change in Volume of Annual Sales, between 2007 and 2012
    1 Less than £176K 1 Less than -2%   1 Less than -35%
    2 Over £176K and less than £215K 2 Over -2% and less than 2%   2 Over -35% and less than -26%
    3 Over £215K and less than £300K 3 Over 2% and less than 6%   3 Over -26% and less than -16%
    4 Over £300K and less than £480K 4 Over 6% and less than 12%   4 Over -16% and less than 30%
    5 Over £480K 5 Over 12%   5 Over 30%

    Affluence - Income Affluence - Housing
    Rank 
    Average 
    Household Income
    Income Band Code Tenure Housing
    3 Excess Over £30K AW01 Many owned mortgaged Some Semi-detached
    9 Excess Over £30K AW07 Many owned mortgaged Many Flats
    16 Excess Over £30K AW09 Many owned mortgaged Some Terraced
    2 Excess Over £30K AX02 Many owned mortgaged Some Terraced
    12 Excess Over £30K AX03 Many owned mortgaged Some Flats
    4 Excess Over £30K AX05 Many owned mortgaged Some Flats
    8 Excess Over £30K AX06 Many owned mortgaged Some Terraced
    20 Excess Over £30K AX10 Many owned mortgaged Many Detached
    1 Excess Over £30K AY04 Excess owned outright Mixed Housing
    11 Excess Over £30K AY08 Excess owned outright Some Terraced
    23 Excess Over £30K BV20 Many owned mortgaged Some Flats
    13 Excess Over £30K BW11 Many owned mortgaged Many Flats
    28 Many Over £30K BW18 Many owned mortgaged Some Flats
    18 Excess Over £30K BX15 Many owned mortgaged Some Flats
    10 Excess Over £30K BY12 Many owned outright Some Flats
    24 Excess Over £30K BY13 Excess owned outright Many Flats
    5 Excess Over £30K BY14 Many owned outright Many Flats
    6 Excess Over £30K BY16 Excess owned outright Some Detached
    15 Excess Over £30K BY17 Excess owned outright Many Flats
    7 Excess Over £30K BY19 Excess owned outright Some Flats
    32 Many Over £30K BY21 Excess owned outright Some Detached
    41 Many Under £10K CV29 Many Private renting Mixed Housing
    30 Mixed CV30 Many owned mortgaged Some Terraced
    50 Excess Under £10K CV31 Excess Private renting Some Flats
    31 Some £10K to £30K CW26 Some owned mortgaged Many Detached
    26 Excess Over £30K CW28 Some owned mortgaged Some Terraced
    22 Excess Over £30K CX22 Some owned mortgaged Some Detached
    14 Excess Over £30K CX27 Some owned mortgaged Some Terraced
    25 Excess Over £30K CY23 Many owned outright Some Terraced
    17 Excess Over £30K CY24 Many owned outright Many Flats
    19 Excess Over £30K CY25 Some owned mortgaged Some Terraced
    42 Many Under £10K DV36 Many Private renting Some Flats
    29 Mixed DW32 Some owned mortgaged Some Detached
    40 Some £10K to £30K DW33 Some owned mortgaged Some Terraced
    44 Many Under £10K DW41 Some private renting Some Terraced
    35 Some £10K to £30K DX34 Some owned mortgaged Some Terraced
    33 Some £10K to £30K DX39 Some owned mortgaged Mixed Housing
    47 Excess Under £10K DX40 Some social renting Some Detached
    21 Excess Over £30K DX42 Some social renting Some Detached
    36 Many Under £10K DY35 Some owned mortgaged Some Flats
    34 Some £10K to £30K DY37 Some social renting Mixed Housing
    27 Many Over £30K DY38 Some social renting Mixed Housing
    48 Excess Under £10K EV46 Some social renting Some Terraced
    43 Some £10K to £30K EW44 Many social renting Some Terraced
    49 Excess Under £10K EW45 Many social renting and private renting Some Detached
    52 Excess Under £10K EW50 Many social renting and private renting Some Terraced
    38 Many £10K to £30K EX49 Many social renting Some Terraced
    45 Many Under £10K EY43 Many social renting Some Detached
    51 Excess Under £10K EY47 Many social renting and private renting Some Detached
    39 Some £10K to £30K EY48 Many social renting Some Detached
    46 Excess Under £10K EY51 Many social renting Some Semi-detached
    37 Some £10K to £30K EY52 Many social renting Some Detached


    Affluence - Employment
    Code Economic Activity Industry Sector Occupation Social Grade
    AW01 Many In Full-time Employment Many finance or public administration Many managers, senior officials, associate managers and technical support Many AB
    AW07 Many In Full-time Employment Many finance, business services or education Many managers, senior officials or professionals Many AB
    AW09 Many Part-time or Self Employed Many public administration Some associate managers and technical support Many AB
    AX02 Many Part-time or Self Employed Many finance Many managers and senior officials Many AB
    AX03 Many Part-time or Self Employed Many finance, business services or education Many managers, senior officials or professionals Many AB
    AX05 Mixed Employment Many finance, business services or education Many managers, senior officials or professionals Many AB
    AX06 Many Part-time or Self Employed Many public administration Some professionals Some AB
    AX10 Many In Full-time Employment Many manufacturing or retail Some administration Some AB
    AY04 Many Part-time or Self Employed Many finance, business services or education Many managers, senior officials or professionals Many AB
    AY08 Many In Full-time Employment Many agriculture, business services or education Many managers, senior officials or professionals Many AB
    BV20 Many In Education Many finance, business services or social and personal services Many managers, senior officials, professionals, associate managers and technical support Many AB
    BW11 Many Part-time or Self Employed Many finance or business services Many managers, senior officials, professionals, associate managers and technical support Many AB
    BW18 Many Part-time or Self Employed Many finance, business services or social and personal services Many managers, senior officials, professionals, associate managers and technical support Many AB
    BX15 Mixed Employment Many manufacturing or retail Some skilled trades Many AB
    BY12 Many Part-time or Self Employed Many education Many professionals Many AB
    BY13 Mixed Employment Many agriculture Some managers and senior officials Many AB
    BY14 Many Part-time or Self Employed Many agriculture or education Many managers and senior officials Many AB
    BY16 Many Part-time or Self Employed Many education Many managers and senior officials Many AB
    BY17 Many Part-time or Self Employed Many agriculture Some skilled trades Some AB
    BY19 Many Part-time or Self Employed Many education Some professionals Some AB
    BY21 Many In Education Many manufacturing Some skilled trades Some AB
    CV29 Many In Education Many hotels, finance, business services or social and personal services Many professionals, associate managers and technical support Some AB
    CV30 Many Unemployed Many finance or business services Many managers, senior officials or professionals Some C1
    CV31 Many In Education Many hotels or education Many professionals Some C1
    CW26 Many In Education Many transport Some administration Some AB
    CW28 Many In Full-time Employment Many retail Some elementary occupations Some C1
    CX22 Many Part-time or Self Employed Many manufacturing or retail Some process support staff Some C2
    CX27 Many Part-time or Self Employed Many manufacturing, construction or retail Many process support staff Many C2
    CY23 Many Part-time or Self Employed Many manufacturing or education Some administration Some C1
    CY24 Many Part-time or Self Employed Many agriculture Some managers and senior officials Some C1
    CY25 Many Part-time or Self Employed Many agriculture Many skilled trades Many C2
    DV36 Many In Education Many hotels, business services or social and personal services Some associate managers and technical support Some C1
    DW32 Many Part-time or Self Employed Many manufacturing or retail Some process support staff Some C1
    DW33 Many Unemployed Many retail or transport Some process support staff Some D
    DW41 Mixed Employment Many manufacturing or retail Many process support staff or elementary occupations Some C1
    DX34 Many Part-time or Self Employed Some construction Many process support staff Many DE
    DX39 Many In Education Many manufacturing, construction or retail Many process support staff or elementary occupations Some C2
    DX40 Many In Education Many manufacturing, construction or retail Many process support staff or elementary occupations Some C2
    DX42 Many In Full-time Employment Many hotels Some elementary occupations Some C2
    DY35 Many In Education Some education Some managers and senior officials Some C2
    DY37 Many Part-time or Self Employed Many manufacturing Some process support staff Some DE
    DY38 Many Part-time or Self Employed Many manufacturing Some process support staff Some C2
    EV46 Many Unemployed Many hotels Some elementary occupations Some C1
    EW44 Many Unemployed Many hotels, transport, business services, or social and personal services Some elementary occupations Some C2
    EW45 Many Unemployed Many manufacturing, retail or hotels Many process support staff or elementary occupations Many DE
    EW50 Many Unemployed Many hotels Many elementary occupations Many DE
    EX49 Many Unemployed Some hotels Many elementary occupations Many DE
    EY43 Many Unemployed Some construction Some process support staff Many DE
    EY47 Many Unemployed Many manufacturing or retail Many process support staff or elementary occupations Many DE
    EY48 Mixed Employment Some health Some personal services Many DE
    EY51 Many In Education Some health Some elementary occupations Many DE
    EY52 Many Unemployed Some manufacturing Many elementary occupations Many DE
    Lifestage - Age Lifestage - Household Make-up
    Code Rank
    Average
    Adult Age
    Age Band Code Marital Status Dependent Children
    AW01 20 45 - 54 AW01 Many couples (married or re-married) Many with one or more; aged 0 - 4
    AW07 30 35 - 44 AW07 Some couples (married or re-married) Some with 2 or more; aged 0 - 4
    AW09 13 25 - 34 AW09 Some couples (married or re-married) Many with one aged 0 - 4
    AX02 21 45 - 54 AX02 Many couples (married or re-married) Many with 2 or more; aged 5 - 11
    AX03 46 45 - 54 AX03 Many couples (married or re-married) Some with 2 or more; aged 12 - 18
    AX05 48 45 - 54 AX05 Many couples (married or re-married) Some with 2 or more; aged 12 - 18
    AX06 38 45 - 54 AX06 Many couples (married or re-married) Some with 2 or more; aged 12 - 18
    AX10 19 45 - 54 AX10 Many couples (married or re-married) Some with 2 or more; aged 12 - 18
    AY04 49 45 - 54 AY04 Many couples (married or re-married) Many with none
    AY08 37 35 - 44 AY08 Many couples (married or re-married) Some with none
    BV20 6 35 - 44 BV20 Many cohabiting or single (never married) Many with none or with one aged 0 - 4
    BW11 44 35 - 44 BW11 Many cohabiting Many with one aged 0 - 4
    BW18 29 25 - 34 BW18 Many cohabiting or single (never married) Many with one aged 0 - 4
    BX15 50 45 - 54 BX15 Some couples (married or re-married) Some with 2 or more; aged 5 - 11
    BY12 42 45 - 54 BY12 Many couples (married or re-married) Many with none
    BY13 41 45 - 54 BY13 Many couples (married or re-married) Some with none
    BY14 40 45 - 54 BY14 Many couples (married or re-married) Many with none
    BY16 52 35 - 44 BY16 Many couples (married or re-married) Many with none
    BY17 51 35 - 44 BY17 Many couples (married or re-married) Some with none
    BY19 47 35 - 44 BY19 Some widowed Some with none
    BY21 9 45 - 54 BY21 Many couples (married or re-married) Many with none
    CV29 2 25 - 34 CV29 Many single (never married) Many with none
    CV30 18 25 - 34 CV30 Some single (never married) Many with none
    CV31 1 18 - 24 CV31 Many single (never married) Many with none
    CW26 5 25 - 34 CW26 Many single (never married) Many with 2 or more; aged 0 - 4
    CW28 17 35 - 44 CW28 Many cohabiting Many with 2 or more; aged 0 - 4
    CX22 31 35 - 44 CX22 Some couples (married or re-married) Some with 2 or more; aged 5 - 11
    CX27 28 25 - 34 CX27 Some cohabiting Some with 2 or more; aged 5 - 11
    CY23 36 45 - 54 CY23 Many couples (married or re-married) Many with none
    CY24 23 35 - 44 CY24 Many couples (married or re-married) Many with none
    CY25 45 25 - 34 CY25 Some couples (married or re-married) Many with none
    DV36 4 25 - 34 DV36 Many single (never married) Many with one aged 0-4
    DW32 43 25 - 34 DW32 Many cohabiting Many with one or more; aged 0 - 4
    DW33 16 25 - 34 DW33 Some married but living alone Many with 2 or more; aged 0 - 4
    DW41 32 25 - 34 DW41 Some single (never married) Many with 2 or more; aged 0 - 4
    DX34 27 25 - 34 DX34 Some couples (married or re-married) Some with one aged 12 - 18
    DX39 14 45 - 54 DX39 Some widowed Some with 2 or more; aged 5 - 11
    DX40 11 35 - 44 DX40 Some widowed Some with 2 or more; aged 5 - 11
    DX42 25 25 - 34 DX42 Some widowed Some with one aged 0-4
    DY35 10 25 - 34 DY35 Many widowed Many with none
    DY37 24 25 - 34 DY37 Some widowed Some with none
    DY38 39 25 - 34 DY38 Some widowed Many with none
    EV46 8 25 - 34 EV46 Many single (either never married or divorced) Some with one aged 5 - 11
    EW44 34 25 - 34 EW44 Many single (never married) Many with one or more; aged 0 - 11
    EW45 35 25 - 34 EW45 Some single (never married) Many with one or more; aged 0 - 11
    EW50 15 25 - 34 EW50 Many single (never married) Many with one aged 0 - 11
    EX49 22 25 - 34 EX49 Some single (never married) Some with one aged 5 - 11
    EY43 12 25 - 34 EY43 Some widowed Some with none
    EY47 7 25 - 34 EY47 Many widowed Some with none
    EY48 33 18 - 24 EY48 Many widowed Many with none
    EY51 3 45 - 54 EY51 Many widowed Many with none
    EY52 26 35 - 44 EY52 Many widowed Some with one aged 5 - 11

    Lifestyle
    Code Religion Qualifications Population Characteristics Newspaper Type Charity Support Mail Order Users
    AW01 Some christian Many Level 4 Mixed population with an excess of people living in households Some medium Many Frequent Some Occasional
    AW07 Some jewish Many Level 4 Many students away from home Some quality In-conclusive In-conclusive
    AW09 Many no professed religion Many Level 4 Many people living in households Some popular Many Frequent Many Frequent
    AX02 Many christian Many Level 4 Mixed population with an excess of people living in households Some quality Many Occasional Many Occasional
    AX03 Many christian Many Level 4 Many people living in households Many quality In-conclusive In-conclusive
    AX05 Many christian or jewish Many Level 4 Many people living in households Many quality Many Frequent Many Regular
    AX06 Many no professed religion Many Level 4 Many people living in households Some quality Many Occasional Many Occasional
    AX10 Many christian Many Level 4 Many people living in households Some quality Many Regular Some Occasional
    AY04 Many christian Many Level 4 Mixed population with an excess of students away from home Many quality Many Frequent Many Regular
    AY08 Many christian Many Level 4 Many people living in households Some quality Many Regular Many Frequent
    BV20 Many no professed religion Many Level 4 Many people living in households Some popular Many Regular Many Frequent
    BW11 Many no professed religion Many Level 4 Mixed population with an excess of people living in households Some quality Many Regular In-conclusive
    BW18 Many no professed religion Many Level 4 Mixed population with an excess of females Some Popular Many Occasional Many Frequent
    BX15 Many christian Many Level 4 Mixed population with an excess of females Some quality Many Occasional Many Occasional
    BY12 Some christian Many Level 4 Mixed population with an excess of people living in households Some quality Many Frequent Many Regular
    BY13 Some no professed religion Many Level 4 Mixed population with an excess of students away from home Some quality Many Frequent Many Occasional
    BY14 Many christian Many Level 4 Mixed population with an excess of people living in households Some quality Many Frequent Many Frequent
    BY16 Many christian Many Level 4 Mixed population with an excess of people living in households Some quality Many Frequent Many Regular
    BY17 Some no professed religion Many Level 4 Many people living in households Some medium Many Frequent Many Regular
    BY19 Some jewish Many Level 4 Many people living in communal establishments Some quality Many Frequent Many Regular
    BY21 Many christian Many Level 4 Mixed population with an excess of people living in households Some medium Many Frequent Many Regular
    CV29 Many no professed religion Many Level 4 Mixed population with an excess of people living in communal establishments Some quality Many Regular Many Regular
    CV30 Many jewish Many Level 4 Many people living in households Some quality Many Regular Many Frequent
    CV31 Many muslim or no professed religion Many Level 3 Mixed population with an excess of people living in households Some quality In-conclusive In-conclusive
    CW26 Many hindu or muslim Many Level 4 Mixed population with an excess of people living in communal establishments Some medium Many Frequent In-conclusive
    CW28 Some no professed religion Many Level 4 Mixed population with an excess of people living in households Some popular Many Frequent In-conclusive
    CX22 Many christian Many Level 4 Mixed population with an excess of people living in households Some popular Many Regular Many Frequent
    CX27 Many christian Many Level 4 Many people living in households Some popular Many Frequent Many Regular
    CY23 Many christian Many Level 2 Mixed population with an excess of people living in communal establishments Some medium Many Frequent Many Regular
    CY24 Many christian Many Level 4 Many people living in households Some quality Many Frequent Many Regular
    CY25 Many christian Many Level 2 Mixed population with an excess of students away from home Some quality Some Regular In-conclusive
    DV36 Many muslim or no professed religion Many Level 2 Mixed population with an excess of students away from home Some popular Many Regular Many Regular
    DW32 Some muslim Many Level 2 Many people living in households Some quality Many Frequent Many Regular
    DW33 Many hindu, muslim or sikh Many Level 3 Many people living in communal establishments Some popular Many Regular Many Frequent
    DW41 Many muslim Many Level 2 Mixed population with an excess of people living in households Many popular Many Occasional Many Occasional
    DX34 Many no professed religion Many Level 2 Many people living in households Many popular Many Occasional Many Frequent
    DX39 Some christian Many Level 2 Mixed population with an excess of females Many popular In-conclusive In-conclusive
    DX40 Many christian Many with no qualifications Many people living in households Many popular Many Frequent Many Occasional
    DX42 Some no professed religion Some with no qualifications Mixed population with an excess of students away from home Some Quality In-conclusive Many Frequent
    DY35 Many christian Many with vocational Qualifications Mixed population with an excess of students away from home Some popular Some Regular In-conclusive
    DY37 Many christian Many Level 2 Mixed population with an excess of people living in households Some medium Some Occasional Many Regular
    DY38 Some christian Many Level 2 Mixed population with an excess of females Some Medium Some Occasional In-conclusive
    EV46 Some muslim Many Level 2 Many people living in households Some popular Many Occasional Many Occasional
    EW44 Many muslim Many Level 2 Many people living in households Some popular Many Occasional Many Regular
    EW45 Some christian Many with no qualifications Mixed population with an excess of people living in households Many popular In-conclusive In-conclusive
    EW50 Many no professed religion Many with no qualifications Many people living in communal establishments Some popular Some Occasional Many Occasional
    EX49 Many no professed religion Many Level 2 Many people living in communal establishments Many popular In-conclusive Some Frequent
    EY43 Many no professed religion Some with no qualifications Many people living in communal establishments Many popular Some Frequent Many Frequent
    EY47 Many christian Some with no qualifications Many people living in communal establishments Many popular Many Occasional Many Frequent
    EY48 Some christian Some with no qualifications Many people living in households Some popular In-conclusive In-conclusive
    EY51 Some christian Some with no qualifications Mixed population with an excess of people living in communal establishments Some popular Some Occasional Some Frequent
    EY52 Some no professed religion Some with no qualifications Many people living in communal establishments Many popular Many Frequent In-conclusive

    Appendix J: Censation Bar Charts

    Income

    sensation-bar-charts

    Tenure

    Names and Numbers - Product Manual

    Housing Type

    Names and Numbers - Product Manual

    Economic Activity

    Names and Numbers - Product Manual

    Industry Sector

    Names and Numbers - Product Manual

    Occupation

    Names and Numbers - Product Manual

    Social Grade

    Names and Numbers - Product Manual

    Age

    Names and Numbers - Product Manual

    Adult Marital Status

    Names and Numbers - Product Manual

    Dependant Children

    Names and Numbers - Product Manual

    Religion

    Names and Numbers - Product Manual

    Qualifications

    Names and Numbers - Product Manual

    Population Characteristics

    Names and Numbers - Product Manual

    Newspaper Readership

    Names and Numbers - Product Manual

    Charity Support

    Names and Numbers - Product Manual

    Appendix K: Censation Glossary

    Accommodation & food services Accommodation and food service activities
    Active: Full-time student Economically active: Full-time student
    Active: Self-employed Economically active: Self-employed
    Active: Unemployed Economically active: Unemployed
    Administrative services Administrative and support service activities
    Affluence An estimate of the relative material comfort experienced within different neighbourhoods of the UK based upon a combination of variables from the 2011 UK Census
    Census A questionnaire distributed to the whole UK population once every decade, the last one was in 2011
    Christian Indicates that a relatively high proportion of a postcode indicated that their religion was Christian in a voluntary question in the latest UK Census
    Comfortable The central band on the affluence scale derived from the Census data
    Commercial Indicates the presence of a high proportion of business and public organisations within a postcode
    Consumer Predominantly businesses that deal directly with the public, e.g. shops, banks, pubs etc.
    Converted flat Flat, maisonette or apartment: Part of a converted or shared house (including bed-sits)
    Detached house Whole house or bungalow: Detached
    Distinctive Where the proportion of a factor within a postcode is substantially larger than the proportion found within the UK as a whole.
    Electricity, gas, steam & air con Electricity, gas, steam and air conditioning supply
    Elementary (occupation) Unskilled jobs, e.g. security guards
    Employee: Full-time Economically active: Employee: Full-time
    Employee: Part-time Economically active: Employee: Part-time
    Empty Nests Adult couples aged over 45, who have no children.
    Established The average length of residency within a postcode is over 6 years.
    Excess A significantly higher proportion of a characteristic when that proportion is large across the whole of the UK.
    Flat In a commercial building Flat, maisonette or apartment: In a commercial building
    Frequently 6+ times per year
    Geodemographic The description of different characteristics about people based upon the location where they live.
    High Usually more than 8 times per year
    Hindu Indicates that a relatively high proportion of a postcode indicated that their religion was Hindu in a voluntary question in the latest UK Census.
    Household A group of people living within one building and accessed through a single main door.
    Household Space Any accommodation occupied by an individual household or, if unoccupied, available for an individual household.
    Human health and social work Human health and social work activities
    In-conclusive Information about the segment does not differentiate significantly between different characteristics
    In employment Economically active: In employment
    Inactive: Long-term sick or disabled Economically inactive: Long-term sick or disabled
    Inactive: Looking after home or family Economically inactive: Looking after home or family
    Inactive: Other Economically inactive: Other
    Inactive: Retired Economically inactive: Retired
    Inactive: Student Economically inactive: Student (including full-time students)
    Life Stage Indicates the distinctive characteristics of a postcode according to their age and household make-up
    Life Style Indications of the different ways that people participate with society and people around them.
    Mail Order Indicates how likely respondents are to make purchases through the use of magazines, catalogues etc. where the product is not seen directly, but sent by mail after it has been ordered.
    Many Indicates that a characteristic for a Censation segment is one of the 10% most distinctive for that variable
    Muslim Indicates that a relatively high proportion of a postcode indicated that their religion was Muslim in a voluntary question in the latest UK Census.
    Normally empty households Household spaces with no usual residents
    Normally occupied households Household spaces with at least one usual resident
    Occasionally 1 - 3 times per year.
    Older Families Adult couples, with children aged over 11.
    Personal Services Jobs that include support for private individuals, these can include health, social services and leisure.
    Professional & scientific activities Professional, scientific and technical activities
    Process Support Low skilled jobs particularly those that support production lines etc.
    Prosperous The next to highest band on the affluence scale derived from the 2011 Census data
    Public Administration Predominantly local and national government offices
    Public administration & defence Public administration and defence; compulsory social security
    Public Sector A grouping of business sectors including Public Administration, Health and Education.
    Purpose-built flats Flat, maisonette or apartment: Purpose-built block of flats or tenement
    Qualification: Level 1 Entry level vocational training: e.g. Skills for Life or Foundational Diploma or GCSEs graded D & E
    Qualification: Level 2 Established Vocational Training: e.g. Higher Diploma plus GCSEs graded A* to C
    Qualification: Level 3 Detailed Vocational Training: e.g. Advanced Diploma plus A/AS levels
    Qualification: Level 4 Further Vocational Training plus any University level courses
    Rank If the clusters are sorted according to a selected variable then this number indicates the position in the list.
    Residential Indicates that a postcode has predominantly private residences within it.
    Residential Services These services are often intermingled with private residences and can include Petrol Stations, Newsagents, Small grocers, Hairdressers etc.
    Religion The 2011 Census included a voluntary question asking each respondent their religion, if they chose to, they ticked their choice from those available.
    Semi-detached house Whole house or bungalow: Semi-detached
    Seniors Adults aged over 65, often living alone
    Sikh Indicates that a relatively high proportion of a postcode indicated that their religion was Sikh in a voluntary question in the latest UK Census.
    Social Grade A grouping of the population derived by the Market Research Society and used within Advertising and Marketing
    SOHO Small office and home office businesses
    Some Indicates that this characteristic is distinctive for that group although it doesn't fall into the top 10% for this variable.
    Sometimes 4 - 5 times per year
    Stable Indicates that the average length of residency in a postcode is between 3 and 6 years.
    Striving The next to lowest band on the affluence scale derived from the 2011 Census data
    Student at their non
    term-time address Schoolchild or full-time student aged 4 and over at their non term-time address
    Struggling The lowest band on the affluence scale derived from the 2011 Census data
    Temporary structure Caravan or other mobile or temporary structure
    Tenure Indicates the type of contract that a respondent holds for their place of residence.
    Terraced house Whole house or bungalow: Terraced (including end-terrace)
    Transient Indicates that the average length of residency within a postcode is below 3 years
    Turnover The rate at which people move in and out of a postcode.
    Variables Different descriptions of the characteristics of people within a postcode.
    Water supply & sewerage Water supply; sewerage, waste management and remediation activities
    Wealthy The highest band on the affluence scale derived from the 2011 Census data
    Wholesale and retail trade Wholesale and retail trade; repair of motor vehicles and motor cycles
    Young Families Adults living as a couple with children aged less than 11 years old.
    Young Singles Adults aged less than 45, who are living alone.

    Appendix L: Occupancy and Address Type Indicators

    Occupancy

    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 2UD  PO Box postcode.  Used by the organisation 'Birmingham City Council'.
    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.

    2. Small User Organisation

    Examples:

    B2 5EP  Used by multiple organisations such as 'Toni & Guy', 'Slaters', and 'Hobbs'.
    B6 5PL  Contains the Organisation 'Birmingham City Council, Birmingham Fleet Maintenance Dso' only.  In this case there is only as 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', 'RPS Engineering', 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 garage 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 1TW  Contains residential addresses, all of which are apartments.
    

    Address Type

    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:

    B3 1AP  Contains three addresses with a house number only and one address with both the Property 'Council House' as well as the number 31.
    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 ten 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:

    B2 5JS  Address simply has an organisation name, town and postcode.  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:

    B4 7DG  This is PO Box 122 for 'Urban Design' in Birmingham.
    B16 8TZ This is PO Box 1990 in Edgbaston, 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 1HH  This is a 'Holiday Inn' on Holiday 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

    ROYAL MAIL TERMS

    Please note not all sections may relate to your License.

    1. Definitions and interpretations

      1.1 In this Licence the following terms have the following meanings:

      • address refers to an address to which mail can be delivered

      • Bureau Customer a customer for a Bureau Service

      • Bureau Services a service comprising the Data Cleansing of a Customer Database and the supply of the resulting Cleansed Customer Database back to the relevant customer

      • Customer Database a database of an End User’s customer

      • Data Cleansing the processing of existing data records using PAFⓇ Data:

        • (a) including validating, reformatting, correcting or appending additional data to those records, and

        • (b) including the use of PAFⓇ Data within address capture applications, but

        • (c) not including Data Extraction (whether carried out by an address capture application or otherwise),

        • and Cleansed shall be read accordingly

      • Data Extraction the extraction of PAFⓇ Data or any part of it for the generation of new address records in a new or existing database

      • End User a single legal entity who you or a Licensee may permit to use PAFⓇ Data through its Users in accordance with this Licence

      • Extracted Data data generated as a result of Data Extraction

      • Licensee a person whose use of PAFⓇ Data you authorise further to this Licence, or whose use authorised by such a person by way of a sub-licence granted further to this Licence (whether directly or by way of a chain of sub-licences) but not an End User

      • PAFⓇ Data Royal Mail’s database known as PAFⓇ, and including the database known as the “Alias File”

      • PAFⓇ Licensing Centre Royal Mail’s website at www.poweredbypaf.com/licensing-centre or such other website as Royal Mail may notify further to this Licence

      • Party either Royal Mail or you (and Parties shall be read accordingly)

      • Royal Mail Royal Mail Group Limited, acting by its Address Management Unit

      • Solution a product or service or other solution which benefits from or includes PAFⓇ Data (including the provision of PAFⓇ Data itself), in whatever form, however produced or distributed and whether or not including other functionality, services, software or data

      • Standard PAFⓇ Licence a licence (other than a licence on the terms of this Licence) for the use of PAFⓇ Data on standard terms for specified uses made generally available by Royal Mail on the PAFⓇ Licensing Centre or otherwise

      • Substantially All a database which on its own or as part of another database comprises all or

      • Database substantially all the addresses in the United Kingdom or any of England, Wales, Scotland or Northern Ireland

      • Term the period during which this Licence is in force according to its terms

      • User an individual authorised by an End User to use a Solution

      • Website a website, application or other remotely-enabled means of communicating with end user customers for products and services, made generally available to such customers

      Website Use the use of PAFⓇ Data to capture or verify address details of users of an End User’s Website where:

      • (a) Website users are not the End User’s employees or concerned with the provision of services to the End User (unless acting in a personal capacity), and

      • (b) neither the use of the Website or the End User’s product and service offering is connected with the management of address data or Data Cleansing, and

      • (c) the address capture or verification is carried out for the purpose of the receipt of products or services enabled by the Website

      Working Day Monday to Friday excluding bank and public holidays in England, and Wales

      1.2 In this Licence (unless the context otherwise requires) words following words such as “includes”, “including” and “in particular” are read without limitation, and references to a person are to any natural or legal person whether incorporated or not.

    2. End Users’ permitted use of Solutions

      End Users may freely use PAFⓇ Data in Solutions in accordance with these End User Terms.

    3. Conditions of use

      • (a) End Users must not make copies of PAFⓇ Data except as permitted by these End User Terms or reasonably necessary for back-up, security, business continuity and system testing purposes.

      • (b) End Users may use PAFⓇ Data for Data Extraction but Extracted Data:

        • (i) may only be accessed by Users, and

        • (ii) must not be supplied or any access to it provided to any third party.

      • (c) End Users may provide Cleansed data to third parties provided that:

        • (i) where that supply is a Bureau Service, the End User and the Bureau Customers comply with the restrictions in Schedule 4, and

        • (ii) if such databases are Substantially All Databases:

          • (A) such databases are not represented or held out as a master, original or comprehensive address database or other similar description,

          • (B) the access is provided in the course of the End User’s normal data supply or routine business activities and is not carried on as a business in its own right, and

          • (C) the provision includes a prominent notice that the relevant Cleansed data has been cleansed against PAFⓇ Data.

      • (d) End Users must not permit access to, display or communicate to the public any Solutions, except for the purposes of capturing or confirming address details of third parties.

      • (e) Except as set out in these End User Terms, End Users must not:

        • (i) transfer, assign, sell or licence Solutions or their use to any other person,

        • (ii) use Solutions to create a product or service distributed or sold to any third party which relies on any use of PAFⓇ Data, including copying, looking up or enquiring, publishing, searching, analysing, modifying and reformatting, or

        • (iii) copy, reproduce, extract, reutilise or publish Solutions or any of them.

    4. Subcontracting

      End Users may provide PAFⓇ Data to their subcontractors who may use it to the extent necessary for:

      • (a) the provision of information technology services to the End User, or

      • (b) acting on behalf of the End User

      in each case for the End User’s own business purposes and not those of the sub-contractor and provided that each such sub-contractor agrees to observe the restrictions on use of PAFⓇ Data contained in these End User Terms and that the End User is responsible for any breaches of those terms by such sub-contractor.

    5. Personal rights

      End User rights are personal, limited and non-transferable.

    6. Royal Mail’s IPR notice

    The End User acknowledges that Royal Mail is the owner of the intellectual property rights in PAFⓇ Data and the PAFⓇ brand and it does not acquire and is not granted any rights to use those intellectual property rights other than as set out in these End User Terms.

    1. Cessation of use of PAFⓇ Data

      End Users must cease use of PAFⓇ Data if their right to use PAFⓇ Data is terminated and also destroy any copies of PAFⓇ Data they hold.

    2. PAFⓇ use by Users

      End Users must ensure that:

      • (a) these End User Terms bind their Users,

      • (b) only their Users exercise the use rights of Solutions and PAFⓇ Data granted to End Users further to these End User Terms, and

      • (c) in the event of termination or expiry of End Users’ rights to use Solutions and PAFⓇ Data, the rights of Users to use them also terminate.