Contents

PND Schema

Dialer creates one PND table per contact list. Each PND has an entry for each contact column in the Contact list. The Phone Number Type for each contact column 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.

Column	Details	Description
I3_IDENTITY	PK, bigint, not null	I3_IDENTITY is an integer value that uniquely identifies each row in the contact list.
I3_CCID	PK, bigint, not null	Contact Column ID (CCID) is the unique id of the corresponding contact phone number in the Contact list table. When a contact column is chosen, if it does not already exist in this list then it is added, and a new CCID is assigned. Items are not removed from this list when a contact column is removed from a campaign.
I3_STATUS	char(1), null	If the DNC scrub indicates that the number is blocked for an undetermined time period, the status will be set to "P" If the DNC scrub indicates that the number is blocked by a calling time restriction (i.e. it is temporarily blocked), the status will be set to "B"
I3_SUBSTATUS	char(1), null	As Dialer works through the records in the PND table, it flags (with an "F") each phone number associated with a contact record as it is dialed. Using these flags allows Dialer to keep track of which numbers have been dialed. This flagging technique is designed to allow Dialer to pick up where it left off in the event that a recycle occurs before all the phone numbers in a particular record have been dialed. Once all the numbers in a record have been dialed, Dialer will clear the I3_SubStatus flags and move on to the next record.
I3_ZONE	nvarchar(25), null	The time zone when this contact can be called.
I3_ATTEMPTS	int, not null	Number of attempts to call this contact.
I3_ATTEMPTSABANDONED	int, not null	Number of attempts that were abandoned, meaning that the call was ended by the contact before a conversation with the agent could take place.
I3_ATTEMPTSBUSY	int, not null	Number of attempts that resulted in a busy signal.
I3_ATTEMPTSFAX	int, not null	Number of attempts that reached a Fax machine.
I3_ATTEMPTSMACHINE	int, not null	Number of attempts that reached an answering machine.
I3_ATTEMPTSNOANSWER	int, not null	Number of call attempts that were not answered.
I3_ATTEMPTSREMOTEHANGUP	int, not null	Number of attempts that were hung up by the remote party.
I3_ATTEMPTSRESCHEDULED	int, not null	Number of attempts that were rescheduled.
I3_ATTEMPTSSYSTEMHANGUP	int, not null	Number of attempts that were disconnected by the system due to no available Agents, high CPU utilization, and so on.
I3_ATTEMPTSSITCALLABLE	int, not null	The number of contact attempts that failed with SIT tones. This also helps indicate how many times the record has been placed. This column can be used with policies or filters to stop dialing records that have exceeded a customer-defined threshold of SITCallable results.
I3_DNCCOMEXPIRATION	datetime, nul	When the I3_STATUS field is B, indicating that the number is temporarily blocked by a calling time restriction, this field will contain the date and time when the number will no longer be restricted. i.e. it will become callable.