Manualsbrain.com
  1. Manuali
  2. Marche
  3. Cisco
  4. Cisco E-Mail Manager Unity Integration Option
  5. Riferimenti tecnici

Cisco Cisco E-Mail Manager Unity Integration Option Riferimenti tecnici

Scarica
Pagina di 548
   
2-37
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Agent_Skill_Group_Logout Table
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:
 (SkillTargetID + SkillGroupSkillTargetID maps to 
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Table 2-19 Agent_Skill_Group_Logout Table Constraints
Constraint
Field Name(s)
PK
LogoutDateTime
SkillGroupSkillTargetID
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
SkillGroupSkillTargetID
SkillTargetID
IE-1
DBDateTime
Table 2-20 Agent_Skill_Group_Logout Table
Field Name
Description
Data Type
Keys and 
Null Option
LoginDuration
Number of seconds the agent was logged in to the 
skill group.
DBINT
NULL
LogoutDateTime
Date and time when the agent logged out of the 
skill group.
DBDATETIME
PK
NOT NULL
ReasonCode
Reason code returned by the peripheral for the 
agent logout.
DBINT
NULL
RecoveryKey
A unique ID assigned to each record and used 
internally by the ICM/IPCC Enterprise software to 
track the record.
DBFLT8
AK-1
NOT NULL
SkillGroupSkillTargetID
Together with SkillTargetID identifies the skill 
group member.
DBINT
PK, FK
NOT NULL
SkillTargetID
The SkillTargetID of the agent. Together with 
SkillGroupSkillTargetID identifies the skill group 
member.
DBINT
PK, FK
NOT NULL
TimeZone
The time zone for the dates and times. The value 
is the offset in minutes from GMT.
DBINT
PK
NOT NULL