Spectrum Universal Address uses a number of required and optional databases. The databases are installed on the Spectrum Technology Platform server. Some of the databases are available by subscription from Precisely and are updated monthly or quarterly. Others are licensed from the USPS®. The following table lists the Spectrum Universal Address databases.
Database Name & Description |
Required or Optional |
Supplier |
---|---|---|
U.S. Postal Database The U.S. Postal Database is in a Precisely proprietary format. It contains every house number range in the United States and is updated on a monthly basis. The database files contain the following information:
The U.S. Postal Database also contains the data needed to perform Enhanced Street Matching (ESM) and All Street Matching (ASM). ESM and ASM apply extra matching logic to any input address that is not matched through the regular address validation process. |
Required for U.S. address processing |
Precisely monthly subscription |
Canadian Postal Database The Canadian Postal database is in Precisely proprietary format. The database files contain the following information:
|
Required for Canadian address processing |
Precisely monthly subscription |
International Postal Database The International Postal Database is a collection of postal address data from around the world. Data from each country is categorized according to the level of data available. The categories are:
|
Required for International address processing |
Precisely quarterly subscription |
DPV® Database The Delivery Point Validation database allows you to check the validity of an individual mailing address in the U.S. The DPV database enhances the U.S. Postal database's ability to validate mailing addresses. Note: The DPV database also contains the data required for
Commercial Mail Receiving Agency (CMRA) processing.
Each time an edition of the U.S. Postal database is released, a corresponding edition of the DPV database is released. Although USPS licensing allows the use of the U.S. Postal database beyond the expiration date (with certain restrictions), DPV lookups may not be performed after the expiration date of the DPV database. USPS licensing prohibits using DPV data for the generation of addresses or address lists. To prevent the generation of address lists, the DPV database contains "false positive records." False positive records are artificially manufactured addresses. For each negative response that occurs in a DPV query, a query is made to the False/Positive table in the DPV database. A match to this table will stop DPV processing. USPS licensing also prohibits exporting the DPV data outside the United States. |
Optional, but required for CASS Certified™ processing; U.S. addresses only |
Precisely monthly subscription |
eLOT® Database The Enhanced Line of Travel ( eLOT) database is a U.S. address database that ensures that Enhanced Carrier Route mailings are sorted as close as possible to the actual delivery sequence. the eLOT database is required for certain types of postal discounts. You will receive monthly updates to your eLOT database on the same media as the U.S. Postal database. You must install the U.S. Postal database and eLOT database from the same month (for example, September eLOT data must be processed with a September U.S. Postal database). If the U.S. Postal database and the eLOT database are not from the same month, there may be ZIP + 4® Codes for which eLOT numbers cannot be assigned. The ZIP Code™, ZIP + 4 Code, carrier route code, and the delivery point of an address must be provided to assign a eLOT code. |
Optional; U.S. addresses only |
Precisely monthly subscription |
EWS Database The Early Warning System (EWS) database prevents address validation errors that can result due to a delay in postal data reaching the U.S. Postal database. The EWS database consists of partial address information limited to the ZIP Code™, street name, pre- and post-directionals, and a suffix. For an address record to be EWS-eligible, it must be an address not present on the most recent monthly production U.S. Postal database. The USPS® refreshes the EWS file on a weekly basis (Thursdays). You can download the EWS file from the USPS® website at https://postalpro.usps.com/. |
Optional; U.S. addresses only |
Download for free from USPS® website |
LACSLink® Database The LACSLink database allows you to correct addresses that have changed as a result of a rural route address converting to street-style address, a PO Box renumbering, or a street-style address changing. USPS licensing prohibits using LACSLink for the generation of addresses or address lists. To prevent the generation of address lists, the LACSLink database contains "false positive records." False positive records are artificially manufactured addresses. For each negative response that occurs in a LACSLink query, a query is made to the False/Positive table in the LACSLink database. A match to this table will stop LACSLink processing. USPS licensing also prohibits exporting the LACSLink database outside the United States |
Optional, but required for CASS Certified™ processing; U.S. addresses only |
Precisely monthly subscription |
RDI™ Database The Residential Delivery Indicator (RDI™) file processing determines whether an address is a residential, business, or mixed (residential and/or business) address. RDI is similar to DPV. In RDI, data is supplied as hash tables. However, RDI is a much simpler process than DPV. In DPV, the standard hash algorithm is determined only for the 9-digit and 11-digit ZIP Code™ rather than the entire address. |
Optional; U.S. addresses only |
Precisely monthly subscription |
SuiteLink™ Database SuiteLink™ corrects secondary address information for U.S. business addresses whose secondary address information could not be validated. If SuiteLink processing is enabled, Validate Address attempts to match the value in the FirmName field to a database of known firm names. Validate Address then supplies the correct secondary address information. |
Optional; U.S. addresses only |
Precisely monthly subscription |