Technical References

This historical table tracks data on all outbound attempts, including personal callback attempts
and preview calls that are skipped by an agent.
Note: IPCC and G3 Support: The Dialer_Detail table is supported for IPCC only. Dialer
Detail records are not supported for the G3 dialer. Some records might be written to the
Dialer_Detail table for older G3 dialers, but the records should not be used.
Related Tables for Dialer_Detail
•
Agent (page 15) (via PeripheralNumber)
•
Campaign (page 125)(via CampaignID)
•
Dialer (page 161) (via DialerID)
•
Peripheral (page 250) (via PeripheralID)
•
Query_Rule (page 266) (via QueryRuleID)
•
SkillGroup (page 364) (via SkillTargetID)
•
Campaign_Target_Sequence (page 141) (via Phone Index)
Table 78: Indexes for Dialer_Detail Table
index_keysindex_descriptionindex_name
DbDateTimenonclustered located on PRIMARYXIE1Dialer_Detail
RecoveryKeyclustered, unique, primary key
located on PRIMARY
XPKDialer_Detail
Fields in Dialer_Detail Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLVARCHAR
Customer account number.
AccountNumber
NULLVARCHAR(32)
PeripheralNumber / AgentID of the Agent that handled the call.
AgentPeripheralNumber
NULLVARCHAR(20)
The phone number at which the customer requested to be called
back. This field remains populated with customer-requested
CallbackPhone
callback numbers for all personal callback calls or regular callback
calls.
NULLDBSMALLDATE
Reserved for future use
CallbackDateTime
NULLDBINT
This field is not currently used. The value will always be NULL.
CallbackTimeZone
NULLDBINT
Reserved for future use
CallDuration
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
164
Chapter 2: All Tables
Dialer_Detail Table