Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Note De Mise
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.
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.
.
active
Whether the record is active in the system. A record
becomes inactive if the campaign is deleted from the
system.
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
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.
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.
to monitor the agent.
datetime year to
fraction (3)
fraction (3)
NOT NULL