Contents

Dialing_List Table

This appendix provides information about the Dialing List table. (This table is used for troubleshooting purposes.)

Other applications are not allowed to access it for reading, writing, or using triggers.

Dialing_List Table Columns

There is a separate Dialing_List table for every Campaign and Query Rule combination. The naming convention for each table is "DL_CCCC_QQQQ," where "CCCC" is the database ID of the campaign and "QQQQ" is the database ID for the query rule. The following table displays the Dialing_List table column names and their description.

Table 1 Dialing_List Table Columns for Release 7.0(0)

Dialing List ID

Type

Autoincrement value - unique for each Campaign Query Rule table

Phone01 through Phone10

VARCHAR20

Phone number imported into Phone01 through Phone 10 standard column

PhoneExt01 through PhoneExt10

VARCHAR8

Phone number extension imported into PhoneExt01 through PhoneExt10 standard column. This column is for future use; it is not currently being used.

CallbackNumber

VARCHAR20

Phone number to be used for a regular callback it can be supplied by the agent

CallResult

SMALLINT

The call result from the last call placed for this record (see Call Result definitions).

CallResult01 through CallResult10

SMALLINT

The call result from the last time Phone01through Phone10 was called (see Call Result definitions). CallResult01 captures the results of all requested regular callback calls for Phone01 to Phone10

LastZoneDialed

SMALLINT

The last zone that was dialed (0 indicates zone1, 1 indicates zone2)

LastNumberDialedZone1

SMALLINT

The last number dialed in zone1 (1 for phone01, 2 for phone02, and so on)

LastNumberDialedZone2

SMALLINT

The last number dialed in zone2 (1 for phone01, 2 for phone02, and so on)

CallsMadeToZone1

SMALLINT

The number of calls made to numbers in zone 1

Note    For a call which an Outbound Agent has scheduled a callback, the CallResult resets to 0

CallsMadeToZone2

SMALLINT

The number of calls made to numbers in zone 2

Note    For a call which an Outbound Agent has scheduled a callback, the CallResult resets to 0

CallbackDateTimeZone1

DATETIME

The date/time when the next call to this zone will occur

CallbackDateTimeZone2

DATETIME

The number of calls made to numbers in zone 2

CallbackDateTime01 through CallbackDateTime010

DATETIME

The date/time when the next call to this phone number will occur

GMTPhone01 through GMTPhone10

SMALLINT

The time zone where this phone number is located

DSTPhone01 through DSTPhone10

SMALLINT

Is DST observed at this phone number (boolean).

CallStatusZone1 and CallStatusZone2

CHAR(1)

The call status (pending, retry, callback, and so forth) for this zone

AccountNumber

VARCHAR25

Customer’s account number

LastName

VARCHAR50

Customer’s last name

FirstName

VARCHAR50

Customer’s first name.

ImportRuleDate

DATETIME

The date/time when the record was imported.
Dialing_List Table

Dialing_List Table

This appendix provides information about the Dialing List table. (This table is used for troubleshooting purposes.)

Other applications are not allowed to access it for reading, writing, or using triggers.

Dialing_List Table Columns

There is a separate Dialing_List table for every Campaign and Query Rule combination. The naming convention for each table is "DL_CCCC_QQQQ," where "CCCC" is the database ID of the campaign and "QQQQ" is the database ID for the query rule. The following table displays the Dialing_List table column names and their description.

Table 1 Dialing_List Table Columns for Release 7.0(0)

Dialing List ID

Type

Autoincrement value - unique for each Campaign Query Rule table

Phone01 through Phone10

VARCHAR20

Phone number imported into Phone01 through Phone 10 standard column

PhoneExt01 through PhoneExt10

VARCHAR8

Phone number extension imported into PhoneExt01 through PhoneExt10 standard column. This column is for future use; it is not currently being used.

CallbackNumber

VARCHAR20

Phone number to be used for a regular callback it can be supplied by the agent

CallResult

SMALLINT

The call result from the last call placed for this record (see Call Result definitions).

CallResult01 through CallResult10

SMALLINT

The call result from the last time Phone01through Phone10 was called (see Call Result definitions). CallResult01 captures the results of all requested regular callback calls for Phone01 to Phone10

LastZoneDialed

SMALLINT

The last zone that was dialed (0 indicates zone1, 1 indicates zone2)

LastNumberDialedZone1

SMALLINT

The last number dialed in zone1 (1 for phone01, 2 for phone02, and so on)

LastNumberDialedZone2

SMALLINT

The last number dialed in zone2 (1 for phone01, 2 for phone02, and so on)

CallsMadeToZone1

SMALLINT

The number of calls made to numbers in zone 1

Note    For a call which an Outbound Agent has scheduled a callback, the CallResult resets to 0

CallsMadeToZone2

SMALLINT

The number of calls made to numbers in zone 2

Note    For a call which an Outbound Agent has scheduled a callback, the CallResult resets to 0

CallbackDateTimeZone1

DATETIME

The date/time when the next call to this zone will occur

CallbackDateTimeZone2

DATETIME

The number of calls made to numbers in zone 2

CallbackDateTime01 through CallbackDateTime010

DATETIME

The date/time when the next call to this phone number will occur

GMTPhone01 through GMTPhone10

SMALLINT

The time zone where this phone number is located

DSTPhone01 through DSTPhone10

SMALLINT

Is DST observed at this phone number (boolean).

CallStatusZone1 and CallStatusZone2

CHAR(1)

The call status (pending, retry, callback, and so forth) for this zone

AccountNumber

VARCHAR25

Customer’s account number

LastName

VARCHAR50

Customer’s last name

FirstName

VARCHAR50

Customer’s first name.

ImportRuleDate

DATETIME

The date/time when the record was imported.