Configuring Data Cleansing

The data cleansing options control address validation. Address validation involves matching and standardizing a U.S., Canadian, or International address against the Pitney Bowes address databases.

Note: The Cleansing Status Flag (Succeeded , Failed , Not Yet Cleansed) are shown only in views where addresses can be added or modified.
  1. From the Siebel window, click Navigate > Site Map.
  2. Click Administration - PBBI Group 1 Data Quality Administration.
  3. Under the PBBI Group 1 Data Quality Administration heading at the top of the page, click Options Manager.
  4. Configure the options. When you are done, click Save Changes. Use Clear Cache to reset the options.
    Table 1. Data Cleansing Options

    Option

    Values

    Description

    Business Address Cleansing

    Enable, Disable

    Specifies whether cleansing is enabled for business address. A business address is one used for business purposes It is associated with a contact's account.

    If enabled, the selected options in the Management Console for ValidateAddress will be activated for processing for business addresses.

    Note: Check the Disable Cleansing column of the business address applet to deactivate the data cleansing for each business address.

    Personal Address Cleansing

    Enable, Disable

    Specifies whether cleansing is enabled for personal address. A personal address is associated with a contact.

    If enabled, the selected options in the Management Console for ValidateAddress will be activated for processing for personal addresses.

    Note: Check the Disable Cleansing column of the personal address applet to deactivate the data cleansing for each personal address.

    Prospect Address Cleansing

    Enable, Disable

    Specifies whether cleansing is enabled for prospect address.A prospect address is the personal address of a prospect.

    If enabled, the selected options in the Management Console for ValidateAddress will be activated during processing for prospect addresses.

    DPV

    Enable, Disable

    Specifies whether Delivery Point Validation will be performed. Delivery Point Validation (DPV®) validates that a specific address exists, as opposed to validating that a specific address is within a range of valid addresses.

    Note: This option is only available if the Delivery Point Validation option is enabled in the Management Console and if the DPV® database is installed.

    RDI

    Enable, Disable

    Specifies whether Residential Delivery Indicator process will be performed. Residential Delivery Indicator (RDI™) processing checks if an address is a residential address (not a business address). To perform RDI™ processing, you must have the RDI™ database installed.

    Note: This option is only available if the RDI™ option is enabled in the Management Console and if the RDI™ database is installed.

    The result of RDI™ processing is shown in a field added in Address Information that contains one of the following:

    • Residential - This value is returned by the Universal Coder in case the address entered by the user is a Residential Address
    • Business - This value is returned by the Universal Coder in case the address entered by the user is a Business Address
    • Mixed - This value is returned by the Universal Coder in case the address entered by the user is both a Residential and Business Address.

    ESM

    Enable, Disable

    Specifies whether Enhanced Street Matching process will be performed. Enhanced Street Matching (ESM) applies additional matching logic to correct misspelled or complex street names and obtain a match. ESM produces more validated addresses but reduces performance.

    Note: This option is only available if the ESM option is enabled in the Management Console.