230 Reference
Interpreting Summary SMDR Data
By default, the Summary SMDR data is recorded in 15 comma-delimited fields. If Software
Protection is enabled, a 16
th
row is recorded. Each row represents one call and each field records a
specific aspect of a call.
Field Description Type Maximum Width
1 Call Sequence Number Numeric 10
2 Call Type (0=out, 1=in, 2=disa) Numeric 1
3 Call Reason Numeric 2
4 CO Port Used Numeric 4
5 Extension Port Used Numeric 4
6 Date of Call Date 10
7 Time of Call 24-Hour Format 8
8 Total time of Call (decimal minutes) Numeric 10
9 Time On Hold (decimal minutes) Numeric 10
10 Touch Tones Dialed Character 40
11 Message Sent to Phone Character 40
12 Account Code Character 16
13 Caller ID Number Character 40
14 Caller ID Name Character 33
15 Called Number Character 17
16 Software Protection (if enabled) Numeric 10
Call
Sequence
Call
Type
Call
Reason
CO
Port
Ext.
Port Date
Time
of Call
Total
Time
Time
on
Hold
Touchtones
Dialed
Message
sent to
Phone
Account
Code
Caller
ID
Number
Caller
ID
Name
Called
Number Software
Protection
166688 1 3 3 7 5/21/2003 14:10:44 0.563 .228 5640801 Susan Richmond
166688 1 1 3 12 5/21/2003 14:11:16 0.256 0 5640801 Susan Richmond
166701 0 1 3 14 5/21/2003 14:16:06 0.049 0 18002E+10 18002E+10
166705 0 1 3 14 5/21/2003 14:16:22 0.25 0 5556676 5556676
Note Field headers are not included in SMDR data, and must be added manually, as shown in
the table above.
For Summary SMDR, the Call Sequence Number (Field 1) is a number assigned to each call and
each transferred call. This information is recorded when the call is ended or transferred. The Call
Sequence Number can be repeated in multiple rows, representing the initial call and each
subsequent transfer.
The Software Protection field relates to the SMDR Output Mode 0/1 setting of the System
Configuration 1 pane of the VS1 Editor. By default, the setting is 0. If set to 1, Software
Protection data is recorded. This will record the last five digits of the Host Adapter Card for the
system, which can be used for call accounting software.
Summary SMDR
data imported into
a
spreadsheet