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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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" |
|