Instruction manual

Database Tables
CentreVu®
CMS Open Database Connectivity
Split/Skill Database Items 3-22
I_AUXINTIME
The amount of time during the collection
interval that POSITIONS were in AUX work,
AVAILABLE, or, for Generic 2.2 and Generic
3 switches, had an ACD or AUXIN/AUXOUT
call on hold and were on inbound extension
calls.
I_AUXINTIME includes I_ACDAUXINTIME.
C integer 4 bytes
I_AUXOUTTIME The amount of time during the collection
interval that POSITIONS were in AUX work,
AVAILABLE; or, for Generic 2.2 and Generic
3 switches, had an ACD or AUXIN/AUXOUT
call on hold and were on outbound extension
calls.
I_AUXOUTTIME includes
I_ACDAUX_OUTTIME.
C integer 4 bytes
I_AUXTIME The amount of time during the collection
interval that POSITIONS were in AUX in this
split/skill.
I_AUXTIME = I_AUXTIME0 + I_AUXTIME1
+ I_AUXTIME2 + I_AUXTIME3 +
I_AUXTIME4 + I_AUXTIME5 + I_AUXTIME6
+ I_AUXTIME7 + I_AUXTIME8 +
I_AUXTIME9.
I_AUXTIME includes I_AUXTIME0,
I_AUXTIME1-9, I_AUXINTIME,
I_AUXOUTTIME, and I_TAUXTIME.
C integer 4 bytes
I_AUXTIME0 The amount of time during the collection
interval that POSITIONS were in AUX for
reason code 0 in this split/skill. This includes
time on extension calls from this AUX state.
For switches with AUX reason codes active,
this represents time agents spent in “system”
AUX. For switches without AUX reason
codes active, I_AUXTIME0 is the same as
I_AUXTIME.
C integer 4 bytes
Database Item Description
Data
Type
Column
Type
Length