Cisco Cisco Unified Contact Center Enterprise 9.0(2) テクニカルリファレンス
2-17
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Skill_Group_Half_Hour Table
InternalCallsOnHoldTimeToHalf
Total number of seconds completed internal calls
were placed on hold during the half-hour interval.
The value is updated in the database when the
after-call work time associated with the call (if any)
is completed.
were placed on hold during the half-hour interval.
The value is updated in the database when the
after-call work time associated with the call (if any)
is completed.
int
NULL
InternalCallsOnHoldToHalf
The total number of internal calls the agent placed
on hold at least once. The value is updated in the
database when the after-call work time associated
with the call (if any) is completed.
on hold at least once. The value is updated in the
database when the after-call work time associated
with the call (if any) is completed.
int
NULL
InternalCallsRcvdTimeToHalf
Number of seconds spent on internal calls received
by the agent during the half-hour interval. The value
is updated in the database when the after-call work
time associated with the call (if any) is completed.
by the agent during the half-hour interval. The value
is updated in the database when the after-call work
time associated with the call (if any) is completed.
int
NULL
InternalCallsRcvdToHalf
Number of internal calls received by the agent
during the half-hour interval. The value is updated
in the database when the after-call work time
associated with the call (if any) is completed.
during the half-hour interval. The value is updated
in the database when the after-call work time
associated with the call (if any) is completed.
int
NULL
InternalCallsTimeToHalf
Number of seconds spent on internal calls initiated
by the agent during the half-hour interval. The value
is updated in the database when the after-call work
time associated with the call (if any) is completed.
by the agent during the half-hour interval. The value
is updated in the database when the after-call work
time associated with the call (if any) is completed.
int
NULL
InternalCallsToHalf
Number of internal calls initiated by the agent
during the half-hour interval. The value is updated
in the database when the after-call work time
associated with the call (if any) is completed.
during the half-hour interval. The value is updated
in the database when the after-call work time
associated with the call (if any) is completed.
int
NULL
LoggedOnTimeToHalf
Total time, in seconds, the agent in the skill group
was logged on during the half-hour interval. This
value is calculated as follows:
was logged on during the half-hour interval. This
value is calculated as follows:
HoldTimeToHalf + TalkInTimeToHalf +
TalkOutTimeToHalf + TalkOtherTimeToHalf +
AvailTimeToHalf + NotReadyTimeToHalf +
WorkReadyTimeToHalf +
WorkNotReadyTimeToHalf +
BusyOtherTimeToHalf +
ReservedStateTimeToHalf
TalkOutTimeToHalf + TalkOtherTimeToHalf +
AvailTimeToHalf + NotReadyTimeToHalf +
WorkReadyTimeToHalf +
WorkNotReadyTimeToHalf +
BusyOtherTimeToHalf +
ReservedStateTimeToHalf
int
NULL
NotReadyTimeToHalf
Total seconds the agent in the skill group was in the
Not Ready state during the half-hour interval.
NotReadyTime is included in the calculation of
LoggedOnTime.
Not Ready state during the half-hour interval.
NotReadyTime is included in the calculation of
LoggedOnTime.
int
NULL
RedirectNoAnsCallsToHalf
The number of ACD calls that rang at the agent’s
terminal and redirected on failure to answer. The
value is updated in the database at the time the call
is diverted to another device.
terminal and redirected on failure to answer. The
value is updated in the database at the time the call
is diverted to another device.
int
NULL
Table 2-8
Agent_Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option