Cisco Cisco Unified Contact Center Enterprise 9.0(2) Referencia técnica
2-321
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service_Five_Minute Table
DateTime
Date and time at the start of the five-minute
interval.
interval.
DBSMALLDATE
PK
NOT NULL
ExpectedDelay
Predicted delay for any new call added to the
service queue at the end of the five-minute
interval. This is valid only if no agents are
available.
service queue at the end of the five-minute
interval. This is valid only if no agents are
available.
DBFLT4
NULL
LongestAvailAgent
Number of seconds the longest available agent for
the service had been available as of the end of the
five-minute interval. If no agent was available, the
value is 0.
the service had been available as of the end of the
five-minute interval. If no agent was available, the
value is 0.
DBINT
NULL
LongestCallQ
Length of time that longest call in the queue for
the service had been there at the end of the
five-minute interval.
the service had been there at the end of the
five-minute interval.
DBINT
NULL
OverFlowInTo5
Number of calls the peripheral re-targeted, or
overflowed, into the service during the
five-minute interval. The ICM software keeps
counts of the number of calls moved out of each
service or route (overflowed out) and moved into
each service or route (overflowed in).
overflowed, into the service during the
five-minute interval. The ICM software keeps
counts of the number of calls moved out of each
service or route (overflowed out) and moved into
each service or route (overflowed in).
DBINT
NULL
OverflowOutTo5
Number of calls the peripheral retargeted, or
overflowed, out of the service during the
five-minute interval. The ICM software keeps
counts of the number of calls moved out of each
service or route (overflowed out) and moved into
each service or route (overflowed in).
overflowed, out of the service during the
five-minute interval. The ICM software keeps
counts of the number of calls moved out of each
service or route (overflowed out) and moved into
each service or route (overflowed in).
DBINT
NULL
PeriphServiceLevelTo5
Service level for the service during five-minute
interval, as calculated by the peripheral.
interval, as calculated by the peripheral.
DBFLT4
NULL
PeriphServiceLevelToday
Service level for the service since midnight, as
calculated by the peripheral.
calculated by the peripheral.
DBFLT4
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
ServiceLevelAbandTo5
Number of calls to the service abandoned within
the service level during the five-minute interval.
the service level during the five-minute interval.
DBINT
NULL
ServiceLevelAbandToday
Number of calls to the service abandoned within
the service level since midnight.
the service level since midnight.
DBINT
NULL
ServiceLevelCallsOfferedTo5
Number of calls to the service answered or
abandoned during the five-minute interval.
abandoned during the five-minute interval.
DBINT
NULL
ServiceLevelCallsOfferedToday
Number of calls to the service answered or
abandoned since midnight.
abandoned since midnight.
DBINT
NULL
Table 2-344 Service_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option