Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-323
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service_Half_Hour Table
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.
Table 2-345 Service_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
SkillTargetID
TimeZone
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
SkillTargetID
IE-1
DbDateTime
Table 2-346 Service_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AnswerWaitTimeToHalf
The sum of AnswerWaitTime in seconds for all
calls answered for the service during the last
half-hour interval. AnswerWaitTime is the elapsed
time from when the call is offered at the
peripheral, to when it is answered. This includes
all DelayTime, LocalQTime, and RingTime
associated with the call.
calls answered for the service during the last
half-hour interval. AnswerWaitTime is the elapsed
time from when the call is offered at the
peripheral, to when it is answered. This includes
all DelayTime, LocalQTime, and RingTime
associated with the call.
For multimedia, the sum of the answer wait times
of all tasks associated with this service that began
in this half-hour interval.
of all tasks associated with this service that began
in this half-hour interval.
DBINT
NULL
AutoOutCallsOnHoldTimeToHalf
Number of seconds that AutoOut (predictive) calls
were placed on hold by this service during the
half-hour interval. This data element is based on
HoldTime. The value is updated in the database
when the after-call work associated with the call
(if any) has completed.
were placed on hold by this service during the
half-hour interval. This data element is based on
HoldTime. The value is updated in the database
when the after-call work associated with the call
(if any) has completed.
Not currently used for Outbound Option.
Not valid for IPCC Enterprise.
DBINT
NULL
AutoOutCallsOnHoldToHalf
Number of ended AutoOut (predictive) calls that
this service has placed on hold at least once. The
value is updated in the database when the
after-call work time associated with the call (if
any) has completed.
this service has placed on hold at least once. The
value is updated in the database when the
after-call work time associated with the call (if
any) has completed.
Not currently used for Outbound Option.
Not valid for IPCC Enterprise.
DBINT
NULL