AO Address Quality and AO Address Report
AO Address Quality
Advanced Object (AOO Address Quality provides for address correction, address parsing and address standardization. You can enable geocode assignment with a single option. If you require a USPS CASS report, a parameter is available on the Processing tab to specify where the report should be created. AO Address Quality accepts a single stream as input and produces a single output.
AO Address Quality macro configuration parameters
The AO Address Quality macro has two sets of configuration parameters in addition to the standard execution options.
Input
Parameter | Description |
---|---|
Company name | Company name used for matching. Optional, except for CASS certification. Defaults to blank. |
Urbanization | Input field containing the Puerto Rican street address designator. Optional. |
Address | Input field containing the postal address. Required. |
Address 2 | Input field containing the second line of a postal address. Optional. |
Lastline type | Select Lastline if city, state, and ZIP Code are contained in a single field, or City/State/ZIP if they are separate fields. Defaults to City/State/ZIP. Required. |
City/State/Zip | If Lastline type is Lastline, the input field containing the City, State, and ZIP Code. |
City | If Lastline type is City/State/ZIP, the input field containing the City. |
State | If Lastline type is City/State/ZIP, the input field containing the State. |
ZIP | If Lastline type is City/State/ZIP, the input field containing the ZIP Code. |
Record ID | Field containing the unique record ID. |
Processing
AO Address Quality always outputs the following fields:
STD_STATUS_CODE
STD_COMPONENT_STATUS
Parameter | Description |
---|---|
Output standardized address | Select to output the following fields:
|
Output address components | Select to output parsed and standardized address components:
|
Output address details | Select to output the following fields:
|
Output all other fields | Select to output the following fields:
|
Multi-address priority | Specify which address has priority in records with more than one address. Options are:
|
Standardize street | Choose whether to keep "vanity" names, abbreviations, or both. Vanity street names are common throughout the US and this option lets you adjust the level of standardization applied. For matching purposes you generally want |
Standardize city | Choose whether to keep "vanity" names, abbreviations, or both. Vanity city names are common throughout the US and this option lets you adjust the level of standardization applied. For matching purposes you generally want |
Keep non-mailing city | Select this to keep city names even if they are technically not mailing names for the standardized Zip Code. For example, some people think they live in Hollywood even though they live in Los Angeles. This option is not CASS-compliant and is not recommended for matching, but you may want to keep customer-preferred city names even if they are technically incorrect. |
Capitalization | Choose capitalization style of the output. |
Directionals | Format of the pre- and postdirectionals. |
Suffix | Format of the street suffix (for example, St, Rd). |
Unit abbreviation | Format of the secondary range format (for example, Apt, Ste). |
Sort data before processing | Select this option to sort the data prior to processing. When comparing source data to the USPS data, data sorted by ZIP Code will produce results faster. |
Delivery Point Validation | Select this option to perform DPV processing. The fields |
Delivery Point Validation additional fields | Select this option to perform DPV processing. The fields |
LACSLink processing | Select this option to perform LACSLink processing. The fields |
eLOT processing | Select this option to perform eLOT processing .The fields |
SuiteLink processing | Select this option to perform SuiteLink processing. The fields |
RDI processing | Select this option to perform RDI processing. The fields |
Geocode | Select this option to provide geocensus data on output. You can choose either the Zip+4 centroid produced by CASS, or a dedicated geocoder. The output fields depend on which option you select:
|
Output geo info fields | Select to output the following fields:
|
CASS report location | Optional. Browse to select a file name and location for the CASS report. |
Parallelism level | If you have 2GB or less of memory, leave this at the default setting of 1. If you have more than 2 GB of memory and the Geocode parameter set to None or CASS ZIP4 Centroid, specify a number less than or equal to the number of CPU cores on the Execution Server. If you have more than 2 GB of memory and the Geocode parameter set to Geocoder, specify <= CPU cores / 2. |
The Delivery Point Validation, LACSLink, eLOT, SuiteLink, and RDI options require an additional Data Management license and installation of current reference data.
Configure AO Address Quality
Select the AO Address Quality macro.
Select the Input tab on the Properties pane.
Specify the address input fields:
Company name: the field containing the business name. Optional.
Urbanization: the Puerto Rican street address designator. Optional.
Address: the postal address.
Address 2: the second line of a postal address. Optional.
Select the Lastline type box:
If | Do this |
---|---|
There is a single last line field | Select Lastline, and then specify the City/State/ZIP field. |
There is not a single last line field | Select City/State/ZIP, and then select the City, State, and ZIP boxes to select the appropriate input fields. |
Go to the Processing tab, and configure outputs and processing options.
Optionally, go to the Execution tab, and then set Web service options.
AO Address Report
AO Address Report accepts results from AO Address Quality and creates a summary report describing the level of address correction achieved and any correction operations performed. It has two output connections.
The "A" (Address) connection outputs counts for the Status Code, Address Type, Non-deliverable Flag, and Component Status Code. This is useful for examining the type of address found in the source data and what level of correction was possible. The output includes the following.
Field | Description |
---|---|
Date Processed | Timestamp from this generated result. Default: |
Value | Field for which output is counted (one of status code, address type, non-deliverable flag, or component status code). Default: |
Code | An entry for each code value that was counted (for example, for each status code value). Default: |
Meaning | The meaning of the code. Default: |
Count | Total number of records for that value and code. Default: |
The "C" (Component) connection outputs information on each position of the 13-character Component Status Code. This is useful for examining what data was changed in each of the address components. The output includes the following.
Field | Description |
---|---|
Date Processed | Timestamp from this generated result. Default: |
Value | Each of the 13 positions represented in the Address Component Status Code: Address number, Predirectional, Street Name, Suffix, Postdirectional, Unit designator, Unit number, City Name, State, ZIP Code, Plus4, Carrier Route, Delivery Point Code. |
Code | The numeric code for this component. |
Meaning | The meaning of the component code. Default: |
Record Count | Total number of records for that code. Default: |
AO Address Report macro configuration parameters
The AO Address Report macro has a single set of configuration parameters in addition to the standard execution options.
Parameter | Description |
---|---|
Status code | Required. The status code from the Address Object. Default: |
Address type | Required. The address type code from the Address Object. Default: |
Non-deliverable flag | Required. Non-deliverable flag from the Address Object. Default: |
Component status code | Required. The component status code from the Address Object. This contains a separate numeric code for each element (such as address number, predirectional, and street name). Default: |
Configure AO Address Report
Select the AO Address Report macro.
Select the Input tab on the Properties pane.
Specify the required input fields:
Status code is the status code from the Address Object.
Address type is the address type code from the Address Object.
Non-deliverable flag is the non-deliverable flag from the Address Object.
Component status code is the component status code from the Address Object.
Optionally, go to the Execution tab, and then set Web service options.