Formatted addresses
Formatted addresses contain the summarized address data for HCPs and HCOs. This field, formatted_address__v, is used across the Network UI; for example, on the profile page, inbox, Network Explorer, and search results.
When an address is added or updated (through a DCR, using the profile page, or through a source subscription), the address is cleansed and then the formatted address field value is calculated.
For all countries, except Japan, formatted addresses are calculated using the following fields in this order:
address_line_1 + address_line_2 + locality + administrative_area + postal_code
Japan's formatted address is calculated using the following fields in this order:
postal_code + administrative_area + locality + address_line_1 + address_line_2 + address_line_3
Calculating formatted addresses
Formatted address can be calculated by one of the following sources:
- Network
- Network's third party address cleansing tool
- Source data
Review the following diagram to understand how the formatted address is calculated.
Note: For US addresses, Network and the third party cleansing tool uses the administrative area reference code (for example, PA (Pennsylvania)) to calculate formatted addresses.
Format
Network's third party cleansing service calculates formatted addresses using address lines 1, 2, and 3 (if available). To ensure that most formatted addresses are consistent, Network also calculates formatted address using both address line 1 and 2. This format applies whether the address lines construction feature is enabled or not.
If the third party cleansing service is unable to calculate formatted address and the formatted address is supplied from source data, the address displays exactly as it was supplied.
Address lines construction
When the address lines construction feature is enabled, formatted addresses are calculated by Network after the address is cleansed when the following conditions are met:
- The address verification status is Verified, Partially Verified, or Ambiguous.
- Street number, name, and/or building are populated.
Review the following diagram to understand how formatted address is calculated.
Process
After addresses are cleansed, Network calculates the formatted address. Review the steps below to understand how the final formatted address is created when the address lines construction feature is enabled.
- An address update is submitted from a source or a data change request.
- Network's third party address cleansing service cleanses the address and provides a formatted address based on the cleansed address lines where:
- Address line 1 = building and/or organization
- Address line 2 = premise, thoroughfare, subbuilding
Example formatted address: Empire State Bldg 350 5th Ave
- The address lines construction feature is applied. The feature recalculates the address to move premise, thoroughfare and subbuilding into address line 1 and building into address line 2.
- Network calculates the final formatted addresses where:
- Address line 1 = premise, thoroughfare, subbuilding
- Address line 2 = building
Example formatted address: 350 5th Ave Empire State Bldg
Examples
Review the examples to understand how the formatted address is calculated by Network after a source file is added and the address lines construction feature runs.
The following conditions are true:
- Third party cleansing tool is enabled in your Network instance
- Address verification status is V (Verified) or A (Ambiguous) or P (Partially Verified) and premise, thoroughfare and/or building are populated
- Address lines construction feature is enabled
Note that the source file values are the only values that change.
Note: The locality__v (city), administrative_area__v (state/province), and postal_code__v fields are always appended at the end of the formatted address, in that order. These fields have been omitted from the table for space purposes.