Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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
Fields in Agent_Logout Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
varchar
Foreign key from Translation Route
Extension
NULL
DBINT
Number of seconds the agent was logged in.
LoginDuration
PK NOT NULL
DBDATETIME
Central Controller date and time when the agent logged
out.
out.
LogoutDateTime
PK NOT NULL
DBINT
The identifier for the Media Routing Domain
associated with the agent logout.
associated with the agent logout.
MRDomainID
NULL
DBINT
The device target the agent was logged on to. This
applies to IPCC agents only.
applies to IPCC agents only.
NetworkTargetID
NULL
DBSMALLINT
The kind of phone being used:
PhoneType
0 = normal ACD/IPCC phone, or non voice task
1 = remote phone, call by call
2 = remote phone, nailed connection
All new agent logout data will have a NOT NULL
value by default.
During upgrade/migration, the value for this column
will be NULL.
1 = remote phone, call by call
2 = remote phone, nailed connection
All new agent logout data will have a NOT NULL
value by default.
During upgrade/migration, the value for this column
will be NULL.
NULL
DBINT
Reason code returned by the peripheral for the agent
logout.
logout.
ReasonCode
AK-1 NOT NULL
DBFLT8
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.
RecoveryKey
NULL
VARCHAR (32)
For a mobile agent working remotely, the current
phone number.
phone number.
RemotePhoneNumber
PK NOT NULL
DBINT
Identifies the agent.
SkillTargetID
PK NOT NULL
DBINT
The time zone for the dates and time. The value is the
offset in minutes from UTC (formerly called GMT).
offset in minutes from UTC (formerly called GMT).
TimeZone
Agent_Real_Time Table
This table is one of the Agent Detail tables in the
. To see
database rules for these tables, click
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
32
Chapter 2: - All Tables
Agent_Real_Time Table