| Previous Article | Addresing section | Next Article |
The following sets of fields are made available via separately licensed optional datasets. In order to output these you would set the fields listed below in the output column of the addressing SSIS task (click here for further details) or in the configuration file if using Stored Procedures (click here for further details)
The Royal Mail UDPRN database provides a Unique Delivery Point Reference Number for each address that does not change during the lifetime of the premises. This contains the following fields:
|
Name |
Description |
|
UDPRN |
Unique Delivery Point Reference Number |
The Royal Mail Multiple Residence database provides details of addresses that share a communal front door – typically flats. In these cases, the standard PAF database contains only one address representing the communal front door, the “owning address”. The Multiple Residence database has the standard address fields for each of the flats behind the communal front door plus these additional fields:
|
Name |
Description |
|
UMRRN |
Unique Multiple Residence Reference Number |
|
OwningUDPRN |
UDPRN of owning DP |
|
OwningAKOK |
Address and Organisation Key of owning DP |
The Royal Mail Not Yet Built database contains addresses where planning permission has been granted but the premise is not yet built. N.B. these are not plot number addresses. At the time that planning permission is granted, the local authority assigns an official address and Royal Mail assigns a postcode. As soon as the premise is able to receive mail the address is moved from the Not Yet Built database to standard PAF. The Not Yet Built database has the standard address fields plus these additional fields:
|
Name |
Description |
|
NOTYETBUILT |
Not Yet Built flag – ‘Y’ for all Not Yet Built addresses |
|
NYB_UDPRN |
Unique Delivery Point Reference Number |
The Dun & Bradstreet Business Database consists of over 3.4 million actively trading organizations, ranging from small businesses and shops through to blue-chip corporations. In addition to the standard address fields, the D&B Business data has the following fields:
|
Name |
Description |
|
DUNS |
D-U-N-S Number |
|
TEL |
Telephone number |
|
FAX |
Fax number |
|
SIC03 |
UK 2003 SIC code |
|
SIC72 |
US ’72 SIC code |
|
NUMEMP |
Number of employees at site |
|
NUMEMPCO |
Number of employees at company |
|
HOF |
Head office flag |
|
TO |
Turnover |
|
YEARSTAR |
Year started |
The Dun & Bradstreet Business Contact Details Database provides the following contact details:
|
Names |
Description |
|
ExecutiveCount |
Count of named executives |
|
Ex1_Function … Ex8_Function |
Executive function |
|
Ex1_FirstName … Ex8_FirstName |
Executive first name |
|
Ex1_Surname … Ex8_Surname |
Executive surname |
|
Ex1_Salutation … Ex8_Salutation |
Executive salutation |
|
Ex1_Sex … Ex8_Sex |
Executive gender |
|
FinFunction, FinFirstName, FinSurname, FinSalutation, FinSex |
Contact details for finance responsibility |
|
HRFunction, HRFirstName, HRSurname, HRSalutation, HRSex |
Contact details for HR responsibility |
|
ITFunction, ITFirstName, ITSurname, ITSalutation, ITSex |
Contact details for IT responsibility |
|
MktingFunction, MktingFirstName, MktingSurname, MktingSalutation, MktingSex |
Contact details for marketing responsibility |
|
NworkFunction, NworkFirstName, NworkSurname, NworkSalutation, NworkSex |
Contact details for networks responsibility |
|
PurchFunction, PurchFirstName, PurchSurname, PurchSalutation, PurchSex |
Contact details for purchasing responsibility |
|
SalesFunction, SalesFirstName, SalesSurname, SalesSalutation, SalesSex |
Contact details for sales responsibility |
|
DecsFunction, DecsFirstName, DecsSurname, DecsSalutation, DecsSex |
Contact details for decisions responsibility |
|
CommsFunction, CommsFirstName, CommsSurname, CommsSalutation, CommsSex |
Contact details for tech comms responsibility |
The consumer names database provides details of householders at an address. With process type NameCorrection, the following additional input field types can be used.
|
Names |
Description |
|
FullName |
Person name |
|
Prefix |
Prefix/title |
|
LastName |
Person surname |
|
FirstNames |
Person forename |
|
MiddleNames |
Person middle name |
|
Gender |
Gender flag |
|
DateOfBirth |
Person date of birth |
|
OnEditedER |
The On Edited ER flag field is a ‘Y’ or ‘N’ flag indicating if the person is on the edited Electoral Roll. |
| Previous Article | Addresing section | Next Article |