Enabling Phone Properties of the Lead Object for Scrubbing

Scrubbing can be enabled for the predefined and custom phone Properties of the Lead Object. By default, the following four predefined phone Properties of the Lead Object are used for scrubbing:

•   Phone - Available in the Property Tab

•   Phone 1 - Available in the Address group in the Property Tab

•   Phone 2 - Available in the Address group in the Property Tab

•   Mobile - Available in the Address group in the Property Tab

Further, if a custom phone Property of type Text or Numeric is configured for the Lead Object, it can also be used for scrubbing after enabling it.

Note

•   Ensure that the names of custom phone Properties of the Lead Object that are enabled for scrubbing is unique.

•   Ensure that the custom phone Property of the Lead Object that are enabled for scrubbing are not a Protected Property.

•   Before enabling Phone Properties for scrubbing, EBR mapping must be done.

To Enable Scrubbing for the Predefined Phone Properties

Run the following SQL statement:

Exec Sproc_DNCConfigPopulatePhoneListForScrubbing 20005

To Enable Scrubbing for the Custom Phone Properties

Run the following SQL statements after replacing the text custPhonePropertyID with the ID of the custom Phone Property:

Declare @trc nvarchar(max), @nRetVal Int

Set @trc = N''

Set @nRetVal = 0

Exec @nRetVal = sproc_ConfigurePhonePropForDNCObject @nObjectType = 20005, @nPhonePropertyID = custPhonePropertyID, @tTraceString = @trc Output

Select @nRetVal, @trc