This chapter demonstrates how to use the Address Correction utility to resolve the scenario in which multiple active addresses of the same format exist in an end user location (EUL).
In this scenario, an end user location with ID L1 has multiple active addresses with IDs A1, A2, and A3 of the same structured format. You can select one active address (for example, with ID A1) as the primary. After you resolve, only the primary active address with ID A1 is retained and all the references of the remaining addresses (with IDs A2 and A3) are replaced with the primary active address with ID A1 at the end user location with ID L1.
The following preferences govern this scenario:
To resolve active addresses of the same address format per end user location:
Run the Address Correction utility. See "Running the Address Correction Utility" for more information.
Click the Criteria tab.
Under the I want to find area, select the Multiple active address per EUL per address structured format option.
From the Country list, select a country.
From the Format list, select an address structured format.
Specifying an address format is mandatory for this scenario. The Query across all Address Formats option is not available for this scenario.
Specify your search criteria in the Network Loc Name, End User Loc Name, or any of the address fields and click the fields where you want to specify the partial names using wild cards and click Set Criteria. See "Setting the Search Criteria" for more information.
In the Limit Number Found To field, enter a value. This value determines the maximum number of records to be retrieved for the search. See "Setting the Maximum Number of Records to Be Retrieved" for more information.
Click Search.
The Address Correction utility searches for all the end user locations with multiple active addresses of the same structured format. The Results tab displays multiple active addresses grouped by end user location ID in the Available Groups area.
Consider an example where the active addresses and end user locations exist with IDs as shown in Table 4-1.
Table 4-1 Multiple Active Addresses Per End User Location
| Address ID | Location ID | Structured Format |
|---|---|---|
|
A1 |
L1 |
MSAG |
|
A2 |
L1 |
MSAG |
|
A3 |
L1 |
MSAG |
|
A1 |
L2 |
MSAG |
For example, if you enter the following as your search criteria:
From the Format list, select North American Master Street Address Guide.
In the address fields, specify the address for A1.
The Address Correction utility first searches for the end user location to which A1 belongs, and then it retrieves all the active addresses that belong to that end user location.
In this example, A1 belongs to the to the end user location with ID L1 with MSAG structured format; therefore, the Address Correction utility retrieves the following active addresses of MSAG structured format that belong to end user location with ID L1 and displays them in the Available Groups area on the Results tab:
A1
A2
A3
In this example, the address with ID A1 belonging to end user location with ID L2 is not retrieved in the search results because L2 does not have multiple active addresses of MSAG structured format.
(Optional) On the secondary toolbar, click Export to export the data displayed in the Available Groups area. See "Exporting Available Groups Data" for more information.
Do one of the following:
Select the addresses/groups of addresses you want to resolve and click the single arrow button, which moves the selected addresses/groups of addresses from the Available Groups area to the Selected Groups area.
Click the double arrow button to move all the addresses from the Available Groups area to the Selected Groups area.
In the Resolution Options area, select one of the following options depending on how you want to resolve multiple active addresses of the same address format per end user location:
Manually
Most Current Row
See "Resolution Options Area" for more information.
Click Resolve.
Note:
The amount of time taken by the Address Correction utility to complete the resolution process depends on the number of rows in the Selected Groups area.A confirmation message is displayed that lists the total count of all the entities that will be impacted by the resolve action.
Click Yes.
You cannot undo this action.
A unique identifier (Job ID) is generated for the group of data in the Selected Groups area whose data inconsistencies are being resolved. This identifier is used to compile log information in the View Log window. See "Viewing Log Information" for more information.
The references of all the active addresses are moved to the primary address.