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

Page of 76
1-41
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1      Database Schema
  Database Table Details
Related Tables
  •
 (via ProfileID)
  •
 (via resourceLoginID, profileID
  •
 (via rmonID, profileID)
  •
 (via rmonID, profileID)
RmonUser
Database table name: RmonUser
The Remote Monitoring User table provides information about the supervisor who is logged in to 
remotely monitor agents.
The RmonUser table contains the fields shown in 
.
Related Tables
  •
 (via profileID)
  •
 (loginID maps to remoteLoginID, via profileID, and rmonID
  •
 (via rmonID and profileID)
Table 1-22
RmonUser Table Fields 
Field Name
Description
Storage
rmonID
Numeric identifier of the remote supervisor.
int
NOT NULL
Primary Key
LoginID
User login name of the remote supervisor.
nvarchar(50)
NOT NULL
name
Name of the supervisor.
nvarchar(50)
NOT NULL
profileID
Identifier of the Unified CCX profile that is associated with 
this record.
int
NOT NULL
Primary Key
type
The type of supervisor:
0 = regular supervisor
1 = remote monitoring supervisor
int
NOT NULL
active
Determines whether the remote supervisor is active.
f = inactive
t = active
boolean
NOT NULL
dateInactive
Date and time the remote supervisor became inactive.
datetime year to 
second
NULL