Listware Online:CCOA

← Listware Online

Upload

You must first upload the file you want to cleanse and enrich.

Then select the data quality service you want to use.

Mapping

By default, the File Name, File Size, Header presence, and Record Count are displayed at the top of this page.

Review and Map the Input Columns

Match the input columns with the correct data type. The service will try to match the columns automatically, but you may need to do some fine tuning.

Outputs

Check the boxes next to your desired output columns

Name

Full Name

Full name. E.g. "Dr. Bill S. Preston, Esquire."

Prefix

Any part of the name that precedes the given name, such as "Mr.," "Ms." or "Dr.," for each full name detected.

First Name

Parsed first name. E.g. "Bill."

Middle Name

Parsed middle name. E.g. "S."

Last Name

Parsed last name. E.g. "Preston."

Suffix

Any part of the name that follows the family name, such as degrees ("MD" or "PhD") and generational indicators ("IV" or "Jr."), for each full name processed.

Address

Company Name

The company or organization name.

Address 1

The updated address or standardized street address that was used for verification.

Address 2

Second address. If you specify a second address line, secondary information (apartment, suite, etc.) will be put here. If you choose to not output to Address 2, secondary information will be appended to the first Address.

City

The city name. The information returned may be different than the contents of the City input field, if the preferred city name has been substituted for a vanity city name or if the address was coded to a different ZIP Code instead.

State

Two-character state abbreviation.

Postal Code

Five-digit U.S. ZIP Code.

Country

Country name.

Address Key

AddressKey for the returned record. The Address Key was created by Melissa Data to uniquely identify an address and used as input to our other individual services like Geocoding.

Move Code

Move Type

Move type description.

Move Status

Move status description.

Move Date

Move effective date.

Address Information

Extra Address Information

Extra information that does not fit in any of the output address columns.

Suite

Suite. If requested, the suite will be populated in this column instead of the output address columns.

Private Mailbox

Private Mailbox. These mailboxes are used in commercial receiving agencies, such as the UPS store. If requested, the Private Mailbox will be populated in this column instead of the output address columns.

Urbanization (PR Only)

Urbanization name. These are used only in Puerto Rican addresses.

City Abbreviation

City abbreviation is any is available.

ISO Country Code

ISO country code.

Carrier Route

Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.

Delivery Point

Delivery Point (DP) and its check digit. This is a 2-digit code defining the address's delivery location. The single-digit check digit follows the delivery point and serves as an error check for the ZIP Code, Plus4 and Delivery Point.

Parsed Address

House Number

Parsed House Number for the output address.

Street Pre-Directional

Any directional indicators that precede the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."

Street Name

The street name, minus the suffixes or directionals. For "SW Main Street," this would return "Main."

Street Suffix/Type

The standard abbreviations for the street types: "RD," "ST," "AVE," "BLVD," etc.

Street Post-Directional

Any directional indicators that follow the street name. The directionals are returned as one- or two-character abbreviations. If the input data contained "Southwest," it would be shortened to "SW."

Suite Name

The descriptive portion of the secondary address: "SUITE," "APT," "UNIT," etc.

Suite Number

Parsed Suite Number for the output address.

Private Mailbox Name

Parsed Private Mailbox Name for the output address. A private mailbox, or PMB, is a secondary address associated with a Commercial Mail Receiving Agency (CMRA). Because the CMRA may itself be located in a suite, such an address may have both a suite number and a PMB number.

Private Mailbox Number

Parsed Private Mailbox Number for the output address.

Route Service Number (Canada)

Parsed Route Service Number for the output address. Canada Only.

Delivery Installation (Canada)

Parsed Delivery Installation for the output address. Canada Only.

Lock Box Number (Canada)

Parsed Lock Box Number for the output address. Canada Only.

Review

This section displays your selected options and columns.

Create Job Name

You must also create a name for the job.

Report

Once we have processed your job, you may access a summary report of the job. This will show you the record counts (e.g. number of verified records, matches, etc.) and credit costs.