Reference Guide#

Business Check#

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.

Select Business Check Service Options#

Return Dominant Business#

Return the dominant business name when the company information is missing or does not match.

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.

Output#

Check the boxes next to your desired output columns

Address Details#

Plus4#

The Plus4 of the address.

Delivery Indicator#

The RBDI Indicator based on the address.

MelissaAddressKey#

(MAK) A unique key assigned to an address record.

MelissaAddressKeyBase#

A unique key assigned to the base address of a complex with apartments or suites.

Business Codes#

SIC Code 1#

A 6-digit SIC code for the business’s primary line of business.

NAICS Code 1#

North American Industry Classification System code. This is related to SIC Code 1.

Business Description#

SIC Description 1#

First SIC code description. Related to SIC Code 1.

NAICS Description 1#

First NAICS code description. Related to NAICS Code 1.

GeoLocation#

Latitude & Longitude#

The latitude and longitude geo coordinates.

Census Details#

County Name#

The name of the county.

County FIPS#

The FIPS code of the county.

Census Block#

The census block number for the address.

Census Tract#

The census tract number for the address.

Place Name#

The Census Bureau place name.

Place Code#

The Census Bureau place code.

Others#

Location Type#

Code denoting the business location type.

Code

Definition

1

Headquarters

2

Branches

3

Subsidiary Headquarters

4

Single Location

Stock Ticker#

The assigned stock exchange abbreviation/symbol for the business.

Web Address#

The web address/domain for the business.

Employees Estimate#

The number of employees who work at this business location.

Sales Estimate#

The sales volume and/or assets of the business.

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.

Global Address#

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.

Data Quality Service Check Options#

Country of Origin#

The origin country for mailing used in the Formatted Address output column.

Output Script#

The character set to use to format the output data.

Default Country#

Used if no country column is specified or if a record’s country column is blank.

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

Output Columns#

Select the addressing style that best describes the type of data that you would like to output.

Multi-Line Address#

The entire mailing address will appear in output Address Lines 1-8.

Delivery Address#

The street address will appear in Address Lines 1-8 and the Regional information to appear in separate fields.

Delivery Address and Parsed Components#

The entire mailing address will appear in output Address Lines 1-8 and the Regional information to appear in separate fields. In addition, you can capture the parsed street address components.

Organization#

Organization#

Matches the Organization input. It is not modified or populated by the Cloud Service.

Address Lines#

Address Line 1#

Address Line 1. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 2#

Address Line 2. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 3#

Address Line 3. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 4#

Address Line 4. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 5#

Address Line 5. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 6#

Address Line 6. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 7#

Address Line 7. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Address Line 8#

Address Line 8. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Country#

Country Name#

The standardized country name.

ISO 3166-1 Country Code#

The country code. Select what format this will be in with the format drop-down.

Format#

Select the format of the output country code.

Code

Definition

Alpha-2

The two letter abbreviation for countries. e.g., for United States; Canada; and the Philippines: US; CA; PH.

Alpha-3

The three letter abbreviation for countries. e.g., for United States; Canada; and the Philippines: USA; CAN; PHL.

Numeric

The number code for countries. e.g., for United States; Canada; and the Philippines: 840; 124; 608.

GeoLocation#

Latitude & Longitude#

The latitude and longitude geo coordinates.

Regional Levels#

Double-Dependent Locality#

Double-Dependent Locality. An area or village (e.g., UK) within a Dependent Locality required to identify an address.

Dependent Locality#

Dependent Locality. A district, area, or neighborhood (e.g., Turkey) within a Locality required to identify an address.

City/Locality#

A city (e.g., US), town, or municipality (e.g., Canada) that is the most common population center element within an Administrative Area.

Sub-Administrative Area#

A county (e.g., US) or region larger than the Locality but smaller than the Administrative Area.

State/Province/Admin Area#

A state (e.g., US), province (e.g., Canada) or canton (e.g., Switzerland) contained within a Country.

Zip/Postal Code#

The postal code or ZIP code (e.g., US) for the input address.

Sub-National Area#

Sub-National Area. Not commonly used. An arbitrary region smaller than a Country but larger than an Administrative Area.

Parsed Components#

Address Type#

A one-character code for the type of address coded. Only for US and Canadian addresses.

Address Key#

A unique key for the address. Only for US and Canadian addresses.

Throughfare#

The thoroughfare (e.g., the name of the street or block).

Throughfare Pre-Direction#

The prefix directional contained within the Thoroughfare.

Throughfare Leading Type#

The leading thoroughfare type indicator within the Thoroughfare.

Throughfare Name#

The name indicator within the Thoroughfare.

Throughfare Trailing Type#

The trailing thoroughfare type indicator within the Thoroughfare.

Throughfare Post-Direction#

The postfix directional contained within the Thoroughfare.

Dependent Throughfare#

The dependent thoroughfare (e.g., the name of the dependent street or block).

Dependent Throughfare Pre-Direction#

The prefix directional contained within the Dependent Thoroughfare.

Dependent Throughfare Leading Type#

The leading thoroughfare type indicator within the Dependent Thoroughfare.

Dependent Throughfare Name#

The name indicator within the Dependent Thoroughfare.

Dependent Throughfare Trailing Type#

The trailing thoroughfare type indicator within the Dependent Thoroughfare.

Dependent Throughfare Post-Direction#

The postfix directional contained within the Dependent Thoroughfare.

Sub-Premises#

The alphanumeric code that identifies an individual location.

Building#

The descriptive name identifying an individual location.

Premises Type#

The leading premises type indicator within Premises.

Premises Number#

The alphanumeric indicator within Premises.

Sub-Premises Type#

The sub-premises type indicator within Sub-Premises.

Sub-Premises Number#

The alphanumeric indicator within Sub-Premises.

Post Box#

The post box information for a particular delivery point.

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.

Global Email#

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

Default Outputs#

Mailbox Name#

The mailbox or user name portion of the email address (All characters preceding the “@” character).

With an example email of “sample@melissa.com” the mailbox name would be “sample”.

Domain Name#

The domain name portion of the email address (All characters between the “@” and “.” characters).

With an example email of “sample@melissa.com” the domain name would be “melissa”.

Top Level Domain#

The description associated with the top-level domain name of the email address.

Top Level Domain Name#

The top level domain name portion of the email address (All characters after the “.”).

With an example email of “sample@melissa.com” the top level domain name would be “com”.

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

Global Phone#

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.

Select Global Phone Service Options#

Append Caller ID#

Returns the name or association linked to the phone number at the time of registration, if available and found to be valid.

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

Columns#

Phone Number#

The standardized phone number after a successful call to the service.

The phone number will return in varying formats depending on the inputs.

Administrative Area#

The administrative area associated with the inputted phone number.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Country Abbreviation#

The abbreviation of the country for the inputted phone number.

Country Name#

The name of the country for the inputted phone number.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Carrier#

The name of the phone’s carrier.

Daylight Savings Time#

Distinguishes whether the region of the inputted phone number observes daylight savings time.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

International Phone Number#

The number you would dial, given your output fields, in order to successfully send a call.

This number can change based on whether a Country of Origin is submitted or not.

Language#

The predominant language of the phone’s detected geographical location.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Latitude#

The latitude of the geographically identifiable service area of the exchange.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Longitude#

The longitude of the geographically identifiable service area of the exchange.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Locality#

The locality (city) associated with the phone number passed to the Lookup function.

Because of phone portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

International Prefix#

The international exit code needed to call a number outside of the dialing country.

If the input country and country of origin differ, this will return the digit(s) required to be dialed before the country code.

Country Dialing Code#

A digit, or combination of digits, known as the country dialing code.

This will return the digit(s) dialed after the international prefix.

Nation Prefix#

A digit, or combination of digits, known as the national prefix.

The national prefix must be dialed before an area (city) code when calling a number within the same country but outside the numbering area.

For example (US phone number): 1-949-589-5200 where 1 is the national prefix.

National Destination Code#

A digit, or combination of digits, known as the national destination code.

The national destination code that identifies a numbering area within a country (or group of countries) and/or network/services.

Subscriber Number#

The subscriber number associated with the phone number passed in.

The subscriber number contains significant leading digits that further define the local exchange area and/or service.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Universal Time Code#

The universal time code for the time zone associated with the inputted phone number.

UTC returns the time zone specified with the format: +/- hh:mm.

Because of phone number portability, geographical information may not reflect the true location of the owner of the phone number for wireless and VOIP numbers.

Postal Code#

The zip code that corresponds to a locality inside the United States.

Since this is US only, all other countries will have PostalCode blank.

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.

Canada Change of Address (CCOA)#

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.

U.S. Change of Address (NCOA)#

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.

Your List Owner PAF Id will also be displayed.

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.

For a complete list of result codes returned by SmartMover, please see:

  • SmartMover V3 Result Codes

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.

Property#

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

Parcel#

These fields return information used to uniquely identify the parcel of land which the property occupies.

FIPS Code#

Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.

FIPS Sub Code#

A secondary classification of a jurisdiction within a FIPS.

Unformatted APN#

Assessor’s Parcel Number in an unformatted form. This is most often used by the county and others as a unique key (e.g., 10132021A).

APN Sequence No.#

This internal sequence number is used to ensure “uniqueness” of the Assessor’s Parcel Number (e.g., 10132021A seq 001).

Formatted APN#

Assessor’s Parcel Number in a formatted form. Dashes and decimals are commonly used to break an APN down into logical components (e.g., 101-32-021.A).

Original APN#

Assessor’s Parcel Number exactly as received by source (e.g., 10132-021A00000).

Census Tract#

Comprised of Census Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce (Bureau Of The Census).

Zoning#

The data contained in this field is based upon County and/or Local established Zoning Codes and are not converted by FARES.

Range#

The “range” portion of geographical coordinates based on local surveys. Ranges typically run east or west of predetermined “meridian” in sixmile intervals.

Township#

The “township” portion of geographical coordinates based on local surveys. Townships typically run north or south of predetermined “meridian” in six-mile intervals.

Section#

The “section” portion of geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range / Township.

Quarter Section#

A section that has been divided into four “sub” sections (e.g., NE, NW, SE, SW).

HomeStead Exempt#

This field will be set with a “Y” if the owner has qualified for a Homeowner/Homestead exemption.

Absentee Owner Code#

This field will be set with an “A” if the owner is an absentee.

For a list of possible codes returned for this element, see Property Codes - Absentee Owner Code.

Land User Code#

A FARES established Land Use code converted from various county Land Use codes to aid in search and extract functions.

For a list of possible codes returned for this element, see Property Codes - Land Use Code.

County Land Use1#

Primary (i.e., highest) Land Use as established by the county or local taxing administration.

County Land Use2#

Secondary Land Use as established by the county or local taxing administration.

Property Indicator Code#

A FARES general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial).

For a list of possible codes returned for this element, see Property Codes - Property Indicator Code.

Municipality Name#

Name of the Municipality where parcel is located.

View Code#

View from building (e.g., Gulf, Mountains, Pool).

For a list of possible codes returned for this element, see Property Codes - View Code.

Location Influence Code#

Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport).

For a list of possible codes returned for this element, see Property Codes - Location Influence Code.

Number Of Building#

Total number of buildings on the parcel.

Property Address#

These fields contain the physical address of the property.

Address#

The first line of the street address (e.g., 22382 Avenida Empresa).

City#

The city associated with the property address (CHICAGO, ATLANTA, DENVER).

State#

The two-letter USPS postal abbreviation associated with the state/protectorants/commonwealth (CA, VI, PR).

Zip#

The nine-digit code (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and nonproprietary processes (95463-0042).

Address Key#

A unique 11-digit address key for the submitted address (92688211282).

Latitude#

Geographic coordinate that specifies the northsouth position of a point on the Earth’s surface (33.637550).

Longitude#

Geographic coordinate that specifies the eastwest position of a point on the Earth’s surface (117.606840).

Parsed Property Address#

These fields contain the parsed address of the physical property.

Range#

The delivery number of a parsed address.

Pre Directional#

The geographic directional that precedes the street name(NW, E, etc).

Street Name#

The name of the street from a parsed address (Empresa, etc).

Suffix#

Suffix portion of a parsed address(Avenida).

Post Directional#

Geographic directional that follows the street name.

Suite Name#

The name of the secondary unit of a parsed address (Apt, Suite, etc.).

Suite Range#

Range of any secondary unit of a parsed address.

Owner#

These fields contain information on the current owner of the property.

Corporate Owner#

The Name of the property owner has been recognized as a corporation or business.

Name#

The name of the property owner.

Name2#

Additional owner names if more than one person owns the property.

Unparsed Name1#

Non-parsed owner name.

Unparsed Name2#

Additional owner names if more than one person owns the property - non-parsed.

Phone#

Phone number of property owner (e.g., 9095551212).

Phone OptOut#

A “Y” represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by phone for solicitation.

Owner Address#

These fields contain the ownder’s mailing address.

Address#

The first line of the street address.

Suite#

The unit or suite number of the property address (e.g., 649 LAKE SHORE DR #1400).

City#

The city associated with the property address (e.g., CHICAGO, ATLANTA, DENVER).

State#

The two-letter USPS postal abbreviation associated with the state/protectorants/commonwealth (e.g., CA, VI, PR).

Zip#

The nine-digit code (i.e., ZIP & plus 4) assigned by the USPS. This is populated by various source files and other proprietary and nonproprietary processes (e.g., 954630042).

Carrier Route#

This is the four-digit code used by the local mail carrier to identify the delivery path.

Match Code#

Indicates the level of matching for an owner’s mailing address (no matching streets, ranges, etc.)

For a list of possible codes returned for this element, see Property Codes - Matchcode.

Mail Opt Out#

A “Y” represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by mail for solicitation.

Values#

These fields contain data on the current value of the property.

Calculated Total Value#

The “TOTAL” (i.e., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities.

Calculated Land Value#

The “LAND” Value closest to current market value used for assessment by county or local taxing authorities.

Calculated Improvement Value#

The “IMPROVEMENT” Value closest to current market value used for assessment by county or local taxing authorities.

Calculated Total Value Code#

The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the TOTAL VALUE CALCULATED field.

For a list of possible codes returned for this element, see Property Codes - Total Value Calculated Indicator.

Calculated Land Value Code#

The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the LAND VALUE CALCULATED field.

For a list of possible codes returned for this element, see Property Codes - Total Value Calculated Indicator.

Calculated Improvement Value Code#

The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the IMPROVEMENT VALUE CALCULATED field.

For a list of possible codes returned for this element, see Property Codes - Total Value Calculated Indicator.

Assessed Total Value#

The Total Assessed Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.

Assessed Land Value#

The Assessed Land Values as provided by the county or local taxing/assessment authority.

Assessed Improvement Value#

The Assessed Improvement Values as provided by the county or local taxing/assessment authority.

Market Total Value#

The Total Market Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.

Market Land Value#

The Market Land Values as provided by the county or local taxing/assessment authority.

Market Improvement Value#

The Market Improvement Values as provided by the county or local taxing/assessment authority.

Appraised Total Value#

The Total Appraised Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority.

Appraised Land Value#

The Appraised Land Values as provided by the county or local taxing/assessment authority.

Appraised Improvement Value#

The Appraised Improvement Values as provided by the county or local taxing/assessment authority.

Tax Amount#

The Total Tax amount provided by the county or local taxing/assessment authority.

Tax Year#

The tax or assessment year for which the taxes were billed.

Current Sale#

These fields contain information from the most recent sale of the property.

Transaction Id#

This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys.

Document Year#

The year a sales transaction document was recorded (e.g., 1984).

Deed Category Code#

The type of deed used to record the sales transaction (e.g., Grant, Quit, Foreclosure).

Recording Date#

The date the sales transaction was recorded at the county (e.g., 19621028).

Sale Date#

The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).

Sale Price#

Price of the sale as depicted on the recorded sales transaction.

Sale Code#

This field indicates whether the financial consideration is F = Full or P = Partial.

For a list of possible codes returned for this element, see Property Codes - Sale Code.

Seller Name#

The seller’s name as it appears on the recorded sales transaction.

Multi APN Code#

The data contained in this field depicts multiple or split parcel sales.

Multi APN Count#

This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).

Residental Model#

A code to indicate whether the property is residential based on individual ZIP codes and values. “Y” = yes, “N” or blank = no.

Current Deed#

These fields contain information about the current mortgage holder on the property.

Mortgage Amount#

The amount of the first mortgage as depicted on the recorded document.

Mortgage Date#

The date the Mortgage was initiated.

Mortgage Loan Type Code#

Type of loan secured (e.g., Conventional, FHA, VA).

For a list of possible codes returned for this element, see Property Codes - Mortgage Loan Type Code.

Mortgage Deed Type Code#

Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).

For a list of possible codes returned for this element, see Property Codes - Mortgage Deed Type Code.

Mortgage Term Code#

This code is used to identify whether the number stored in the MORTGAGE TERM field is in Days, Months or Years.

For a list of possible codes returned for this element, see Property Codes - Mortgage Term Code.

Mortgage Term#

The length of time before the mortgage matures (e.g., 15yrs, 30 yrs, 45dys).

Mortgage Due Date#

The date the mortgage amount becomes due.

Mortgage Assumption Amount#

The assumption amount related to an existing mortgage.

Lender Code#

This is a FARES internal code used to identify the Lending Company that was associated with the sales transaction.

Lender Name#

This is the name of the lender on the original recorded document.

Second Mortgage Amount#

This is the amount associated with the 2nd mortgage.

Second Mortgage Loan Type Code#

Type of loan secured as part of the 2nd mortgage (e.g., Conventional, FHA, VA).

Second Mortgage Deed Type Code#

Type of deed used for recording the 2nd mortgage (e.g., Agreement of Sale, Assumption, Correction Deed).

Prior Sale#

These fields contain information about a sale of the property prior to the most recent one.

Transaction Id#

This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys.

Document Year#

The year a sales transaction document was recorded (e.g., 1984).

Deed Category Code#

The type of deed used to record the prior sales transaction (e.g., Grant, Quit, Foreclosure).

For a list of possible codes returned for this element, see Property Codes - Deed Category Code.

Recording Date#

The date the sales transaction was recorded at the county (e.g., 19621028).

Sale Date#

The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025).

Sale Price#

Price of the sale as depicted on the recorded sales transaction.

Sale Code#

This field indicates whether the financial consideration is F = Full or P = Partial.

Transaction Code#

This identifies situations associated with the sale (e.g., Resale, Construction Loan, Seller Carryback).

Multi APN Code#

The data contained in this field depicts multiple or split parcel sales.

For a list of possible codes returned for this element, see Property Codes - Multi APN Code.

Multi APN Count#

This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).

Mortgage Amount#

This is the amount associated with the mortgage of the prior sale.

Deed Type Code#

Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).

Lot#

These fields contain data on the physical dimensions of the entire property.

Front Footage#

The linear feet across the front of the lot - facing the street.

Depth Footage#

The linear feet between the front and back of the lot.

Acreage#

Total land mass in Acres.

Square Footage#

Total land mass in Square Feet.

Square Footage#

These fields contain physical information about the building or buildings on the property.

Universal Building#

The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross).

Building Area Code#

The codes appearing in this field indicate the source used to populate the UNIVERSAL BUILDING SQUARE FEET field (e.g., Living, Adjusted, Gross).

For a list of possible codes returned for this element, see Property Codes - Building Area Code.

Building Area#

The size of the building in Square Feet. This field is most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas.

Living Space#

This is the area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and does not include Garage, Porch or Basement square footage.

Ground Floor#

Square footage of the part of the building which is level with the ground (typically the front of the building). This is generally above the basement(s) and below the second floor.

Gross#

This is the square footage for the entire building. Typically this represents all square feet under the roof.

Adjusted Gross#

This is the square footage used by the county or local taxing / assessment authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area.

Basement#

This is total square footage associated with Basement portion of a building. This would include both finished and unfinished areas.

Garage Or Parking#

This is the total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas.

Building#

These fields contain information about the features of the building or buildings on the property.

Year Built#

This is the construction year of the original building.

Effective Year Built#

This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974). The Year Built would be 1960 and the Effective Year Built would be 1974.

Bed Rooms#

Total number of Bedrooms contained in the primary building.

Total Rooms#

Total number of rooms contained in the primary building.

Total Baths Calculated#

Total number of Bathrooms in whole numbers (e.g., a home containing 2 1/2 baths would have the number 3 stored in this field as, three actual rooms have been designated for this purpose).

Total Baths#

Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75).

Full Baths#

Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field.

Half Baths#

Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 1 stored in this field.

One Quarter Baths#

Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms).

Three Quarter Baths#

Total number of Three-Quarter Baths (typically comprised of a sink, toilet & shower stall).

Bath Fixtures#

The total number of bathroom fixtures (typically a Full Bath would have 4 fixtures - 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head).

Air Conditioning Code#

The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative).

For a list of possible codes returned for this element, see Property Codes - Air Conditioning Code.

Basement Code#

The type of basement finish found in the building (e.g., Finished, Half, Crawl).

For a list of possible codes returned for this element, see Property Codes - Basement Code.

Building Code#

The primary building type (e.g., Bowling Alley, Supermarket).

For a list of possible codes returned for this element, see Property Codes - Building Code.

Improvement Code#

The primary improvement type (e.g., Grain Silo, Hanger, Marina).

For a list of possible codes returned for this element, see Property Codes - Improvement Code.

Condition Code#

This represents the physical condition of the main improvement (e.g., Good, Fair, Under Construction).

For a list of possible codes returned for this element, see Property Codes - Condition Code.

Construction Code#

The primary method of construction (e.g., Steel/Glass, Concrete Block, Log).

For a list of possible codes returned for this element, see Property Codes - Construction Code.

Exterior Wall Code#

The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone).

For a list of possible codes returned for this element, see Property Codes - Exterior Wall Code.

Fireplace#

This field is populated with a “Y” if a fireplace is located within the building.

Fireplaces#

This represents the number of fireplace openings located within the building

Fireplace Code#

The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick).

For a list of possible codes returned for this element, see Property Codes - Fireplace Code.

Foundation Code#

The type of foundation (e.g., Continuous Footing, Pier, Mud Sill).

For a list of possible codes returned for this element, see Property Codes - Foundation Code.

Flooring Code#

The type of floor construction (e.g., Concrete, Plywood).

For a list of possible codes returned for this element, see Property Codes - Flooring Code.

Roof Framing Code#

The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore).

For a list of possible codes returned for this element, see Property Codes - Roof Framing Code.

Garage Code#

Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage).

For a list of possible codes returned for this element, see Property Codes - Garage Code.

Heating Code#

Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant).

For a list of possible codes returned for this element, see Property Codes - Heating Code.

Mobile Home#

This element is populated with a “Y” if a Mobile Home is present on the parcel.

Parking Spaces#

This represent the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type.

Parking Code#

Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature.

For a list of possible codes returned for this element, see Property Codes - Parking Code.

Pool#

This element is populated with a “Y” if a Pool is present on the parcel.

Pool Code#

Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated).

For a list of possible codes returned for this element, see Property Codes - Pool Code.

Quality Code#

Type of construction quality of building (e.g., excellent, economical).

For a list of possible codes returned for this element, see Property Codes - Quality Code.

Roof Cover Code#

Type of roof covering (e.g., Clay Tile, Aluminum, Shake).

For a list of possible codes returned for this element, see Property Codes - Roof Cover Code.

Roof Type Code#

Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard).

For a list of possible codes returned for this element, see Property Codes - Roof Type Code.

Stories Code#

Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story).

For a list of possible codes returned for this element, see Property Codes - Stories Code.

Stories#

Number of stories associated with the building (e.g., 2, 1.5).

Building Style Code#

Type of building style (e.g., Colonial, Cape Code, Bungalow).

For a list of possible codes returned for this element, see Property Codes - Building Style Code.

Units#

Number of Residential, Apartment or Business Units.

Electricity Code#

Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source).

For a list of possible codes returned for this element, see Property Codes - Electricity Code.

Fuel Code#

Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil).

For a list of possible codes returned for this element, see Property Codes - Fuel Code.

Sewer Code#

Type of sewer system on the parcel (e.g., Public, Septic, Commercial).

For a list of possible codes returned for this element, see Property Codes - Sewer Code.

Water Code#

Type of water service on the parcel (e.g., Public, Well, Cistern).

For a list of possible codes returned for this element, see Property Codes - Water Code.

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.