Siebel Data Quality Administration Guide > Examples of Parameter and Field Mapping Values for Universal Connector > Universal Connector Parameter and Field Mapping Values for Oracle Data Quality Matching Server >

Preconfigured Field Mappings for Oracle Data Quality Matching Server


This topic includes information about the preconfigured Oracle Data Quality Matching Server (Informatica Identity Resolution) field mappings for the following business components:

Preconfigured Field Mappings for Business Component - Account

Table 30 shows the Oracle Data Quality Matching Server data matching field mappings for the Account business component and DeDuplication operation.

Table 30. Preconfigured Oracle Data Quality Matching Server Field Mappings for Account
Business Component Field
Mapped Field

DUNS Number

DUNSNumber

Name

Name

Primary Account City

PAccountCity

Primary Account Country

PAccountCountry

Primary Account Postal Code

PAccountPostalCode

Primary Account State

PAccountState

Primary Account Street Address

PAccountStrAddress

Row Id

RowId

Preconfigured Field Mappings for Business Component - Contact

Table 31 shows the Oracle Data Quality Matching Server data matching field mappings for the Contact business component and DeDuplication operation.

Table 31. Preconfigured Oracle Data Quality Matching Server Field Mappings for Contact
Business Component Field
Mapped Field

Birth Date

BirthDate

Cellular Phone #

CellularPhone

Email Address

EmailAddress

First Name Last Name

NAME

Home Phone #

HomePhone

Middle Name

MiddleName

Primary Account Name

Account

Primary Personal City

City

Primary Personal Country

Country

Primary Personal Postal Code

PrimaryPostalCode

Primary Personal State

State

Primary Personal Street Address

StreetAddress

Row Id

RowId

Social Security Number

SocialSecurityNumber

Work Phone #

Work Phone

Preconfigured Field Mappings for Business Component - List Mgmt Prospective Contact

Table 32 shows the Oracle Data Quality Matching Server data matching field mappings for the List Mgmt Prospective Contact business component and DeDuplication operation.

Table 32. Preconfigured Oracle Data Quality Matching Server Field Mappings for List Mgmt Prospective Contact
Business Component Field
Mapped Field

Account

Account

Cellular Phone #

CellularPhone

City

City

Country

Country

Email Address

EmailAddress

First Name Last Name

NAME

Home Phone #

HomePhone

Id

RowId

Middle Name

MiddleName

Postal Code

PostalCode

Social Security Number

SocialSecurityNumber

State

State

Street Address

StreetAddress

Work Phone

WorkPhone

Field Mappings for Business Component - CUT Address

Table 33 shows the data matching field mappings for the CUT Address business component and DeDuplication operation. In your Siebel application, you must manually add these field mappings if you want to configure deduplication against multiple addresses, which is supported only by Oracle Data Quality Matching Server. For more information, see Configuring Deduplication Against Multiple Addresses.

NOTE:  For Siebel Industry Applications, the CUT Address business component is used instead of the Business Address business component.

Table 33. Oracle Data Quality Matching Server Field Mappings for CUT Address
Business Component Field
Mapped Field

City

PAccountCity

Country

PAccountCountry

Postal Code

PAccountPostalCode

Row Id

PAccountAddressID

State

PAccountState

Street Address

PAccountStrAddress

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