Cisco Cisco IP Contact Center Release 4.6.1 Technical References

2-258

Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)

Chapter 2 Table Details

Route_Call_Detail Table

Central database only.

Each row records information about a routing request received by the ICM software and the route it
choose for it.

The ICM software generates a Route_Call_Detail record for every routing request it processes.

Table 2-283 Route_Call_Detail Table Constraints

Constraint

Field Name(s)

AK-1

RecoveryKey

CallTypeID
DialedNumberID
LabelID
NetworkTargetID
RouteID
RoutingClientID
ScriptID

IE-1

DateTime

IE-2

DbDateTime

Table 2-284 Route_Call_Detail Table

Field Name

Description

Data Type

Keys and
Null Option

ANI

Automatic Number Identification, identifies the
calling party.

VNAME32

NULL

BeganCallTypeDateTime

A new time stamp that indicates when the call
entered the current CallType.

DBDATETIME

NULL

BeganRoutingDateTime

A new time stamp that indicates when the first
route request was received for this call.

DBDATETIME

NULL

CallSegmentTime

Time in seconds that the system took to segment a
private network call. For example, if the ICM
software handed the caller off to a menu of
choices, CallSegmentTime reflects the length of
time the caller spent in the menu.

DBINT

NULL

CallTrace

A trace of all script nodes traversed by the call.
The ICM software produces this information only
if a debugging option is set.

image

NULL

CallTypeID

Foreign key from Call Type table. If a script
changed the call type, this is the final call type for
the call. This unique identifier is generated
automatically by the ICM software.

DBINT

NULL