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
PK, FK
NOT
NULL
DBINT
An identifier that is unique among all skill targets
in the enterprise.
SkillTargetID
NOT
NULL
DBINT
The type of translation route:
• = DNIS
• = CDPD
Type
Translation_Route_Half_Hour
This table is in the
category. To see database rules for these tables, see
.
Provides statistics for each translation route. These statistics are updated every 30 minutes.
Related tables
(via RoutingClientID)
(via TranslationRouteSkillTargetID)
Table 388: Indexes for Translation_Route_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key located
on PRIMARY
XAK1Translation_Route_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Translation_Route_Half_Hour
DateTime, RoutingClientID,
TranslationRouteSkillTargetID, TimeZone
clustered, unique, primary key located on
PRIMARY
XPKTranslation_Route_Half_Hour
Table 389: Fields in Translation_Route_Half_Hour table
Keys and
NULL
Option
Data Type
Description
Name
NULL
DBINT
Average number of routes in use in the last half
hour.
AvgRoutesInUseToHalf
NULL
DBINT
Average time (in seconds) to successfully complete
a translation route for a routing client.
AvgRouteTimeToHalf
   Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
600
All tables
Translation_Route_Half_Hour