| 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:
|
| 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:
|
| 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:
|
| DeleteFlag | boolean | The flag that indicates if an address is deleted. The possible values are:
|
| 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. |