Guest

Preview Tool

Cisco Bug: CSCus23999 - Database Schema Guide LoggedOnTime calculation needs clarification

Last Modified

Feb 12, 2018

Products (1)

  • Cisco Unified Contact Center Enterprise

Known Affected Releases

10.0(1) 10.5(1) 11.0(1) 8.5(1) 8.5(2) 8.5(3) 8.5(4) 9.0(1)

Description (partial)

Symptom:
Definition of LoggedOnTime in the Unified CCE Database Schema guide needs to be updated. This defect has two parts:


1) Some documents include availtime as part of the calculation of loggeontime, and others don't

Total time, in seconds, agents associated with this skill group were logged on during the reporting interval. This field applies to both Unified ICM, Unified CCE and Outbound Option. 
This value is based on the following: 
HoldTime
TalkInTime
TalkOutTime
TalkOtherTime
NotReadyTime
WorkReadyTime
WorkNotReadyTime
BusyOtherTime
ReservedStateTime
TalkAutoOutTime
TalkPreviewTime
TalkReservedTime

Need to add AvailTime to this list.


2) The documentation states "This value is based on the following". It is not clear that this is a summation. Should it instead state "This value is the sum of the following"?

This affects the Database Schema guide and online schema help on the AWs.

Conditions:
N/A
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.