Cisco Cisco E-Mail Manager Unity Integration Option Technical References
Keys
and Null
Option:
and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of calls transferred out by the agent during the half-hour
interval. The value is updated at the time the agent completes the
transfer of the call.
interval. The value is updated at the time the agent completes the
transfer of the call.
TransferredOutCallsToHalf
NULL
DBINT
During the half-hour interval, the number of calls coached either by
the supervisor or by the agent.
the supervisor or by the agent.
WhisperCallsToHalf
NULL
DBINT
Total time in seconds an agent associated with this skill group was
in the Work Not Ready state during the half-hour interval.
in the Work Not Ready state during the half-hour interval.
WorkNotReadyTimeToHalf
WorkNotReadyTime is included as in the calculation of
LoggedOnTime.
LoggedOnTime.
NULL
DBINT
Total seconds an agent in the skill group was in the Work Ready state
for tasks associated with this skill group that ended during the
for tasks associated with this skill group that ended during the
WorkReadyTimeToHalf
half-hour interval. WorkReadyTime is included in the calculation of
LoggedOnTime.
LoggedOnTime.
Agent_Skill_Group_Logout Table
. To see database rules for these tables, click
Each row provides information about a single login session for a member of a skill group. If an
individual agent is a member of multiple skill groups, multiple Agent Skill Group Logout rows
are created for that agent.
individual agent is a member of multiple skill groups, multiple Agent Skill Group Logout rows
are created for that agent.
The software generates an Agent_Skill_Group_Logout record for each skill group member.
Table 17: Related Table for Agent_Skill_Group_Logout
(SkillTargetID + SkillGroupSkillTargetID maps to
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Table 18: Indexes for Agent_Skill_Group_Logout Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Skill_Group_Logout
LogoutDateTime, SkillTargetID,
SkillGroupSkillTargetID, TimeZone
SkillGroupSkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Skill_Group_Logout
Fields in Agent_Skill_Group_Logout Table :
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of seconds the agent was logged in to the skill group.
LoginDuration
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
47
Chapter 2: All Tables
Agent_Skill_Group_Logout Table