Personator:Output Columns

← Personator

Default Columns

AddressExtras

Any extra information that does not fit in the AddressLine fields.

AddressKey

Returns a unique identifier for an address. This key can be used with other current and future Melissa services.

AddressLine1

Returns the address entered in the AddressLine field. If two addresses were entered and only one is valid, the valid address is returned instead. This includes the suite and private mailbox.

AddressLine2

If two addresses are passed into the AddressLine field, the second address is returned here. If only one of two addresses is valid, the valid address will be returned in AddressLine1.

City

Returns the city entered in the City field.

CompanyName

Returns the company name.

EmailAddress

Returns the email address entered in the Email field.

MelissaAddressKey

Returns a unique key associated with an address.

MelissaAddressKeyBase

Returns a unique key associated with a building containing multiple suites/apartments.

NameFull

Returns the full name for the record.

PhoneNumber

Returns the standardized phone number for the record.

PostalCode

Returns the 9-digit postal code for U.S. addresses and 6-digit postal code for Canadian addresses.

State

Returns the state for the record.

No Group Columns

These columns are not default and have no group. They normally will not be needed unless for specific legacy requirements.

MoveDate

Returns the date associated with the move address.

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.

PrivateMailBox

Returns the private mail box number for the address in the AddressLine 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.

Suite

Returns the suite for the address in the AddressLine field, if any. If requested, the suite will be populated in this field instead of the Address field.

Address Details Group Columns

These columns are not default and belong to the GrpAddressDetails group.

AddressTypeCode

Returns a code for the address type in the AddressLine field. Please see the appendix for the list of possible codes.

CarrierRoute

Returns a 4-character code defining the carrier route for this record.

CityAbbreviation

Returns an abbreviation for the city entered in the City field, if any.

CountryCode

Returns the country code for the country in the Country field.

CountryName

Returns the country name for the record.

DeliveryIndicator

Returns an indicator of whether an address is a business address or residential address.

Code	Definition
B	Business
R	Residential
U	Unknown

DeliveryPointCheckDigit

Returns a string value containing the 1-digit delivery point check digit.

DeliveryPointCode

Returns a string value containing the 2-digit delivery point code.

StateName

Returns the full name of the state entered in the State field.

UrbanizationName

Returns the urbanization name for the address entered in the AddressLine field. Usually only used if the address is in Puerto Rico.

UTC

Returns the time zone of the requested record. All Melissa Data products express time zones in UTC (Coordinated Universal Time).

Census Group Columns

These columns are not default and belong to the GrpCensus group.

CBSACode

Census Bureau’s Core Based Statistical Area (CBSA). Returns the 5-digit code for the CBSA associated with the requested record.

CBSADivisionCode

Returns the code for a division associated with the requested record, if any.

CBSADivisionLevel

Returns whether the CBSA division, if any, is metropolitan or micropolitan.

CBSADivisionTitle

Returns the title for the CBSA division, if any.

CBSALevel

Returns whether the CBSA is metropolitan or micropolitan.

CBSATitle

Returns the title for the CBSA.

CensusBlock

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.

CensusTract

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.

CongressionalDistrict

Returns the 2-digit congressional district that belongs to the requested record.

CountyFIPS

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.

CountyName

Returns the county name.

PlaceCode,PlaceName

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, PlaceCode/PlaceName will refer to that area.

Census Group Columns 2

CensusKey

Returns a 15 digit string containing the concatenated County FIPS, Census Tract and Census Block.

CountySubdivisionCode

Returns a 5 digit string representing the County Subdivision Code for the requested record.

CountySubdivisionName

Returns the County Subdivision Name for the requested record.

ElementarySchoolDistrictCode

Returns a 5 digit string representing the Elementary School District Code for the requested record.

ElementarySchoolDistrictName

Returns the Elementary School District Name for the requested record.

SecondarySchoolDistrictCode

Returns a 5 digit string representing the Secondary School District Code for the requested record.

SecondarySchoolDistrictName

Returns the Secondary School District Name for the requested record.

UnifiedSchoolDistrictCode

Returns a 5 digit string representing the Unified School District Code for the requested record.

UnifiedSchoolDistrictName

Returns the Secondary Unified District Name for the requested record.

StateDistrictUpper

Returns a 3 digit string representing the Upper State District Code for the requested record.

StateDistrictLower

Returns a 3 digit string representing the Lower State District Code for the requested record.

GeoCode Group Columns

These columns are not default and belong to the GrpGeocode group.

Latitude

Returns the geocoded latitude for the address entered in the AddressLine field.

Longitude

Returns the geocoded longitude for the address entered in the AddressLine field.

Demographic Basic Group Columns

If any demographics are enabled, <DemographicsResults> will return a comma delimited string containing all the results of the demographics combined.

DateOfBirth

Returns the date of birth in the format YYYYMM. Accuracy is only to the month.

HouseholdIncome

Returns the range of the household's income.

Code Definition ID00 Unknown ID01 $0-$15,000 ID02 $15,001-$20,000 ID03 $20,001-$30,000 ID04 $30,001-$40,000 ID05 $40,001-$50,000 ID06 $50,001-$60,000 ID07 $60,001-$75,000 ID08 $75,001-$100,000 ID09 $100,001-$125,000 ID10 $125,001-$150,000 ID11 $150,001+

LengthOfResidence

Returns the range of the individual's length of residency in their current address.

Value Less than 1 year 1-2 years 2-3 years 3-4 years 4-5 years 5-6 years 6-7 years 7-8 years 8-9 years 9-10 years 10-11 years 11-12 years 12-13 years 13-14 years 14-15 years 15+ years Unknown

PresenceOfChildren

Returns the presence of children in the household.

Value Unknown No Children Present Children Present

MaritalStatus

Returns the individual's marital status.

Value Unknown Definitely Single Inferred Single Inferred Married Definitely Married

DateOfDeath

Returns the full date of death in the format YYYYMMDD.

DemographicsGender

Returns gender based on demographics data.

Value Unknown Male Female Neutral

OwnRent

Returns the individual's status as owner or renter of the property.

Value Unknown Definite Renter Inferred Renter Inferred Owner Definite Owner

Occupation

Returns the category for the individual's occupation.

Value Physician/Dentist Healthcare Lawyer/Judge Professional/Technical Management Teacher/Educator Sales/Marketing Clerical/Service Worker Tradesmen/Laborer Farmer Student Homemaker Retired Federal Employee Unknown Military Military Retired Other Business Owner Religious Self Employed Financial

Name Details Group Columns

These columns are not default and belong to the GrpNameDetails group.

Gender

Returns a gender for the name in the FullName field.

Gender2

Only used if 2 names are in the FullName field. Returns a gender for the second name in the FullName field.

NameFirst

Returns the first name in the FullName field.

NameFirst2

Only used if 2 names are in the FullName field. Returns the second name in the FullName field.

NameLast

Returns the last name in the FullName field.

NameLast2

Only used if 2 names are in the FullName field. Returns a last name for the second name in the FullName field.

NameMiddle

Returns a middle name for the name in the FullName field.

NameMiddle2

Only used if 2 names are in the FullName field. Returns a middle name for the second name in the FullName field.

NamePrefix

Returns a prefix for the name in the FullName field.

NamePrefix2

Only used if 2 names are in the FullName field. Returns a prefix for the second name in the FullName field.

NameSuffix

Returns a suffix for the name in the FullName field.

NameSuffix2

Only used if 2 names are in the FullName field. Returns a suffix for the second name in the FullName field.

Salutation

Returns a salutation for the name in the FullName field.

Parsed Address Group Columns

These columns are not default and belong to the GrpParsedAddress group.

AddressDeliveryInstallation (Canada Only)

Returns the parsed delivery installation for the address entered in the AddressLine field.

AddressHouseNumber

Returns the parsed house number for the address entered in the AddressLine field.

AddressLockBox (Canada Only)

Returns the parsed lock box number for the address entered in the AddressLine field.

AddressPostDirection

Returns the parsed post-direction for the address entered in the AddressLine field.

AddressPreDirection

Returns the parsed pre-direction for the address entered in the AddressLine field.

AddressPrivateMailboxName

Returns the parsed private mailbox name for the address entered in the AddressLine field.

AddressPrivateMailboxRange

Returns the parsed private mailbox range for the address entered in the AddressLine field.

AddressRouteService (Canada Only)

Returns the parsed route service number for the address entered in the AddressLine field.

AddressStreetName

Returns the parsed street name for the address entered in the AddressLine field.

AddressStreetSuffix

Returns the parsed street suffix for the address entered in the AddressLine field.

AddressSuiteName

Returns the parsed suite name for the address entered in the AddressLine field.

AddressSuiteNumber

Returns the parsed suite number for the address entered in the AddressLine field.

Parsed Email Group Columns

These columns are not default and belong to the GrpParsedEmail group.

DomainName

Returns the parsed domain name for the email entered in the Email field.

MailboxName

Returns the parsed mailbox name for the email entered in the Email field.

TopLevelDomain

Returns the parsed top-level domain name for the email entered in the Email field.

Parsed Phone Group Columns

These columns are not default and belong to the GrpParsedPhone group.

AreaCode

Returns the parsed area code for the phone number entered in the Phone field.

NewAreaCode

Returns the parsed new area code for the phone number entered in the Phone field.

PhoneCountryCode

Returns the 2 character country code for the phone number entered in the Phone field.

PhoneCountryName

Returns the full country name for the phone number entered in the Phone field.

PhoneExtension

Returns the parsed extension for the phone number entered in the Phone field.

PhonePrefix

Returns the parsed prefix for the phone number entered in the Phone field.

PhoneSuffix

Returns the parsed suffix for the phone number entered in the Phone field.