beautypg.com

Data schema, Table 1: agentactivity – AltiGen MAXCS 7.0 Update 1 CDR User Manual

Page 59

background image

Records and Data Schema

CDR Manual 55

Re
co
rd
s an

d

Data S

c

hema

Data Schema

This section describes the data schema used in CDR and RTM records.

Table 1: AGENTACTIVITY

Total Inbound Talk Time

Total of Calls Answered Duration

Average Inbound Talk
Time

Total Inbound Talk Time divided by Total Calls
Answered

Average Wait Time for
Answered Calls

Total Wait Time for Answered Calls divided by Total
Calls Answered

Average Wait Time for
Overflowed Calls

Total Wait Time (Queue Duration + Ring Duration)
for Overflowed Calls
divided by Total Calls
Overflowed

Average Wait Time for
Abandoned Calls

Total Wait Time (Queue Duration + Ring Duration)
for Abandoned Calls
divided by Total Calls
Abandoned

Total Wait Time for
Answered Calls

Total of Wait Time (Queue Duration + Ring Duration)
for Answered Calls

Total Wait Time for
Overflowed Calls

Total Wait Time (Queue Duration + Ring Duration) for
overflowed calls

Total Wait Time for
Abandoned Calls

Total of Wait Time (Queue Duration + Ring Duration)
for Abandoned Calls

Total Outbound
Connected Calls

Total of Outgoing Calls

Total Outbound Talk
Time

Total of Outgoing Calls Duration

Average Outbound Talk
Time

Total Outbound Talk Time divided by Total
Outbound Connected Calls

Database
Element

Definition

Type

Specification

Version

Version of the
record

LONG

2 = OE/ACM 5.0A

NodeID

Server ID (System
ID) assigned to a
MAXCS system in
MaxAdmin

LONG

value: 1–100

Field

Definition