Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Database Items 3-62
TI_STAFFTIME
The amount of time during the collection
interval that the agent was staffed in any
split/skill. “TI_” time is only stored for the
split/skill logged into the longest. “TI_”
time needs to be summed across the
splits/skills the agents may log in to, in
case the login order changes during the
collection interval.
sum(TI_STAFFTIME) =
sum(I_ACDTIME + I_ACWTIME +
I_DA_ACDTIME + I_DA_ACWTIME +
I_RINGTIME + TI_AUXTIME +
TI_AVAILTIME + TI_OTHERTIME), over
all splits/skills the agent was logged into.
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
TRANSFERRED The number of calls the agent transferred
to another destination. Note that
TRANSFERRED calls include both
inbound and outbound calls. Therefore,
OTHERCALLS and O_OTHERCALLS
may each include some SHORTCALLS.
For Generic 2.1 switches, includes
transfers to measured VDNs or
splits/skills.
For Generic 2.2 and Generic 3 switches,
this includes transferring all calls.
C smallint
(dagent,
hagent);
integer
(magent,
wagent)
2 bytes
(dagent,
hagent);
4 bytes
(magent,
wagent)
Database Item Description
Data
Type
Column
Type
Length