Cisco Cisco IP Contact Center Release 4.6.2 Riferimenti tecnici

Pagina di 620
Fields in Agent_Logout Table:
Keys and Null
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.
LogoutDateTime
PK NOT NULL
DBINT
The identifier for the Media Routing Domain associated with the
agent logout.
MRDomainID
NULL
DBINT
The device target the agent was logged on to. This 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.
NULL
DBINT
Reason code returned by the peripheral for the agent 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.
RecoveryKey
NULL
VARCHAR (32)
For a mobile agent working remotely, the current 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).
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 7.2(2)
29
Chapter 2:  All Tables
Agent_Real_Time Table