Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
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.
This field is applicable for both ICM and IPCC 
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. 
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.
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.
This field is applicable for both ICM and IPCC 
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. 
This field is applicable for both ICM and IPCC 
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. 
Examples: agent-to-agent transfers and supervisor 
calls. 
TalkOtherTime is included in the calculation of 
TalkTime and LoggedOnTime.
This field is applicable for both ICM and IPCC 
Enterprise
.
DBINT
NULL
Table 2-18 Agent_Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and 
Null Option