Specifications

Call Detail Record Reports
ShoreTel 7.5 Administration Guide C – 55
calls. Once one of the agents is successfully hunted, if you looked at the Connect table
you see the agent being attached to the original call.
Field Name Data Type Description
ID AutoNumber Unique identifier. (4-byte integer, required)
CallID Number Unique number for the existence of the call. (4-byte integer)
SIP GUID Text SIP Unique Global ID number (32 characters, zero-length)
StartTime Date/Time For an inbound call, this is when the trunk has been seized. For
an outbound call, this is when the user has completed dialing.
(8-byte date/time, required)
StartTimeMS Number Append this information to the StartTime to reduce the absolute
start time to the millisecond when the call began. (2-byte integer,
required)
EndTime Date/Time Time when the call terminates (either by the near end hanging
up or when the end external to the system hangs up) and the
ShoreTel switch receives the notification of the disconnect.
(8-byte date/time)
EndTimeMS Number Append this information to the StartTime to reduce the absolute
start time to the milliseconds of when the call began
(milliseconds). (2-byte integer, required)
CallNote Text User entered Call Note. This can be added from the ShoreTel
desktop client. (64 characters, zero-length)
BillingCode Text Account code assigned to the call. (32 characters, zero-length)
Locked Yes/No Read-only status for this call (set once call has ended). Not
locked means the call is still in progress. (boolean)
Extension Text For an outbound or extension-to-extension call, the extension
has the dialed number of the originator of the call.
This field is blank for an outbound call from an anonymous
phone with no currently assigned DN.
For an inbound call, the extension field contains the DN of the
last party involved in the call (excluding voice mail or auto-
attendant). For instance, an incoming call to an extension that
transferred the call to extension 300 has “300” in the extension
field (the complete history of parties connecting to the call can
be found on the Connect table).
All calls to an extension that forwarded to voice mail have the
extension of the called party and not the voice mail number. (15
characters, zero-length)
Duration Date/Time Elapsed time of the call from beginning to end. Calculated by
subtracting StartTime from EndTime. Start time begins when the
first party is added to a call. End time is when the last party
leaves resulting in the end of the call. (8-byte date/time).
CallType Number See enumeration in CallType table. (1-byte integer, required)
WorkGroupCall Yes/No Is this a workgroup call? Yes indicates that the workgroup server
was involved in processing the call.
If the call was directed toward a workgroup server, but that
server was unavailable, then this field is set to “No” because the
workgroup server never becomes involved in the call. (boolean)
LongDistance Yes/No From the perspective of the trunk for the call, did this call
involve a long distance connection? The first connect record of
the call is used to determine whether a call is long distance. If
the first leg is an extension call, the value is always No.
Note A trunk call can be transferred or conferenced, so the
total long distance time can only be determined by
examining all Connect records. (boolean)