Sky Dance Completions

Carrier, Dial Code, Deviation, Trunk, Custom, Call Look Up, Mediation

Table of Contents

TABLE OF FIGURES 5

INTRODUCTION 7

MINIMUM REQUIREMENTS 8

GET STARTED 9

THE MAIN MENU BAR 12

1 TRAFFIC DASHBOARD 12

2 CARRIER 12

2.1 CARRIER -> INCOMING 12

2.1.1 CARRIER REPORTS INCOMING TRAFFIC 16

2.1.2 TRAFFIC/LAST 24 HOURS 22

2.1.3 LAST 15 DAYS 25

2.1.4 GENERAL INCOMING TRAFFIC – LAST 15 DAYS 26

2.2 CARRIER -> OUTGOING 27

3 CARRIER LAST 15 MINS 30

4 DIAL CODE 32

4.1 DIAL CODE -> INCOMING DESTINATION 32

4.2 DIAL CODE -> OUTGOING DESTINATION 34

4.3 DIAL CODE -> INCOMING AND OUTGOING COUNTRY 35

5 DEVIATION 39

5.1 DEVIATION -> INCOMING 39

5.2 DEVIATION -> OUTGOING 41

6 TRUNK 44

7 CUSTOM 45

7.1 CUSTOM -> CUSTOM REPORTS 45

7.2 CUSTOM -> CUSTOM GRAPH 51

8 CALL LOOK UP 53

9 MEDIATION 53

10 LOGOUT 54

APPENDIX 55

Table of Figures

Figure 1. Login Window. 9

Figure 2. Opening Screen – Traffic Dashboard. 10

Figure 3. Search by Date Window. 11

Figure 4. The Main Menu Bar. 12

Figure 5. Levels of Detail in the Carrier -> Incoming Window 13

Figure 6. Trunk Level Detail in the Carrier -> Incoming Window 15

Figure 7. Carrier -> Incoming Screen – Level 1. 17

Figure 8. Table Customization. 18

Figure 9. Detailed Report for a Carrier in the Incoming Screen – Level 2. 20

Figure 10. Detailed Report for a Destination – Level 3 21

Figure 11. CDR for a Specific Customer and Destination – Level 4. 22

Figure 12. The Traffic for the Last 24 Hours Window. 22

Figure 13. Details of the Traffic for the Last 24 Hours Window. 23

Figure 14. Levels of Detail in the Traffic /Last 24 hour Window. 24

Figure 15. Dial Code Sub - Level in the Traffic / Last 24 Hour Window. 25

Figure 16. Last 15 Days Windows. 26

Figure 17. General Incoming Traffic. 27

Figure 18. Levels of Detail in the Carrier -> Outgoing Window 28

Figure 19. The Carrier -> Outgoing Screen. 29

Figure 20. Levels of Detail in the Carrier Last 15 Minutes-> Incoming Window 30

Figure 21. Levels of Detail in the Carrier Last 15 Minutes-> Outgoing Window 31

Figure 22. Dial Code -> Incoming Destination Window. 32

Figure 23. Level of Detail in the Dial Code -> Incoming Destination Window. 33

Figure 24. Traffic in the Last 24 hours for a Specific Destination and Customer. 34

Figure 25. Levels of Detail in the Dial Code -> Outgoing Destination Window. 35

Figure 26. Levels of Detail in the Dial Code -> Incoming Country Window. 36

Figure 27. Levels of Detail in the Dial Code -> Outgoing Country Window. 38

Figure 28. Levels of Detail in the Deviation -> Incoming Window. 40

Figure 29. Sub Level of Detail in the Deviation -> Incoming Window. 41

Figure 30. Levels of Detail in the Deviation -> Outgoing Window. 42

Figure 31. Sub Level of Detail in the Deviation -> Outgoing Window. 43

Figure 32. Trunk -> Incoming Window. 44

Figure 33. Trunk -> Outgoing Window. 45

Figure 34. Custom Reports Window. 46

Figure 35. Destination List Search in the Custom Reports Window. 46

Figure 36. Customize Destination – Dial Code in the Custom Reports Windows 47

Figure 37. Customize Destination – Destination in the Custom Reports Window. 48

Figure 38. Carrier List in the Custom Reports Window. 48

Figure 39. Detailed Carrier List in the Custom Reports Windows. 49

Figure 40. Customize Carrier in the Custom Reports Window. 49

Figure 41. Example of a Report. 50

Figure 42. Line chart for Traffic Stats in the Custom Report Window. 51

Figure 43. Custom Graph Window. 51

Figure 44. Example of a Custom Graph. 52

Figure 45. Call Look Up Window. 53

Figure 46. Mediation Files Window. 54

Introduction

This is COMPLETIONS, a powerful interactive web application that will help you manage your traffic effectively, and will provide you with updated data and detailed information that will aid you in taking decisions about your maintenance, supervision, routing schemes and business practices.

COMPLETIONS collects data and records it over the previous hour, day, week, and month. This data is processed and represented to supervise the current traffic volumes, locate potential problems, compare performances, and manage the Call Detail Records (CDR).

This edition of the User’s Guide applies to released version 4.0.15.

Minimum Requirements

COMPLETIONS runs on a customized Linux server. The hardware configuration has been designed to fit your specific needs.

Being a web application, COMPLETIONS runs on all the major browsers: Firefox Google Chrome Internet Explorer Safari

The communication channel between your switch and the LAN where the web application will be running has to be IP. Several standard protocols can be used, SCP, NFS, FTP, etc. It is always recommended to use an encrypted connection and have enough bandwidth to avoid delays importing the CDR files.

Get Started

To begin a session in COMPLETIONS type the URL of the application that is assigned to your network in the address bar of your browser. This address will have the following format: http://completions.yourcompanyname.com

Your screen will display the Login page (Figure 1). Type your Username and Password to initiate the application. Your administrator will define your profile based on a role and permission security.

Note: Your Username will be restricted after three unsuccessful login attempts.

Figure 1. Login Window.

Once your Username and Password have been authenticated, you will see the opening screen with four pie charts (Figure 2).

Figure 2. Opening Screen – Traffic Dashboard.

These pie charts describe the traffic volumes (minutes) on your network for the 00:00 - 23:59 timeframe of the previous day.

• First Chart – Minutes by Country This is a graphic summary of the countries with higher terminating and originating traffic: top 9 countries and rest of the world.

• Second Chart – Minutes by Type of Traffic This chart reports Incoming and Outgoing traffic per type of customer.

• Third Chart – Minutes by Client This is a graphical representation of your top 9 customers. The rest of the customers are represented in the division “OTHER”. • Fourth Chart – Minutes by Provider. This is a report of your top 9 providers. The rest of the providers are represented in the division “OTHER”.

Note: Client here is referred as the operator or carrier that uses your network to direct calls toward a given country/city/network, and Provider is the operator or carrier that terminates your calls in that country/city/network.

By scrolling the mouse over the pie divisions you will get detailed information of the amount of minutes for that day. To recall information of a specific date and time, just change the parameters in the Search by date window (Figure 3).

Figure 3. Search by Date Window.

The Main Menu Bar

In this bar (Figure 4) you will find every resource you need to understand in detail the traffic performance and volumes.

Figure 4. The Main Menu Bar.

Note: Most of the options in the Main Menu Bar are divided into Incoming and Outgoing. Incoming is referred to the traffic that your clients send to your network. Outgoing refers to the traffic that you send to the providers to terminate it in the corresponding destinations.

1 TRAFFIC DASHBOARDÃ¥

The icon will take you back to the Traffic Dashboard (Figure 2) showing data for the prior day.

2 CARRIER

2.1 Carrier -> Incoming

This option is dedicated to the traffic coming from your customers. There are various levels of detail that you can retrieve. The following diagram summarizes those levels:

Figure 5. Levels of Detail in the Carrier -> Incoming Window

• The first level shows by default a list of your customers and the traffic details for the previous hour. • Click on any customer to enter the second level. Here you have information about the destinations for a specific customer. You can retrieve information for the last 24 hours and last 15 days for that Customer -> Destination. • To go to the third level, click on a destination and you will see the list of carriers that deliver traffic to that destination. Or click on a dial code to see the carriers for that code. Here you have access the last 24 hours and last 15 days reports.

• To go to level four, click on any of the terminating carriers and you will retrieve the list of CDR for the previous hour.

Note: Destination refers to the network where the call is intended to terminate.

Now, if you want to access data of a specific trunk, expand using on a customer of Level 1 and follow the sequence shown in Figure 6.

Figure 6. Trunk Level Detail in the Carrier -> Incoming Window

• Click on a trunk to see the list of destinations for that specific trunk. • Select a destination, and you will have a list of providers for that network, or, expand the destination and you will have access to the dial codes available for that destination. • Click on a dial code or destination to see the list of providers. • Click on a provider to access the CDR.

Following is a detailed explanation of each table on the Carrier -> Incoming Window: • Carrier Reports Incoming Traffic. • Traffic Last 24 Hours. • Last 15 Days. • General Incoming Traffic – Last 15 days

2.1.1 Carrier Reports Incoming Traffic

The first Screen – Carrier Reports Incoming Figure 7- gives you general information about the traffic per customer for the previous hour. You can make use of the Search by Date window to retrieve data previously recorded.

Figure 7. Carrier -> Incoming Screen – Level 1.

By default you will see a list (Expand) of your customers sorted by traffic type. The traffic categories depend on the type of service rendered: hubbing, retail, etc. Click on Collapse all to show only the totals per type of traffic.

To customize the table, click on the right corner of any parameter and checkmark on the columns you want to see (Figure 8).

Figure 8. Table Customization.

The complete list of parameters related to your traffic is shown in Appendix A.

Most COMPLETIONS data related with the quality and duration of the call is displayed in pairs separated by a forward slash (/). The value to the left of the slash represents the measurement of the previously recorded hour; the value to the right of the slash represents the average value in the same hour and same day for the last 8 weeks; this value helps determine the typical performance of the route. In some cases measurements are taken for one full day, for example when you make use of the Search By Date Window. In that situation, the value to the right of the slash represents the average value in the same day for the last 8 weeks. For new routes, the average values are calculated from the previous two days.

COMPLETIONS uses three colors to indicate an abnormal situation. To mark a parameter as abnormal, COMPLETIONS’ algorithm feeds itself with historical data and analyzes trends based on time of the day, day of the week, client, destination and provider. This algorithm prevents false positives.

Table 1. Events Color Codification COLOR CODE DESCRIPTION Red A red cell on the table indicates an abnormally low value in comparison to the typical performance of the route. Green A green cell indicates abnormally high values in comparison to the typical performance of the route. Yellow A yellow cell indicates a new source of traffic, for example a new route. It indicates that there’s no previous data to determine typical performance for that route. This means that you are receiving new traffic not seen before.

The symbol allows you to prioritize your customers according to the volume of traffic, the profit, or other criteria. There are three categories: gold, silver, and bronze.

Figure 9 shows the screen of the Destination Reports. Here you can retrieve data for the last 24 hours or last 15 days for that specific network.

Figure 9. Detailed Report for a Carrier in the Incoming Screen – Level 2.

Figure 10 shows the list of carriers that terminate the traffic in the destination you chose. Again, data for the last 24 hours and last 15 days are available.

Figure 10. Detailed Report for a Destination – Level 3

Figure 11 shows the CDR for that route. To customize the CDR table, click on the right corner of any parameter. In the window displayed you can sort data and select the parameters you want to see. See Appendix B for a description of the parameters in the CDR.

Figure 11. CDR for a Specific Customer and Destination – Level 4.

2.1.2 Traffic/Last 24 hours

The second table on the screen is the traffic for the last 24 hours (Figure 12). To retrieve data, click on the “load table button,” .

Figure 12. The Traffic for the Last 24 Hours Window.

The table will show a summary per type of traffic for the last 24 hours (Figure 13). Three parameters are shown per hour: volume of traffic for that hour (MINUTES), ASR and ALOC. You can expand and collapse (Expand/Collapse All) all the data displayed or only the data of certain type of traffic ( and ).

Figure 13. Details of the Traffic for the Last 24 Hours Window.

From the table in Figure 13 you can retrieve detailed information as shown in Figure 14.

Figure 14. Levels of Detail in the Traffic /Last 24 hour Window.

• Click on a specific hour of level 1 and you will retrieve the list of customers for that hour (Level 2 - Figure 14). • Click on a specific customer and you will retrieve the list of destinations for that customer at the specified hour (level 3). • Or click on a trunk assigned to a customer and you will see the destinations for that trunk (level 3.1). In this level the Last 15 Days table shows the traffic volumes for that customer in the prior two weeks for that specific hour. • On level 3 you have two options: retrieve information for a destination or for a specific dial code. • Then on level 4 you can see the list of carriers for that destination or code and on level 5, the CDR for the route.

Now lets see level 3.1 (Figure 15) in detail: • Once you have selected a specific hour, customer and trunk, you have two options: you can access a specific destination for that trunk or you can access a dial code. • From there you can see the providers, • And then the CDR.

Figure 15. Dial Code Sub - Level in the Traffic / Last 24 Hour Window.

2.1.3 Last 15 Days

The third section of the Carrier -> Incoming screen is the Last 15 Days window (Figure 16). It provides traffic volumes (minutes) for the previous two weeks.

Figure 16. Last 15 Days Windows.

2.1.4 General Incoming Traffic – Last 15 days

The last section of the screen is the General Incoming Traffic – Last 15 days chart. It describes the behavior of your incoming traffic in terms of minutes per day.

Figure 17. General Incoming Traffic.

In this chart, the bars marked as “So Far” represent the daily traffic volume for the same amount of hours that has past in the present day. Scrolling the mouse over the bars shows the exact value.

Note: All the tables can be exported using any of the following formats: csv, xls, xml, pdf. This option is always at the bottom of the table.

2.2 Carrier -> Outgoing

This section describes the traffic that you send to your providers. It has the same structure and functionality as the Carrier -> Incoming section shown in Figure 5.

The following figure shows the level of detail in the Carrier -> Outgoing option:

Figure 18. Levels of Detail in the Carrier -> Outgoing Window

• The first level shows a list of providers and, by default, the traffic details for the previous hour. • Click on any provider or trunk to enter the second level. Here you have information about the destinations of a specific provider or trunk. You can retrieve information for the last 24 hours and last 15 days for that Provider -> Destination. • To go to the third level, click on a destination or dial code. You can see the list of customers sending traffic to that destination or dial code Here you have access to the last 24 hours and last 15 days reports. • To go to level 4, click on any of the customers and you will retrieve the list of CDR for the previous hour.

Figure 19. The Carrier -> Outgoing Screen.

3 CARRIER LAST 15 MINS

In this option of the Main Menu Bar you can retrieve information about the Incoming and Outgoing traffic for the last 15 minutes (0:01 – 15:00, 15:01 – 30:00, 30:01 – 45:00, 45:01 – 0:00). It has the same structure and functionality as the Carrier -> Incoming or Outgoing option.

Figure 20 represents the sequence of levels for the Carrier Last 15 Minutes -> Incoming option.

Figure 20. Levels of Detail in the Carrier Last 15 Minutes-> Incoming Window

• When you open the Carrier Last 15 Minutes -> Incoming window, you see a complete list of customers (level 1), organized by type of service. • Click on a customer to see the list of destinations (level 2) or click on to retrieve the list of trunks for a customer, and then select a trunk. • Now to see the list of providers (level 3), click on a destination or click on and then select a dial code. • The CDR (level 4) is displayed when you select a provider.

Figure 21. Levels of Detail in the Carrier Last 15 Minutes-> Outgoing Window

Figure 21 represents the sequence of levels for the Carrier Last 15 Minutes -> Outgoing option:

• First you will see a complete list of providers organized by type of service (level 1). • Click on a provider to see the list of destinations (level 2) or click on to retrieve the list of trunks for that provider, and then select a trunk. • Now to see the list of customers (level 3), click on a destination or click on to see the list of dial codes then select a dial code. • The CDR (level 4) is displayed when you select a customer.

4 DIAL CODE

This option in the Main Menu Bar allows you to retrieve data by dial code.

4.1 Dial Code -> Incoming Destination

This option shows the traffic data of your customers disaggregated per destination. By default, you will see data for the previous hour.

Figure 22. Dial Code -> Incoming Destination Window.

On this screen you will retrieve the first hundred lines of your destinations. In the top section of the window, you can customize this table by date and hour, and/or Dial Code (Figure 20). You can also customize the information in the columns by clicking on the right side of any header cell.

Figure 23. Level of Detail in the Dial Code -> Incoming Destination Window.

Figure 23 is an example where three customers send traffic to Dial Code 880.

• To expand the information of a destination in Level 1, click on . • Now, click on one of the customers to see information of the carriers used to terminate traffic and on which there was at least one call attempt (Level 2). • Level 3 represents the CDR of the route for that specific provider.

Back to Level 2, you have the option to load data for the last 24 hours and last 15 days (Figure 24). When you load these tables, you can see the details of the carriers on which there was at least one call attempt in the last 24 hours.

Figure 24. Traffic in the Last 24 hours for a Specific Destination and Customer.

Once in this window you can go to the CDR level by clicking on one carrier.

4.2 Dial Code -> Outgoing Destination

This section describes the traffic that you send to your providers, disaggregated by destination. It has the same structure and functionality as the Dial Code -> Incoming Destination section. By default it shows data for the previous hour.

Figure 25 represents the sequence of levels for the Dial Code -> Outgoing Destination.

Figure 25. Levels of Detail in the Dial Code -> Outgoing Destination Window.

• Once you have narrowed your search by Dial Code and/or date you can access the first level. Here you have a list of destinations and providers that deliver the traffic there. • To access level 2 click on one of the carriers and you will see a list of customers that are sending traffic to that destination. • And on level 3 you have the CDR for the route.

4.3 Dial Code -> Incoming and Outgoing Country

This option shows the traffic data disaggregated per country. It has a similar structure and functionality as the Dial Code -> Incoming. By default you will see data for the previous hour.

Figure 26. Levels of Detail in the Dial Code -> Incoming Country Window.

This figure represents the level of detail in the Dial Code -> Incoming Destination window for dial code 351. It starts with a general list of all the countries. Narrow the list by making use of the search window.

• Level 1 shows the list of customers for this dial code. • In the second level you can access a list of destinations per customer. If you expand one of those destinations, you can see the list of dial codes for that destination. • In the third level you have a list of providers for a specific destination or dial code. • And level 4 contains the CDR of the route.

The option Dial Code -> Outgoing Destination has a similar distribution of levels.

Figure 27. Levels of Detail in the Dial Code -> Outgoing Country Window.

In Figure 27 you have an example of a narrowed search by dial code (351).

• Level 1 shows the list of providers for this dial code. • In the second level you can access a list of destinations per provider. If you expand one of those destinations, you can see the list of detailed dial codes for that destination. • In the third level you have a list of customers for a specific destination or dial code. • And level 4 contains the CDR of the route. 5 DEVIATION

This functionality is very useful to locate potential problems or unusual behavior of your traffic in the previous hour (by default). The Events Color Codification of Table 1 is used to denote such cases.

5.1 Deviation -> Incoming

In this screen you can locate specific changes in your incoming traffic behavior. You can narrow your search using the following options:

• Top New Traffic: This option presents new traffic coming to your network, new routes or, customers that have started to send traffic. • Top Increase: Denotes an unusual increase of traffic on a destination or route compared to the typical ranges of the route. • Top Decrease: Shows the abnormally low values of traffic of a route compared to its typical performance. • All Traffic: Compiles all the events of your routes.

You can also narrow your search for a specific timeframe by using the Search by Date Window.

Figure 28. Levels of Detail in the Deviation -> Incoming Window.

• Once you go to Deviation -> Incoming, your screen will show you a complete list of events sorted by customer (level 1). • Click on a destination and you will have a list of providers for that destination. • In this level you can locate the provider that shows unusual values (level 2). • In level 3 you have the CDR for that route.

Figure 29. Sub Level of Detail in the Deviation -> Incoming Window – Level A

• Now, to enter level A click on a carrier. You will see a complete list of destinations for that carrier. • Here you have two options: you can see the performance of one destination or the performance of a specific Dial Code. • In the next level you can determine the provider that is showing unusual values of traffic.

5.2 Deviation -> Outgoing

This section describes the unusual events in your outgoing traffic. It has a similar structure as Deviation -> Incoming.

Figure 30. Levels of Detail in the Deviation -> Outgoing Window – Level A

• In level 1 you have the list of providers and destinations that show an unusual behavior. • If you click on one of them you will see a complete list of destinations for that carrier (level 2). • You can click on a destination or you can expand it to access a list of dial codes and then select one (level 3). • In level 4, you have the CDR for each case.

Figure 31. Sub Level of Detail in the Deviation -> Outgoing Window – Level A

Now, in level 1 if you click on a destination (level A) you will retrieve a list of customers for that destination and then, the CDR.

6 TRUNK

In this option you can see the traffic per trunk in the last hour. You can filter the information using the Search by Date option and customize the table by changing the header cells. Also, you can expand the incoming or outgoing trunk to see the details of the traffic per channel.

Figure 32. Trunk -> Incoming Window.

Figure 33. Trunk -> Outgoing Window.

7 CUSTOM

With this option you have the possibility to retrieve information about the traffic performance of incoming or outgoing carriers and/or destination.

7.1 Custom -> Custom Reports

With the Custom Reports (Figure 34) you can load data related to the traffic performance of your routes.

Figure 34. Custom Reports Window.

You can customize your search as follows:

• Start and End: Use these fields to recall stats information for a specific timeframe. Note that the reference time is +0000 GMT. Data for the current day is not available.

• Direction Here you choose between incoming and outgoing traffic.

• Destination List: A complete list of your destinations is displayed. You can choose more than one destination (Figure 35).

Figure 35. Destination List Search in the Custom Reports Window.

• Customize Destination: If you don’t want to use the Destination List, you can customize your report by Dial Code and/or Destination. In the Dial Code field you must enter at least two digits of the destinations you want to the data to be retrieved. The codes must be separated by commas (Figure 36.)

Figure 36. Customize Destination – Dial Code in the Custom Reports Windows

In the Destination field, you can type the country, city or operator name -for example “Comcel”. You must type at least the first four letters and separate different destinations by a comma (Figure 37).

Figure 37. Customize Destination – Destination in the Custom Reports Window.

• Carrier List: In this field you can look for a specific carrier in the list and add multiple carriers to your search (Figures 38 and 39).

Figure 38. Carrier List in the Custom Reports Window.

Figure 39. Detailed Carrier List in the Custom Reports Windows.

• Customize Carrier: You can type the name of the carrier directly in the field carrier and separate them by commas when you type multiple carriers.

Figure 40. Customize Carrier in the Custom Reports Window.

Now let’s take a look at the report. Figure 41 is an example of the list of customers sending traffic to Dial Codes 57310 and 576, between November 1st and 4th. The report shows the subtotals per customer and a grand total at the bottom of the table.

Figure 41. Example of a Report.

At the bottom of the window you will see the stats variation over the actual timeframe (Figure 42).

Figure 42. Line chart for Traffic Stats in the Custom Report Window.

7.2 Custom -> Custom Graph

With the Custom Graph Window (Figure 43) you can generate a line graph that displays the traffic performance of a specific route.

Figure 43. Custom Graph Window.

This window has the same structure as the Custom Reports window.

Figure 44. Example of a Custom Graph.

The graph generated shows the stats values for each hour of the timeframe specified in the Search by Date fields.

8 CALL LOOK UP

This option is useful to locate potential problems on a route. You can enter either the dialed number or the number from where the call is generated, or both.

Figure 45. Call Look Up Window.

Figure 45 is an example of the table generated when you enter the number from where the calls are generated. Here you can analyze the corresponding CDR to locate quality problems.

9 MEDIATION

This window gives you information about the CDR files that have being mediated between the switches and the Completions every hour. These files are needed to generate further reports. A red X denotes that the file has not been successfully retrieved.

Figure 46. Mediation Files Window.

10 LOGOUT

With this option you safely exit the application and the Login window of Figure 1 is displayed again.

Appendix

Appendix A. Telephone Traffic Monitoring Parameters.

PARAMETER DESCRIPTION Attempts An "attempt" refers to an attempted call. For example: subscriber X abroad tries to call subscriber Y in your country. Such a call may not always be successful; various factors may prevent the operator from establishing the connection. The “Attempts” column in COMPLETIONS indicates the total number of calls connected or not connected by a customer or received by a provider (carrier). This number is used to calculate other indicators, as will be shown further below. Answered A call is said to be "answered" when it has been connected, or more simply, when the called party has answered it. The “Answered” column of COMPLETIONS indicates the total number of connected calls (billed). Long / Short This column indicates the number of long calls and the number of short calls as a percentage of the total of successful calls. A call is considered long when it exceeds thirty minutes and short when it lasts less than six seconds. The value to the left of the slash refers to long calls percentage and the value to the right of the slash refers to short calls percentage. No Circuit This column displays the signals known to the customer or issued by the provider and that indicate that a circuit is busy or a call is blocked. Minutes This column displays the total number of minutes generated by successful (connected) calls. ALOC (Average Length of Call) or ACD (Average Call Duration) This column displays the average duration of all successful (connected) calls. ASR (Average Seizure Ratio) This column displays the successful (connected) calls as a percentage of the total number of attempted calls. The ASR is obtained by dividing the number of attempted calls by the number of successful calls. NER (Network Effectiveness Ratio) Like the ASR column, this column displays the percentage of attempted calls that were successful. However, the NER measures the technical capacity of a network to route calls from one user to another. This indicator is calculated by taking into account both successful calls and calls that could not be completed due to non-technical reasons. For example, a call that could not be completed because the number dialed by the subscriber was invalid will be included in the calculation. (NER = (successful calls + calls not completed due non-technical reasons)/total number of attempts x 100) AAR (Automatic Alternate Routing) This column displays the number of rejected or blocked calls as a percentage of attempted calls. QoS (Quality of Service) This column gives an indication of the quality of service level, measured with the aid of a QoS indicator. The QoS is calculated by multiplying the average duration of calls by the ASR. The duration is taken into account because very short calls generally indicate quality-of-service problems: static on the line, bad connection, etc. Thus, the poorer the service provided to the subscriber is, the shorter the subscriber's calls will be. Conversely, a higher average call duration multiplied by a high percentage of connected calls (ASR) indicates a better quality of service. PDD (Post-Dial Delay) This column shows the average time that elapses between the moment the caller dials the last digit of the number being called and the moment when the first ring is heard. Connected A call is successfully connected when there’s a ringing tone or the call is answered. Short Calls A call is considered to be short when it lasts less than 6 seconds. Average Attempts This value is the average of the past 8 weeks at the same time frame that the Attempts column is measured. Average Answered It is the average of the past 8 weeks at the same time frame that the Average column is measured. Average Minutes This value is the average of the past 8 weeks at the same time frame that the Minutes column is recorded. Average ALOC This is the average of the past 8 weeks at the same time frame that the ALOC column is recorded.

Appendix B. Descriptive Parameters in the CDR.

PARAMETER DESCRIPTION Tr/Sp/Ch In Indicates the Trunk Group of the Customer and the Span and Channel of the customer through which the call went. Trunk Name In Indicates the customer sending telephone traffic to a specific destination. Tr/Sp/Ch Out Indicates the Trunk Group of the provider, the span and channel of the carrier through which the call went. Trunk Name Out Indicates the provider terminating the telephone traffic to a specific destination. ANI In Indicates the calling number (A number) just as we receive it from the customer. After the number we see a number after a slash. This number is the NOA, which determines if the call is national (/3) or international (/4). Call can coming as national and go as international. ANI Out Indicates the called number just as we sent it to the carrier. DNI In Makes reference to the called number (B number), number that is sent by the Customer. Sometimes, the numbers are sent by a prefix before the country code set by the customer. DNI Out It makes reference to the called number as you send it to the carrier. Sometimes, the numbers are sent by a prefix before the country code set by the carrier. Called ID The destination number that the calling party dials. The B-number. Date Date the call was made. Seize Time Time when the call was placed. Disc. Time Time when the call ended. Duration It is the duration of the call. PDD Post Dialing Delay. It is the time between the start of the call and the moment the phone of the called party starts ringing. CC Refers to the connection of the call: number 5 indicates call completed, and numbers 3 and 4 that the call did not complete. R. Cause Indicates the disconnection cause of the call. Route Indicates the route of the call. Rt. Source Route Source. This field indicates if the route is static or if the automatic routing has selected the route. Rt. Position Route Position. There are various carriers per route in ordinal sequence. This field indicates what carrier of the list has been used to route the traffic. Gatekeeper Indicates the gatekeeper. Not always shown, depending on how we send / receive the traffic. R. Gateway Indicates the remote gateway (customer / provider gateway). Not always shown, depending on how we send / receive the traffic. L. Gateway Indicates the local gateway (our gateway). Not always shown, depending on how we send / receive the traffic. Codec Type of codec used.