Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas

Página de 718
Keys and
NULL
Option
Data Type
Description
Name
NULL
DBINT
Number of calls to the service handled within the
service level today.
ServiceLevelCallsToday
NULL
DBFLT4
Service level during the five-minute interval. This
is derived from ServiceLevelCallsTo5 and
ServiceLevelCallsHandledTo5.
ServiceLevelTo5
NULL
DBFLT4
Cumulative service level for the service since
midnight. This is derived from
ServiceLevelCallsToday and
ServiceLevelCallsOfferedToday.
ServiceLevelToday
PK, FK
NOT
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).
TimeZone
NULL
DBINT
This field is not currently used.
Unused1
Service_Half_Hour
This table is in the
category. To see database rules for these tables, see
Central database only.
Contains information about each service during the most recent 30-minute interval.
The system software generates Service_Half_Hour records for each service.
Related table
(via SkillTargetID)
Table 356: Indexes for Service_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Service_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Service_Half_Hour
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key located
on PRIMARY
XPKService_Half_Hour
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0    
463
All tables
Service_Half_Hour