background image

-- Call Detail Reporting Guide -- September 2000 -- Page 26 -- 

 

Reporting fields 

CDR Fields Used 

Comments 

Agent View 

 

 

Number of agents  signed 
on by workgroup  

StartTime 
Interval very important here 
Sum of number of call records 
where  
a.  ExitState=Hex80 and StartTime 

is > Midnight and < 
(stInterval) 

b.  And, ExitState=Hex100 FOR 

THE SAME Party1Number 
does not occur before 
(stinterval) 

By

 Party1WGNumber 

 

Basically : how many agents 
were logged on to the given 
workgroup for the entire 
interval 

Average TalkTime and 
Average wrap-up time      
by Agent in each 
workgroup signed in 

StartTime 
TrunkDirection

 =2 

Party1WGHandleDuration>0 
Average of Party1HandleDuration 
Average of WGWrapUpDuration 

By

 Party1WGNumber 

By Party1Number(agent number)

 

 

 

Total Sign-On Duration by 
Agent 

For all matching records where: 

TrunkDirection

=0 

And 

Party1Number

 is the same; 

StartTime

[

ExitState

=Hex100] – 

StartTime

[

ExitState

=Hex80] = Sign-

on Duration 
By 

Party1Number

 

Show how long each agent has 
been signed on that day, 
irrespective of how many 
workgroups the agent is 
signed onto. 

 

CALL  
VIEW 

 

 

Number of calls received 
with an ANI number 

 

 

Number of calls received 
with a CallerID 

 

 

Average Speed of Answer  

 

Average speed of answer is 
the average time it takes for an 
arriving call to reach an agent.   
 
Since a call can first go 
through an AutoAttendant 
before reaching an agent, and 
or in addition be queued, the 
average speed of answer 
covers both call duration 
before 

and 

throughout the 

queue until an agent answers. 
 

Number of calls received 
via the web  

 

AltiGen can receive and 
accept IP calls from web page  

Summary of Contents for Altiware Open Edition 4.0

Page 1: ...Call Detail Reporting Guide For AltiWare Open Edition OE 4 0 AltiGen Communications Copyright 2000 AltiGen Communications Inc Fremont California USA 4403 0012...

Page 2: ...DR APPLICATIONS 7 3 0 BACKING UP AND INSTALLING ALTIWARE S CDR RECORDS 8 3 0 EXTERNAL LOGGER SERVICE 8 3 1 EXTERNAL CDR LOGGER INSTALLATION GUIDE 9 3 2 INSTALLING EXTERNAL CDR LOGGER SERVICE TO SQL SE...

Page 3: ...ample the manager may find that certain types of calls are spending a great deal of processing time in the Auto Attendant handling and therefore decide to change either how many calls are sent to an A...

Page 4: ...queuing duration talk time wrap up time voice message duration and optionally call associated data User Defined Data 1 3 Management Objectives CDR and reporting packages help managers get the most out...

Page 5: ...packages examine the CDR records and create summary statistics and graphical displays useful to the phone system manager 2 1 Bundled Reporting Solution AltiGen and TriVium Systems signed an agreement...

Page 6: ...s Inbound Trunk Type View Date 07 17 2000 24 Hour Period Number of Calls by Quarter Hour Analog T1 PRI IP Total 00 00 00 15 xxxx xxxx xxxx xxxx xxxxx 00 15 00 30 xxxx xxxx xxxx xxxx xxxxx 00 30 00 45...

Page 7: ...eporting program to work with the new CDR database schema 2 4 No Reporting of Extension to Extension Calls AltiWare 4 0 does not support reporting CDR records for internal calls between extensions or...

Page 8: ...xcel may be adequate for you but it does not provide the reports found in the bundled solution It does not permit reasonable consolidation of multi site CDR data though with real work you can combine...

Page 9: ...uter name of the SQL server SA Name Enter the SQL System Administrator login name Since sa is one of the system administrator accounts created by SQL installation we will use this account as our examp...

Page 10: ...n t need to change the buffer size Default 500 records means that the system will buffer 500 calls in memory totaling about 500KB Typically 500 should be good enough to accommodate most situations unl...

Page 11: ...caller 0 two or less parties spoke with the caller A party is an extension or tie trunk Transfer Trunk Number The phone number to which a call was transferred outside the system otherwise it is empty...

Page 12: ...erved1 Reserved UCHAR 16 Party1Number Extension Number UCHAR 21 For non workgroup calls party1 is always set even if the extension doesn t answer the call For workgroup calls if the call is answered t...

Page 13: ...minutes seconds that a call was in connection with a target device or service represented by Party1Number Party1Tenant Extension s tenant name UCHAR 31 A name defined in AltiWare via AltiAdmin screens...

Page 14: ...utgoing trunk has been freed i e set to idle state WG Wrap Up Time TimeStamp when an agent extension within a workgroup goes out of wrap up state ULONG See WG Wrap Up Duration for explanation This is...

Page 15: ...to represent the tenant or department associated with the particular extension Wrap up Setting the wrap up time or supporting AltiX ActiveX controls can affect the level of CDR information For example...

Page 16: ...A Transfer Extension Party2 CDR Record Result First Agent is in party 1 Second Agent Ext is in Party2 5 In Call Auto Attend Party1 WG A Transfer Agent Party2 WG B Transfer Agent Party3 WG C Party 1 i...

Page 17: ...who consistently handles customer inquiries of all types Agents Signed On The number of agents signed on to the phone system to be agents using their phone or Center 4 0 to sign on All Trunks Busy An...

Page 18: ...the call from the system Exit State The state of the call in the phone system when the caller decided to disconnect The nominally correct exit state is when a caller disconnects during conversation wi...

Page 19: ...g calls finding all trunks busy for a given route table AltiServ AltiWare currently does not support overflow queuing for inbound calls waiting for a free agent PAD A Physical ADdress generalized to r...

Page 20: ...usy no trunks available then the route table can be configured with an alternative choice Ultimately the call takes a single final route Score This may or may not be found in the reports created withi...

Page 21: ...find useful in shared tenant environments One supported area is tracking who placed an outbound call by business name or dialing plan This name is called the tenant name and is configured in AltiWare...

Page 22: ...Customers you need to employ a system integrator in order to implement the use of User Data VM Box Extension The voice message mailbox is an extension number where calls are sent to leave messages VM...

Page 23: ...mber of incoming calls by trunk number StartTime TrunkDirection 2 Organized by TrunkPAD and Interval Total number of early abandoned calls by trunk number StartTime TrunkDirection 2 CallDuration 2 sec...

Page 24: ...ge queue duration by workgroup StartTime TrunkDirection 2 Party1WGWaitDuration 0 Party1WGHandleDuration 0 ExitState 8 Average of Party1WGWaitDuration By Party1WGNumber Total number of calls going to V...

Page 25: ...Number not blank By Party1WGNumber Service level of a workgroup StartTime TrunkDirection 2 Sum of number of call records where Party1WGWaitDuration X Divided by number of call records where Party1WGWa...

Page 26: ...By Party1WGNumber By Party1Number agent number Total Sign On Duration by Agent For all matching records where TrunkDirection 0 And Party1Number is the same StartTime ExitState Hex100 StartTime ExitSt...

Page 27: ...he field must be numeric 1 Suppose the customer tracks revenue per call AltiGen allows the customer to place how much revenue was generated by a call into the CDR record before it is written to the da...

Page 28: ...r a specific route group OUTBOUND CALL VIEW Total Minutes by AreaCode Call Duration Total number of calls by Area Code Total duration of calls by Area Code Call Duration Average duration of calls by A...

Page 29: ...15 etc xxxx xxxx xxxx xxxx xxxx 23 34 00 00 pm xxxx xxxx xxxx xxxx xxxx Total Calls 100 1000 1874 550 3524 Graphic Total all trunks by Qtr Hour _______________________________________________________...

Page 30: ...e reporting software Incoming calls can be declared early abandoned calls if the call duration is 2 secs Outgoing calls can be declared early abandoned or short duration calls for the same duration Sh...

Page 31: ...00 30 00 45 xxxx xxxx xxxx xxxx 00 45 01 00 am xxxx xxxx xxxx xxxx 01 00 01 15 etc xxxx xxxx xxxx xxxx 23 34 00 00 pm xxxx xxxx xxxx xxxx Total Calls 100 1000 1874 550 5 0 Outbound Route View Date 07...

Page 32: ...Hour Period OUTBOUND Tenant Name Number Minutes Ave Duration Carl Johnson 14 Martha Smith Alan Green ______________________________________________________________________________________ Note That T...

Page 33: ...0 Graphic 1 Number Queued by Qtr Hour 2 Queue Ave Dur by Qtr Hour 11 0 Inbound Call View DNIS Date 07 17 2000 24 Hour Period WG Number __________ user entered All an option Number Average Duration Tot...

Page 34: ...13 0 AutoAttendant View Date 07 17 2000 24 Hour Period AA Table Name Calls Ave AA Duration Exit VM Disconnect WG EXT AA Name1 xxxx 00 00 xxxx xxxx xxxx xxxx AA Name2 AA Name3 AA NameN 14 0 Agent View...

Page 35: ...pair Whose name in the name value pairing called score 15 0 WorkGroup Service View Date 07 17 2000 24 Hour Period For WorkGroup Number XX entered by user At Threashold YY entered by user Time Interva...

Page 36: ...ed off before start interval time Maximum Wait Time For a given workgroup and selected time interval continuously bubble up the maximum wait time duration of all calls in or exiting the queue over the...

Page 37: ...0 00 00 15 xxxx 00 00 00 15 00 30 00 30 00 45 00 45 01 00 am 01 00 01 15 etc 23 34 00 00 pm xxxx 00 00 Graphic Number by Qtr Hour 20 0 Voice Mail SpillOver for ACD Calls View Date 07 17 2000 24 Hour P...

Page 38: ...of Calls Received with ANI CallerID Number ANI Number xxx xxxxxxx Number of Calls yyy Number of Calls Received For DNIS number DNIS Number xxx xxxxxx Number of Calls yyy Number of Calls received for...

Reviews: