Cisco Cisco E-Mail Manager Unity Integration Option Technical References
![Cisco](https://files.manualsbrain.com/attachments/7380d0050044647c30f5c24bbbf5d0c0b6d9bb84/common/fit/150/50/faa183d287233c52228cfea3dbc2a127fe780f60564fcb0955d9c3d1cd23/brand_logo.png)
2-18
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Skill_Group_Half_Hour Table
RedirectNoAnsCallsTimeToHalf
The number of seconds ACD calls rang at the
agent’s terminal before being redirected on failure
to answer. The value is updated in the database at the
time the call is diverted to another device.
agent’s terminal before being redirected on failure
to answer. The value is updated in the database at the
time the call is diverted to another device.
int
NULL
ReservedStateTimeToHalf
Total seconds the agent in the skill group was in the
Reserved state during the half-hour interval.
ReservedStateTime is included in the calculation of
LoggedOnTime.
Reserved state during the half-hour interval.
ReservedStateTime is included in the calculation of
LoggedOnTime.
int
NULL
ShortCallsToHalf
Number of calls answered by the agent where the
duration of the calls falls short of the Abandoned
Call Wait Time. You might choose to factor these
calls out of handle time statistics that you calculate.
A call is determined to be a short call if it is
abandoned before the Abandoned Call Wait Time
expired. Short calls are not considered abandoned
and are not accounted for in any of the ICM
abandoned calls calculations.
duration of the calls falls short of the Abandoned
Call Wait Time. You might choose to factor these
calls out of handle time statistics that you calculate.
A call is determined to be a short call if it is
abandoned before the Abandoned Call Wait Time
expired. Short calls are not considered abandoned
and are not accounted for in any of the ICM
abandoned calls calculations.
int
NULL
SupervAssistCallsTimeToHalf
Number of seconds that agents in the skill group
spent on supervisor- assisted calls during the half-
hour interval. The value is updated in the database
when the supervisor assist call completes.
spent on supervisor- assisted calls during the half-
hour interval. The value is updated in the database
when the supervisor assist call completes.
int
NULL
SupervAssistCallsToHalf
Number of calls for which agents received
supervisor assistance during the half- hour interval.
The value is updated in the database when the
supervisor assist call completes.
supervisor assistance during the half- hour interval.
The value is updated in the database when the
supervisor assist call completes.
int
NULL
TalkInTimeToHalf
Number of seconds that agents in the skill group
spent talking on inbound ACD calls (neither
outbound nor internal) during the half-hour interval.
TalkInTime is included in the calculation of
TalkTime and LoggedOnTime.
spent talking on inbound ACD calls (neither
outbound nor internal) during the half-hour interval.
TalkInTime is included in the calculation of
TalkTime and LoggedOnTime.
int
NULL
TalkOtherTimeToHalf
Number of seconds that agents in the skill group
spent talking on internal outbound or consultative
transfer calls (examples: agent-to-agent transfers
and supervisor calls) during the half-hour interval.
TalkOtherTime is included in the calculation of
TalkTime and LoggedOnTime.
spent talking on internal outbound or consultative
transfer calls (examples: agent-to-agent transfers
and supervisor calls) during the half-hour interval.
TalkOtherTime is included in the calculation of
TalkTime and LoggedOnTime.
int
NULL
TalkOutTimeToHalf
Number of seconds that agents in the skill group
spent talking on external outbound or consultative
transfer calls during the half-hour interval.
TalkOutTime is included in the calculation of
TalkTime and LoggedOnTime.
spent talking on external outbound or consultative
transfer calls during the half-hour interval.
TalkOutTime is included in the calculation of
TalkTime and LoggedOnTime.
int
NULL
Table 2-8
Agent_Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option