Preface

Change History

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

Change See

Date

Initial Release of Document for Release 12.5(1)

February 2020

Added a new ServiceType for Principal VVB

 Machine_Service

Added the following new tables:

  • Smart_License_Server

  • Smart_License_Info

  • Smart_License_Entitlements

  • Smart_License_Product

Updated datatypes of these fields in the following tables:

  • Config_Message_Log

    • Changed the datatype of ConfigMessage to varbinary(max).

  • Event

    • Changed the datatype of BinData to varbinary(max).

  • Application_Event

    • Changed the datatype of BinData to varbinary(max).

  • Feature_Control_Set

    • Changed the datatype of FeatureSetData to varbinary(max).

  • Route_Call_Detail

    • Changed the datatype of CallTrace to varbinary(max).

  • Machine_Connection_Profile

    • Changed the datatype of Password to varbinary(max).

  • Machine_Service

    • Changed the datatype of EnablePassword to varbinary(max)

    • Changed the datatype of Password to varbinary(max)

  • Script_Real_Time

    • Changed the datatyype of ScriptMeters to varbinary(max).

  • Script_Data

    • Changed the datatype of ScriptData to varbinary(max).

  • System_Capacity_Interval

    • Changed the datatype of DbDateTime to DBDATETIME NULL.

Added new fileds to these tables:

Updated the ICR_Globals table, added the following fields:

  • AnalyzerIntegrated

  • CVPCxSurveyAppName

ICR_Globals

Updated the System_Capacity_Interval table, added the following fields:

  • MaxVoiceAgentsLoggedIn

  • MaxNonVoiceAgentsLoggedIn

  • MaxAgentsHandledPrevOB

  • MaxAgentsHandledPredProgOB

  • MaxPerpetualPremiumAgentsLoggedIn

  • MaxFlexStdAgentsLoggedIn

  • MaxFlexPremiumAgentsLoggedIn

  • CustomerDefinitionId

System_Capacity_Interval

Updated the System_Capacity_Real_Time table:

  • MaxVoiceAgentsLoggedIn

  • MaxNonVoiceAgentsLoggedIn

  • MaxAgentsHandledPrevOB

  • MaxAgentsHandledPredProgOB

  • MaxPerpetualPremiumAgentsLoggedInNow

  • MaxStdAgentsLoggedInNow

  • MaxCVPCallControlPorts

  • MaxVRUPorts

  • CustomerDefinitionId

  • FutureUseInt3

  • FutureUseInt4

  • MaxPremiumAgentsLoggedInNow

System_Capacity_Real_Time

Updated the Agent_Event_Detail table:

  • RouterCallKey

  • RouterCallKeyDay

  • PeripheralCallKey

  • AgentDialedNumber

  • EventDateTimeUTC

  • DialedNumber

  • TaskIndex

  • AgentSessionId

  • AgentState

  • RouterCallKeySequenceNumber

  • Direction

  • PrecisionQueueID

  • SkillGroupID

  • WrapupData

Agent_Event_Detail

Updated the Route_Call_Detail tables:

  • CallStartDateTimeUTC

Route_Call_Detail

Updated the Termination_Call_Detail table:

  • AnsweredDateTimeUTC

  • WrapUpStartDateTimeUTC

  • ConsultStartDateTimeUTC

  • ConsultEndDateTimeUTC

  • ConferenceStartDateTimeUTC

  • ConferenceEndDateTimeUTC

  • TransferredDateTimeUTC

  • CallTerminatedDateTimeUTC

  • AgentSessionId

Termination_Call_Detail

Updated the User_Group table:

  • EmailAddress

User_Group

About This Guide

The Database 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/c/en/us/support/contact-center/category.html. 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.

Communications, Services, and Additional Information

  • To receive timely, relevant information from Cisco, sign up at Cisco Profile Manager.

  • To get the business impact you’re looking for with the technologies that matter, visit Cisco Services.

  • To submit a service request, visit Cisco Support.

  • To discover and browse secure, validated enterprise-class apps, products, solutions and services, visit Cisco Marketplace.

  • To obtain general networking, training, and certification titles, visit Cisco Press.

  • To find warranty information for a specific product or product family, access Cisco Warranty Finder.

Cisco Bug Search Tool

Cisco Bug Search Tool (BST) is a web-based tool that acts as a gateway to the Cisco bug tracking system that maintains a comprehensive list of defects and vulnerabilities in Cisco products and software. BST provides you with detailed defect information about your products and software.

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:

Table 1. 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 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.