Instruction manual
Database Tables
CentreVu®
CMS Open Database Connectivity
Agent Database Items 3-45
ANSRINGTIME
The amount of time split/skill and direct
agent ACD calls spent ringing at the
agent’s voice terminal before being
answered.
Available for ring-tracking on Generic 2
and Generic 3 switches.
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
ASSISTS The number of times the supervisor was
called (supervisor assists) by agents on a
split/skill direct agent ACD calls, or in call-
related ACW for this split/skill.
C smallint
(dagent,
hagent);
integer
(magent,
wagent)
2 bytes
(dagent,
hagent);
4 bytes
(magent,
wagent)
AUXINCALLS The number of inbound extension calls
received by agents while in AUX
(auxiliary work), AVAILABLE; or, for
Generic 2.2 and Generic 3 switches, with
an ACD or AUXIN/AUXOUT call on hold.
C smallint
(dagent,
hagent);
integer
(magent,
wagent)
2 bytes
(dagent,
hagent);
4 bytes
(magent,
wagent)
AUXINTIME The amount of talk time of all
AUXINCALLS (does not include
HOLDTIME except on Generic 2.1
switches).
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
AUXOUTADJCALLS The number of AUXOUTCALLS that
were placed by an adjunct on behalf of an
agent (keyboard dialed). If such calls are
placed to off-switch destinations, then
they are also counted as
AUXOUTOFFCALLS.
Available for outbound calls on Generic
2.2 switches with the ASAI Gateway
Interface feature and Generic 3 switches
with the ASAI feature.
C smallint
(dagent,
hagent);
integer
(magent,
wagent)
2 bytes
(dagent,
hagent);
4 bytes
(magent,
wagent)
Database Item Description
Data
Type
Column
Type
Length