Dynamics:Personator:Fields

From Melissa Data Wiki
Jump to navigation Jump to search

← Clean Suite for CRM:Dynamics

Personator Navigation
Overview
Installation
Configuration
Custom Mapping
Tutorial
Fields
Result Codes
Result Codes



Personator Details

Basic Details

Full Name
Returns the full name for the record.
Company Name
Returns the company name.
Address Line 1
Returns the address entered in the Address Line field. If two addresses were entered and only one is valid, the valid address is returned instead. This includes the suite and private mailbox.
Address Line 2
If two addresses are passed into the Address Line field, the second address is returned here. If only one of two addresses is valid, the valid address will be returned in Address Line 1.
Suite
Returns the suite for the address in the Address Line field, if any. If requested, the suite will be populated in this field instead of the Address field.
Address Extras
Any extra information that does not fit in the Address Line fields.
Private MailBox
Returns the private mail box number for the address in the Address Line field, if any. Private mailboxes are private mail boxes in commercial mail receiving agencies, like a UPS Store. If requested, the Private mailbox will be populated in this field instead of the Address field.
City
Returns the city entered in the City field.
State
Returns the state for the record.
Postal Code
Returns the 9-digit postal code for U.S. addresses and 6-digit postal code for Canadian addresses.
Plus4
Returns the 4-digit plus4 for the input address. If this column is requested, the PostalCode field will only contain the 5-digit ZIP for U.S. addresses.
Address Key
Returns a unique identifier for an address. This key can be used with other current and future Melissa Data services.
Phone Number
Returns the standardized phone number for the record.
Email Address
Returns the email address entered in the Email field.


Census Details

County Name
Returns the county name.
County FIPS
Returns the FIPS code for the county in the County field. FIPS code is a 5-digit code. The first two digits are a state code and the last three indicate the county within the state.
Census Tract
Returns a 4-to 6-digit string containing the census tract number associated with the requested record. Census tracts are small subdivisions of a county.
Census Block
Returns a 4-digit string containing the census block number associated with the requested record. Census blocks are the smallest geographic area for which the Bureau of the Census collects and tabulates decennial census data.
Place Code
When ZIP codes overlap, the City field will always return the city that covers most of the ZIP area. If the address is located outside of that city but within the ZIP Code, Place Code or Place Name will refer to that area.
Place Name
When ZIP codes overlap, the City field will always return the city that covers most of the ZIP area. If the address is located outside of that city but within the ZIP Code, Place Code or Place Name will refer to that area.
CBSA Code
Census Bureau’s Core Based Statistical Area (CBSA). Returns the 5-digit code for the CBSA associated with the requested record.
CBSA Title
Returns the title for the CBSA.
CBSA Level
Returns whether the CBSA is metropolitan or micropolitan.
CBSA Division Code
Returns the code for a division associated with the requested record, if any.
CBSA Division Level
Returns whether the CBSA division, if any, is metropolitan or micropolitan.
CBSA Division Title
Returns the title for the CBSA division, if any.
Congressional District
Returns the 2-digit congressional district that the requested record belongs to.


Results

Results
Returns result codes specific to the record.
Melissa Address Key
Returns a propietary unique key assigned to the address record.
Record Extras
Returns any extra details on the current record.
Record ID
Returns the unique identifier for the current record.


Name Details

Gender
Returns a gender for the name in the FullName field.
Gender 2
Only used if 2 names are in the Full Name field. Returns a gender for the second name in the Full Name field.
Salutation
Returns a salutation for the name in the Full Name field.
Name Prefix
Returns a prefix for the name in the Full Name field.
First Name
Returns the first name in the Full Name field.
Middle Name
Returns a middle name for the name in the Full Name field.
Last Name
Returns the last name in the Full Name field.
Name Suffix
Returns a suffix for the name in the Full Name field.
Prefix Name 2
Only used if 2 names are in the Full Name field. Returns a prefix for the second name in the Full Name field.
First Name 2
Only used if 2 names are in the Full Name field. Returns the second name in the Full Name field.
Middle Name 2
Only used if 2 names are in the Full Name field. Returns a middle name for the second name in the Full Name field.
Last Name 2
Only used if 2 names are in the Full Name field. Returns a last name for the second name in the Full Name field.
Name Suffix 2
Only used if 2 names are in the Full Name field. Returns a suffix for the second name in the Full Name field.


Parsed Address

Address House Number
Returns the parsed house number for the address entered in the Address Line field.
Address Pre Direction
Returns the parsed pre-direction for the address entered in the Address Line field.
Address Street Name
Returns the parsed street name for the address entered in the Address Line field.
Address Street Suffix
Returns the parsed street suffix for the address entered in the Address Line field.
Address Post Direction
Returns the parsed post-direction for the address entered in the Address Line field.
Address Suite Name
Returns the parsed suite name for the address entered in the Address Line field.
Address Suite Number
Returns the parsed suite number for the address entered in the Address Line field.
Address Private Mailbox Name
Returns the parsed private mailbox name for the address entered in the Address Line field.
Address Private Mailbox Range
Returns the parsed private mailbox range for the address entered in the Address Line field.


Parsed Email Details

Domain Name
Returns the parsed domain name for the email entered in the Email field.
Mailbox Name
Returns the parsed mailbox name for the email entered in the Email field.
Top Level Domain
Returns the parsed top-level domain name for the email entered in the Email field.


Census Details 2

Census Key
Returns a 15 digit string containing the concatenated County FIPS, Census Tract and Census Block.
County Subdivision Code
Returns a 5 digit string representing the County Subdivision Code for the requested record.
County Subdivision Name
Returns the County Subdivision Name for the requested record.
Elementary School District Code
Returns a 5 digit string representing the Elementary School District Code for the requested record.
Elementary School District Name
Returns the Elementary School District Name for the requested record.
Secondary School District Code
Returns a 5 digit string representing the Secondary School District Code for the requested record.
Secondary School District Name
Returns the Secondary School District Name for the requested record.
Unified School District Code
Returns a 5 digit string representing the Unified School District Code for the requested record.
Unified School District Name
Returns the Secondary Unified District Name for the requested record.
State District Lower
Returns a 3 digit string representing the Lower State District Code for the requested record.
State District Upper
Returns a 3 digit string representing the Upper State District Code for the requested record.


Address Details

City Abbreviation
Returns an abbreviation for the city entered in the City field, if any.
State Name
Returns the full name of the state entered in the State field.
Address Type Code
Returns a code for the address type in the Address Line field. Please see the appendix for the list of possible codes.
Country Code
Returns the country code for the country in the Country field.
Delivery Indicator
Returns an indicator of whether an address is a business address or residential address.
Urbanization Name
Returns the urbanization name for the address entered in the Address Line field. Usually only used if the address is in Puerto Rico.
Carrier Route
Returns a 4-character code defining the carrier route for this record.
Delivery Point Code
Returns a string value containing the 2-digit delivery point code.
Delivery Point Check Digit
Returns a string value containing the 1-digit delivery point check digit.
UTC
Returns the time zone of the requested record. All Melissa Data products express time zones in UTC (Coordinated Universal Time).


Pased Address (Canada Only)

Address Route Service (Canada Only)
Returns the parsed route service number for the address entered in the Address Line field.
Address Lock Box (Canada Only)
Returns the parsed lock box number for the address entered in the Address Line field.
Address Delivery Installation (Canada Only)
Returns the parsed delivery installation for the address entered in the Address Line field.


Geocode Details

Latitude
Returns the geocoded latitude for the address entered in the Address Line field.
Longitude
Returns the geocoded longitude for the address entered in the Address Line field


Phone Details

Area Code
Returns the parsed area code for the phone number entered in the Phone field.
New Area Code
Returns the parsed new area code for the phone number entered in the Phone field.
Phone Extension
Returns the parsed extension for the phone number entered in the Phone field.
Phone Prefix
Returns the parsed prefix for the phone number entered in the Phone field.
Phone Suffix
Returns the parsed suffix for the phone number entered in the Phone field.
Phone Country Code
Returns the 2 character country code for the phone number entered in the Phone field.
Phone Country Name
Returns the full country name for the phone number entered in the Phone field.


Demographics

Date Of Birth
Returns the date of birth in the format YYYYMM. Accuracy is only to the month.
Household Income
Returns the range of the household's income.
Length Of Residence
Returns the range of the individual's length of residency in their current address.
Own Rent
Returns the individual's status as owner or renter of the property.
Occupation
Returns the category for the individual's occupation.
Presence Of Children
Returns the presence of children in the household.
Marital Status
Returns the individual's marital status.
Date Of Death
Returns the full date of death in the format YYYYMMDD.
Demographics Gender
Returns gender based on demographics data.
Demographics Results
Returns the result codes for demographics.