AltiGen comm MAXCS 87 CDR Manual

Records and Data Schema
CDR Manual 65
ExitState specifications (see database element ExitState):
1 –  Auto Attendant: call exits in the AA / IVR.
2 –  Forward: call is forwarded from an extension by configuration 
forwarding.
3 –  Call Redirect: call is redirected to another extension or trunk by the 
AltiLinkPlus command "Redirect".
4 –  Ring No Answer: call rang target but no agent answered.
5 –  Busy: call tried to ring an agent but the agent extension was busy.
6 –  Queue: call abandoned from...

Data Schema
66 CDR Manual
15 –  Go to VM w/out leaving vm: A calls B. B is busy or ring no answer. 
A goes into B's voice mail. A drops without leaving any voice mail.
16 –  Go to VM with leaving vm: A goes into B's voice mail, leaves a voice 
mail, and then drops.
17 –  General VM: A presses ## to enter the voice mail system, inputs 
password, then drops.
18 –  VM Access: A presses ### to enter another extension’s voice mail, 
then drops.
19 –  VM Notify: A receives a notification call, enters...

Records and Data Schema
CDR Manual 67
Table: WGRTSUMMARY
Database ElementDefinitionTypeSpecification
VersionVersion of the recordLONG2 = OE/ACM 
5.0A
NodeIDServer ID (System ID) 
assigned to a MAXCS 
system in MaxAdminLONGvalue: 1–100 
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 1970/01/
01 00:00:00.
LONG
GMTOffset
Offset to GMT time, 
includes daylight 
savings, in seconds; ex: 
Pacific Summer time...

Data Schema
68 CDR Manual
CurNumAgentBusyTotal Agents Busy 
(Snapshot at EndTime)LONG
CurNumAgentNotReadyTotal Agents Not Ready 
(Snapshot at EndTime)LONG
CurNumAgentWrapUpTotal Agents Wrap-up 
(Snapshot at EndTime)LONG
CurNumAgentDNDFWDTotal Agents DND/FWD 
(Snapshot at EndTime)LONG
CurNumAgentAvailableTotal Agents Available 
(Snapshot at EndTime)LONG
CurLongestQTimeLongest Queue Time 
(Snapshot at EndTime)LONG
CurQLengthNumber of calls in 
Queue (Snapshot at 
EndTime)LONG
CurNumCallOverSLTNumber of...

Records and Data Schema
CDR Manual 69
Table: WGSUMMARY
IntvMaxLongestQTimeMaximum longest queue 
time in record's periodLONG
IntvMaxQLengthMaximum queue length 
in record's periodLONG
IntvMaxNumCallOverSL
TMaximum calls exceed 
SLT in record's periodLONG
IntvMaxServiceLevelMaximum Service Level 
% for WG Queue in 
record's periodLONG
IntvMinServiceLevelMinimum Service Level 
% for WG Queue in 
record's periodLONG
Database ElementDefinitionTypeSpecification
VersionVersion of the...

Data Schema
70 CDR Manual
DayOfWeekDay of the weekLONG
0 = Sunday 
1 = Monday
2 = Tuesday
3 = Weds
4 = Thursday
5 = Friday
6 = Saturday
WGNumWorkgroup NumberLONG
NumInWGCallTotal inbound WG call 
during intervalLONG
NumInCallInQTotal calls in queue during 
intervalLONG
DurInCallQTotal queue duration during 
time interval for all WG 
inbound callsLONG
NumInAnswered
Total WG inbound calls 
answered by agents during 
interval. If a login agent 
uses pick call from queue 
feature in MaxAgent, this 
counter...

Records and Data Schema
CDR Manual 71
DurInWrapUpWrap-up duration for 
incoming callsLONG
NumInAbnInQTotal number of calls hang-
up in queueLONG
DurInAbnInQTotal queue time of calls 
hang-up in queueLONG
DurInAbnInQ_RingTim
eTotal ring time of calls 
hang-up in queueLONG
NumInAbnDuringRingNumber of calls hang-up 
during ring (in queue or 
never in queue)LONG
DurInAbnDuringRingTotal Queue time for calls 
hang-up during ringLONG
DurInAbnDuringRing_
RingTimeTotal Ring time for calls 
hang-up during ring (in...

Data Schema
72 CDR Manual
DurInAbnToAppTotal Queue time for calls 
abandoned to add-on 
applicationsLONG
DurInAbnToApp_Ring
TimeTotal Ring time for calls 
abandoned to add-on 
applications (in queue or 
never in queue)
LONG
NumInAbnToOthers
Number of all calls 
abandoned to a target 
other than VM when caller 
in queue presses a digit
LONG
DurInAbnToOthersTotal Queue time for 
NumInAbnToOthers callsLONG
DurInAbnToOthers_Ri
ngTimeTotal Ring time for 
NumInAbnToOthers callsLONG
DurInAbnQRing...

Records and Data Schema
CDR Manual 73
NumInHold
Number of inbound WG 
calls were ever hold by 
agent (One call on hold 
multiple times will count 
just one time)
LONG
DurInHoldDuration of inbound WG 
calls were hold by agentLONG
NumInRecordNumber of inbound WG 
calls were recordedLONG
DurInRecordDuration of inbound WG 
calls were recordedLONG
NumOutConnectedNumber of WG outbound 
connected callsLONG
DurOutTalk
Duration of outgoing WG 
calls (NumOutConnected); 
from the call enters 
"Connected"...

Data Schema
74 CDR Manual
NumInAbnInQWithinS
LT
Total number of calls hang-
up in queue with wait time 
less than or equal to 
Service Level Threshold 
within report interval 
(QueueTime+RingTime