Cisco Cisco Administrative Workstation Referencia técnica
2-376
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Skill_Group_Half_Hour Table
TalkReserveTimeToHalf
Number of seconds the agent spent talking on
agent reservation calls during the half-hour
interval. TalkReserveTimeToHalf is included in
the calculation of LoggedOnTimeToHalf.
agent reservation calls during the half-hour
interval. TalkReserveTimeToHalf is included in
the calculation of LoggedOnTimeToHalf.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
TalkTimeToHalf
Total seconds agents associated with this skill
group were in the Talking state during the
half-hour interval. This value is based on the
following:
group were in the Talking state during the
half-hour interval. This value is based on the
following:
•
TalkInTimeToHalf
•
TalkOutTimeToHalf
•
TalkOtherTimeToHalf
•
TalkAutoOutTime
•
TalkPreviewTime
•
TalkReservedTime
This field is applicable for both ICM, IPCC
Enterprise and Outbound Option.
Enterprise and Outbound Option.
DBINT
NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
PK
NOT NULL
TransferInCallsTimeToHalf
Number of seconds agents associated with this
skill group spent handling transferred in calls that
ended during this half-hour interval. The value is
updated in the database when the after-call work
time associated with the call (if any) is completed.
skill group spent handling transferred in calls that
ended during this half-hour interval. The value is
updated in the database when the after-call work
time associated with the call (if any) is completed.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
TransferInCallsToHalf
Number of calls transferred into the skill group
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.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
TransferOutCallsToHalf
Number of calls transferred out of the skill group
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.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
Table 2-360 Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option