Bookshelf v8.0: Preconfigured Field Mappings for SSA

This topic lists the preconfigured field mappings for the various business components and operations supported by SSA applications, including:

Some of the mapped field values are indicated by a lettering nomenclature where different letters indicate standard input types for personal name, company name, address fields, and ID data. For example, Z indicates postal or ZIP code while I indicates a general unique identifier such as the D-U-N-S number for accounts or social security number for contacts. For more information about field mappings for business components using the embedded SSA-NAME3 software, see the relevant documentation included in Siebel Business Applications Third-Party Bookshelf in the product media pack on Oracle E-Delivery.

NOTE: The tables in this section indicate when field mappings are different for Siebel Industry Applications.

Preconfigured Field Mappings for Business Component- Account

Table 42 shows the data matching field mappings for the Account business component and DeDuplication operation.

Table 42. Preconfigured SSA Data Matching Mappings for the Account Business Component
Business Component Field	Mapped Field
Primary Account City	City
Primary Account Country	Country
DUNS Number	I
Name	C
Primary Account Postal Code	Z
Primary Account State	State
Primary Account Street Address	A

Preconfigured Field Mappings for Business Component - Contact

Table 43 shows the data matching field mappings for the Contact business component and DeDuplication operation.

Table 43. Preconfigured SSA Data Matching Mappings for the Contact Business Component
Business Component Field	Mapped Field
Primary Account Name Account (Siebel Industry Applications)	C
Birth Date	D
Cellular Phone #	T
Primary City Primary Personal City (Siebel Industry Applications)	City
Primary Country Primary Personal Country (Siebel Industry Applications)	Country
Email Address	E
First Name	First
Home Phone #	T
Last Name	Last
Middle Name	Middle
Primary Postal Code Primary Personal Postal Code (Siebel Industry Applications)	Z
Social Security Number	I
Primary State Primary Personal State (Siebel Industry Applications)	State
Primary Street Address Primary Personal Street Address (Siebel Industry Applications)	A
Work Phone #	T

Preconfigured Field Mappings for Business Component - List Mgmt Prospective Contact

Table 44 shows the data matching field mappings for the List Mgmt Prospective Contact business component and DeDuplication operation.

Table 44. Preconfigured SSA Data Matching Mappings for the List Mgmt Prospective Contact Business Component
Business Component Field	Mapped Field
Account Name Account (Siebel Industry Applications)	C
Cellular Phone #	T
City	City
Country	Country
Email Address	E
First Name	First
Home Phone #	T
Last Name	Last
Middle Name	Middle
Postal Code	Z
Social Security Number	I
State	State
Street Address	A
Work Phone #	T

Preconfigured Field Mappings for Business Component - Business Address

Table 45 shows the data matching field mappings for the Business Address business component and DeDuplication operation.

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

NOTE: This mapping is required to support the automatic deduplication on address update functionality.

Table 45. Preconfigured SSA Data Matching Mappings for the Business Address Business Component
Business Component Field	Mapped Field
City	City
Country	Country
Id	Id
Postal Code	Z
State	State
Street Address	A

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