Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Database Items 3-59
ROW_DATE (index)
The day for which the data was collected
or the exception occurred.
I date 4 byte
Informix
date
SPLIT
(index)
The split number to which the
EXTENSION is assigned to or the skill
number that the agent logged into.
I smallint 2 bytes
STARTTIME The start time for the interval for which
data was collected.
STARTTIME applies only to the Interval
table.
I smallint;
only in
hagent
table
2 bytes
TI_AUXTIME TI_AUXTIME includes TI_AUXTIME0,
TI_AUXTIME1-9, I_AUXINTIME, and
I_AUXOUTTIME.
sum(TI_AUXTIME) =
sum(TI_AUXTIME0 + TI_AUXTIME1 +
TI_AUXTIME2 + TI_AUXTIME3 +
TI_AUXTIME4 + TI_AUXTIME5 +
TI_AUXTIME6 + TI_AUXTIME7 +
TI_AUXTIME8 + TI_AUXTIME9), over all
splits/skills the agent was logged into.
Requires an ECS with the EAS feature.
C integer;
smallint in
hagent
table
4 bytes;
2 bytes in
hagent
table
TI_AUXTIME0 The amount of time the agent spent in
AUX with reason code 0 (zero). This is
time in “system” AUX for switches with
AUX reason codes active. It is the same
as TI_AUXTIME for switches without
AUX reason codes active. “TI_” time is
only stored for the skill logged in to the
longest. “TI_” time needs to be summed
across the skills the agents may log in to,
in case the login order changes during
the collection interval.
Requires an ECS with the EAS feature.
C integer 4 bytes
Database Item Description
Data
Type
Column
Type
Length