Cisco Cisco Unified Contact Center Express 10.6(1) Technical References
1-59
Cisco Unified CCX Database Schema Guide, Release 10.6(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
•
(via profileID)
•
(via skillID and profileID)
Supervisor
Database table name: Supervisor
The Supervisor table contains the information about the supervisor.
The Supervisor table contains the fields shown in
active
Determines whether the record is active in the CSQ:
f —Inactive
t —Active
A record becomes inactive if the new skill group is deleted
or updated.
or updated.
boolean
NOT NULL
skillWeight
Skills within a CSQ can be assigned weights. This field is
used in the weighted skill calculation of the skill-based
resource selection algorithm.
used in the weighted skill calculation of the skill-based
resource selection algorithm.
Default value is 1.
int
NOT NULL
skillOrder
Skills within a CSQ can be ordered. This field is used in the
order skill calculation of the skill-based resource selection
algorithm.
order skill calculation of the skill-based resource selection
algorithm.
Default value is 1.
int
NOT NULL
Table 1-34
Skill Group Table Fields (continued)
Field Name
Description
Storage
Table 1-35
Supervisor Table Fields
Field Name
Description
Storage
recordID
Numeric identifier of this supervisor.
int
NOT NULL
Primary Key
resourceLoginID
User ID in the Unified CM configuration.
nvarchar(50)
NOT NULL
managedTeamID
Team identifier of the managed team.
int
NOT NULL
profileID
Identifier of the Unified CCX profile that is associated
with this record.
with this record.
int
NOT NULL
Primary Key