Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Note De Mise

Page de 76
1-31
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1      Database Schema
  Database Table Details
Related Tables
  •
 (via dialingListID and profileID)
  •
 (via gmtZone)
  •
 (via campaignID and profile ID)
  •
 (via campaignID and profileID)
  •
 (via campaignID)
  •
 (via profileID)
MonitoredResourceDetail
Database table name: MonitoredResourceDetail
The MonitoredResourceDetail table records the actual agents who are monitored. The 
RemoteMonitoringDetail table records the original agent or the CSQ that the supervisor plans to 
monitor. Monitoring a CSQ involves monitoring the agents who handle calls for that CSQ. So the actual 
agents (which can be more than one) that are monitored will be recorded in the MonitoredResourceDetail 
table.
The MonitoredResourceDetail table contains the fields shown in 
.
 
active
Whether the record is active in the system. A record 
becomes inactive if the campaign is deleted from the 
system.
f = Inactive
t = Active
boolean
NOT NULL
dateinactive
Date this record was deleted.
datetime year to 
second
NULL
Table 1-13
DialingList Table Fields (continued)
Field Name
Description
Storage
Table 1-14
MonitoredResourceDetail Table Fields
Field Name
Description
Storage
sessionid
Identifier that the system assigned to the call. This 
identifier remains the same for all legs of the call. It is the 
sessionID of the IVR call; that is, when the supervisor 
starts monitoring, the monitoring call itself is an IVR 
call. The supervisor monitors one or more Unified CCX 
calls.
decimal(18)
NOT NULL
Primary Key
startmonitoringreqtime
The time and date that the remote supervisor attempted 
to monitor the agent.
datetime year to 
fraction (3)
NOT NULL