Instruction manual

Database Tables
CentreVu®
CMS Open Database Connectivity
Call Record Database Items 3-141
DURATION
The total time the trunk was in use. This is the
overall trunk holding time from the beginning of the
call segment until the caller is disconnected. For
the first segment of a call, this will be the trunk
holding time for the caller for the entire call (from
seized until idle). With a transfer, the original trunk
remains associated with both call segments until
the call ends.
integer 4 bytes
EQLOC The physical equipment location (trunk number)
for which data was collected or for which the
exception occurred. This will be blank if the trunk
is not measured.
For the
DEFINITY
ECS R8, this field is eight
characters. For previous switch releases, it is nine
characters.
char(8) 8 byte
ASCII
text
string
EVENT1-9 The number of times each event (stroke count)
button (buttons 1 to 9) was entered for this call
segment.
Available with the ECS, Generic 2, and Generic 3
switches.
smallint 2 bytes
FIRSTVECTOR The number of the first vector associated with the
first VDN for the call segment. This will be blank if
no vector is involved.
smallint 2 bytes
FIRSTVDN The number of the first VDN associated with the
call segment. This will be blank for calls not
associated with a VDN.
char(5) 5 byte
ASCII
text
string
HELD The total number of times this call was placed on
hold by the answering agent in this call segment.
With agent-to-agent calls, this count is
incremented for the agent who puts the call on
hold, but not for the calling agent. (For the ECS,
Generic 2.2, and Generic 3 switches, applies to all
calls the agent put on hold.)
smallint 2 bytes
Database Item Description
Column
Type
Length