tPersonator output schema - 7.3

Melissa Data address standardization

Version
7.3
Language
English (United States)
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components

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