Siebel Data Quality Administration Guide > Configuring Siebel Data Quality > Siebel Data Quality User Properties >

Data Cleansing User Properties


The following data cleansing user properties are described in this topic:

DataCleansing Field n

This user property allows you to specify a correspondence between a field name in the vendor Connector and a field name in the Siebel application.

Parent Object Type

Business Component

Value

The value for the DataCleansing Field user property uses the following syntax:

"[Vendor Field Name]", "[Siebel Field Name]"

For example, the following value specifies a correspondence between the Firm Location field in the Vendor Connector and the Primary Account Location field in the Siebel application.

"Firm Location", "Primary Account Location"

Usage

Used for Siebel Data Quality, which performs address verification, name and address standardization, and duplicate record identification, in real-time and batch modes.

NOTE:  All data quality user properties require components from the vendor's Corporation.

See also Siebel Developer's Reference.

DataCleansing Type

This user property allows you to specify to the vendor Connector what kind of data is being validated in the Data Cleansing Field.

Parent Object Type

Business Component

Value

The value for the DataCleansing Type user property must be one of the following:

  • Contact   indicates that the data consists of person name records.
  • Account   indicates that data consists of business or office name records.
  • Address   indicates that data consists of postal addresses.

All types have capitalization validated.

Usage

Data cleansing operates differently on each of these types. For example, business components with Address cleansing have reconciliation performed between address fields and the ZIP (Postal Code) field.

Siebel Data Quality Administration Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.