Listware Online:CCOA

From Melissa Data Wiki
Jump to navigation Jump to search

← 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.