Instruction manual

Database Tables
CentreVu®
CMS Open Database Connectivity
Agent Database Items 3-50
DA_OTHERTIME
The amount of time spent in queue or
ringing by DA_OTHERCALLS before
being redirected.
Requires a Generic 3 switch with the
ASAI or EAS feature for direct agent
calling.
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
DA_RELEASE The number of direct agent ACD calls
released or dropped by the agent before
the far end released.
Requires an ECS with the ASAI or EAS
feature for direct agent calling.
C integer 4 bytes
EVENT1-9 The number of times each event (stroke
count) feature button (1 to 9) was pressed
while the agent was on an ACD call or in
call-related after call work.
Available on Generic 2 and Generic 3
switches.
C smallint
(dagent,
hagent);
integer
(magent,
wagent)
2 bytes
(dagent,
hagent);
4 bytes
(magent,
wagent)
EXTENSION The extension number for which data
were collected.
A char(6) 6 byte
ASCII
text string
HOLDABNCALLS The number of times callers abandoned
from hold.
For Generic 2.2 and Generic 3 switches,
HOLDABNCALLS applies to all calls the
agent put on hold.
For Generic 2.1 switches,
HOLDABNCALLS applies to split ACD
calls held.
C smallint
(dagent,
hagent);
integer
(magent,
wagent)
2 bytes
(dagent,
hagent);
4 bytes
(magent,
wagent)
HOLDACDTIME The amount of time split/skill and direct
agent ACD calls spent on hold at the
agent’s voice terminal. This includes time
on AUXIN or AUXOUT calls with the ACD
calls on hold.
C integer 4 bytes
Database Item Description
Data
Type
Column
Type
Length