SAP Module Databases - spectrum_platform - 23.1

Spectrum Quality Connector for SAP Guide

Product type
Software
Portfolio
Integrate
Product family
Spectrum
Product
Spectrum > Spectrum Platform
Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Quality Connector for SAP Guide
Topic type
Installation
How Do I
Reference
Configuration
First publish date
2007
ft:lastEdition
2024-02-22
ft:lastPublication
2024-02-22T23:28:41.647612

The SAP Module relies on other Spectrum Technology Platform modules to provide various capabilities such as address standardization and geocoding. Depending on the features you have licensed you may have one or more of the following modules. Each module requires certain reference data (databases) to be installed on the Spectrum Technology Platform server.

Note: For instructions on installing these databases, see the Spectrum Technology Platform Installation Guide.

Universal Addressing Module Databases

Table 1. 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:

  • ZIP + 4® Code
  • Standardized address elements
  • City and state 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

monthly subscription

Canadian Postal Database

The Canadian Postal database is in proprietary format. The database files contain the following information:

  • Postal code
  • Standardized address elements
  • Municipality and province information

Required for Canadian address processing

monthly subscription

Australia Post Postal Address File Database

The Postal Address File is part of Australia Post's Address Matching Approval System (AMAS) program. The database file contains the following information:

  • Postal code
  • Standardized address elements

Required for Australian address processing

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:

  • Category A—Enables the validation and correction of an address's postal code, city name, state/county name, street address elements, and country name.
  • Category B—Enables the validation and correction of an address's postal code, city name, state/county name, and country name. It does not support the validation or correction of street address elements.
  • Category C—Enables the validation and correction of the country name, and the validation of the format of the postal code.

Required for International address processing

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

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

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

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

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

monthly subscription