Loading...

address

Attribute NameData TypeDescription
IDstringThe unique identifier of the address in CDP.
TenantIDintThe unique identifier of the client in CDP. For example, the tenant ID for the Demo tenant is 465 in the US-Prod environment.
SourceSystemIDstringThe unique identifier of the upstream source system in CDP.
SourceAddressNumberstringThe unique ID for the address.
Address1stringThe first line of the address. Typically, this includes the street name and street number.
Address2stringThe second line of the address. Typically, this includes unit, suite, and apartment number.
CitystringThe city in which the address is located.
ZipstringThe zip code for the address. You can use the ZIP+4 format.
ZipExtstringThe 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.
StatestringThe state or province where the address is located.
CountrystringThe country where the address is located.
CountryCodestringThe standard ISO Alpha-2 code for the country where the address is located. For example, for the United States, the value is US.
CertifiedstringSpecifies whether the winning mailing address is a USPS-certified address or not.
DpvConfirmstringThe 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.
DeliveryPointCodestringThe postnet barcode that includes a ZIP+4 barcode and two digits or 10 additional bars. This value indicates a specific delivery point.
DateCertifiedstringThe date when the address is certified to be accurate and is returned by Melissa Data.
SuitestringThe apartment, suite, or room number of the winning address.
CarrierRoutestringA 4-character code indicating the type of delivery for the address. It is returned by Melissa address validation.
CMRAstringCommercial 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.
DeliveryPointCheckDigitstringThe 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.
ErrorCodestringThe Melissa result code system to indicate data quality when validating addresses. However, it is not used in CDP.
ErrorstringstringThe 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.
LACSstringLocatable Address Conversion System (LACS) converts non-specific rural addresses to street addresses. This system helps emergency services to identify address locations quickly and accurately.
RBDIstring

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
AddressTypestringThe type of address. For example, primary residence, work.
LatitudestringThe measurement of distance north or south of the equator.
LongitudestringThe measurement of distance east or west of the prime meridian.
NCOADateModifiedstringThis is populated by the NCOA process, if available.
NCOADateUpdatestringThe date when the record last went through National Change of Address (NCOA) processing. This is internal and set by Acquia.
MoveTypestring

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
MoveDatestringThe 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.
MatchFlagstring

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

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
RowCreatedtimestampThe time when the address was first ingested in CDP.
RowModifiedtimestampThe time when the address was last modified in CDP.
BatchstringThe time when the address was last modified in CDP. This is used for bucketing the ingestion of records in CDP.
NamestringThe name of the address. For example, San Diego home.
TypestringThe type of address. For example, primary residence, work.
SourcestringThe last file origin that modified the address record.
RowProcessedtimestampThe time when the address was last processed by CDP.

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Back to Section navigation
Back to Site navigation