Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Release Note
1-45
Cisco Unified CCX Database Schema Guide, Release 8.0(1)
Chapter 1 Database Schema
Database Table Details
Related Tables
None.
Skill
Database table name: Skill
The Unified CCX system creates a new record in the Skill table when a skill is set up in the Unified CCX
Administration.
Administration.
A Skill record contains information about a skill. One such record exists for each configured skill.
The Skill table contains the fields shown in
startdatetime
Data collection starting time.
datetime year to
second
second
NOT NULL
enddatetime
Date and time this table was last updated.
datetime year to
second
second
NOT NULL
convavgtalkduration
Average talk duration in HH:MM:SS format.
varchar(25)
NOT NULL
convavgwaitduration
Average wait duration in HH:MM:SS format
varchar(25)
NOT NULL
convlongesttalkduration
Longest talk duration in HH:MM:SS format.
varchar(25)
NOT NULL
convlongestwaitduration
Longest wait duration in HH:MM:SS format.
varchar(25)
NOT NULL
convoldestcontact
Oldest call in the queue in HH:MM:SS format.
varchar(25)
NOT NULL
Table 1-24
RtICDStatistics Table Fields (continued)
Field Name
Description
Storage
Table 1-25
Skill Table Fields
Field Name
Description
Storage
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