McDewey

Storage Description Field Name nvarchar(30) NULL Telephone number of the device to which the call or leg was presented. If the call or leg was placed to a Unified CCX Route Point, this field shows the directory number configured in the Unified CM for that Route Point. If the call was placed to an external party, this field shows the telephone number dialed by the caller. calledNumber nvarchar(30) NULL Telephone number dialed by the caller if the call was placed from an IP phone. The Unified CM directory number to which the VoIP gateway routed the call if the call was placed from outside the VoIP2 network (for example, from the PSTN3 or a TDM4 PBX5). Null if the caller picked up the phone but did not dial any digits. origCalledNumber decimal(18,0) NULL Identifier of the Unified CCX or Cisco Unified IP IVR6(Unified IP IVR) application task that is associated with the call or the leg. Null for a call that does not have an application associated with it. applicationTaskID int NULL Identifier of the Unified CCX or Unified IP IVR application that processed the call or the leg. Null for a call or a leg that does not have an application associated with it. applicationID nvarchar(30) NULL Name of the Unified CCX or Unified IP IVR application associated with the call. Null for a call or a leg that does not have an application associated with it. applicationName int NULL Duration of the call in seconds. connectTime varchar(40) NULL Contents of the variable _ccdrVar1, if this variable is set by the Set Enterprise Call step in the script that the Unified CCX or Unified IP IVR application associated with this call or this leg invoked. Null if this variable is not set. customVariable1 Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 38 Database Schema ContactCallDetail