Support DESK

Follow

A1.2 - UK Addressing Optional Output Fields

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

 

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.