Run the Address Validation program to validate addresses in the TCA Registry in bulk. The program sends data to the address validation black box, which must be integrated with at least one adapter for address validation. For example, if the adapter is integrated with a third party product called Gorman, the adapter would validate the TCA addresses against the Gorman address database. See: Administering Adapters.
Each address is validated through the default adapter set up for each country. For example, if the Gorman adapter is the default for Peru, all Peruvian addresses in the Registry are validated against Gorman's standard addresses.
If an address from the TCA Registry differs from the validated address, the TCA address is updated with the validated address only if the TCA address is valid above a specified threshold. Such an update is called an address correction. For example, if you set the Override Threshold parameter at the Municipality Match level, then an address is corrected if at least its city or town is valid.
Note: Aside from the validation threshold, address correction only occurs if the update does not violate other validations, such as tax validation rules.
Your administrator can set up address validation, including determining the timeout limit for communication with third party service providers and custom solutions. The default is 300 seconds. See: Setting Up Batch Address Validation.
The Address Validation program has three pairs of parameters, each including a filter operator and the corresponding value, to determine which addresses in the TCA Registry to include in the address validation.
For each parameter pair, you must use both or neither. To include addresses that were never validated, do not use the validation status and date validated parameters.
Specify the operator for filtering addresses to validate, based on the last validation status. For example, you enter <= and select 3 as the validation status code. The program would include only addresses that have validation status 3, 2, 1, or 0 from the last address validation.
Enter the validation status to use with the validation status filter for including only addresses based on their last validation status. The program considers addresses last validated by any adapter, unless you specify one in the Adapter parameter.
Specify the operator for filtering addresses to validate, based on the last validation date. For example, you enter > and 01-JAN-2004 as the validation date. The program would include only addresses that were last validated on January 2, 2004 or later.
Enter the validation date to use with the date validated filter for including only addresses based on their last validation date. The program considers addresses last validated by any adapter, unless you specify one in the Adapter parameter.
Specify the operator for filtering addresses to validate, based on the last update date. For example, you enter < and 01-JAN-2004 as the validation date. The program would include only addresses that were last updated on December 31, 2003 or earlier.
Enter the update date to use with the last update date filter for including only addresses based on their last update date. Updates include user-entered changes, address corrections, or enrichment from a third party data source such as D&B.
Leave this parameter blank to validate addresses in all countries, or enter the country you want to validate.
Enter the adapter that you want to use to validate addresses against. Use this parameter, for example, to validate against a specific source after the source's libraries are updated with new data.
If you use the validation status or date validated parameters, the program further limits the addresses to only those last validated by the specified adapter.
Enter the code for the validation threshold that an address must reach or exceed to be corrected with the valid address. For example, if you select 2, addresses must be validated at least to the street or thoroughfare level to be updated. Addresses with validation status 0, 1, or 2 would be updated.
This table describes the available status codes.
| Status | Meaning | Description |
|---|---|---|
| 0 | Valid Address | The highest level of validation. The address has been certified deliverable based on postal authority certifications. |
| 1 | Multiple or Ambiguous Address | Address has been validated to the street level, but there is ambiguity to locate the specific address. |
| 2 | Street or Thoroughfare Match | Address has been validated to the street level, but no further. |
| 3 | Municipality Match | Address has been validated to the city or town level, but no further. |
| 4 | Administrative Subdivision Match | Address has been validated to be within the country's main administrative subdivision, such as province or state, but no further. |
| 5 | Country Match | Address has only been validated to the country level, but no further. |
| 6 | No Match | Address could not be validated in any way. |