Dynamics:Personator:Fields

← Clean Suite for CRM:Dynamics

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.