Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Call Work Codes Database Items 3-120
ACDTIME
The amount of talk time of all ACDCALLS
(not including HOLDTIME) associated with
this call work code.
C integer 4 bytes
ACWTIME The amount of time that the agent spent in
ACW for ACDCALLS that were associated
with this call work code.
C integer 4 bytes
CWC
(index)
The call work code for which data was
collected.
I char(16) 16 byte
ASCII
text
string
INCOMPLETE This item indicates whether or not data is
complete for this 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 collection is incomplete for the interval
(0 = N0, 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
INTRVL The number of minutes in the intrahour
interval (15, 30, or 60).
INTRVL applies to intrahour tables only.
A smallint;
in hcwc
table
only
2 bytes
ROW_DATE
(index)
The day for which data was collected or the
exception occurred.
I date 4 byte
Informix
date
STARTTIME The start time of the interval for which data
was collected.
STARTTIME applies to the only interval
table.
I smallint;
in hcwc
table
only
2 bytes
Database Item
Description
Data
Type
Column
Type
Length