View source for Dynamics:Personator:Fields

{{DynamicsPersonatorNav}}


{{CustomTOC}}

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


[[Category:Clean Suite for CRM:Dynamics]]
[[Category:Dynamics Personator]]