Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Multidomain MDM 10.3 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction
  3. Informatica IDQ Cleanse Engine
  4. Informatica Address Verification Cleanse Engine
  5. FirstLogic Direct Cleanse Engine
  6. Trillium Director Cleanse Engine
  7. SAP Data Services XI Cleanse Engine
  8. Troubleshooting

Cleanse Adapter Guide

Cleanse Adapter Guide

Back Next

Informatica Address Verification 5 Output Fields

The output field names in
Informatica Address Verification
 5 are different than those in
Informatica Address Verification
 4. See the descriptions and examples in the following table to understand what data is handled by a particular field.
The following table lists all the
Informatica Address Verification
 5 output fields. The 'Field #' column indicates the range of fields available. For example, the available field names for AEBuilding#COMPLETE are: AEBuilding1COMPLETE, AEBuilding2COMPLETE, AEBuilding3COMPLETE, AEBuilding4COMPLETE, AEBuilding5COMPLETE, and AEBuilding6COMPLETE.
Informatica Address Verification
 5 Output Field Name
Field #
Description
ACComplete
-
Contains the formatted address, with each formatted address line separated by a vertical bar character. For example, addressline1|addressline2|addressline3.
AEBuilding#COMPLETE
1-6
See example 3.
AEBuilding#COMPLETE_WITH_SUBBUILDING
1-6
Contains the complete building and subbuilding information.
AEBuilding#DESCRIPTOR
1-6
See example 3.
AEBuilding#NAME
1-6
See example 3.
AEBuilding#NUMBER
1-6
Contains the building number.
AEContact#COMPLETE
1-3
See examples 1, 2, 3, and 4.
AEContact#FIRST_NAME
1-3
See examples 1, 2, 3, and 4.
AEContact#FUNCTION
1-3
Contains the job function of the contact.
AEContact#GENDER
1-3
Contains the gender of the contact.
AEContact#LAST_NAME
1-3
See examples 1, 2, 3, and 4.
AEContact#MIDDLE_NAME
1-3
See examples 1, 2, and 3.
AEContact#NAME
1-3
See examples 1, 2, 3, and 4.
AEContact#SALUTATION
1-3
See examples 1, 2, 3, and 4.
AEContact#TITLE
1-3
Contains the title of the contact.
AECountry#ABBREVIATION
1-3
Contains the abbreviated country name.
AECountry#ISO_NUMBER
1-3
See example 4.
AECountry#ISO2
1-3
See examples 1, 2, 3, and 4.
AECountry#ISO3
1-3
See examples 1, 2, 3, and 4.
AECountry#NAME_CN
1-3
Contains the name of the country in Chinese.
AECountry#NAME_DA
1-3
Contains the name of the country in Danish.
AECountry#NAME_DE
1-3
Contains the name of the country in German.
AECountry#NAME_EN
1-3
Contains the name of the country in English. See examples 1, 2, 3, and 4.
AECountry#NAME_ES
1-3
Contains the name of the country in Spanish.
AECountry#NAME_FI
1-3
Contains the name of the country in Finnish.
AECountry#NAME_FR
1-3
Contains the name of the country in French.
AECountry#NAME_GR
1-3
Contains the name of the country in Greek.
AECountry#NAME_HU
1-3
Contains the name of the country in Hungarian.
AECountry#NAME_IT
1-3
Contains the name of the country in Italian.
AECountry#NAME_JP
1-3
Contains the name of the country in Japanese.
AECountry#NAME_KR
1-3
Contains the name of the country in Korean.
AECountry#NAME_NL
1-3
Contains the name of the country in Dutch.
AECountry#NAME_PL
1-3
Contains the name of the country in Polish.
AECountry#NAME_PT
1-3
Contains the name of the country in Portuguese.
AECountry#NAME_RU
1-3
Contains the name of the country in Russian.
AECountry#NAME_SA
1-3
Contains the name of the country in Arabic.
AECountry#NAME_SE
1-3
Contains the name of the country in Swedish.
AEDeliveryService#ADD_INFO
1-3
Contains additional delivery service information.
AEDeliveryService#COMPLETE
1-3
See example 1.
AEDeliveryService#DESCRIPTOR
1-3
See example 1.
AEDeliveryService#NUMBER
1-3
See example 1.
AEKey#RECORD_ID
1-3
Contains the record ID.
AEKey#TRANSACTION_KEY
1-3
Contains the transaction key.
AELocality#ADD_INFO
1-6
Contains portions of the locality that could not be validated against reference data.
AELocality#COMPLETE
1-6
See examples 1, 2, 3, and 4.
AELocality#NAME
1-6
See examples 1, 2, 3, and 4.
AELocality#SORTING_CODE
1-6
Contains a sorting code defining where mail is sorted for localities with more than one sorting location.
AENumber#ADD_INFO
1-6
Contains portions of the street number that could not be validated against reference data.
AENumber#COMPLETE
1-6
See example 3.
AENumber#DESCRIPTOR
1-6
See example 3.
AENumber#NUMBER
1-6
See examples 1, 2, 3, and 4.
AEOrganization#COMPLETE
1-3
See example 4.
AEOrganization#DEPARTMENT
1-3
See example 4.
AEOrganization#DESCRIPTOR
1-3
See example 4.
AEOrganization#NAME
1-3
See example 4.
AEPostalCode#FORMATTED
1-3
See example 2.
AEPostalCode#UNFORMATTED
1-3
See example 2.
AEPostalCode#Base
1-3
See example 2.
AEPostalCode#ADD_ON
1-3
See example 2.
AEProvince#ABBREVIATION
1-6
Contains the abbreviated province name.
AEProvince#COUNTRY_STANDARD
1-6
Contains the standard province name.
AEProvince#EXTENDED
1-6
See example 2.
AEProvince#ISO
1-6
Contains the ISO province code.
AEResidue#NECESSARY
1-6
In parsing mode: contains address data that is redundant.
AEResidue#SUPERFLUOUS
1-6
In batch, certified, fast completion, or interactive mode: contains address data that is redundant.
AEResidue#UNRECOGNIZED
1-6
Contains data that cannot be parsed to an address port.
AEStreet#ADD_INFO
1-6
Contains portions of the street information that could not be validated against reference data.
AEStreet#COMPLETE
1-6
See examples 1, 2, 3, and 4.
AEStreet#COMPLETE_WITH_NUMBER
1-6
See examples 1, 2, 3, and 4.
AEStreet#NAME
1-6
See examples 1, 2, 3, and 4.
AEStreet#POST_DESCRIPTOR
1-6
See examples 1, 2, 3, and 4.
AEStreet#POST_DIRECTIONAL
1-6
See example 4.
AEStreet#PRE_DESCRIPTOR
1-6
Contains street descriptors that appear before the street name.
AEStreet#PRE_DIRECTIONAL
1-6
See example 2.
AESubBuilding#COMPLETE
1-6
See example 3.
AESubBuilding#DESCRIPTOR
1-6
See example 3.
AESubBuilding#NAME
1-6
See example 3.
AESubBuilding#NUMBER
1-6
See example 3.
ALCountrySpecificLocalityLine#
1-6
See example 5.
ALDeliveryAddressLine#
1-6
See example 5.
ALFormattedAddressLine#
1-19
See example 5.
ALRecipientLine#
1-6
See example 5.
EDCASSStatus
-
Indicates if the address contains enough data for USPS Coding Accuracy Support System (CASS) certification.
EDGeoCodingStatus
-
Indicates the level of accuracy of the Geocode value.
EDSERPStatus
-
Indicates if the address contains enough data for Canada Post Software Evaluation and Recognition Program (SERP) certification.
EDSNAStatus
-
Indicates if the address contains enough data for France's La Post National Address Management Service (SNA) certification.
EDSupplementaryGBStatus
-
Indicates whether GB country-specific output is available.
EDSupplementaryUSStatus
-
Indicates whether US country-specific output is available.
EECASSBARCODE
-
Contains the USPS barcode number for the address.
EECASSCARRIER_ROUTE
-
Contains the USPS carrier route for a US address.
EECASSCONGRESSIONAL_DISTRICT
-
Contains the congressional district based on the United States Postal Service (USPS) Zip+4 code.
EECASSDEFAULT_FLAG
-
Indicates if a US address matches a high-rise exact, high-rise default, or rural route default address in the reference data.
EECASSDELIVERY_POINT
-
Contains a unique Delivery Point Code (DPC) assigned to each USPS address in a Zip+4 code area.
EECASSDELIVERY_POINT_CHECK_DIGIT
-
Contains a number between 0 and 9 that, when added with the digits in the USPS Zip+4 and DPC, create a sum divisible by 10.
EECASSDPV_CMRA
-
Indicates if the address is for a USPS Commercial Mail Receiving Agent (CMRA), such as a post office box, and not the physical location of a business or residence.
EECASSDPV_CONFIRMATION
-
Contains a code indicating to what degree the USPS DPC value is valid.
EECASSDPV_FALSE_POSITIVE
-
Indicates whether an address was generated from encrypted USPS reference data.
EECASSDPV_FOOTNOTE_1
-
Indicates whether the address matches the USPS Zip+4 code data.
EECASSDPV_FOOTNOTE_2
-
Contains a DPV status code.
EECASSDPV_FOOTNOTE_3
-
Indicates whether an address is a USPS CMRA.
EECASSDPV_FOOTNOTE_COMPLETE
-
Contains the combined data for the DPV footnotes 1, 2, and 3.
EECASSDSF2_NOSTATS_INDICATOR
-
Indicates whether a USPS address is valid but undeliverable.
EECASSDSF2_VACANT_INDICATOR
-
Indicates whether a USPS address is inactive.
EECASSERRORCODE
-
Contains the CASS error code.
EECASSEWS_RETURNCODE
-
Indicates whether an address is in the USPS Early Warning System (EWS) list of new addresses that are not yet referenced to a ZIP+4 level.
EECASSHIGHRISE_DEFAULT
-
Indicates whether a USPS address matches a high-rise record in the address reference data and does not contain a unit identifier.
EECASSHIGHRISE_EXACT
-
Indicates whether a USPS address matches a high-rise record in the address reference data and also contains a unit identifier.
EECASSLACS
-
Indicates whether a United States address is present in the USPS Locatable Address Conversion Service (LACS) table.
EECASSLACSLINK_INDICATOR
-
Indicates if the address validator checks the address against the USPS LACS reference database.
EECASSLACSLINK_RETURNCODE
-
Indicates the degree to which the input address matches USPS LACS data and whether the address validation process updated the address.
EECASSRECORDTYPE
-
Contains additional information about the deliverable status of non-DPC USPS addresses.
EECASSRURALROUTE_DEFAULT
-
Indicates if the address is a valid rural route but exact data is unavailable.
EECASSRURALROUTE_EXACT
-
Indicates if the address matches a rural route address in the USPS address reference data set.
EECASSSUITELINK_RETURNCODE
-
Identifies high-rise business addresses in the United States that lack suite identification information.
EECASSZIPMOVE_RETURNCODE
-
Indicates if the USPS has recently changed the ZIP+4 Code assigned to the address.
EEGeoCodingCOMPLETE
-
Contains the complete geocode coordinates for the output address.
EEGeoCodingLATITUDE
-
Contains the latitude coordinate of the address.
EEGeoCodingLONGITUDE
-
Contains the longitude coordinate of the address.
EEGeoCodingLAT_LONG_UNIT
-
Contains the latitude and longitude unit of measure.
EESERPCATEGORY
-
Contains the SERP Certification status code.
EESNACATEGORY
-
Contains the SNA Certification status code.
EESupplementaryGBDELIVERY_POINT_ SUFFIXES
-
Contains the two-character suffix assigned to a mailbox in a UK post code area (Royal Mail).
EESupplementaryUSCBSA_ID
-
Contains a USPS Core-Based Statistical Area (CBSA) identification number. A CBSA identifies an urban area with a population greater than 10,000.
EESupplementaryUSCOUNTY_FIPS_CODE
-
Contains the US Federal Information Processing Standard (FIPS) Code that identifies a county or county equivalent in the United States and United States possessions.
EESupplementaryUSFINANCE_NUMBER
-
Contains the code assigned to United States post offices and other postal facilities to enable collection of cost and statistical data.
EESupplementaryUSMSA_ID
-
Contains the USPS Metropolitan Statistical Area identification number. This number identifies an urban area with a population greater than 50,000.
EESupplementaryUSRECORD_TYPE
-
Contains a single-character code that describes the type of mailbox.
EESupplementaryUSSTATE_FIPS_CODE
-
Contains the FIPS Code that identifies a state or state equivalent in the United States and United States possessions.
MDMLastError
-
The MDM Last Error output. Not associated with the
Informatica Address Verification
 result.
RDElementInputStatus
-
Indicates the similarities between input address data and the address reference data.
RDElementRelevance
-
Indicates if an address element is required for postal delivery.
RDElementResultStatus
-
Contains a description of changes made to input address data elements during address validation.
RDMailabilityScore
-
Contains a single digit that represents the likelihood of successful delivery to the validated address, based on overall validation results.
RDResultPercentage
-
Indicates the percentage likelihood of successful delivery to the validated address.
RPCount
-
Contains the number number of results available.
RPCountOverflow
-
Indicates whether there are more results available than the 20 results that were returned.
RPCountryISO3
-
Contains the ISO3 country code.
RPModeUsed
-
Indicates which mode was used to process the address data.
RPPreferredLanguage
-
Identifies which language should be returned.
RPPreferredScript
-
Identifies which alphabet should be returned.
RPProcessStatus
-
Contains the process status value.
0 COMMENTS
We’d like to hear from you!