|
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.2)
This topic lists the preconfigured Business Service properties valid for the 7.8.2.2 release and later. Preconfigured Account Business Component User Properties
Table 39 shows data matching user properties for the Account business component.
Table 39. Preconfigured Properties for the Account Business Component
|
|
DeDuplication Connector - Firstlogic |
"Dedup" |
Dedup Type |
Account |
Dedup Token Expression |
"IfNull (Left ([Primary Account Postal Code], 5), '_____') + IfNull (Left ([Name], 1), '_') + IfNull (Mid ([Street Address], FindNoneOf ([Street Address], '1234567890 '), 1), '_')" |
Dedup Query Expression |
"IfNull (Left ([Primary Account Postal Code], 5), '?????') + IfNull (Left ([Name], 1), '?') + IfNull (Mid ([Street Address], FindNoneOf ([Street Address], '1234567890 '), 1), '?')" |
Dedup DeDuplication Field 1 |
"Account.Name", "Name" |
Dedup DeDuplication Field 2 |
"Account.Location", "Location" |
Dedup DeDuplication Field 3 |
"Account.Street Address", "Street Address" |
Dedup DeDuplication Field 4 |
"Account.City", "City" |
Dedup DeDuplication Field 5 |
"Account.State", "State" |
Dedup DeDuplication Field 6 |
"Account.Postal Code", "Postal Code" |
Dedup DeDuplication Field 7 |
"Account.Country", "Country" |
Dedup DeDuplication Field 8 |
"Account.Id", "Id" |
Dedup DeDuplication Field 9 |
"Account.MatchCandidateToken", "Dedup Token" |
Table 40 shows data cleansing user properties for the Account business component
Table 40. Preconfigured Firstlogic Data Cleansing Properties for the Account Business Component
|
|
DataCleansing Connector - Firstlogic |
"DataCleanse" |
DataCleanse Type |
Account |
DataCleanse DataCleansing Field 1 |
"Name", "Account.Name" |
DataCleanse DataCleansing Field 2 |
"Location", "Account.Location" |
Preconfigured Contact Business Component User Properties
Table 41 shows data matching user properties for the Contact business component.
Table 41. Preconfigured Firstlogic Data Matching Properties for the Contact Business Component
|
|
DeDuplication Connector - Firstlogic |
"Dedup" |
Dedup Type |
Contact |
Dedup Token Expression |
"IfNull (Left ([Postal Code], 5), '_____') + IfNull (Left ([Account], 1), '_') + IfNull (Left ([Last Name], 1), '_')" |
Dedup Query Expression |
"IfNull (Left ([Postal Code], 5), '?????') + IfNull (Left ([Account], 1), '?') + IfNull (Left ([Last Name], 1), '?')" |
Dedup DeDuplication Field 1 |
"Contact.First Name", "First Name" |
Dedup DeDuplication Field 2 |
"Contact.Middle Name", "Middle Name" |
Dedup DeDuplication Field 3 |
"Contact.Last Name", "Last Name" |
Dedup DeDuplication Field 4 |
"Contact.Account", "Account" |
Dedup DeDuplication Field 5 |
"Contact.Account Location", "Account Location" |
Dedup DeDuplication Field 6 |
"Contact.Street Address", "Street Address" |
Dedup DeDuplication Field 7 |
"Contact.City", "City" |
Dedup DeDuplication Field 8 |
"Contact.State", "State" |
Dedup DeDuplication Field 9 |
"Contact.Postal Code", "Postal Code" |
Dedup DeDuplication Field 10 |
"Contact.Country", "Country" |
Dedup DeDuplication Field 11 |
"Contact.Id", "Id" |
Dedup DeDuplication Field 12 |
"Contact.MatchCandidateToken", "Dedup Token" |
Table 42 shows the data cleansing user properties for the Contact business component.
Table 42. Preconfigured Firstlogic Data Cleansing Properties for the Contact Business Component
|
|
DataCleansing Connector - Firstlogic |
"DataCleanse" |
DataCleanse Type |
Contact |
DataCleanse DataCleansing Field 1 |
"Last Name", "Contact.Last Name" |
DataCleanse DataCleansing Field 2 |
"First Name", "Contact.First Name" |
DataCleanse DataCleansing Field 3 |
"Middle Name", "Contact.Middle Name" |
DataCleanse DataCleansing Field 4 |
"Job Title", "Contact.Job Title |
Preconfigured List Mgmt Prospective Contact Business Component User Properties
Table 43 shows the data matching user properties for the List Mgmt Prospective Contact business component.
Table 43. Preconfigured Firstlogic Data Matching Properties for the List Mgmt Prospective Contact Business Component
|
|
DeDuplication Connector - Firstlogic |
"Dedup" |
Dedup Type |
List Mgmt Prospective Contact |
Dedup Token Expression |
"IfNull (Left ([Postal Code], 5), '_____') + IfNull (Left ([Account], 1), '_') + IfNull (Left ([Last Name], 1), '_')" |
Dedup Query Expression |
"IfNull (Left ([Postal Code], 5), '?????') + IfNull (Left ([Account], 1), '?') + IfNull (Left ([Last Name], 1), '?')" |
Dedup DeDuplication Field 1 |
"List Mgmt Prospective Contact.First Name", "First Name" |
Dedup DeDuplication Field 2 |
"List Mgmt Prospective Contact.Middle Name", "Middle Name" |
Dedup DeDuplication Field 3 |
"List Mgmt Prospective Contact.Last Name", "Last Name" |
Dedup DeDuplication Field 4 |
"List Mgmt Prospective Contact.Account", "Account" |
Dedup DeDuplication Field 5 |
"List Mgmt Prospective Contact.Primary Account Location", " Primary Account Location" |
Dedup DeDuplication Field 6 |
"List Mgmt Prospective Contact.Street Address", "Street Address" |
Dedup DeDuplication Field 7 |
"List Mgmt Prospective Contact.City", "City" |
Dedup DeDuplication Field 8 |
"List Mgmt Prospective Contact.State", "State" |
Dedup DeDuplication Field 9 |
"List Mgmt Prospective Contact.Postal Code", "Postal Code" |
Dedup DeDuplication Field 10 |
"List Mgmt Prospective Contact.Country", "Country" |
Dedup DeDuplication Field 11 |
"List Mgmt Prospective Contact.Id", "Id" |
Dedup DeDuplication Field 12 |
"List Mgmt Prospective Contact.MatchCandidateToken", "Dedup Token" |
Table 44 shows the data cleansing user properties for the List Mgmt Prospective Contact business component.
Table 44. Preconfigured Firstlogic Data Cleansing Properties for the List Mgmt Prospective Contact Business Component
|
|
DataCleansing Connector - Firstlogic |
"DataCleanse" |
DataCleanse Type |
List Mgmt Prospective Contact |
DataCleanse DataCleansing Field 1 |
"Street Address", "List Mgmt Prospective Contact.Street Address" |
DataCleanse DataCleansing Field 2 |
"Account", "List Mgmt Prospective Contact.Account" |
DataCleanse DataCleansing Field 3 |
"Primary Account Location", "List Mgmt Prospective Contact.Primary Account Location" |
DataCleanse DataCleansing Field 4 |
"Street Address 2", "List Mgmt Prospective Contact.Street Address 2" |
DataCleanse DataCleansing Field 5 |
"City", "List Mgmt Prospective Contact.City" |
DataCleanse DataCleansing Field 6 |
"State", "List Mgmt Prospective Contact.State" |
DataCleanse DataCleansing Field 7 |
"Postal Code", "List Mgmt Prospective Contact.Postal Code" |
DataCleanse DataCleansing Field 8 |
"Country", "List Mgmt Prospective Contact.Country" |
DataCleanse DataCleansing Field 9 |
"Last Name", " List Mgmt Prospective Contact.Last Name" |
DataCleanse DataCleansing Field 10 |
"First Name", " List Mgmt Prospective Contact.First Name" |
DataCleanse DataCleansing Field 11 |
"Middle Name", " List Mgmt Prospective Contact.Middle Name" |
DataCleanse DataCleansing Field 12 |
"Job Title", " List Mgmt Prospective Contact.Job Title" |
Preconfigured Business Address Business Component User Properties
Table 45 shows the data cleansing user properties for the Business Address business component.
Table 45. Preconfigured Data Cleansing Properties for the Business Address Business Component
|
|
DataCleansing Connector - Firstlogic |
"DataCleanse" |
DataCleanse Type |
Business Address |
DataCleanse DataCleansing Field 1 |
"Street Address", "Business Address.Street Address" |
DataCleanse DataCleansing Field 2 |
"City", "Business Address.City" |
DataCleanse DataCleansing Field 3 |
"State", "Business Address.State" |
DataCleanse DataCleansing Field 4 |
"Postal Code", "Business Address.Postal Code" |
DataCleanse DataCleansing Field 5 |
"Country", "Business Address.Country" |
DataCleanse DataCleansing Field 6 |
"Street Address 2", "Business Address.Street Address 2" |
|
