Bookshelf Home | Contents | Index | PDF     

Siebel Data Quality Administration Guide > Example of Universal Connector Properties and Field Mapping Values > Preconfigured Field Mappings >

Preconfigured Business Component User Properties (7.8.2)

This topic lists the preconfigured Business Component properties valid up to the 7.8.2. release.

Preconfigured Account Business Component User Properties

Table 46 shows data matching user properties for the Account business component

CAUTION:  MP_KEYFLD_KEYMISC is used to store the Siebel ROW_ID during the data matching process; do not configure this user property.

.

Table 46. Preconfigured Firstlogic Data Matching Properties for the Account Business Component
User Property Name
Value

DeDuplication Connector Vendor1

"match"

match Type

Account

match DeDuplication Field 1

"MATCH_FIELD_FIRM", "Name"

match DeDuplication Field 2

"MATCH_FIELD_FIRMLOC", "Location"

match DeDuplication Field 3

"MATCH_FIELD_UNPADDRLINE", "Street Address"

match DeDuplication Field 4

"MATCH_FIELD_CITY", "City"

match DeDuplication Field 5

"MATCH_FIELD_STATE", "State"

match DeDuplication Field 6

"MATCH_FIELD_ZIP4", "Postal Code"

match DeDuplication Field 7

"MATCH_FIELD_COUNTRY", "Country"

match DeDuplication Field 8

"MP_KEYFLD_KEYMISC", ""

Table 47 shows data cleansing user properties for the Account business component.

Table 47. Preconfigured Firstlogic Data Cleansing Properties for the Account Business Component
User Property Name
Value

DataCleansing Connector - Vendor1

"namefirm"

namefirm DataCleansing Field 1

"Name", "drl_ifirmname1", "drl_firm_std1"

namefirm DataCleansing Field 2

"Location", "drl_ifirmloc1", "drl_firm_loc_std1"

Preconfigured Contact Business Component User Properties

Table 48 shows data matching user properties for the Contact business component.

CAUTION:  MP_KEYFLD_KEYMISC is used to store the Siebel ROW_ID during the data matching process; do not configure this user property.

Table 48. Preconfigured Firstlogic Data Matching Properties for the Contact Business Component
User Property Name
Value

DeDuplication Connector - Vendor1

"match"

match Type

Contact

match DeDuplication Field 1

"MATCH_FIELD_LASTNAME", "Last Name"

match DeDuplication Field 2

"MATCH_FIELD_FIRSTNAME", "First Name"

match DeDuplication Field 3

"MATCH_FIELD_MIDDLENAME", "Middle Name"

match DeDuplication Field 4

"MATCH_FIELD_FIRM", "Account"

match DeDuplication Field 5

"MATCH_FIELD_FIRMLOC", "Account Location"

match DeDuplication Field 6

"MATCH_FIELD_UNPADDRLINE", "Street Address"

match DeDuplication Field 7

"MATCH_FIELD_CITY", "City"

match DeDuplication Field 8

"MATCH_FIELD_STATE", "State"

match DeDuplication Field 9

"MATCH_FIELD_ZIP4", "Postal Code"

match DeDuplication Field 10

"MATCH_FIELD_COUNTRY", "Country"

match DeDuplication Field 11

"MP_KEYFLD_KEYMISC", ""

Table 49 shows the data cleansing user properties for the Contact business component.

Table 49. Preconfigured Firstlogic Data Cleansing Properties for the Contact Business Component
User Property Name
Value

DataCleansing Connector - Vendor1

"namefirm"

namefirm DataCleansing Field 1

"Last Name", "drl_ilname1", "drl_last_name_std1"

namefirm DataCleansing Field 2

"First Name", "drl_ifname1", "drl_first_name_std1"

namefirm DataCleansing Field 3

"Middle Name", "drl_imname1", "drl_mid_name_std1"

namefirm DataCleansing Field 4

"Job Title", "drl_ititle1", "drl_title_std1"

Preconfigured List Mgmt Prospective Contact Business Component User Properties

Table 50 shows the data matching user properties for the List Mgmt Prospective Contact business component.

CAUTION:  MP_KEYFLD_KEYMISC is used to store the Siebel ROW_ID during the data matching process; do not configure this user property.

Table 50. Preconfigured Firstlogic Data Matching Properties for the List Mgmt Prospective Contact Business Component
User Property Name
Value

DeDuplication Connector - Vendor1

"match"

match Type

Prospect

match DeDuplication Field 1

"MATCH_FIELD_LASTNAME", "Last Name"

match DeDuplication Field 2

"MATCH_FIELD_FIRSTNAME", "First Name"

match DeDuplication Field 3

"MATCH_FIELD_MIDDLENAME", "Middle Name"

match DeDuplication Field 4

"MATCH_FIELD_FIRM", "Account"

match DeDuplication Field 5

"MATCH_FIELD_UNPADDRLINE", "Street Address"

match DeDuplication Field 6

"MATCH_FIELD_CITY", "City"

match DeDuplication Field 7

"MATCH_FIELD_STATE", "State"

match DeDuplication Field 8

"MATCH_FIELD_ZIP4", "Postal Code"

match DeDuplication Field 9

"MATCH_FIELD_COUNTRY", "Country"

match DeDuplication Field 10

"MATCH_FIELD_FIRMLOC", "Primary Account Location"

match DeDuplication Field 11

"MP_KEYFLD_KEYMISC", ""

Table 51 shows the data cleansing user properties for the List Mgmt Prospective Contact business component.

Table 51. Preconfigured Firstlogic Data Cleansing Properties for the List Mgmt Prospective Contact Business Component
User Property Name
Value

DataCleansing Connector - Vendor1

"namefirm, address"

namefirm DataCleansing Field 1

"Last Name", "drl_ilname1", "drl_last_name_std1"

namefirm DataCleansing Field 2

"First Name", "drl_ifname1", "drl_first_name_std1"

namefirm DataCleansing Field 3

"Middle Name", "drl_imname1", "drl_mid_name_std1"

namefirm DataCleansing Field 4

"Job Title", "drl_ititle1", "drl_title_std1"

namefirm DataCleansing Field 5

"Account", "drl_ifirmname1", "drl_firm_std1"

namefirm DataCleansing Field 6

"Primary Account Location", "drl_ifirmloc1", "drl_firm_loc_std1"

address Type

Prospect Address

address DataCleansing Field 1

"Street Address", "nad_line_address1", "nad_line_address1"

address DataCleansing Field 2

"City", "nad_line_locality1", "nad_line_locality1"

address DataCleansing Field 3

"State", "nad_line_region1"

address DataCleansing Field 4

"Postal Code", "nad_line_postcode", "nad_line_postcode"

address DataCleansing Field 5

"Country", "nad_line_country"

Preconfigured Business Address Business Component User Properties

Table 52 shows the data cleansing user properties for the Business Address business component.

Table 52. Preconfigured Data Cleansing Properties for the Business Address Business Component
User Property Name
Value

DataCleansing Connector - Vendor1

"namefirm, address"

address Type

Business Address

address DataCleansing Field 1

"Street Address", "nad_line_multiline1", "nad_line_multiline1"

address DataCleansing Field 2

"City", "nad_line_locality1", "nad_line_locality1"

address DataCleansing Field 3

"State", "nad_line_region1"

address DataCleansing Field 4

"Postal Code", "nad_line_postcode", "nad_line_postcode"

address DataCleansing Field 5

"Country", "nad_line_country"

address DataCleansing Field 6

"Street Address 2", "nad_line_multiline2", "nad_line_multiline2"

    
Siebel Data Quality Administration Guide Copyright © 2006, Oracle. All rights reserved.