Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-46
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
•
(via profileID)
•
(via skillID and profileID)
•
(via skillID and profileID)
SkillGroup
Database table name: SkillGroup
The Unified CCX system creates a new record in the SkillGroup table when skills are associated with a
CSQ in the Unified CCX Administration.
CSQ in the Unified CCX Administration.
A SkillGroup record describes each skill that is associated with the CSQ.
.
skillName
Name of the skill, as set up in the Unified CCX
Administration.
Administration.
nvarchar(50)
NOT NULL
active
Determines whether the record is active in the Unified CCX
system:
system:
f —Inactive
t —Active
A record becomes inactive if the skill is deleted or updated.
boolean
NOT NULL
dateInactive
If the active field is “f”, date and time that the record
became inactive.
became inactive.
datetime year to
fraction(3)
fraction(3)
NULL
Table 1-25
Skill Table Fields (continued)
Field Name
Description
Storage
Table 1-26
Skill Group Table Fields
Field Name
Description
Storage
skillGroupID
Numeric identifier of the skill group.
int
NOT NULL
Primary Key
skillID
Numeric identifier of the skill.
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
Minimum acceptable skill level for agents with this skill, as
set up in the Unified CCX Administration. Values range
from 1 (lowest) to 10 (highest).
set up in the Unified CCX Administration. Values range
from 1 (lowest) to 10 (highest).
smallint
NOT NULL