Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen
Related Tables for Agent_Half_Hour
•
(via SkillTargetID)
•
Table 10: Indexes for Agent_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAKIAgentHalfHour
DbDateTime
nonclustered located on PRIMARY
XIE1Agent_Half_Hour
DateTime, SkillTargetID, TimeZone,
MRDomainID
MRDomainID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Half_Hour
Fields in Agent_Half_Hour Table :
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of seconds in the half-hour interval that
this agent was available with respect to this Media
Routing Domain.
this agent was available with respect to this Media
Routing Domain.
AvailableInMRDTimeToHalf
NULL
DBINT
Total time, in seconds, the agent was in the NOT
ACTIVE state during the half- hour interval.
ACTIVE state during the half- hour interval.
AvailTimeToHalf
PK NOT
NULL
NULL
DBSMALLDATE
The Central Controller date and time at the start of
the interval.
the interval.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the records
are written to the HDS database. The logger database
has NULL for this column.
are written to the HDS database. The logger database
has NULL for this column.
DbDateTime
NULL
DBINT
Total time, in seconds, the agent was logged into this
Media Routing Domain during the half- hour interval.
Media Routing Domain during the half- hour interval.
LoggedOnTimeToHalf
PK, FK
NOT NULL
NOT NULL
DBINT
Identifies the Media Routing Domain.
MRDomainID
NULL
DBINT
Total time, in seconds, the agent was in the Not
Ready state (a state in which agents are logged on,
Ready state (a state in which agents are logged on,
NotReadyTimeToHalf
but are neither involved in any call handling activity,
nor available to handle a call) with respect to this
Media Routing Domain during the half- hour interval.
nor available to handle a call) with respect to this
Media Routing Domain during the half- hour interval.
AK-1 NOT
NULL
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
DBINT
Reserved for future use.
Reserved1
NULL
DBINT
Reserved for future use.
Reserved2
NULL
DBINT
Reserved for future use.
Reserved3
NULL
DBINT
Reserved for future use.
Reserved4
NULL
DBFLT4
Reserved for future use.
Reserved5
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
29
Chapter 2: All Tables
Agent_Half_Hour Table