Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-34
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Skill_Group_Half_Hour Table
SkillTargetID
The SkillTargetID of the agent. Together with
SkillGroupSkillTargetID identifies the skill group
member.
SkillGroupSkillTargetID identifies the skill group
member.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
PK, FK
NOT NULL
SupervAssistCallsTimeToHalf
Number of seconds an agent associated with this
skill group spent on supervisor-assisted calls
during the half-hour interval. The value is updated
in the database when the supervisor-assisted call
completes.
skill group spent on supervisor-assisted calls
during the half-hour interval. The value is updated
in the database when the supervisor-assisted call
completes.
This field is applicable for IPCC Enterprise only.
DBINT
NULL
SupervAssistCallsToHalf
Number of calls for which an agent received
supervisor assistance during the half-hour
interval. The value is updated in the database
when the supervisor-assisted call completes.
supervisor assistance during the half-hour
interval. The value is updated in the database
when the supervisor-assisted call completes.
This field is applicable for IPCC Enterprise only.
DBINT
NULL
TalkAutoOutTimeToHalf
The number of seconds the agent spent talking on
AutoOut (predictive) calls during the half-hour
interval. TalkAutoOutTime is included in the
calculation of LoggedOnTime.
AutoOut (predictive) calls during the half-hour
interval. TalkAutoOutTime is included in the
calculation of LoggedOnTime.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
TalkInTimeToHalf
Number of seconds an agent associated with this
skill group spent talking on inbound ACD calls
(neither internal nor outbound) during the
half-hour interval. TalkInTime is included in the
calculation of TalkTime and LoggedOnTime.
skill group spent talking on inbound ACD calls
(neither internal nor outbound) during the
half-hour interval. TalkInTime is included in the
calculation of TalkTime and LoggedOnTime.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
TalkOtherTimeToHalf
Number of seconds that an agent in the skill group
spent talking on other calls (neither inbound or
outbound) during the half-hour interval.
spent talking on other calls (neither inbound or
outbound) during the half-hour interval.
Examples: agent-to-agent transfers and supervisor
calls.
calls.
TalkOtherTime is included in the calculation of
TalkTime and LoggedOnTime.
TalkTime and LoggedOnTime.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
Table 2-18 Agent_Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option