sessionID
|
Identifier that the system assigned to the call. This identifier remains the same for all legs of the call.
|
decimal(18,0)
NOT NULL
Primary Key
|
sessionSeqNum
|
Session sequence number that the system assigned to the call or the leg. Each leg of a call is assigned a new sequence number.
|
smallint
NOT NULL
Primary Key
|
nodeID
|
Unique identifier assigned to each server in the cluster.
|
smallint
NOT NULL
Primary Key
|
profileID
|
Identifier of the Unified CCX profile that is associated with this record.
|
int
NOT NULL
Primary Key
|
contactType
|
Contact type of the call or the leg:
-
1—Incoming. Outside call received by the Unified CCX system.
-
2—Outgoing. Call originated by the Unified CCX system, other than a call made within the system.
-
3—Internal. Call transferred or conferenced between agents, or a call made within the system.
-
4—Redirect in
-
5—Transfer in
-
6—Preview Outbound
-
7—IVR Outbound
-
8—Agent Outbound
-
9—Agent Outbound call transferred to IVR
|
smallint
NOT NULL
|
contactDisposition
|
Disposition of the call or the leg.
-
1—Abandoned
-
2—Handled
-
3—Do not care
-
4—Aborted1
-
5-22—Rejected
-
99—Cleared
|
smallint
NOT NULL
|
dispositionReason
|
Reason why the call is aborted or rejected by the system.
|
varchar(100,0)
NULL
|
originatorType
|
Originator of the call or the leg:
-
1—Agent. Call originated by an agent.
-
2—Device. Call originated by a simulated caller (used for testing) and an agent phone where the agent is not currently logged
in.
-
3—Unknown. Call originated by an outside caller through a gateway or by an unknown device.
|
smallint
NOT NULL
|
originatorID
|
Numeric identifier of the agent who originated the call or the leg.
Used only if originatorType is 1.
|
int
NULL
|
originatorDN
|
If originatorType is 1 and the call was placed by the agent using the non-IPCC extension then this field contains the non-IPCC
extension, else it contains an empty character ('').
If originatorType is 2, this field shows the CTI port number.
If originatorType is 3, this field shows the telephone number of the caller as received by the Unified CM, if available.
An empty character ('') if originatorType is 1. This is not applicable for agent based progressive and predictive outbound
calls.
|
nvarchar(30,0)
NULL
|
destinationType
|
Destination of the call or the leg:
-
1—Agent. Call presented to an agent.
-
2—Device. Call presented to a route point.
-
3—Unknown. Call presented to an outside destination through a gateway or to an unknown device.
-
Null if no destination.
|
smallint
NULL
|
destinationID
|
Numeric identifier of the agent who received the call or the leg.
Used only if destinationType is 1.
|
int
NULL
|
destinationDN
|
If the destinationType is 1 and the call was received by an agent using the non-IPCC extension, then this field contains the
non-IPCC extension, else it contains an empty character ('').
If destinationType is 2, this field shows the CTI port number.
If destinationType is 3, this field shows the telephone number called, if available.
An empty character ('') if destinationType is 1.
|
nvarchar(30)
NULL
|
startDateTime
|
For an incoming call or a leg, date and time that the call or the leg started to ring in the system.
For an internal call or for an outgoing call, date and time that the call originated.
For a transferred call or a leg, endDateTime of the transferring call or leg.
|
datetime year to fraction (3)
NOT NULL
|
endDateTime
|
Date and time that this call or the leg was transferred or was disconnected.
|
datetime year to fraction (3)
NOT NULL
|
gmtOffset
|
Offset, in minutes, between the local time of the Unified CCX server and Greenwich Mean Time. As the time information is stored
in GMT, this field will always be zero.
|
smallint
NOT NULL
|
calledNumber
|
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.
|
nvarchar(30)
NULL
|
origCalledNumber
|
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.
|
nvarchar(30)
NULL
|
applicationTaskID
|
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.
|
decimal(18,0)
NULL
|
applicationID
|
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.
|
int
NULL
|
applicationName
|
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.
|
nvarchar(30)
NULL
|
connectTime
|
Amount of time, in seconds, between the start time of the call or the leg and the end time of the call or the leg.
|
smallint
NULL
|
customVariable1
|
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.
|
varchar(40)
NULL
|
customVariable2
|
Contents of the variable _ccdrVar2, 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.
|
varchar(40)
NULL
|
customVariable3
|
Contents of the variable _ccdrVar3, 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.
|
varchar(40)
NULL
|
customVariable4
|
Contents of the variable _ccdrVar4, 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.
|
varchar(40)
NULL
|
customVariable5
|
Contents of the variable _ccdrVar5, 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.
|
varchar(40)
NULL
|
customVariable6
|
Contents of the variable _ccdrVar6, 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.
|
varchar(40)
NULL
|
customVariable7
|
Contents of the variable _ccdrVar7, 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.
|
varchar(40)
NULL
|
customVariable8
|
Contents of the variable _ccdrVar8, 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.
|
varchar(40)
NULL
|
customVariable9
|
Contents of the variable _ccdrVar9, 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.
|
varchar(40)
NULL
|
customVariable10
|
Contents of the variable _ccdrVar10, 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.
|
varchar(40)
NULL
|
accountNumber
|
Account number entered by the caller.
|
varchar(40)
NULL
|
callerEnteredDigits
|
Phone number entered by the caller.
|
varchar(40)
NULL
|
badCallTag
|
Tag for a bad call.
Default = N
|
char(1)
NULL
|
transfer
|
Was this call leg transferring the call:
t = transfer
f = no
|
boolean
NULL
|
redirect
|
Was this call leg redirecting the call:
t = redirect
f = no
|
boolean
NULL
|
conference
|
Was this call leg conferencing the call:
t = conference
f = no
|
boolean
NULL
|
flowout
|
When this flag is set, it means this call leg is sent to another application or destination outside the system.
|
boolean
NULL
|
metServiceLevel
|
Did the call meet the service level:
t = met service level
f = no
Note: Reserved for future use.
|
boolean
NULL
|
campaignID
|
Unique identifier of the campaign that generated this call.
|
int
NULL
|
OrigProtocolCallRef
|
Unique identifier to identify a call leg that enters the Unified CCX system. This is used to trace a call which has traversed
from some product to the Unified CCX.
|
Varchar(32)
NULL
|
DestProtocolCallRef
|
Unique Identifier to identify a call leg that exits the Unified CCX system. This is used to trace a call which has traversed
from Unified CCX to some other product.
|
Varchar(32)
NULL
|
CallResult
|
The result of an IVR based or agent based progressive or predictive outbound call.
|
smallint
NULL
|
dialingListID
|
Unique identifier of a contact that is dialed for an outbound campaign. Links with DialingList.dialingListID.
|
int
NULL
|