Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-39
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via profileID)
•
(via resourceSkillMapID and profileID)
•
(via skillID and profileID)
RmonCSQConfig
Database table name: RmonCSQConfig
The Remote Monitoring Contact Service Queue Configuration table contains the CSQs that a remote
monitoring supervisor is allowed to monitor (the supervisor’s allowed list). This table is updated when
you configure the Unified CCX system through the Unified CCX Administration pages.
monitoring supervisor is allowed to monitor (the supervisor’s allowed list). This table is updated when
you configure the Unified CCX system through the Unified CCX Administration pages.
The RmonCSQConfig table contains the fields shown in
.
Table 1-19
ResourceSkillMapping Table Fields
Field Name
Description
Storage
resourceSkillMapID Identifier of the skill set that is associated with a resource.
int
NOT NULL
Primary Key
skillID
Identifier of the skill that is associated with a resource.
int
NOT NULL
Primary Key
profileID
Identifier of the Unified CCX profile that is associated with
this record.
this record.
int
NOT NULL
Primary Key
competenceLevel
Competence level associated with the skill, as set up in the
Unified CCX Administration.
Unified CCX Administration.
Values range from 1 (lowest)
to 10 (highest).
smallint
NOT NULL
active
Whether the record is active:
f —Inactive
t —Active
A record becomes inactive if a new skill or a new
competence level is assigned to the resource that is
associated with this record.
competence level is assigned to the resource that is
associated with this record.
boolean
NOT NULL