Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
FK, IE-1 NULL
DBINT
Associated Service.SkillTargetID. Every route
that terminates at a peripheral should have a
service.
that terminates at a peripheral should have a
service.
ServiceSkillTargetID
FK, IE-1 NULL
DBINT
Foreign key from the Skill Target table that
represents the destination of the route. The
represents the destination of the route. The
SkillTargetID
destination is a Service, Skill Group, Agent, or
Translation Route.
Translation Route.
Route_Call_Detail Table
This table can become very large. Running custom reporting queries against it while it is on the
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
Central database only.
Each row records information about a routing request received by the ICM software and the
route it choose for it.
route it choose for it.
The ICM software generates a Route_Call_Detail record for every routing request it processes.
Related tables
NetworkTargetID)
(via
DialedNumberID)
CallTypeID)
RoutingClientID)
(RecoveryKey maps to
Route_Call_Variable.RCDRecoveryKey)
Route_Call_Variable.RCDRecoveryKey)
(via RouteID)
(via
Day + RouterCallKey)
FinalObjectID)
(via ScriptID)
Table 158: Indexes for Route_Call_Detail Table
index_keys
index_description
index_name
DateTime
nonclustered located on PRIMARY
XIE1Route_Call_Detail
DbDateTime
nonclustered located on PRIMARY
XIE2Route_Call_Detail
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
236
Chapter 2: - All Tables
Route_Call_Detail Table