Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-333
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service_Level_Threshold Table
Related tables:
(via SkillTargetID)
Service_Level_Threshold Table
The Service Level Threshold table specifies how the ICM calculates service level for a particular
peripheral. Each row in this table contains specific default values for a PeripheralID-Media Routing
Domain pair.
peripheral. Each row in this table contains specific default values for a PeripheralID-Media Routing
Domain pair.
SkillTargetID
The SkillTargetID of this service. Foreign key
from the Service table.
from the Service table.
DBINT
PK, FK
NOT NULL
TalkTimeToHalf
The number of seconds that agents spent in the
ACTIVE state or the PAUSED state for tasks
associated with this service that ended in this
half-hour interval.
ACTIVE state or the PAUSED state for tasks
associated with this service that ended in this
half-hour interval.
DBINT
NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NOT NULL
TransferInCallsToHalf
Number of calls transferred into the service during
the half-hour interval. This count includes
consultative transfers and blind transfers to the
service. The count is populated in the database
when the after-call work associated with the call
(if any) is finished.
the half-hour interval. This count includes
consultative transfers and blind transfers to the
service. The count is populated in the database
when the after-call work associated with the call
(if any) is finished.
Not valid for IPCC Enterprise.
Not valid for non-voice tasks. Set to zero by OPC.
DBINT
NULL
TransferOutCallsToHalf
Number of calls transferred out of the service
during the half-hour interval. This count includes
consultative transfers and blind transfers made
from the service. The count is populated in the
database when the after-call work associated with
the call (if any) is finished.
during the half-hour interval. This count includes
consultative transfers and blind transfers made
from the service. The count is populated in the
database when the after-call work associated with
the call (if any) is finished.
Not valid for IPCC Enterprise.
Not valid for non-voice tasks. Set to zero by OPC.
DBINT
NULL
Table 2-346 Service_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option
Table 2-347 Service_Level_Threshold Table Constraints
Constraint
Field Name(s)
PK
MRDomainID
PeripheralID
PeripheralID
FK
PeripheralID