CLEAN_Address Data Sheet
CLEAN_Address Datasheet  Supported Territories
Features US Canada Global

Verify Global addresses in over 240 countries and territories

Server side address processing for enterprise scalability

Batch verify your address table in Oracle without exporting any data

Enhance address records by appending County, ZIP + 4®, Address Type, and other Demographics

GeoCode Addresses to append latitude and longitude coordinates

Subscription service so you always have up to date data

Monthly/ Bimonthly Monthly Monthly/ Varies

Verify Addresses from any application running on the Web, Oracle Forms, PL/SQL, C++, Visual Basic, ASP, or Java/JSP

Options US Canada Global

Address Verification and Standardization provides standard functionality for verifying addresses, standardizing to postal regulations (CASS™/SERP™), correcting street misspellings, identifying undeliverable addresses with error codes, and correcting cities, states, and postal codes. This is standard product functionality.

The DPV™ Product is the most accurate verification you can achieve for US addresses, down to the actual delivery point. The DPV™ Product option verifies a known address down to the deliverable house number, including the identification of missing or invalid apartment or suite numbers.

GeoCoder returns very accurate Latitude and Longitude coordinates and census tract and census block identifiers. These are used to map and pinpoint locations for targeting marketing, nearest dealer locators, and radial searches a given distance from a point. The census tract and block identifiers relate to the 2000 Census demographics.

Telephone Verification verifies and updates area codes based on the zip code and can correct area code splits and data entry errors. This will help prevent fraud and eliminate time wasted on re-dials and wrong numbers. This option is included with the basic CLEAN_Address product.

Name Parser & Genderizer parses names into 5 individual components such as prefix, suffix, first, middle, last. Genderize based on first name to determine Male, Female, Neutral, or Unknown names. This option is included with the basic CLEAN_Address product.

Email Check will perform a syntax check, parse, and check the domain name for accuracy. This option is included with the basic CLEAN_Address product.

Demographic Data Option returns statistical information summarized at the ZIP Code™, county, and MSA level. This is useful for demographic analysis of your data as well as qualifying targeted mailings. Census information is also returned, summarized at the ZIP Code™ level.

USPS® Data - CASS™ processed, updated bimonthly or monthly

Canada Post Data - SERP Certified, updated monthly

Global Data - over 240 countries and territories, updated monthly (varies by country). Data is sourced directly from the country postal authorities for highest quality, rather than using a watered down version from the UPU (Universal Postal Union). Contact us for details.

Platforms US Canada Global

Windows - CLEAN_Address has been certified on the following Windows operating systems
   * Windows NT
   * Windows 2000 Professional
   * Windows 2000 Server
   * Windows 2003 Professional
   * Windows 2003 Server
   * Windows XP Professional
   * Windows XP Server

Linux - Support for
   * Linux RedHat 8.0 (psyche) or greater --or--
   * Linux RedHat 7.1 (seawolf) or greater --or--
   * Linux Red Hat Enterprise Linux WS release 2.1 (Tampa) or greater

Solaris - Support for Solaris 7 or greater (i.e., SunOS 5.7 or greater), SPARC Platform

AIX - Support for AIX 5.2, 5.3. POWER, rs/6000, PPC, 32-Bit

HP-UX - Support for HP-UX 11.11 - 11.23, PA-RISC, 32-bit

Components US Canada Global

Real Time Simple Procedure Call - Verify and standardize address components with a simple procedure call.

Batch Processing - Verify and enhance your address table in Oracle without exporting any data.

Postal Code Selection Table - Quickly access postal code information such as multiple city/state combinations using information stored in Oracle tables.

Standardized Address Table - Store and verify addresses before merging with production data. Identify duplicate addresses after verification.

Interfaces US Canada Global

PL/SQL Batch - Integration scripts and reports for address verification with PL/SQL batch processing.

Banner - Pre-built integration and reports for Banner by Ellucian; Banner is an Oracle-based higher education management system used widely across the US at colleges and universities.

PeopleSoft - Pre-built integration and reports with PeopleSoft.
PeopleSoft for Higher Education is an industry solution in Oracle's Enterprise product line.

Oracle Applications - Pre-built integration and reports with Oracle Applications. Oracle for Higher Education and Research provides a combination of technology and preintegrated business applications.

Oracle Forms Interface - Integration templates and procedures for address verification within Oracle Forms.

Oracle Warehouse Builder (OWB) - Integrates seamlessly with OWB for the address and name functions during ETL (Data Extraction, Transformation, and Load).

Java/JSP Interface - Seamless integration for address verification within Java and JSP applications. Sample code provided in the toolkit.

Free Online Demo - Explore CLEAN_Address in real time! Try out our free online web demo to verify and standardize global addresses, parse names, verify telephone numbers, check email addresses, and more. This is a web implementation calling the PL/SQL procedure within the database.

Additional Products & Services US Canada Global

NCOALink® Processing - perform USPS® change-of-address processing on your address lists as an external job. 18-20% of companies and individuals change their address every year. Call for pricing.

CCOA Processing - perform Canadian change-of-address processing on your address lists as an external job. Call for pricing.

Mailers+4™ - PAVE™ Gold certified for pre-sorting and postal rate discounts. MAILERS+4™ automates the mailing process to meet USPS® requirements for maximum discounted mailings. You'll save up to 65% in postage and printing! MAILERS+4™ verifies and standardizes addresses, adds ZIP + 4® codes, eliminates duplicates, postal presorts, and prints POSTNET™ barcoded labels and tags, plus required postal forms.

The following trademarks are owned by the United States Postal Service®: ZIP + 4, United States Postal Service, USPS, NCOALink, DPV, CASS, PAVE, ZIP, ZIP Code, and POSTNET. NCOALink® services are provided by a non-exclusive licensee of the United States Postal Service®.

·  For additional information please contact our Account Representatives:
   Toll Free: 877-784-0003
   Phone: 561-395-9322
   Email: sales@runnertechnologies.com
   Online: Contact us

Copyright © 1997-2005 Runner Technologies, Inc. All rights reserved.