Cisco Cisco IP Contact Center Release 4.6.1 Referencia técnica
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
NULL
DBFLT4
Service level during the five-minute interval. This is derived from
ServiceLevelCallsTo5 and ServiceLevelCallsHandledTo5.
ServiceLevelCallsTo5 and ServiceLevelCallsHandledTo5.
ServiceLevelTo5
NULL
DBFLT4
Cumulative ICM service level for the service since midnight. This
is derived from ServiceLevelCallsToday and
ServiceLevelCallsOfferedToday.
is derived from ServiceLevelCallsToday and
ServiceLevelCallsOfferedToday.
ServiceLevelToday
PK, FK NOT
NULL
NULL
DBINT
Foreign key from the Service table.
SkillTargetID
PK NOT NULL
DBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
minutes from UTC (formerly called GMT).
TimeZone
NULL
DBINT
This field is not currently used.
Unused1
Service_Half_Hour Table
. To see database rules for these tables, click
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.
Related table
(via SkillTargetID)
Table 190: Indexes for Service_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Service_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Service_Half_Hour
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService_Half_Hour
Fields in Service_Half_Hour Table:
Keys
and
Null
Option:
and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The sum of AnswerWaitTime in seconds for all calls answered for the
service during the last half-hour interval. AnswerWaitTime is the
service during the last half-hour interval. AnswerWaitTime is the
AnswerWaitTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
334
Chapter 2: All Tables
Service_Half_Hour Table