Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
varchar(255)
The value of the call variable or array element.
ECCValue
AK-2, FK NOT
NULL
NULL
DBSMALLINT
Identifies the expanded call variable.
ExpandedCallVariableID
AK-2 NOT NULL
DBFLT8
The RecoveryKey value from the associated
Route_Call_Detail row.
Route_Call_Detail row.
RCDRecoveryKey
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software
to track the record.
internally by the ICM/IPCC Enterprise software
to track the record.
RecoveryKey
Route_Five_Minute Table
Central database only. Each row contains statistics about a route during the most recent
fi
fi
ve-minute interval. The ICM software generates Route_Five_Minute records for each route.
Related Table
Table 160: Indexes for Route_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Route_Five_Minute
DateTime, RouteID, TimeZone
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKRoute_Five_Minute
Fields in Route_Five_Minute Table:
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of agents in the Talking state for the route
at the end of the five-minute interval.
at the end of the five-minute interval.
AgentsTalking
NULL
DBINT
Average delay time of abandoned calls in queue
for the route during the five-minute interval.
for the route during the five-minute interval.
AvgDelayQAbandTo5
NULL
DBINT
Average delay in queue for the route at the end
of the five-minute interval.
of the five-minute interval.
AvgDelayQNow
NULL
DBINT
Average handle time in seconds for calls to the
route ending during the five-minute interval. This
route ending during the five-minute interval. This
AvgHandleTimeTo5
includes any HoldTime, TalkTime, and
WorkTime associated with the call. The
HandleTime and AvgHandleTime values are
WorkTime associated with the call. The
HandleTime and AvgHandleTime values are
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
242
Chapter 2: - All Tables
Route_Five_Minute Table