Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-207
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Service_Half_Hour Table
Related tables:
Service (via SkillTargetID)
Service_Half_Hour Table
Central database only.
Contains information about each service during the most recent 30-minute interval.
The ICM software generates Service_Half_Hour records for each service.
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).
int
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).
int
NULL
CallsAnsweredToday
Number of calls to the service answered by
agents since midnight.
agents since midnight.
int
NULL
CallsAnsweredTo5
Number of calls to the service answered by
agents during the five-minute interval.
agents during the five-minute interval.
int
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.
for the service had been available as of the end
of the five-minute interval. If no agent was
available, the value is 0.
int
NULL
RecoveryDay
A value used internally by the ICM software to
track virtual time.
track virtual time.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
AK1, NOT
NULL
NULL
Table 2-169 Service_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-170 Service_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time at the start of
the half-hour interval.
the half-hour interval.
smalldatetime
PK, NOT NULL
SkillTargetID
Foreign key from the Service table.
int
PK, FK, NOT
NULL
NULL