Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 404
 
2-23
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Agent_Skill_Group_Logout Table
Related tables:
Skill Group Member (SkillTargetID + SkillGroupSkillTargetID maps to 
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Agent_Skill_Group_Logout Table  
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.
The ICM software generates an Agent_Skill_Group_Logout record for each skill group member.
Related tables:
Skill Group Member (SkillTargetID + SkillGroupSkillTargetID maps to 
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
EmergencyAssistsToHalf
The number of emergency assist requests made 
either by the agent or by the supervisor.
int
NULL
InterruptedTimeToHalf
The number of seconds the agent was in the 
Interrupted state during the half-hour interval.
int
NULL
Table 2-8
Agent_Skill_Group_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-9, Part 1
Agent_Skill_Group_Logout Table
Field Name
Description
Data Type
Keys and Null 
Option
LogoutDateTime
Date and time when the agent logged in to the skill 
group.
datetime
PK, NOT NULL
SkillTargetID
The SkillTargetID of the agent. Together with 
SkillGroupSkillTargetID identifies the skill group 
member.
int
PK, FK, NOT 
NULL
SkillGroupSkillTargetID
Together with SkillTargetID identifies the skill 
group member.
int
PK, FK, NOT 
NULL
TimeZone
The time zone for the dates and times. The value is 
the offset in minutes from GMT.
int
PK, NOT NULL
LoginDuration
Number of seconds the agent was logged in to the 
skill group.
int
NULL
RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
AK1, NOT 
NULL
ReasonCode
Reason code returned by the peripheral for the agent 
logout.
int
NULL