• FixTownCounty - set to True to always keep the town and county in the last two address lines, or False to use the first available columns.
• AddressLines - set to a number between 2 and 10 to indicate the number of lines to split the address over, not including the postcode.
• KeepNonLeadingData - set to True to retain any customer-supplied cherished address details that are not recognised by Royal Mail, or False to use only the official address.
• IncludeDPS - set to True to include a column containing the delivery point suffix (DPS) required for generating barcodes, or False to ignore it.
• IncludeParsedAddress - set to True to include additional columns containing each element of the address in a separate column, or False to use include only the formatted address.
• NoOrganisation - set to True remove the organisation from the formatted address - org is still available in Raw address.

• PAF.AddressLinexx - contains the xx^th line of the address, where xx is a zero-padded two digit number from 1 to the value in the AddressLines option.
• PAF.Postcode - contains the postcode.
• PAF.CMBDPS - contains the DPS code.
• PAF.CMBDepartment - contains the department name part of the address.
• PAF.CMBOrganisation - contains the organisation name part of the address.
• PAF.CMBSubBuilding - contains the sub-building name part of the address.
• PAF.CMBBuildingName - contains the building name part of the address.
• PAF.CMBBuildingNo - contains the building number part of the address.
• PAF.CMBPOBox - contains the PO Box number part of the address.
• PAF.CMBDependantThorofare - contains the dependent thoroughfare part of the address.
• PAF.CMBThorofare - contains the thoughfare part of the address.
• PAF.CMBDoubleDependantLocality - contains the double-dependent locality part of the address.
• PAF.CMBDependantLocality - contains the dependent locality part of the address.
• PAF.CMBLocality - contains the locality part of the address.
• PAF.CMBCounty - contains the county part of the address.
• PAF.MatchType - contains "OK_Unchanged" if the address has not been corrected by address cleansing, "OK_Corrected" if the address has been cleansed, "NOK_Building" if the address is valid up to building level but does not uniquely identify a known delivery point, "NOK_Street" if the address is valid only up to thoroughfare level, "NOK_Town" if the address is valid only up to locality level, "NOK_NoMatch" if the address could not be validated against PAF, or "NOK_Foreign" if the address appears to be foreign.

NOTE: the PAF.CMBDPS column is only added if the IncludeDPS option is set to True.

NOTE: the remaining PAF.CMBxxx columns are only added if the IncludeParsedAddress option is set to True.

• BCF.Reactiv8Legend - this column is set to "BCF" if the record has been updated with a new address, or blank otherwise.
• BCF.NewAdd1 - address line 1. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• BCF.NewAdd2 - address line 2. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• BCF.NewAdd3 - address line 3. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• BCF.NewAdd4 - address line 4. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• BCF.NewAdd5 - address line 5. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• BCF.NewAdd6 - address line 6. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• BCF.NewPC - postcode. If the record has been moved, this will be the new address. Otherwise, it will be the original address.

NOTE: if the AddressCleanse service is also selected, the BCF.New... columns will not be added. Instead, the new address will be cleansed and provided in the columns added by the AddressCleanse service itself.

• SuppressionType - set to Flag to add a column with a flag to indicate matching records, or Suppress to remove matching records entirely.

• BGA.GoneAwayLegend - this column is set to "BGA" if the record has been identified as a goneaway.
• BGA.GoneAwayData - this column is set to "OB" if the organisation is out of business, "RL" if it has relocated, "RN" if it has been renamed, "SR" if it is a SOHO that has relocated, "UM" if it is an unmarketable address, "IM" if it is an individual within the organisation that has moved, or "ID" if it is an individual that is deceased.

NOTE: if the SuppressionType option is set to Suppress, no columns are added and any matching records are simply removed from the output file.

NOTE: if the BCF service is also selected, the output columns are named BGA.GoneAwayWithMoversLegend and BGA.GoneAwayWithMoversData respectively. Only records that have not been matched by the BCF service will be flagged by this service.

• BP.CLS - code for the category the organisation has been classified as
• BP.ClassificationDescription - human-readable description of the category the organisation has been classified as
• BP.UKSIC2007 - UK SIC (2007) classification code
• BP.UKSIC2007Description - human-readable description of the UK SIC (2007) classification

• BP.ContactTitle - title of the key contact at the company
• BP.ContactFirstName - first name of the key contact at the company
• BP.ContactLastName - last name of the key contact at the company
• BP.ContactResponsibility - responsibility of the key contact at the company
• BP.TitleOfExecutive - title used for executive officers of the company

• BP.SiteEmployeeRange - number of employees at the site
• BP.CompanyEmployeeRange - number of employees across the company
• BP.TurnoverBand - company turnover

• TPSType - set to TPS to screen new numbers against the TPS file, CTPS to screen against the CTPS file, or Both to screen against both
• SuppressionType - set to Flag to add a column for each new telephone number to indicate its CTPS status, or SuppressField to hide any CTPS numbers

• NBTN.NewTPS1 - this column is set to "CTPS" if the first newly appended telephone number is on the CTPS, or "TPS" if it is on the TPS.
• NBTN.NewTPS2 - this column is set to "CTPS" if the second newly appended telephone number is on the CTPS, or "TPS" if it is on the TPS.
• NBTN.NewTPS3 - this column is set to "CTPS" if the third newly appended telephone number is on the CTPS, or "TPS" if it is on the TPS.

NOTE: if the SuppressionType option is set to SuppressField, no columns are added and any CTPS or TPS numbers are removed from the output data.

• FormatTelNo - set to True to provide the telephone number formatted with spaces, or False to remove all spaces.

The following columns are added once and used by the DebtSearch, TelNoAppendLifestyle Landline, TelNoAppendLifestyle Mobile and TelNoAppendOSIS services. If more than one of these services are selected, the NTN.NewDisplaySourcex columns are included and indicate which of these services was the source for the associated number. If only one of these services is selected, the NTN.NewDisplaySourcex columns are not included.

• NTN.NewPhoneNumberx - contains the x^th newly appended telephone number.
• NTN.NewXDx - if ex-directory telephone numbers have been selected from the TelNoAppendOSIS service, contains XD if the telephone number is ex-directory, or blank otherwise. If this option is not selected, this column is not added.
• NTN.NewTPSx - if the TPS service is selected, contains "TPS" if the telephone number is on TPS, "CTPS" if it is on CTPS, or blank otherwise. If the TPS service is not selected, this column is not added.
• NTN.NewCollectionDatex - if the DebtSearch, TelNoAppendLifestyle Landline or TelNoAppendLifestyle Mobile services are selected, contains the date on which the telephone number was obtained. Any telephone numbers obtained from the TelNoAppendOSIS service will be shown as being collected on today's date. If only the TelNoAppendOSIS service is selected, this column is not added.
• NTN.NewDisplaySourcex - if more than one telephone number appending service is selected, contains a description of the service from which this telephone number was sourced. Otherwise, this column is not added.

The columns listed above will be added up to three times, with x being replaced by a number from 1 to 3.

• MatchLevel - set to Forename to require full forename level matches, Initial to require initial level matches, or Surname to require only surname level matches.
• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

The following columns are added only if the SuppressionType option is set to Flag.

• DE.DeceasedLegend - contains "Deceased" if the record is identified as being deceased, or blank otherwise.

• MatchLevel - set to Forename to require full forename level matches, Intial to require initial level matches, Surname to require surname level matches, or Premise to require only premise level matches.
• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

The following columns are added only if the SuppressionType option is set to Flag.

• DD.OriginalData8ID - contains a unique identifier for the record
• DD.MatchLevelDuplicateLegend - contains "DUP" if the record is a duplicate of another record, or blank if it is unique.
• DD.MatchLevelDuplicateIDs - contains a semi-colon delimited list of the unique identifiers for the other records with which this record is duplicated.
• DD.KeepRecordAtMatchLevel - contains 1 if the record should be kept (is unique or is the first of a set of duplicates), or 0 if it should be discarded (it is duplicated with an earlier record in the file).

• ValidationType - set to Syntax to perform basic email address syntax checking, or MX to perform more detailed checking.

• EV.EmailxLegend - contains "VALID" if the x^th email address is valid, or "INVALID" if not. Blank email addresses are shown as valid.

• MatchLevel - set to Forename to require full forename level matches, Initial to require initial level matches, or Surname to require only surname level matches.
• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

The following columns are added only if the SuppressionType option is set to Flag.

• GA.GoneAwayLegend - contains "GA" if the record is identified as being goneaway, or blank otherwise.

NOTE: if the NCOA service is also included, the added column is called GA.GoneAwayWithMoversLegend instead.

• MatchLevel - set to Forename to require full forename level matches, Initial to require initial level matches, or Surname to require only surname level matches.
• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

The following columns are added only if the SuppressionType option is set to Flag.

• DE.DeceasedLegend - contains "Deceased" if the record is identified as being deceased, or blank otherwise.

• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

The following columns are added only if the SuppressionType option is set to Flag.

• MPS.MPSLegend - contains "MPS" if the record is identified as being on the MPS, or blank otherwise.

• NA.NamesMatched - contains the number of additional names added to the record.
• NA.FullResults - a pipe (|) delimited string of all the residents at this address. Each person is listed as Forename|Middle|Surname|Title. This structure will be repeated as many times as there are people.

• NP.Title - contains the title part of the name.
• NP.Forename - contains the first name.
• NP.MiddleName - contains the middle name(s).
• NP.Surname - contains the surname.
• NP.NameSuffix - contains any suffix information.

NOTE: the MatchLevel option cannot be changed. Use the MoversProcessing field of the Workflow definition to change how movers should be processed before submitting the job.

• MatchLevel - set to Forename to require full forename level matches, Initial to require initial level matches, or Surname to require only surname level matches.

• NCOA.Reactiv8Legend - this column is set to "NCOA" if the record has been updated with a new address, or blank otherwise.
• NCOA.NewAdd1 - address line 1. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• NCOA.NewAdd2 - address line 2. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• NCOA.NewAdd3 - address line 3. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• NCOA.NewAdd4 - address line 4. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• NCOA.NewAdd5 - address line 5. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• NCOA.NewAdd6 - address line 6. If the record has been moved, this will be the new address. Otherwise, it will be the original address.
• NCOA.NewPC - postcode. If the record has been moved, this will be the new address. Otherwise, it will be the original address.

NOTE: if the AddressCleanse service is also selected, the NCOA.New... columns will not be added. Instead, the new address will be cleansed and provided in the columns added by the AddressCleanse service itself.

NOTE: the MatchLevel option cannot be changed. Use the MoversProcessing field of the Workflow definition to change how movers should be processed before submitting the job.

• MatchLevel - set to Forename to require full forename level matches, Initial to require initial level matches, or Surname to require only surname level matches.

This service cannot be selected and will not produce any output when processed in an automated job. Due to restrictions on the data source, purchasing this data requires manual intervention from Data8. If you have submitted a job for processing via Foundation Technology and wish to purchase the reConnect data, you will need to call us once the job has been processed. After we have performed the manual process, this service will then be selectable. The new addresses provided by this service will be included in the same output columns added by the NCOA service - those records that have been updated by reConnect can be identified by the NCOA.Reactiv8Legend column being set to "reConnect" rather than "NCOA".

• MatchLevel - set to Forename to require full forename level matches, Initial to require initial level matches, or Surname to require only surname level matches.

• NA.ERValidatedMatchLevelLegend - set to "RV" if the record has been verified at the selected MatchLevel, or blank otherwise.

• BlankNames - set to True to flag records as unusable if they does not contain sufficient name information, or False to ignore these errors.
• UndeliverableAddresses - set to True to flag records as unusable if they do not contain sufficient address information to allow mail to be delivered, or False to ignore these errors.
• Salacious - set to True to flag records as unusable if they contain recognised salacious words in the name or address, or False to ignore these errors.
• Random - set to True to flag records as unusable if they appear to be entered with random keystrokes, or False to ignore these errors.
• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

The following columns are added only if the SuppressionType option is set to Flag.

• SN.Legend - contains "IncompleteName" if BlankNames is True and the record contains a blank forename or surname, "UndeliverableAddress" if UndeliverableAddresses is True and the record does not contain sufficient address information, "ProbablyUndeliverableAddress" if UndeliverableAddresses is True and the record does not contain sufficiently correct address information, "RandomName" if Random is True and the name appears to have been entered with random keystrokes, "RandomAddress" if Random is True and the address appears to have been entered with random keystrokes, "SalaciousName" if Salacious is True and the name contains salacious words, "SalaciousAddress" is Salacious is True and the address contains salacious words.

• MatchLevel - set to Forename to require full forename level matches, Intial to require initial level matches, Surname to require surname level matches, or Premise to require only premise level matches.
• SuppressionType - set to Flag to add a new column containing a flag to indicate if a record has been matched, or Suppress to remove any matched records entirely.

• SFStopFileName.MatchLevelMatchLegend - contains "StopFileName" if the record matched against the stop file, or blank otherwise.
• SFStopFileName.MatchLevelMatchedIDs - contains a semi-colon separated list of the identifiers of the records in the stop file the record matched against.
• SFStopFileName.MatchLevelColumnName - contains a semi-colon separated list of the values from the custom column ColumnName in the stop file.

NOTE: stop files can contain any number of custom columns, so this service can produce a variable number of output columns.

NOTE: matching can be performed against any number of stop files, so this service may appear multiple times with a different stop file name.

• FormatTelNo - set to True to provide the telephone number formatted with spaces, or False to remove all spaces.

The following columns are added once and used by the DebtSearch, TelNoAppendLifestyle Landline, TelNoAppendLifestyle Mobile and TelNoAppendOSIS services. If more than one of these services are selected, the NTN.NewDisplaySourcex columns are included and indicate which of these services was the source for the associated number. If only one of these services is selected, the NTN.NewDisplaySourcex columns are not included.

• NTN.NewPhoneNumberx - contains the x^th newly appended telephone number.
• NTN.NewXDx - if ex-directory telephone numbers have been selected from the TelNoAppendOSIS service, contains XD if the telephone number is ex-directory, or blank otherwise. If this option is not selected, this column is not added.
• NTN.NewTPSx - if the TPS service is selected, contains "TPS" if the telephone number is on TPS, "CTPS" if it is on CTPS, or blank otherwise. If the TPS service is not selected, this column is not added.
• NTN.NewCollectionDatex - if the DebtSearch, TelNoAppendLifestyle Landline or TelNoAppendLifestyle Mobile services are selected, contains the date on which the telephone number was obtained. Any telephone numbers obtained from the TelNoAppendOSIS service will be shown as being collected on today's date. If only the TelNoAppendOSIS service is selected, this column is not added.
• NTN.NewDisplaySourcex - if more than one telephone number appending service is selected, contains a description of the service from which this telephone number was sourced. Otherwise, this column is not added.

The columns listed above will be added up to three times, with x being replaced by a number from 1 to 3.

• FormatTelNo - set to True to provide the telephone number formatted with spaces, or False to remove all spaces.

The following columns are added once and used by the DebtSearch, TelNoAppendLifestyle Landline, TelNoAppendLifestyle Mobile and TelNoAppendOSIS services. If more than one of these services are selected, the NTN.NewDisplaySourcex columns are included and indicate which of these services was the source for the associated number. If only one of these services is selected, the NTN.NewDisplaySourcex columns are not included.

• NTN.NewPhoneNumberx - contains the x^th newly appended telephone number.
• NTN.NewXDx - if ex-directory telephone numbers have been selected from the TelNoAppendOSIS service, contains XD if the telephone number is ex-directory, or blank otherwise. If this option is not selected, this column is not added.
• NTN.NewTPSx - if the TPS service is selected, contains "TPS" if the telephone number is on TPS, "CTPS" if it is on CTPS, or blank otherwise. If the TPS service is not selected, this column is not added.
• NTN.NewCollectionDatex - if the DebtSearch, TelNoAppendLifestyle Landline or TelNoAppendLifestyle Mobile services are selected, contains the date on which the telephone number was obtained. Any telephone numbers obtained from the TelNoAppendOSIS service will be shown as being collected on today's date. If only the TelNoAppendOSIS service is selected, this column is not added.
• NTN.NewDisplaySourcex - if more than one telephone number appending service is selected, contains a description of the service from which this telephone number was sourced. Otherwise, this column is not added.

The columns listed above will be added up to three times, with x being replaced by a number from 1 to 3.

• MatchLevel - set to DE to retrieve only telephone numbers available from the telephone directory, or XD to retrieve ex-directory flags and DQR restricted telephone numbers.
• FormatTelNo - set to True to provide the telephone number formatted with spaces, or False to remove all spaces.

The following columns are added once and used by the DebtSearch, TelNoAppendLifestyle Landline, TelNoAppendLifestyle Mobile and TelNoAppendOSIS services. If more than one of these services are selected, the NTN.NewDisplaySourcex columns are included and indicate which of these services was the source for the associated number. If only one of these services is selected, the NTN.NewDisplaySourcex columns are not included.

• NTN.NewPhoneNumberx - contains the x^th newly appended telephone number.
• NTN.NewXDx - if ex-directory telephone numbers have been selected from the TelNoAppendOSIS service, contains XD if the telephone number is ex-directory, or blank otherwise. If this option is not selected, this column is not added.
• NTN.NewTPSx - if the TPS service is selected, contains "TPS" if the telephone number is on TPS, "CTPS" if it is on CTPS, or blank otherwise. If the TPS service is not selected, this column is not added.
• NTN.NewCollectionDatex - if the DebtSearch, TelNoAppendLifestyle Landline or TelNoAppendLifestyle Mobile services are selected, contains the date on which the telephone number was obtained. Any telephone numbers obtained from the TelNoAppendOSIS service will be shown as being collected on today's date. If only the TelNoAppendOSIS service is selected, this column is not added.
• NTN.NewDisplaySourcex - if more than one telephone number appending service is selected, contains a description of the service from which this telephone number was sourced. Otherwise, this column is not added.

The columns listed above will be added up to three times, with x being replaced by a number from 1 to 3.

• MatchLevel - set to DE to retrieve only telephone numbers available from the telephone directory, or XD to retrieve ex-directory flags and DQR restricted telephone numbers.
• FormatTelNo - set to True to provide the telephone number formatted with spaces, or False to remove all spaces.
• IncludeFaxNumbers - set to True to output fax numbers as well as telephone numbers, or False to output only telephone numbers.

• NBTN.NewPhoneNumberx - contains the x^th newly appended telephone number.
• NBTN.NewXDx - if ex-directory telephone numbers have been selected, contains XD if the telephone number is ex-directory, or blank otherwise. If this option is not selected, this column is not added.
• NBTN.NewTPSx - if the CTPS service is selected, contains "CTPS" if the telephone number is on CTPS, "TPS" if it is on TPS, or blank otherwise. If the CTPS service is not selected, this column is not added.
• NFN.NewPhoneNumberx - contains the x^th newly appended fax number.
• NFN.NewXDx - if ex-directory telephone numbers have been selected, contains XD if the fax number is ex-directory, or blank otherwise. If this option is not selected, this column is not added.

The columns listed above will be added up to three times, with x being replaced by a number from 1 to 3.

NOTE: the NFN.... columns will only be added if the IncludeFaxNumbers option is set to True.

• NTN.CompareFlagx - indicates the status of the x^th existing telephone number. "Conf" if the number is confirmed by the new numbers, "Alt" if a different new number is found, "New" if the original number is blank but a new number is found, "XD" if the new number is ex-directory so the existing number cannot be confirmed, "Unco" if there were no new numbers to confirm against, or "NoMa" if the existing and new numbers are blank.

These fields are repeated for each of the supplied telephone numbers, with x being a number from 1 to the number of supplied telephone numbers.

• TV.TelNoxLegend - indicates the status of the x^th existing telephone number. "VALID" if it is valid or blank, or "INVALID" if it is invalid.

These fields are repeated for each of the supplied telephone numbers, with x being a number from 1 to the number of supplied telephone numbers.

• TPSType - set to TPS to screen new numbers against the TPS file, CTPS to screen against the CTPS file, or Both to screen against both
• SuppressionType - set to Flag to add a column for each new telephone number to indicate its TPS status, or SuppressField to hide any TPS numbers

• NTN.NewTPS1 - this column is set to "TPS" if the first newly appended telephone number is on the TPS, or "CTPS" if it is on the CTPS.
• NTN.NewTPS2 - this column is set to "TPS" if the second newly appended telephone number is on the TPS, or "CTPS" if it is on the CTPS.
• NTN.NewTPS3 - this column is set to "TPS" if the third newly appended telephone number is on the TPS, or "CTPS" if it is on the CTPS.

NOTE: if the SuppressionType option is set to SuppressField, no columns are added and any TPS numbers are removed from the output data.

• TPSType - set to TPS to screen new numbers against the TPS file, CTPS to screen against the CTPS file, or Both to screen against both
• SuppressionType - set to Flag to add a column for each new telephone number to indicate its TPS status, or SuppressField to hide any TPS numbers

The following columns are added if the SuppressionType option is set to Flag.

• NTN.ExistingTPS1 - this column is set to "TPS" if the first existing telephone number is on the TPS.
• NTN.ExistingTPS2 - this column is set to "TPS" if the second existing telephone number is on the TPS.
• NTN.ExistingTPS3 - this column is set to "TPS" if the third existing telephone number is on the TPS.
• NBTN.ExistingTPS1 - this column is set to "CTPS" if the first existing telephone number is on the CTPS.
• NBTN.ExistingTPS2 - this column is set to "CTPS" if the second existing telephone number is on the CTPS.
• NBTN.ExistingTPS3 - this column is set to "CTPS" if the third existing telephone number is on the CTPS.

The following columns are added if the SuppressionType option is set to SuppressField,

• NTN.ExistingPhoneNumber1 - this column is set to the first existing telephone number, or blank if it is on the TPS.
• NTN.ExistingPhoneNumber2 - this column is set to the second existing telephone number, or blank if it is on the TPS.
• NTN.ExistingPhoneNumber3 - this column is set to the third existing telephone number, or blank if it is on the TPS.
• NBTN.ExistingPhoneNumber1 - this column is set to the first existing telephone number, or blank if it is on the CTPS.
• NBTN.ExistingPhoneNumber2 - this column is set to the second existing telephone number, or blank if it is on the CTPS.
• NBTN.ExistingPhoneNumber3 - this column is set to the third existing telephone number, or blank if it is on the CTPS.