Table of Contents

Search

  1. Preface
  2. Introduction
  3. Informatica IDQ Cleanse Engine
  4. Informatica Address Verification Cleanse Engine
  5. Trillium Director Cleanse Engine
  6. 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!