Bookshelf v7.7: Viewing or Changing SDQ Business Component User Properties

Siebel Data Quality Administration Guide > Preconfigured SDQ Universal Connector Properties for Firstlogic Applications >

Viewing or Changing SDQ Business Component User Properties

Business component user properties store configurable settings specific to a business component, in particular, field mappings from the vendor's field to the Siebel field. The properties are available for both the Siebel Data Quality Universal Connector and the Siebel Data Quality Matching Server.

This section explains how to view or change business component user properties in general and then provides values for these properties specific to Firstlogic applications.

TIP: If you deactivate a field mapping, you may need to shift the remaining fields ahead so that your list of field mappings is sequential. For example, if you deactivate field 2, you may need to change field 3 to field 2, field 4 to field 3, and so on. If you do not shift the remaining fields, the Siebel application recognizes only one field mapping and cannot find field 2 or subsequent fields.

To view or change SDQ business component user properties

Log in to Siebel Tools.
For more information about Siebel Tools, see Using Siebel Tools.
In the Object Explorer, expand the Business Component object.
In the Business Objects list, select the business component.
For this example, select Account.
In the Object Explorer, click Business Component User Prop.
The default business component user properties appear in the Business Component User Props list.

TIP: You can use a similar procedure for viewing the other data quality business component default user properties.

Table 25 and Table 26 provide the default data cleansing and deduplication user property values for the Account business component for Firstlogic applications.

Table 25. Account Business Component User Properties (Data Cleansing)
Property Name	Value1
DataCleansing Connector - Vendor12	"namefirm"
namefirm DataCleansing Field 1	"Name", "drl_ifirmname1", "drl_firm_std1"
namefirm DataCleansing Field 2	"Location", "drl_ifirmloc1", "drl_firm_loc_std1"

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

Table 26. Account Business Component User Properties (Deduplication)
Property Name	Value1
DeDuplication Connector - Vendor12	"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", ""

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

Table 27 and Table 28 provide the default data cleansing and deduplication user property values for the Contact business component for Firstlogic applications.

Table 27. Contact Business Component User Properties (Data Cleansing)
Property Name	Value1
DataCleansing Connector - Vendor12	"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"

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

Table 28. Contact Business Component User Properties (Deduplication)
Property Name	Value1
DeDuplication Connector - Vendor12	"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", ""

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

Table 29 and Table 30 provide the default data cleansing and deduplication user property values for the List Mgmt Prospective Contact business component for Firstlogic applications.

Table 29. List Mgmt Prospective Contact Business Component User Properties (Data Cleansing)
Property Name	Value1
DataCleansing Connector - Vendor12	"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"

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

Table 30. List Mgmt Prospective Contact Business Component User Properties (Deduplication)
Property Name	Value1
DeDuplication Connector - Vendor12	"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", ""

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

Table 31 provides the default data cleansing user property values for the Business Address business component for Firstlogic applications.

Table 31. Business Address Business Component User Properties (Data Cleansing)
Property Name	Value1
DataCleansing Connector - Vendor12	n"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"

1The values with three strings show type of parameter, parameter name, and parameter value, in that order. These parameters are provided by third-party vendors and cannot be changed.

2By default, Vendor1 is mapped to fields for the Firstlogic data quality link for Siebel eBusiness Applications.

NOTE: You can run data cleansing for the Personal Address business component by configuring the Personal Address business component user properties and the following parameters: Operation Type = Data Cleansing, Business Component = Personal Address, and Business Object = Contact.