Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Database Items 3-56
I_RINGTIME
The amount of time during the collection
interval that the agent had split/skill and
direct agent ACD calls ringing. If the
agent changes work modes or
makes/receives another call instead of
answering the ringing call, I_RINGTIME
will stop accumulating. RINGTIME is the
time the caller spends ringing and is
independent of agent activity.
Available on a Generic 2 and Generic 3
switch for ring tracking.
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
I_STAFFTIME The amount of time during the collection
interval that the agent was staffed (logged
in) in this split/skill.
I_STAFFTIME includes I_AUXTIME,
I_AVAILABLE, I_ACDTIME,
I_ACWTIME, I_DA_ACDTIME,
I_DA_ACWTIME, I_OTHERTIME, and
I_RINGTIME.
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
INCOMPLETE This item indicates whether or not data is
complete for this collection interval. Data
is incomplete whenever the link goes
down and whenever tracking is aborted
for calls, due to trunk failures (Generic 2),
the trunk going maintenance busy with a
call active (Generic 3), protocol failures
with data collection active, or when
split/skill or VDN call profile is changed
with data collection active.
The value for interval tables indicates
whether data is incomplete for the interval
(0 = NO, 1 = YES). The value in the daily,
weekly, and monthly tables indicates the
number of incomplete intervals in the day,
week, or month.
Changing split/skill or VDN call profile
data while data collection is active only
affects the respective split/skill or VDN
data.
C smallint 2 bytes
Database Item Description
Data
Type
Column
Type
Length