Difference between revisions of "Listware for Excel:US:Output Columns"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{{LWEUSNav
 
|StepsCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''US Check and Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|style="border-bottom:1px solid #aaaaaa;"|[[Listware for Excel:Check and Verify|← Check and Verify]]
|-
|[[Listware for Excel:US|Overview]]
|-
|[[Listware for Excel:US Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:US:Processing Range|Processing Range]]
|-
|[[Listware for Excel:US:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:US:Input Columns|Input Columns]]
|-
|[[Listware for Excel:US:Output Columns|Output Columns]]
|-
|[[Listware for Excel:US:Reporting|Reporting]]
|-
|[[Listware for Excel:US:Review Settings|Review Settings]]
|-
|[[Listware for Excel:US:Processing|Processing]]
|-
|[[Listware for Excel:US:Review Results|Review Results]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 80: Line 37:
;Gender
;Gender
:This will output the name's gender. "M" for male, "F" for female, and "N" for neutral.
:This will output the name's gender. "M" for male, "F" for female, and "N" for neutral.
:;Use Demographic Data When Available
::Check this item if you want to use the more accurate demographic-derived gender. This option is available for Output Name1 Gender only.




Line 115: Line 75:
;AddressKey
;AddressKey
:Output the AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa Data products.
:Output the AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa Data products.
;MAK and Base MAK
:A unique key assigned to the submitted address (MAK) and base address of a complex with apartments or suites (Base MAK). For more information, see [[Melissa Address Key:Technology|Melissa Address Key]].




Line 120: Line 83:
;Latitude and Longitude
;Latitude and Longitude
:Output the latitude and longitude.
:Output the latitude and longitude.
;Link to Map Location
:US Check and Verify use the returned Address and Latitude Longitude pair to create a hyperlink to the specified Map Server. Unverified records with no returned Lat Long pair, may therefore display a map to the user’s local area determined by the selected Map Server.




Line 201: Line 167:


;City Abbreviation
;City Abbreviation
:Output the city abbreviation is any is available.
:Output the city abbreviation if any is available.


;State Name
;State Name
Line 245: Line 211:


;Census Block
;Census Block
:Output the Census Block. This is a 4-digit string indicating the Census Block number associated with the address. Census Blockas are the smallest geographic area for which the Bureau of the Census collects information.
:Output the Census Block. This is a 4-digit string indicating the Census Block number associated with the address. Census Blocks are the smallest geographic area for which the Bureau of the Census collects information.


;Census Tract
;Census Tract
:Output the Census Tract. This is a 4 to 6-digit string containing the Census Tract number associated with the address. Censsu Tracts are small subdivisions of the county.
:Output the Census Tract. This is a 4 to 6-digit string containing the Census Tract number associated with the address. Census Tracts are small subdivisions of the county.


;Place Name
;Place Name
Line 258: Line 224:
;Congressional District
;Congressional District
:Output the Congressional District. This is a 2-digit code indicating the address's congressional district.
:Output the Congressional District. This is a 2-digit code indicating the address's congressional district.
;CensusKey
:Check this item if you want the Census Key.
;CountySubdivisionCode
:Check this item if you want the output County Subdivision Code.
;CountySubdivisionName
:Check this item if you want the output Upper State District Code.
;StateDistrictUpper
:Check this item if you want the output Upper State District Code.
;StateDistrictLower
:Check this item if you want the output Lower State District Code.
;ElementarySchoolDistrictCode
:Check this item if you want the output Elementary School District Code.
;ElementarySchoolDistrictName
:Check this item if you want the output Elementary School District Name.
;SecondarySchoolDistrictCode
:Check this item if you want the output Secondary School District Code.
;SecondarySchoolDistrictName
:Check this item if you want the output Secondary School District Name.
;UnifiedSchoolDistrictCode
:Check this item if you want the output Unified School District Code.
;UnifiedSchoolDistrictName
:Check this item if you want the output Unified School District Name.




Line 266: Line 265:
;Date of Death
;Date of Death
:Output the Date of Death demographic. The date of death will be formatted: yyyy-mm-dd.
:Output the Date of Death demographic. The date of death will be formatted: yyyy-mm-dd.
;Gender
:Output the name's gender.
:{|class="alternate01" cellspacing="0"
!Code
!Description
|-
|M
|Male
|-
|F
|Female
|-
|N
|Neutral
|}


;Household Income
;Household Income
Line 298: Line 280:
|-
|-
|PR
|PR
|Probable Renter
|Inferred Renter
|-
|-
|PO
|PO
|Probable Owner
|Inferred Owner
|-
|-
|DO
|DO
Line 313: Line 295:
:Output the occupation demographic.
:Output the occupation demographic.


;Married?
;Marital Status
:Output the marital status demographic.
:Output the marital status demographic.


Line 320: Line 302:
!Description
!Description
|-
|-
|U
|
|Unknown
|Unknown
|-
|-
Line 327: Line 309:
|-
|-
|PS
|PS
|Possibly Single
|Inferred Single
|-
|-
|PM
|PM
|Possibly Married
|Inferred Married
|-
|-
|DM
|DM
Line 336: Line 318:
|}
|}


;Children Present?
;Presence of Children
:Output the children demographic.
:Output the children demographic.


Line 349: Line 331:
|No
|No
|}
|}
;Education
:Returns the highest level of education completed by an individual.
;Household Size
:Returns the number of occupants in the household.
;Political Party
:Returns an individual’s political affiliation.
;Presence of Senior
:Returns the presence of senior/s in the household.
;Credit Card User
:Returns whether the user has a credit card or not.
;Ethnic Code
:Returns an individual’s specific ethnicity.
;Ethnic Group
:Returns the grouped category for a person’s ethnicity. This is a more generalized grouping compared to Ethnic Codes.
;Child Age Range
:Returns the age range of children in the household.




Line 361: Line 367:
:Output the property owner's address. This is present for 98% of properties.
:Output the property owner's address. This is present for 98% of properties.


;Total Property Value
;Improvement Value
:Output the calculated total value (parcel plus improvement values, closest to market value, used for assessment by tax agencies.) This is present for 97% of properties.
:Output the Calculated Improvement Value. This is closed to the current market value, and is used for assessment by tax agencies. This is present for 59% of properties.


;Improvement Value
;Estimated Home Value
:Output the Calculated Improvement Value. This is clsoed to the current market value, and is used for assessment by tax agencies. This is present for 68% of properties.
:Output the estimated home value.


;Assessed Property Value
;Assessed Property Value
Line 387: Line 393:
;Building Square Footage
;Building Square Footage
:Output the total building area in square feet. This is present for 35% of properties.
:Output the total building area in square feet. This is present for 35% of properties.
;Living Space Square Footage
:Output the area of the building used for general living. This is for heated or cooled areas. This does not include any garage, basement, or porch areas. This is present for 53% of properties.


;Year Built
;Year Built

Latest revision as of 17:01, 18 September 2020

← Listware for Excel Reference

US Check and Verify Navigation
← US & Canada
Overview
Tutorial
Steps
Processing Range
Cleansing Operations
Input Columns
Output Columns
Reporting
Review Settings
Processing
Review Results
Result Codes



LWE US OutputColumns.png

Specify what data you want to output by checking the box next to the desired columns.

You can right-click each section to 'Check All' or 'Check None'.

The following output columns are available:


Name 1

This section contains name components.

Full Name
Output the full name. E.g. "Dr. Bill S. Preston, Esquire."
Prefix
Output the parsed name prefix. E.g. "Dr."
First Name
Output the parsed first name. E.g. "Bill."
Middle Name
Output the parsed middle name. E.g. "S."
Last Name
Output the parsed last name. E.g. "Preston."
Suffix
Output the parsed name suffix. E.g. "Esquire."
Gender
This will output the name's gender. "M" for male, "F" for female, and "N" for neutral.
Use Demographic Data When Available
Check this item if you want to use the more accurate demographic-derived gender. This option is available for Output Name1 Gender only.


Name 2

This section contains a second set of name components for when your input contains two names. The columns here have the same definitions as the columns contained under Name 1.


Salutation

Salutation
Output a salutation. E.g. "Dear Mr. Preston."


Address

Company
Output the company or organization.
Address
Output the address.
Address 2
Output the 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
Output the city.
State
Output the US State or Canadian Province.
ZIP Code
Output the US ZIP Code or Canadian Postal Code.
Country
Output the Country.
AddressKey
Output the AddressKey. The AddressKey is a unique identifier for a given address and is required as input for some other Melissa Data products.
MAK and Base MAK
A unique key assigned to the submitted address (MAK) and base address of a complex with apartments or suites (Base MAK). For more information, see Melissa Address Key.


GeoLocation

Latitude and Longitude
Output the latitude and longitude.
Link to Map Location
US Check and Verify use the returned Address and Latitude Longitude pair to create a hyperlink to the specified Map Server. Unverified records with no returned Lat Long pair, may therefore display a map to the user’s local area determined by the selected Map Server.


Phone

Phone
Output the phone number. The number will be formatted in the selected format below.
Format
(800) 800-6245
(800) 800 6245
800-800-6245
800 800 6245
800.800.6245
8008006245


E-mail

E-mail
Output the e-mail address.


Address Information

Address Type
Output the Address Type.
Code Description
S Standard Address
G General Delivery Address
M Military Address
P PO Box Address
R Rural Route Address
U Unique/LVR Address
Delivery Indicator
Output the Delivery Indicator.
Code Description
B Business Address
R Residential Address
U Unknown Address
Extra Address Information
Output extra information that does not fit in any of the output address columns.
Suite
Output the suite.
If requested, the suite will be populated in this column instead of the output address columns.
Private Mailbox
Output the 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)
Output the urbanization name. These are used only in Puerto Rican addresses.
City Abbreviation
Output the city abbreviation if any is available.
State Name
Output the full state name.
ISO Country Code
Output the ISO country code.
Carrier Route
Output the Carrier Route (CRRT.) This is a 4-character code defining the carrier route for the address.
Delivery Point
Output the 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.
Universal Time Code
Output the Universal Time Code (UTC.) This indicates the amount of hours:minutes offset from Greenwich Mean Time (GMT.)


Census Information

CBSA Code
Output the Census Bureau Core-Based Statistical Area (CBSA) code. This is a 5-digit code for the address.
CBSA Title
Output the Title describing the CBSA code.
CBSA Level
Output the Level of the CBSA code. If present, the CBSA Level will be Metropolitan or Micropolitan.
Divisional CBSA Code
Output the CBSA representing the division associated with the address.
Divisional CBSA Title
Output the Title describing the Divisional CBSA code.
Divisional CBSA Level
Output the Level of the Divisional CBSA code. If present, the Divisional CBSA Level will be Metropolitan or Micropolitan.
County Name
Output the County name.
County FIPS Code
Output the County FIPS code. This is a 5-digit code. The first two digits indicate the state while the last three digits indicate the county within the state.
Census Block
Output the Census Block. This is a 4-digit string indicating the Census Block number associated with the address. Census Blocks are the smallest geographic area for which the Bureau of the Census collects information.
Census Tract
Output the Census Tract. This is a 4 to 6-digit string containing the Census Tract number associated with the address. Census Tracts are small subdivisions of the county.
Place Name
Output the Place Name. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Name will refer to that area.
Place Code
Output the Place Code. When ZIP Codes overlap, the returned city will indicate the city that covers the majority of the ZIP area; for addresses located outside the city but within the ZIP Code, the Place Code will refer to that area.
Congressional District
Output the Congressional District. This is a 2-digit code indicating the address's congressional district.
CensusKey
Check this item if you want the Census Key.
CountySubdivisionCode
Check this item if you want the output County Subdivision Code.
CountySubdivisionName
Check this item if you want the output Upper State District Code.
StateDistrictUpper
Check this item if you want the output Upper State District Code.
StateDistrictLower
Check this item if you want the output Lower State District Code.
ElementarySchoolDistrictCode
Check this item if you want the output Elementary School District Code.
ElementarySchoolDistrictName
Check this item if you want the output Elementary School District Name.
SecondarySchoolDistrictCode
Check this item if you want the output Secondary School District Code.
SecondarySchoolDistrictName
Check this item if you want the output Secondary School District Name.
UnifiedSchoolDistrictCode
Check this item if you want the output Unified School District Code.
UnifiedSchoolDistrictName
Check this item if you want the output Unified School District Name.


Demographics

Date of Birth
Output the Date of Birth demographic. The date of birth will be formatted: yyyy-mm (no day will be specified.)
Date of Death
Output the Date of Death demographic. The date of death will be formatted: yyyy-mm-dd.
Household Income
Output the household income demographic.
Residence Type
Output the residence type demographic.
Code Description
DR Definite Renter
PR Inferred Renter
PO Inferred Owner
DO Definite Owner
Length of Residence
Output the length of residence demographic (i.e., the number of years at the current residence.)
Occupation
Output the occupation demographic.
Marital Status
Output the marital status demographic.
Code Description
Unknown
DS Definitely Single
PS Inferred Single
PM Inferred Married
DM Definitely Married
Presence of Children
Output the children demographic.
Code Description
Y Yes
N No
Education
Returns the highest level of education completed by an individual.
Household Size
Returns the number of occupants in the household.
Political Party
Returns an individual’s political affiliation.
Presence of Senior
Returns the presence of senior/s in the household.
Credit Card User
Returns whether the user has a credit card or not.
Ethnic Code
Returns an individual’s specific ethnicity.
Ethnic Group
Returns the grouped category for a person’s ethnicity. This is a more generalized grouping compared to Ethnic Codes.
Child Age Range
Returns the age range of children in the household.


Property

Assessors Parcel Number (APN)
Output the formatted Assessor's Parcel Number (APN.) This is present for 99% of properties.
Owner Name
Output the property owner's name. This is present for 45% of properties.
Owner Address
Output the property owner's address. This is present for 98% of properties.
Improvement Value
Output the Calculated Improvement Value. This is closed to the current market value, and is used for assessment by tax agencies. This is present for 59% of properties.
Estimated Home Value
Output the estimated home value.
Assessed Property Value
Output the Total Assessed value. This is parcel plus improvement values. This is present for 92% of properties.
Tax Amount
Output the property's total tax amount. This is present for 89% of properties.
Last Sale Date
Output the property's sale date, formatted yyyy-mm-dd. This is present for 47% of properties.
Last Sale Price
Output the property's sale price. This is present for 46% of properties.
Acreage
Output the total land area in acres. This is present for 86% of properties.
Property Square Footage
Output the property's square footage. This is present for 8% of properties.
Building Square Footage
Output the total building area in square feet. This is present for 35% of properties.
Year Built
Output the original building's year of construction. This is present for 55% of properties.
Total Rooms
Output the property's number of rooms in the primary building. This is present for 27% of properties.
Bedrooms
Output the total number of bedrooms in the primary building. This is present for 39% of properties.
Bathrooms
Output the property's total bathrooms. This is present for 48% of properties.
Mortgage Term
Output the property's mortgage term. This is present for 19% of properties.
Mortgage Due Date
Output the property's mortgage due date. This is present for 19% of properties.
Mortgage Amount
Output the property's mortgage amount. This is present for 27% of properties.


Parsed Address

House Number
Output the parsed House Number for the output address.
Street Pre-Directional
Output the parsed Street Pre-Directional for the output address.
Street Name
Output the parsed Street Name for the output address.
Street Suffix/Type
Output the parsed Street Suffix (a.k.a. Street Type) for the output address.
Street Post-Directional
Output the parsed Post-Direction for the output address.
Suite Name
Output the parsed Suite Name for the output address.
Suite Number
Output the parsed Suite Number for the output address.
Private Mailbox Name
Output the parsed Private Mailbox Name for the output address.
Private Mailbox Number
Output the parsed Private Mailbox Number for the output address.
Route Service Number (CAN Only)
Output the parsed Route Service Number for the output address.
Canada Only.
Delivery Installation (CAN Only)
Output the parsed Delivery Installation for the output address.
Canada Only.
Lock Box Number (CAN Only)
Output the parsed Lock Box Number for the output address.
Canada Only.