Technical References

Fields in Agent_Logout Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NULLvarchar
Foreign key from Translation Route
Extension
NULLDBINT
Number of seconds the agent was logged in.
LoginDuration
PK NOT NULLDBDATETIME
Central Controller date and time when the agent logged out.
LogoutDateTime
PK NOT NULLDBINT
The identifier for the Media Routing Domain associated with the
agent logout.
MRDomainID
NULLDBINT
The device target the agent was logged on to. This applies to IPCC
agents only.
NetworkTargetID
NULLDBSMALLINT
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.
NULLDBINT
Reason code returned by the peripheral for the agent logout.
ReasonCode
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULLVARCHAR (32)
For a mobile agent working remotely, the current phone number.
RemotePhoneNumber
PK NOT NULLDBINT
Identifies the agent.
SkillTargetID
PK NOT NULLDBINT
The time zone for the dates and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
Agent_Real_Time Table
This table is one of the Agent Detail tables in the Skill Target category (page 456). To see
database rules for these tables, click here (page 510).
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
29
Chapter 2: All Tables
Agent_Real_Time Table