Skip to main content Skip to complementary content

tPersonator output schema

The tPersonator component generates read-only columns that are all of type String. There are two types of output columns: dependent and default. Information is returned in the dependent output columns if you have selected the corresponding settings. The default output columns are independent of the settings.

The output columns contain one of the following types of information:
  • The input information.
  • The information returned by the Personator™ Consumer Web Service.
  • null: you have not selected the corresponding setting.
  • The column is empty: there is no information to return.

The default output columns

md_RecordID; md_AddressExtras; md_AddressKey; md_AddressLine1; md_AddressLine2; md_City; md_CompanyName; md_EmailAddress; md_MelissaAddressKey; md_PhoneNumber; md_PostalCode; md_Reserved; md_Results; md_RecordExtras.

These output columns depend on the Basic (Default) setting that is always enabled.

The dependent output columns

If you select... Information is returned in...
Address outputs Address details md_AddressTypeCode; md_CarrierRoute; md_CityAbbreviation; md_CountryCode; md_CountryName; md_DeliveryIndicator; md_DeliveryPointCheckDigit; md_DeliveryPointCode; md_StateName; md_UTC; md_UrbanizationName
Plus4 md_Plus4
Private mailbox md_PrivateMailBox
Suite md_AddressSuiteNumber; md_Suite
Parsed address md_AddressDeliveryInstallation; md_AddressLockBox; md_AddressPostDirection; md_AddressPreDirection; md_AddressPrivateMailboxName; md_AddressPrivateMailboxRange; md_AddressRouteService; md_AddressStreetName; md_AddressStreetSuffix; md_AddressSuiteName
Geographics outputs Census md_CBSACode; md_CBSADivisionCode; md_CBSADivisionLevel; md_CBSADivisionTitle; md_CBSALevel; md_CBSATitle; md_CensusBlock; md_CensusTract; md_CongressionalDistrict; md_CountyFIPS; md_CountyName; md_PlaceCode
Census 2 md_CensusKey; md_CountySubdivisionCode; md_CountySubdivisionName; md_ElementarySchoolDistrictCode; md_ElementarySchoolDistrictName; md_SecondarySchoolDistrictCode; md_SecondarySchoolDistrictName; md_StateDistrictLower; md_StateDistrictUpper; md_UnifiedSchoolDistrictCode; md_UnifiedSchoolDistrictName
Geocode md_Latitude; md_Longitude
Miscellaneous outputs Demographic details md_DateOfBirth; md_DateOfDeath; md_DemographicsGender; md_DemographicsResults; md_HouseholdIncome; md_LengthOfResidence; md_MaritalStatus; md_PresenceOfChildren
Name details md_Gender; md_Gender2; md_NameFirst; md_NameFirst2; md_NameFull; md_NameLast; md_NameLast2; md_NameMiddle; md_NameMiddle2; md_NamePrefix; md_NamePrefix2; md_NameSuffix; md_NameSuffix2; md_Salutation
Parsed email md_DomainName; md_MailboxName; md_TopLevelDomain
Parsed phone md_AreaCode; md_NewAreaCode; md_PhoneExtension; md_PhonePrefix; md_PhoneSuffix

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!