Cisco Cisco IPCC Web Option Technical References
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The count of calls routed or queued to the agent in the half-hour
interval.
interval.
RouterCallsOfferedToHalf
This field is valid only if calls are routed directly to an agent, via either
the Queue-to-Agent node or the Send-to-Agent node in the routing
script.
the Queue-to-Agent node or the Send-to-Agent node in the routing
script.
NULL
DBINT
Number of calls queued to the agent by the CallRouter during the
half-hour interval.
half-hour interval.
RouterQueueCallsToHalf
PK, FK NOT
NULL
NULL
DBINT
Identifies the agent.
SkillTargetID
NULL
DBINT
Total time, in seconds, the agent spent talking on internal calls during
the half- hour interval.
the half- hour interval.
TalkOtherTimeToHalf
Only defined for voice media.
For non-voice media, this is set to zero.
PK NOT
NULL
NULL
DBINT
The time zone for the date and time. The value is the offset in minutes
from UTC (formerly called GMT).
from UTC (formerly called GMT).
TimeZone
Agent_Logout Table
This table is one of the Agent Detail tables in the
. To see
database rules for these tables, click
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.
when an agent first logs in to the system and ends when the agent logs outs.
Table 11: Related tables for Agent_Logout
(via NetworkTargetID)
(via SkillTargetID)
(via MRDomainID)
Table 12: Indexes for Agent_Logout Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Logout
LogoutDateTime, SkillTargetID,
TimeZone, MRDomainID
TimeZone, MRDomainID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Logout
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
28
Chapter 2: All Tables
Agent_Logout Table