Personator:Output Columns: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 1: Line 1:
[[Personator|← Personator]]
[[Personator|← Personator]]
{{CustomTOC}}
{{CustomTOC}}
*ChildrenAgeRange?
*CreditCardUser?
*Education?
*HouseholdSize?
*PoliticalParty?
*PresenceOfSenior?
*RecordExtras?
*RecordID?
*Reserved?
*TypeOfVehicles?
*PlaceCode/PlaceName???
*AddressDeliveryInstallation (Canada Only)???
*AddressRouteService (Canada Only)???
*AddressLockBox (Canada Only)???


==Default Columns==
==Default Columns==

Latest revision as of 23:16, 18 July 2017

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