AltiGen comm MAXCS 87 CDR Manual

Records and Data SchemaCDR Manual  55
Table: AGENTPERWGSUMMARY3
Database 
ElementDefinitionTypeSpecification
Version Version of the record LONG2 = OE/ACM 5.0A
NodeID Server ID (System ID) 
assigned

 to a MAXCS system 
in MaxAdmin LONG
value: 1–100 
uid Unique ID to link to 
AGENTPERWGSUMMARY1 LONG
DurLogin The total time agent was 
logged in. LONG
DurOutWGTalk
Talk duration of outgoing 
con

nected calls 
(NumOutWGConnected) 
from the time the call 
enters "Connected" state 
until disconnected,...

Data Schema
56 CDR Manual
Table: AGENTSUMMARY1
Database 
ElementDefinitionTypeSpecification
Version Version of the record LONG2 = OE/ACM 5.0A
NodeID Server ID (System ID) assigned to 
a MAXCS system in MaxAdmin LONG
value: 1–100 
uid Unique ID to link to 
AGE

NTSUMMARY2, 
AGENTSUMMARY3, and 
AGENTSUMMARY4 LONG
StartTime GMT start time of record's period. 
Seconds since 1970/01/01

 
00:00:00. LONG
EndTime GMT end time of record's period. 
Seconds since GMT

 1970/01/01 
00:00:00. LONG
GMTOffset...

Records and Data Schema
CDR Manual 57
NodeIDServer ID (System ID) 
assigned to a MAXCS 
system in MaxAdminLONGvalue: 1–100 
uidUnique ID to link to 
AGENTSUMMARY1LONG
NumInDirCallDirect (non-workgroup) 
incoming callLONG
NumInDirAnsweredDirect (non-workgroup) 
incoming call answeredLONG
DurInDirTalkTotal talk duration of direct 
(non-workgroup) incoming 
callsLONG
NumInDirVMCount of direct inbound 
voicemail messageLONG
DurInDirVMTotal duration of direct 
inbound voicemail messageLONG
NumInDirHold
The...

Data Schema
58 CDR Manual
Table: AGENTSUMMARY3
Database ElementDefinitionTypeSpecification
Version Version of the record LONG2 = OE/ACM 
5.0A
NodeID Server ID (System ID) 
assigned to

 a MAXCS 
system in MaxAdmin LONG
value: 1–100 
uid Unique ID to link 
AGE

NTSUMMARY1 LONG
CountLogonWG Count of workgroups that 
agent 

is logged into LONG
DurAgentLogon The login duration when 
agent 

logs into at least one 
workgroup LONG
NumAgentAvailable Number of times agent is 
available LONG
DurAgentAvailable...

Records and Data Schema
CDR Manual 59
Table: CDRMAIN
NumAgentDNDNumber of times agent entered 
DNDLONG
DurAgentDNDTotal duration of the DNDLONG
NumAgentFWDNumber of times agent enable 
extension forward and enter FWD 
stateLONG
DurAgentFWDDuration of agent in FWD stateLONG
NumAgentErrorNumber of times agent enter Error 
State while loginLONG
DurAgentErrorDuration of agent in Error State 
while loginLONG
NumNotReadyCount of Agent enters Not-Ready 
stateLONG
DurNotReadyDuration of Agent Not-ReadyLONG...

Data Schema
60 CDR Manual
DayOfWeekDay of the weekLONG
0 = Sunday 
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
SessionID
Session ID: a unique 
number, usually 9 digits 
or larger, assigned by 
MAXCS to a call
LONG
SequenceID
A unique number to 
identify multiple records 
of same call (same 
Session ID), beginning 
with 0
LONG
TrunkCallTrunk call or external 
callLONG1=Internal
2=Trunk Call
DirectionDirection of the call 
(incoming or outgoing)LONG
1=Outgoing
2=Incoming
3=Not...

Records and Data Schema
CDR Manual 61
CallerTypeType of line for an 
incoming call LONG
0 = Unknown line type
1 = Ext analog
2 = Ext IP
3 = Reserved
4 = Ext virtual
5 = Workgroup
6 = Application Extension
7 = Analog Trunk
8 = T1 Trunk
9 = IP Trunk
10 = PRI Trunk
11 = not used
12 = E1 trunk
CallerPadLine’s physical address 
for an incoming callCHAR (5)
E.g. “0004”, where 
“00”=slot, “04”=channel
Always “-1-1” for WG or 
virtual extension
CallerNum
Caller phone number of 
an incoming call 
(extension...

Data Schema
62 CDR Manual
TargetTypeCalled target line typeLONG
0 = Unknown line type
1 = Ext analog
2 = Ext IP
3 = Reserved
4 = Ext virtual
5 = Workgroup
6 = Application Extension
7 = Analog Trunk
8 = T1 Trunk
9 = IP Trunk
10 = PRI Trunk
11 = not used
12 = E1 trunk
TargetPadPhysical address of line 
for a called targetUCHAR (5)
E.g. “0004,” where 
“00”=slot and 
“04”=channel
TargetNumNumber for a called 
targetCHAR (41)
TargetNameName for a called targetCHAR (65)
TargetTenantTenant name for called...

Records and Data Schema
CDR Manual 63
AADuration
Duration in seconds an 
incoming call is 
connected to the Auto 
Attendant/IVR; multiple 
connections to AA/IVR 
in a single session 
produces multiple 
records
LONG
RingDurationDuration in seconds a 
call is ringing and in 
workgroup queueLONG
QueueDurationDuration in seconds 
when a call stays in a 
queue.LONG
VMDuration
Duration in seconds 
after a call goes into a 
voicemail box; includes 
greeting, false attempts 
at messages, 
successful message,...

Data Schema
64 CDR Manual
AbnTargetTypeType of abandon 
forward targetLONG
1=Abandon to AA
2=Abandon to Operator
3=Abandon to Extension
4=Abandon to Outside      Number
5 =Abandon to VM
6 = Abandon to        Application
7 = Abandon to Others
8 = Call Disconnected
AdvQAppTypeType of Advanced 
Queue Management 
ApplicationLONG
MMCallTypeMulti-Media call typeLONG
PriorityQueueDur
ationThe duration in seconds 
of a call hold current 
priority in queueLONG
IVRExitPointExit Point of IVR/AACHAR 
(63)
When a...