Contents

Custom Source Details

When you select Custom as the Type, the Source Details section displays the following configuration choices.

Connection

Selects the UDL connection used by database operations.

Table

Selects the name of the custom table that contains the list of DNC numbers. These are the telephone numbers that will be used later to scrub contact lists.

Phone Number Column

Selects the column in that table which contains blocked numbers. All the numbers in the DNC data source must be in the same format, e.g. (xxx) xxx‑xxxx, and the numbers in the contact list must also be in that same format (Varchar), so that no normalization has to be done.

The data type of the phone number column of the table used as a custom DNC source must be of type Varchar. If a column of a different data type is used, the bulk scrub will fail and Dialer will warn: "Bulk scrubbing failed due to an internal Dialer error".

Database Column to Exclude

A campaign can be configured to match a contact list column against an additional column in the custom DNC table. This drop list selects a column in the DNC table that DNC processing will be compare to a similarly named column in the contact list, for the purpose of not dialing matching records. These columns might store account numbers, for example. When there is a match, Dialer will not call any phone number in the matching account. See also DNC Excluded Column Identifier on the Contact List tab of a campaign configuration entry.

Expiration Column

Identifies an Expiration date-time column in the DNC table, after which time the DNC entry is ignored or deleted. If a campaign is configured to use this DNC source, the time in the DNC column is compared with the current time. This comparison is made using UTC time.

If the current time is previous to the expiration time, the number is not dialed. It is treated like a traditional do-not-call number.

If the current time is past the expiration time, the number is dialed because the entry has expired.