Cisco Cisco IPCC Web Option 技术参考
2-268
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route_Five_Minute Table
CallsQNow
Calls in queue for the route at the peripheral at the
end of the interval.
end of the interval.
DBINT
NULL
CallsRoutedToday
Running total of calls the ICM software sent to the
route since midnight.
route since midnight.
DBINT
NULL
DateTime
The Central Controller date and time at the start of
the five-minute interval.
the five-minute interval.
DBSMALLDATE
PK
NOT NULL
LongestCallQ
Length of time that the longest call in the queue
for the route had been there at the end of the
five-minute interval.
for the route had been there at the end of the
five-minute interval.
DBINT
NULL
RecoveryDay
Currently not used, set to zero (0).
DBINT
NOT NULL
RecoveryKey
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.
DBFLT8
AK-1
NOT NULL
RouteID
Foreign key from the Route table.
DBINT
PK, FK
NOT NULL
ServiceLevelAbandTo5
Total of calls to the route abandoned within the
ICM service level threshold during the five-minute
interval.
ICM service level threshold during the five-minute
interval.
DBINT
NULL
ServiceLevelAbandToday
Cumulative total of calls to the route abandoned
within the ICM service level threshold since
midnight.
within the ICM service level threshold since
midnight.
DBINT
NULL
ServiceLevelCallsOfferedTo5
Total number of calls to the route that had a
during the five-minute interval.
DBINT
NULL
ServiceLevelCallsOfferedToday
Total number of calls to the route that had a
since midnight.
DBINT
NULL
ServiceLevelCallsQHeld
Number of calls to the route that had been in queue
longer than the service level threshold as of the
end of the five-minute interval.
longer than the service level threshold as of the
end of the five-minute interval.
DBINT
NULL
ServiceLevelCallsTo5
Total of calls to the route answered within the ICM
service level threshold during the five-minute
interval.
service level threshold during the five-minute
interval.
DBINT
NULL
ServiceLevelCallsToday
Cumulative total of calls to the route answered
within the ICM service level since midnight.
within the ICM service level since midnight.
DBINT
NULL
ServiceLevelTo5
The ICM service level for the route for the
five-minute interval.
five-minute interval.
DBFLT4
NULL
ServiceLevelToday
Cumulative ICM service level for this route since
midnight. The ICM software uses the same type of
calculation as specified for the service associated
with the route.
midnight. The ICM software uses the same type of
calculation as specified for the service associated
with the route.
DBFLT4
NULL
Table 2-288 Route_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option