Personator:Output Columns
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 Data 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. Reference Guide Response Details 35 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. Response Details Personator 36 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. Reference Guide Response Details 37 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. Response Details Personator 38 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 the requested record belongs to. 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, Reference Guide Response Details 39 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. Response Details Personator 40 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. Reference Guide Response Details 41 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+ Response Details Personator 42 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 Reference Guide Response Details 43 Value 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 Response Details Personator 44 Value 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. Reference Guide Response Details 45 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. Response Details Personator 46 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. Reference Guide Response Details 47 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. Response Details Personator 48 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.