Specifications

5-75
Cisco Unity Express Voice-Mail and Auto-Attendant CLI Administrator Guide for 3.0 and Later Versions
OL-14010-09
Chapter 5 Configuring System Components
Configuring Historical Reporting
Ta b l e 5-4 Call Contact Detailed Records (CCDRs) Descriptions
Field Name Data Type Required Field Possible Values Description
sessionID decimal(28) NOT NULL When a caller calls into the system, a unique
session ID is established. This session ID is
used for entire call, through all conferences
and transfers.
sessionSeqNum smallint NOT NULL [0, 1, 2, 3, …] Each transfer of a call creates a new
sequence number, but the session ID
remains the same.
profileID int NOT NULL Always set to 0 (reserved for future use).
contactType tinyint NOT NULL 1 = incoming
2 = outgoing
3 = internal
Incoming calls are those calls coming into
the system. Outgoing call are calls
originated by the Cisco Unity Express
system. Internal calls are transfers.
contactDisposition tinyint NOT NULL 1 = abandoned
2 = handled
The call was either processed or abandoned
during this part of the call.
originatorType tinyint NOT NULL 2= device
3= unknown
Device indicates call was originated by the
CTI port. Unknown device includes
gateway.
originatorID int NULL CTI port, NULL For gateway or unknown originator type,
the value is NULL.
originatorDN nvarchar(30) NULL Call ANI, the telephone number of the
originator of the caller.
For gateway or unknown originator type,
the value is NULL.
destinationType smallint NULL 2 = device
3= unknown
Device indicates call was presented to a CTI
port. Unknown device includes gateway.
destinationID int NULL CTI port, NULL For gateway or unknown destination type,
the value is NULL.
destinationDN nvarchar(30) NULL For gateway or unknown destination type,
the value is NULL.
startDateTime datetime NOT NULL Start date and time when this call leg was
connected.
endDateTime datetime NOT NULL End date and time when this call leg was
transferred or disconnected.
gmtOffset smallint NOT NULL DST adjusted offset.
calledNumber nvarchar(30) NOT NULL If the call was a transfer, this is the number
to which the call was transferred. In other
cases, this information is the same as the
Original Called Number.
origCalledNumber nvarchar(30) NOT NULL Telephone number the caller originally
dialed.
applicationTaskID decimal(28) NULL Task ID of currently executing application.