Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
2-15
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Logout Table
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.
agent first logs in to the system and ends when the agent logs outs.
Related tables:
(via SkillTargetID)
(via NetworkTargetID)
(via MRDomainID)
Table 2-13 Agent_Logout Table Constraints
Constraint
Field Name(s)
PK
LogoutDateTime
MRDomainID
SkillTargetID
TimeZone
MRDomainID
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
MRDomainID,
NetworkTargetID
SkillTargetID
NetworkTargetID
SkillTargetID
Table 2-14 Agent_Logout Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
LoginDuration
Number of seconds the agent was logged in.
DBINT
NULL
LogoutDateTime
Central Controller date and time when the agent
logged out.
logged out.
DBDATETIME
PK
NOT NULL
MRDomainID
The identifier for the Media Routing Domain
associated with the agent logout.
associated with the agent logout.
DBINT
PK
NOT NULL
NetworkTargetID
The device target the agent was logged on to. This
applies to IPCC agents only.
applies to IPCC agents only.
DBINT
NULL
ReasonCode
Reason code returned by the peripheral for the
agent logout.
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.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
SkillTargetID
Identifies the agent.
DBINT
PK
NOT 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.
DBINT
PK
NOT NULL