Database Schema Handbook for Cisco Unified ICM/Contact Center Enterprise & Hosted, Release 10.0(1)
Downloads: This chapterpdf (PDF - 1.24 MB) The complete bookPDF (PDF - 8.09 MB) | The complete bookePub (ePub - 1.85 MB) | Feedback



Change History

This table lists and links to changes made to this guide and gives the dates those changes were made. Earliest changes appear in the bottom rows.

Change Date

Initial release of document.

December 12, 2013

About This Guide

The Cisco Unified Contact Center Enterprise Database Schema Guide describes the database schema used by Unified Contact Center Enterprise (Unified CCE), including the types of data stored in the database and the relationships among those data. This guide documents each table, major categories of tables, coded values used, and the dependencies and constraints.


This manual is intended for Unified ICM and Unified CCE software system managers and supervisors. Understanding the database schema helps you to create your own monitoring screens and reports. It also helps you to understand how the Unified ICM and Unified CCE software works.

The Schema Help, which you can open from the Administration & Data Server, has the same information as this PDF manual.

You can navigate the PDF file using the Contents, the Index, and the links.


The manual is divided into the following chapters:
Part/Chapter Title Description
Chapter 1 Introduction Describes the types of data stored in the database and the relationships among those data.
Chapter 2 All Tables Fully documents each table. Provides field descriptions and indexes.
Chapter 3 Tables by Group Explains major categories (groupings) of tables, arranged logically by their domains and interrelationships.
Chapter 4 Field Values Explains the coded values used for specific fields within the database.
Chapter 5 Database Rules Explains the dependencies and constraints that govern the relationships among tables.

Related Documents

Documentation for Cisco Unified Intelligent Contact Management (Unified ICM), Cisco Unified Contact Center Enterprise (Unified CCE), Cisco Unified Contact Center Hosted (Unified CCH), as well as related documentation, is accessible from at: http:/​/​​web/​psa/​products/​index.html.

Documentation and Support

To download documentation, submit a service request, and find additional information, see What's New in Cisco Product Documentation at: http:/​/​​en/​US/​docs/​general/​whatsnew/​whatsnew.html.

You can also subscribe to the What's New in Cisco Product Documentation RSS feed to deliver updates directly to an RSS reader on your desktop. The RSS feeds are a free service. Cisco currently supports RSS Version 2.0.

Field Alerts and Field Notices

Note that Cisco products may be modified or key processes may be determined important. These are announced through use of the Cisco Field Alert and Cisco Field Notice mechanisms. You can register to receive Field Alerts and Field Notices through the Product Alert Tool on This tool enables you to create a profile to receive announcements by selecting all products of interest.

Log into; then access the tool at: http:/​/​​cisco/​support/​notifications.html

Documentation Feedback

To provide comments about this document, send an email message to the following address: contactcenterproducts_​

We appreciate your comments.


This document uses the following conventions:



boldface font

Boldface font is used to indicate commands, such as user entries, keys, buttons, and folder and submenu names. For example:

  • Choose Edit > Find.
  • Click Finish.

italic font

Italic font is used to indicate the following:

  • To introduce a new term. Example: A skill group is a collection of agents who share similar skills.
  • For emphasis. Example: Do not use the numerical naming convention.
  • A syntax value that the user must replace. Example: IF (condition, true-value, false-value)
  • A book title. Example: See the Cisco Unified Contact Center Enterprise Installation and Upgrade Guide.

window font

Window font, such as Courier, is used for the following:

  • Text as it appears in code or that the window displays. Example: <html><title>Cisco Systems,Inc. </title></html>

< >

Angle brackets are used to indicate the following:

  • For arguments where the context does not allow italic, such as ASCII output.
  • A character string that the user enters but that does not appear on the window such as a password.