Contents

• Termination_Call_Detail Table
• Dialing_List Table Columns

Termination_Call_Detail Table

---

This appendix provides a summary of new peripheral call types that identify the dialing mode of reservation and customer calls, and describes the PeripheralCallType and CallDisposition column values used in the Termination_Call_Detail table. It also provides the CED column values for Outbound Option reservation or personal callback calls.

• Dialing_List Table Columns

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.

---

Contents

• Termination_Call_Detail Table
• Dialing_List Table Columns

Termination_Call_Detail Table

---

This appendix provides a summary of new peripheral call types that identify the dialing mode of reservation and customer calls, and describes the PeripheralCallType and CallDisposition column values used in the Termination_Call_Detail table. It also provides the CED column values for Outbound Option reservation or personal callback calls.

• Dialing_List Table Columns

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.

---