Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
Table 353: Fields in Service_Array_Member table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
PK, FK
NOT
NULL
NOT
NULL
DBINT
Identifies the service array.
ServiceArraySkillTargetID
PK NOT
NULL
NULL
DBINT
Identifies a service that is a member of the service
array.
array.
ServiceSkillTargetID
Service_Five_Minute
This table is in the
category. To see database rules for these tables, see
Central database only.
Contains statistics about each service during the most recent five-minute interval.
The system software generates Service_Five_Minute records for each service.
Use the Service Explorer tool to add, update, and delete Service_Array records.
Related table
(via SkillTargetID)
Table 354: Indexes for Service_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Service_Five_Minute
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKService_Five_Minute
Table 355: Fields in Service_Five_Minute table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
NULL
DBINT
Number of service agents in the talking state at the
end of the five-minute interval.
end of the five-minute interval.
AgentsTalking
NULL
DBINT
Average delay time of abandoned calls in queue for
the service during the five-minute interval.
the service during the five-minute interval.
AvgDelayQAbandTo5
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
459
All tables
Service_Five_Minute