Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Call Record Database Items 3-137
ANSREASON
The reason code (0 through 9) associated with the
answering agent’s mode, if the agent is in the AUX
mode. For agents in AUX on switches with
releases prior to the ECS or switches that do not
have EAS and reason codes active,
ANSREASON is always 0.
smallint 2 bytes
ASSIST This item indicates whether or not the answering
agent in this segment requested supervisor
assistance on this call. Valid values for ASSIST
are 0=NO, 1=YES.
smallint 2 bytes
AUDIO This item indicates whether or not an agent in this
segment reported an audio difficulty problem. Valid
values for AUDIO are 0=NO, 1=YES.
smallint 2 bytes
CALLID A unique number assigned to this call and all its
call segments. For conferenced/transferred calls,
two (or more) calls are tied together. When the
entire call is recorded, one call ID is used to tie
together all call segments. In “meet-me”
conferences, this may result in a “later” segment of
the call starting earlier than the first segment. Call
IDs are not necessarily strictly sequential, but will
be unique for calls over a day.
integer 4 bytes
CALLING_II The Information Indicator (II) digits associated with
the call. These digits are a two-digit string
provided by the ISDN to indicate the type of
originating line of the caller. These digits supply
information about the originator location; for
example, pay phone, hospital, or prison. The
column is blank if the call does not contain II digits.
Available on the ECS and newer switches.
char(2) 2 byte
ASCII
text
string
CALLING_PTY The calling party identification, which is the
Automatic Number Identification (ANI)/Station
Identification (SID) (for Generic 2.2 or Generic 3
Version 4 switches or the ECS with ISDN ANI
delivery), extension or trunk equipment location
identifying the originator of the call. This field is
blank if the trunk is not measured or, for internal
calls, if the originating extension is not measured.
(Up to 12 digits in this field.)
char(12) 12 byte
ASCII
string
Database Item Description
Column
Type
Length