Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Call Record Database Items 3-143
ORIGHOLDTIME
The total time the call was put on hold by the
originating agent.
Requires the
DEFINITY ECS R6 .
integer 4 bytes
ORIGLOGIN The login ID of the agent originating the call. This
is used for calls an agent originates to another
agent, to an on-switch extension, or to an external
destination.
char(9) 9 byte
ASCII
text
string
ORIGREASON The reason code (0 through 9) associated with the
originating 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,
ORIGREASON is always 0.
smallint 2 bytes
ROW_DATE The date for which data was collected or the
exception occurred.
date 4 byte
Informix
date
ROW_TIME The starting time for this segment. smallint 2 bytes
SEGMENT The number identifying the call segment. Segment
numbers are from 1 up to the number of segments
in the call.
smallint 2 bytes
SEGSTART The
UNIX time and date when the call segment
started. (
UNIX time and date is the number of
seconds since midnight, 01/01/70.) Call segments
start when CMS receives the first message for the
call, since each call segment represents a call.
(When an agent transfers or conferences a call,
the agent makes another call to bring about the
transfer/conference.)
integer 4 bytes
SEGSTOP The
UNIX time and date when the call segment
ended. (
UNIX time and date is the number of
seconds since midnight, 01/01/70.) A call segment
ends when all trunks and agents associated with
the call segment have dropped off the call. This
means that after call work time for the agent(s) is
included when calculating the call segment stop
time.
integer 4 bytes
Database Item Description
Column
Type
Length