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

Página de 620
Keys and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of agents in the skill group in the Work Not Ready state at
the end of the five-minute interval.
WorkNotReady
NULL
DBINT
Number of seconds agents in the skill group were in the Work Not
Ready state during the five-minute window. WorkNotReadyTime
is included in the calculation of LoggedOnTime.
WorkNotReadyTimeTo5
NULL
DBINT
Number of agents in the skill group in the Work Ready state at the
end of the five-minute interval.
WorkReady
NULL
DBINT
Number of seconds agents in the skill group were in the Work Ready
state during the five-minute interval. WorkReadyTime is included
in the calculation of LoggedOnTime.
WorkReadyTimeTo5
Skill_Group_Half_Hour Table
To see database rules for these tables, click
Central database only. Contains statistics about each skill group during the last 30-minute
interval.
The ICM generates Skill_Group_Half_Hour records for each skill group.
Related table
 (via SkillTargetID)
Table 197: Indexes for Skill_Group_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Skill_Group_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Skill_Group_Half_Hour
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
XPKSkill_Group_Half_Hour
Fields in Skill_Group_Half_Hour Table:
Keys
and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of outbound calls that abandon while on hold. This will
be reported by OPC.
AbandonHoldCallsOutToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
371
Chapter 2:  All Tables
Skill_Group_Half_Hour Table