Preface

Change History

This table lists changes made to this guide. Most recent changes appear at the top.

Change See

Date

Updates for Router_Queue_Interval table

Router_Queue_Interval

October 1, 2017

Initial Release of Document for Release 11.6(1)

August 2017

New machine types: Data Center, Unified CCE Peripheral Gateway for the remote Data Center, Unified CVP for the remote Data Center, Finesse Primary for the remote Data Center, and Finesse Secondary for the remote Data Center.

Machine_Host

New service types: Voice Response Unit Connection, Unified Communications Manager Connection, Cisco Virtualized Voice Browser IP Address, Data Center IP Address.

Machine_Service

Added the table: System_Capacity_Interval

System_Capacity_Interval

Updated the Dialer_Real_Time table with the description for FutureUseInt3.

Dialer_Real_Time

Updated the Dialer_Interval table with the description for FutureUseInt3.

Dialer_Interval

Updated the Dialer Detail: CallStatusZone topic with the Dialed (D) state information.

Dialer Detail: CallStatusZone

Added new Deployment Type 16 (UCCE: 2000 Agents) and updated the list of configuration limits.

Configuration_Limit

Congestion Control

Updated the calculation for Service Level.

Router_Queue_Interval

Precision_Q_Real_Time Table

Removed support for HCS-CC 500 Agent Deployment Type.

Congestion Control

System_Capacity_Real_Time

Added a note about unsupported Half Hour tables in the database.

Real-Time and Historical Data

Added a new value "32" to the Dialer Detail: CallResult table.

Dialer Detail: CallResult

Added details related to Precision Queue tables, such as descriptions and list of related tables where applicable.

Various topics related to Precision Queue tables.

About This Guide

The Database Schema Guide for Cisco Unified Contact Center EnterpriseDatabase Schema Handbook for Cisco Unified Contact Center Enterprise 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.

Audience

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.

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

Related Documents

Documentation for contact center enterprise solutions is accessible from Cisco.com at: https://www.cisco.com/cisco/web/psa/default.htm. Click Voice and Unified Communications, then click Cisco Unified Contact Center Products or Cisco Unified Voice Self-Service Products, then click the product or option you want.

Obtaining Documentation and Submitting a Service Request

For information on obtaining documentation, using the Cisco Bug Search Tool (BST), submitting a service request, and gathering additional information, see What's New in Cisco Product Documentation at https://www.cisco.com/c/en/us/td/docs/general/whatsnew/whatsnew.html.

Subscribe to What's New in Cisco Product Documentation, which lists all new and revised Cisco technical documentation as an RSS feed and delivers content directly to your desktop using a reader application. The RSS feeds are a free service.

Field Notice

Cisco publishes Field Notices to notify customers and partners about significant issues in Cisco products that typically require an upgrade, workaround, or other user action. For more information, see Product Field Notice Summary at https://www.cisco.com/c/en/us/support/web/tsd-products-field-notice-summary.html.

You can create custom subscriptions for Cisco products, series, or software to receive email alerts or consume RSS feeds when new announcements are released for the following notices:

  • Cisco Security Advisories

  • Field Notices

  • End-of-Sale or Support Announcements

  • Software Updates

  • Updates to Known Bugs

For more information on creating custom subscriptions, see My Notifications at https://cway.cisco.com/mynotifications.

Conventions

This document uses the following conventions:

Convention

Description

boldface font

Boldface font is used to indicate commands, such as user entries, keys, buttons, folder names, 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.

  • A syntax value that the user must replace. Example: IF (condition, true-value, false-value)

  • A book title. Example: See the Installation and Configuration Guide for Cisco Unified CCECisco 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.