Cisco Cisco IPCC Web Option テクニカルリファレンス

ページ / 620
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
 (via PeripheralNumber)
(via CampaignID)
 (via PeripheralID)
 (via QueryRuleID)
 (via SkillTargetID)
Table 78: Indexes for Dialer_Detail Table
index_keys
index_description
index_name
DbDateTime
nonclustered located on PRIMARY
XIE1Dialer_Detail
RecoveryKey
clustered, unique, primary key
located on PRIMARY
XPKDialer_Detail
Fields in Dialer_Detail Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
VARCHAR
Customer account number.
AccountNumber
NULL
VARCHAR(32)
PeripheralNumber / AgentID of the Agent that handled the call.
AgentPeripheralNumber
NULL
VARCHAR(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.
NULL
DBSMALLDATE
Reserved for future use
CallbackDateTime
NULL
DBINT
This field is not currently used. The value will always be NULL.
CallbackTimeZone
NULL
DBINT
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