Siebel Developer's Reference > User Properties >

DeDup Token Value


Parent Object Type
Business Component
Description
Modifies the dedup token calculation expression for a business component. Changes the calculation expression to adjust the filtering that generates the candidate set. A larger or more restricted candidate set may be desired, or a field may need to be added to or removed from the expression. Calculation expressions for dedup tokens follow the same syntax rules as calculated fields.
Calculation expressions for Dedup tokens follow the same syntax rules as calculated Fields. If the calculation value is changed, you will need to regenerate the token values in the database for existing data. This is accomplished by running deduplication in batch mode.
The Dedup token is generated based on the following calculations.
Contacts: Dedup token consists of a concatenated string of the cleansed five-digit ZIP Code of the account address, the first letter of the cleansed account name, and the first letter of the cleansed last name. The calculation expression is
IfNull (Left ([Postal Code], 5), "_") + IfNull (Left ([Account],1), "_") + IfNull (Left ([Last Name], 1), "_")
Accounts and Sub-Accounts: Dedup token consists of a concatenated string of the cleansed five-digit ZIP Code of the account address, the first letter of the cleansed account name, and the first nonblank nonnumeric character of the cleansed street name. The calculation expression is
IfNull (Left ([Postal Code], 5), "_") + IfNull (Left ([Name], 1),"_") + IfNull (Mid ([Street Address], FindNoneOf ([Street Address], "1234567890 "), 1), "_")·
Prospects: Dedup token consists of a concatenated string of the cleansed 5-digit ZIP Code of the account address, the first letter of the cleansed account name, and the first letter of the cleansed last name. The calculation expression is
IfNull (Left ([Postal Code], 5), "_") + IfNull (Left ([Primary Account Name], 1), "_") + IfNull (Left ([Last Name], 1), "_")
Functional Area
Data Quality
Where Documented
Siebel Data Quality Administration Guide

 Siebel Developer's Reference 
 Published: 23 October 2003