Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Call Record Database Items 3-136
Call Record Database Items 3
Overview 3
The Call Record database item descriptions are historical items that
apply specifically to the Call Record (
call_rec
) table. The indexes are
ACD and ROW_DATE.
Call Record
Database Items
3
The following table describes the database items in the CMS Call Record
database table.
Database Item Description
Column
Type
Length
ACD (index) The ACD number for which data was collected. smallint 2 bytes
ACWTIME The time spent, in seconds, in After Call Work
(ACW) associated with this call by the answering
agent in this segment.
integer 4 bytes
AGT_RELEASED The agent who released or dropped the split/skill
or direct agent ACD call. This is always true for
ACD calls the agent transferred or conferenced.
(0=NO, 1=YES).
Available on Generic 3 and newer switches.
smallint 2 bytes
ANSHOLDTIME The total time, in seconds, the call was put on hold
by the answering agent in this call segment. In
agent-to-agent calls, ANSHOLDTIME is accrued
for the answering agent if the agent puts the call
on hold, but not for the other agent (who continues
to accrue talk time).
For Generic 2.1 switches, hold time is accrued
only for ACD calls.
For Generic 2.2 and Generic 3 switches, and
DEFINITY ECS Release 5, hold time is accrued
for any type of call.
integer 4 bytes
ANSLOGIN The login ID of the agent who answered the call in
this segment. This field is blank for unmeasured
extensions when EAS is not active.
char(9) 9 byte
ASCII
text
string