ContactList Schema

Column

Details

Description

ATTEMPTS

int, null

The number of times that Dialer attempted to call this party. This cumulative total is never reset. This column is managed by Dialer. Customers can populate the attempts column before uploading a call list, but this column is optional and not required.

I3_ACTIVECAMPAIGNID

varchar(80), null

GUID of the last campaign that this record was selected for. I3_ACTIVECAMPAIGNID holds the Id of the active campaign associated with this contact—the campaign that has this contact cached.

When a campaign stops, its active contacts are reset in the contact list (status changed from 'I' to 'C'), and the active campaign's GUID (i3_activecampaignid) is used by a stored procedure to ensure that only contacts associated with this campaign are cleared.

I3_ATTEMPTSABANDONED

int, null

The total number of times that this party was abandoned (disconnected before an agent could speak with the party).

I3_ATTEMPTSBUSY

int, null

The total number of calls to this party that returned busy signals.

I3_ATTEMPTSDAILY

int, null

Number of contact attempts today.

I3_ATTEMPTSFAX

int, null

The total number of calls to this party that were answered by a Fax machine.

I3_ATTEMPTSMACHINE

int, null

The total number of calls to this party that reached an answering machine.

I3_ATTEMPTSNOANSWER

int, null

The total number of calls to this party that were not answered.

I3_ATTEMPTSREMOTEHANGUP

int, null

The number of contact attempts that resulted in remote party hang up.

I3_ATTEMPTSRESCHEDULED

int, null

The number of times that this contact was rescheduled due to agent unavailability.

I3_ATTEMPTSSITCALLABLE

int, 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_ATTEMPTSSYSTEMHANGUP

int, null

The number of contact attempts that resulted in System Hang Up.

I3_campaignownerexpiration

datetime, null

The time that the ownership expires.

I3_campaignownerid

varchar(80), null

The ID of the campaign that owns the record.

I3_campaignownername

varchar(80), null

The name of the campaign that owns the record.

I3_IDENTITY

PK, bigint, not null

I3_IDENTITY is an integer value that uniquely identifies each row in the contact list. This column is managed for the customer. Customers may insert records that contain I3_ROWID, but they cannot and should not modify I3_IDENTITY columns. Although I3_ROWID is deprecated from Dialer's point of view, it was retained for backward compatibility purposes.

I3_LASTCALLED_UTC

datetime, null

UTC time of the last contact attempt.

I3_ROWID

varchar(80), null

I3_ROWID is a customer-managed field used to uniquely identify a row. Dialer no longer uses this column. I3_ROWID is superseded by I3_IDENTITY, a Dialer-managed field. I3_ROWID is not a required field. However, I3_ROWID is supported in the contact list and is propagated to the CallRecordSchedule and CallHistory tables. I3_ROWID is also available in Scripter and in policies for backwards compatibility.

I3_SITEID

varchar(80), null

The name of the Outbound Dialer server that last called this contact.

I3_UPLOAD_ID

int

Upload Id is a sequential number populated when contacts are added or uploaded to a contact list. For details, see Penetration Rate Report Data and Penetration Rate Tables ERD in this document. In Dialer 4.0 SU3 and later, null values are no longer supported. I3_UPLOAD_ID has a default value of -1.

STATUS

char(1), null

This field contains a one-character alphabetical flag that indicates the overall status of a contact in a campaign. Interaction Dialer uses this flag to determine whether to select a record for processing.

The status column in the contact list indicates the overall status of a contact, not the callable status of individual numbers, which is maintained in the Phone Number Detail table. This approach allows a DNC status to be maintained in the PND table for individual telephone numbers associated with a contact.

A

"A" indicates that maximum retry attempts for busy, answering machine, no answer and so on have been reached for the record. It will never be called again. This status is also assigned when "max attempt" thresholds have been reached for auto-schedule options or the total attempts to dial the record.

C

"C" indicates a callable record.

F

"F" indicates that all of a contact's numbers are uncallable, and that the record has been "flagged" for customer review.

For example, if all attempts to dial phone numbers for a contact fail with SIT wrap-up Category, then that contact is essentially uncallable until a new contact column is added or some of the existing numbers are changed. Rather than mark the contact as uncallable, it is flagged with "F" so that customers can change the status back to "C" after they have added a new contact column, or updated contact numbers.

I

"I" stands for In Process. The record selection process has selected this record for processing, and the record has been passed to an Outbound Dialer server. However, the record may not have been dialed yet, and it has not been dispositioned by an agent.

When a campaign stops, its active contacts are reset in the contact list (status changed from 'I' to 'C'), and the active campaign ID (I3_ACTIVECAMPAIGNID) is used by a stored procedure to ensure that only contacts associated with this campaign are cleared.

This process takes into account the active campaign so that if the contact list is in use by multiple campaigns, the queued flag will be cleared on all contacts when the campaign stops (even ones queued by Dialer for other campaigns). This prevents contacts from being called back once they are completed or processed.

J

"J" identifies a record inserted into the contact list table for Priority Dialing.

O

"O" stands for auto-scheduled call. When the system schedules a call back according to the defined auto-schedule settings, Status is set to O to indicate that a callback has been scheduled, but has not been attempted yet.

R

 "R" is used for records that have been rescheduled because the designated agent was not logged on to take the call. If these are campaign wide calls, then if no agents are logged on, calls will be rescheduled with "R" in the status field.

If 'ignore recycles' is checked, auto scheduled calls will be distinguished from agent scheduled campaign wide calls and own agent callbacks.

The contact list status will appear as 'C' for auto-scheduled and rescheduled auto-scheduled calls if ignore recycles is not checked.

S

"S" stands for Scheduled call. When an agent schedules a call back, Status is set to S to indicate that a callback has been scheduled, but has not been attempted yet.

T

"T" stands for auto-rescheduled call (scheduled call that was rescheduled by dialer, not an agent). This status is assigned to a scheduled callback that failed to reach a contact, and the maximum number of callback attempts has not been reached. When it is, the status will be changed to "A".

U

"U" stands for unusable call record. This status flag designates that the contact will not be called again. Items are given a "U" status when the assigned wrap-up category code indicates Success, SIT Uncallable, Failed, or Wrong Party.

SUCCESSRESULT

float, null

SUCCESSRESULT is a customer-managed column in both the ContactList and CallHistory tables. Customers can use SUCCESSRESULT to maintain running counters, such as a money counter for example. The value of SUCCESSRESULT can be NULL when records are added or updated.

The value of SUCCESSRESULT in a CallHistory row will contain whatever was in the SUCCESSRESULT column of the associated contact at the time the history row was written. Its value in this table can be incremented by the customer as need to manage a running total of some sort.

ZONE

varchar(25), null

The time zone when this contact can be called.