Cisco Cisco IPCC Web Option Technical References
2-9
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Logout Table
Related tables:
Agent (via SkillTargetID)
Media Routing Domain (via MRDomainID)
Agent_Logout Table
Central database only.
Each row provides statistics for an agent’s session. A session begins when an agent first logs in to the
system and ends when the agent logs outs.
system and ends when the agent logs outs.
LoggedOnTimeToHalf
Total time, in seconds, the agent was logged on
during the half- hour interval.
during the half- hour interval.
int
NULL
AvailTimeToHalf
Total time, in seconds, the agent was in the
Available state for any skill group during the half-
hour interval.
Available state for any skill group during the half-
hour interval.
int
NULL
NotReadyTimeToHalf
Total time, in seconds, the agent was in the Not
Ready state for all skill groups during the half- hour
interval.
Ready state for all skill groups during the half- hour
interval.
int
NULL
TalkOtherTimeToHalf
Total time, in seconds, the agent spent talking on
internal calls during the half- hour interval.
internal calls during the half- hour interval.
int
NULL
AvailableInMRDTimeToHalf
The number of seconds in this half-hour interval that
this agent was available with respect to this MRD.
this agent was available with respect to this MRD.
int
NULL
RoutableInMRDTimeToHalf
The number of seconds in this half-hour interval that
this agent was routable with respect to this MRD.
this agent was routable with respect to this MRD.
int
NULL
Table 2-5
Agent_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-6
Agent_Logout Table
Field Name
Description
Data Type
Keys and Null
Option
Option
LogoutDateTime
Central Controller date and time when the agent
logged out.
logged out.
datetime
PK, NOT NULL
SkillTargetID
Identifies the agent.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the dates and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
int
PK, NOT NULL
MRDomainID
The identifier for the Media Routing Domain
associated with the agent logout.
associated with the agent logout.
int
PK, FK NOT
NULL
NULL
LoginDuration
Number of seconds the agent was logged in.
int
NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL