Contents

PND Table

The Phone Number Detail (PND) table tracks time zone, contact attempts, and rescheduling attempts for each phone number associated with a contact record. The PND table also stores Do-Not-Call (DNC) status of individual phone numbers in the table. Customers should not modify PND tables as they are automatically created and maintained by Interaction Dialer.

Interaction Dialer automatically creates a separate PND table for each contact list in use. As it does so, Dialer adds a separate row to the PND table for each contact column, for each contact in the list.
Interaction Dialer also automatically maintains the contents of the PND table, which also includes a periodic clean up operation to prevent the PND table from getting too large. After midnight each day, DialerTran deletes any PND entries that have no corresponding call list entry or that are for a column that is no longer used.

Tracing in the DialerTran log records the SQL that was run during this cleanup operation. As such, you can determine what was removed from the PND table by searching for the trace entries labeled DeleteOrphanedPNDRecords.

Relationship between Contact List and PND

Dialer creates one PND table per Contact List.
Each PND table is a child table of a Contact List.
Each PND has an entry for each contact column in the Contact List.
PND tables manage the details associated with each individual phone number in the Contact List.
The Phone Number Type for each contact column in the PND table is read from the Dialer configuration file.
A PND table tracks time zone, contact attempts, and rescheduling attempts for each phone number associated with a contact record.

PND/Contact List Status fields and DNC

DNC scrubbing marks entries in a PND table with a status of "P" if a number should not be called. However, DNC scrubbing does not modify the status field in a Contact List.

The status column in the Contact List indicates the overall status of a contact, not the callable status of individual numbers, which are maintained in the PND table. This approach allows a DNC status to be maintained for individual telephone numbers associated with a contact. If all of the numbers for a contact are flagged not to be called, then Dialer will never dial the contact, since the contact has no callable numbers.