Interactive Queries

address

Attribute Name

Data Type

Description

ID

string

The unique identifier of the address in CDP.

TenantID

int

The unique identifier of the client in CDP. For example, the tenant ID for the Demo tenant is 465 in the US-Prod environment.

SourceSystemID

string

The unique identifier of the upstream source system in CDP.

SourceAddressNumber

string

The unique ID for the address.

Address1

string

The first line of the address. Typically, this includes the street name and street number.

Address2

string

The second line of the address. Typically, this includes unit, suite, and apartment number.

City

string

The city in which the address is located.

Zip

string

The zip code for the address. You can use the ZIP+4 format.

ZipExt

string

The zip extension of your customer’s winning address. The default value is Unknown. By default, CDP promotes addresses that are DPV, certified, recent, opted-in to receive mail, and complete.

State

string

The state or province where the address is located.

Country

string

The country where the address is located.

CountryCode

string

The standard ISO Alpha-2 code for the country where the address is located. For example, for the United States, the value is US.

Certified

string

Specifies whether the winning mailing address is a USPS-certified address or not.

DpvConfirm

string

The DPV confirmation results that CDP receives from USPS for US addresses. Y indicates that the address is DPV confirmed, and N indicates that the address is not certified by the USPS.

DeliveryPointCode

string

The postnet barcode that includes a ZIP+4 barcode and two digits or 10 additional bars. This value indicates a specific delivery point.

DateCertified

string

The date when the address is certified to be accurate and is returned by Melissa Data.

Suite

string

The apartment, suite, or room number of the winning address.

CarrierRoute

string

A 4-character code indicating the type of delivery for the address. It is returned by Melissa address validation.

CMRA

string

Commercial Mail Receiving Agency (CMRA) is a private business that accepts mail from the Postal Service for recipients, keeps it for collection, or re-mails to another location with newly paid postage.

DeliveryPointCheckDigit

string

The output port that validates the ZIP+4 code and Delivery Point Code (DPC) information in a United States address. While validating addresses, a delivery point checks digit for all addresses with valid ZIP+4 code and DPC information.

ErrorCode

string

The Melissa result code system to indicate data quality when validating addresses. However, it is not used in CDP.

Errorstring

string

The Melissa result code system to indicate data quality when validating addresses. This also indicates status and any errors. These codes are four-character codes, where two letters are followed by two numbers, and are delimited by commas.

LACS

string

Locatable Address Conversion System (LACS) converts non-specific rural addresses to street addresses. This system helps emergency services to identify address locations quickly and accurately.

RBDI

string

This indicates whether the address is a business or residential address for the United States only. The possible values are:

  • R: Residential Address

  • B: Business Address

  • U: No address or address unknown by the USPS

AddressType

string

The type of address. For example, primary residence, work.

Latitude

string

The measurement of distance north or south of the equator.

Longitude

string

The measurement of distance east or west of the prime meridian.

NCOADateModified

string

This is populated by the NCOA process, if available.

NCOADateUpdate

string

The date when the record last went through National Change of Address (NCOA) processing. This is internal and set by Acquia.

MoveType

string

The type of move that is registered in the USPS NCOA database. The possible values are:

  • I for individual match

  • F for family match

  • B for business name match

MoveDate

string

The date when the move was registered with USPS in the NCOA database. The format of this value is YYYYMM. For example, 201905 was registered in January, 2014. Note that the actual move might happen earlier or later and the NCOA database cannot provide that information.

MatchFlag

string

The match flag that was returned by NCOA processing. The possible values are:

  • M for moved

  • G for PO box closed

  • K for moved or left without any forwarding address

  • F for moved to a foreign country.

DeleteFlag

boolean

The flag that indicates if an address is deleted. The possible values are:

  • True when an address is deleted

  • False or null when an address is not deleted

RowCreated

timestamp

The time when the address was first ingested in CDP.

RowModified

timestamp

The time when the address was last modified in CDP.

Batch

string

The time when the address was last modified in CDP. This is used for bucketing the ingestion of records in CDP.

Name

string

The name of the address. For example, San Diego home.

Type

string

The type of address. For example, primary residence, work.

Source

string

The last file origin that modified the address record.

RowProcessed

timestamp

The time when the address was last processed by CDP.