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