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

Informatica Address Verification 5 Input Fields

Informatica Address Verification
5 Input Fields

The input 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 input 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 Input Field Name
Field #
Description
ACComplete
-
Contains the formatted address, with each formatted address line separated by a vertical bar character ('|').
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 job 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
1-3
See examples 1, 2, 3, and 4.
AEDeliveryService#ADD_INFO
1-3
Contains additional delivery service information that passes through validation unchanged.
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
-
AEKey#TRANSACTION_KEY
1-3
-
AELocality#ADD_INFO
1-6
Contains locality information that passes through validation unchanged.
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 that defines where mail is sorted for localities with more than one sorting location.
AENumber#ADD_INFO
1-6
Contains additional street number information that passes through validation unchanged.
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.
AEStreet#ADD_INFO
1-6
Contains additional street information that passes through validation unchanged.
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.
MDMCorrectionType
-
This input has these possible values:
  • CORRECT_ONLY. In this mode,
    Informatica Address Verification
    performs address standardization and validates the address components against address reference tables. This is the equivalent to Batch mode.
  • CERTIFY_ONLY. In this mode,
    Informatica Address Verification
    validates an address according to the certification rules defined by the local postal authority. In the US, Certify_Only mode uses CASS. This is equivalent to Certified mode.
  • CORRECT_THEN_CERTIFY. In this mode,
    Informatica Address Verification
    process the address in Batch mode and then in Certified mode.
  • TRY_CERTIFY_THEN_CORRECT. In this mode,
    Informatica Address Verification
    processes the address in Certified mode. If issues are encountered, the address is processed again in Batch mode.
  • PARAMETERS_DEFAULT. In this mode, the correction type is derived from the
    Parameters.xml
    file.
  • PARSE_ONLY. In this mode,
    Informatica Address Verification
    parses the address, but does not correct or certify the address.

0 COMMENTS

We’d like to hear from you!