Cisco Cisco Administrative Workstation Technical References
2-170
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Real_Time Table
Related tables:
Route (via RouteID)
Route_Real_Time Table
Local database only.
Each row contains real time information about a route.
The ICM software generates a Route_Real_Time record for each route.
HoldTimeToHalf
Total hold time in seconds for calls to the route
that ended during the half-hour interval.
that ended during the half-hour interval.
int
NULL
BlindTransferOutToHalf
The number of calls that were blind transferred
out for this route during the half-hour interval.
out for this route during the half-hour interval.
int
NULL
Table 2-142 Route_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-143 Route_Real_Time Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RouteID
Foreign key from the Route table.
int
PK, FK, NOT
NULL
NULL
DateTime
Date and time that this data was last updated.
datetime
NOT NULL
AgentsTalking
Number of agents for the route currently in the
talking state
talking state
int
NULL
AnswerWaitTimeHalf
Sum of answer wait time in seconds for all calls
offered to the route during the current half-hour
interval.
offered to the route during the current half-hour
interval.
int
NULL
AnswerWaitTimeTo5
Sum of answer wait time in seconds for all calls
offered to the route during the current
five-minute interval.
offered to the route during the current
five-minute interval.
int
NULL
AnswerWaitTimeToday
Sum of answer wait time in seconds for all calls
offered to the route since midnight.
offered to the route since midnight.
int
NULL
AvgDelayQAbandTo5
Average delay time of abandoned calls in queue
for the route during the current five-minute
interval: DelayQAbandTimeTo5 /
CallsAbandQTo5.
for the route during the current five-minute
interval: DelayQAbandTimeTo5 /
CallsAbandQTo5.
int
NULL
AvgDelayQNow
Average delay for calls to the route currently in
queue.
queue.
int
NULL
AvgHandleTimeTo5
Average handle time in seconds for calls to the
route ending during the current five-minute
interval: HandleTimeTo5 / CallsHandledTo5.
route ending during the current five-minute
interval: HandleTimeTo5 / CallsHandledTo5.
int
NULL