/mcpKeys and NULL Option Data Type Description Name IE1, YES DBDATETIME The current date and time stamp when the records are written to the HDS database. The logger database has NULL for this column. DbDateTime YES DBINT Sum of delay time of all calls to the service in queue during the reporting interval. This field is populated from the LocalQTime. This field is not valid for Unified CCE or for non-voice tasks. Set to zero by OPC. DelayQTime YES DBINT Number of seconds that calls for the service that were abandoned in queue waited during the interval. These are calls that existed in the queue but were abandoned before being handled by an agent or trunk device. Not valid for Unified CCE. Not valid for non-voice tasks. Set to zero by OPC. DelayQAbandTime YES DBINT Number of calls to the service that were determined to be closed following an interruption in data during the reporting interval. ForcedClosedCalls are calls that terminated because of errors tracking the calls state transition. Calls may become forced closed if there is lack of events from the ACD CTI interfaces (for example, a lack of a Disconnect event, or failure on the switch CTI connection). Not valid for Unified CCE. ForcedClosedCalls YES DBINT The total time in seconds that calls were handled for the service during the reporting interval. HandleTime is tracked only for inbound ACD calls that are counted as handled for the service. HandleTime is the time spent from the agent answering the call to the agent completing after-call work time for the call. This includes any HoldTime, TalkTime, and WorkTime associated with the call (from the Termination_Call_Detail table). The HandleTime value is counted when the after-call work time associated with the call (if any) is completed, and the database is updated every reporting. For multimedia, this is TalkTime + HoldTime + HandledWorkReadyTime. Valid for Unified CCE. HandleTime YES DBINT The total time in seconds for calls to the service that ended during the reporting interval. For multimedia, the number of seconds that agents spent in the PAUSED state for tasks associated with this service that ended in this reporting interval. Valid for Unified CCE. HoldTime Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 467 All Tables Service_Interval