Quarterly Operational Requirements
Revised for NTO, CTO and PIPs
Prepared by PricewaterhouseCoopers
For
The Uganda Communications Commission (UCC)
Table of Contents
1 Quarterly operational requirements review ... 3 2 Appendix 1 – Quarterly Operational Requirements, NTO, CTO and PIPs ... 4 3 Appendix 2 – Quarterly Operational Requirements, NTO, CTO and PIPs Standard Forms ... 8
1 Quarterly operational requirements review
As part of the current market study, UCC has reviewed the existing Reporting Framework, with respect to the following areas:
o Quarterly Operational Requirements for NTO, CTO and PIPs; o Quarterly Operational Requirements for PSPs;
o Annual Reporting for all operators; and o Financial Reports.
Following the review, the Quarterly Operational Requirements for NTO, CTO and PIPs has been amended, with the following key changes:
o Information request restructured to provide more clarity and consistency.
o Standard input forms created to facilitate data input by the operators, as well as to enable information analysis by UCC. The proposed template aims to set up an optimal layout for comparative analysis between periods and operators.
o Additional requirements included in the forms to increase transparency and enable more detailed market analysis.
The current requirements for PSPs seem reasonable and sufficiently informative, therefore no changes are proposed.
Annual financial reports should continue to be submitted to UCC following the same process and timeframe. These include the audited annual accounts of the operators.
The proposed structure for the Quarterly Operational Requirements for NTO, CTO and PIPs is set out in Appendix 1.
The standard templates for data submission are shown in Appendix 2. These are also available as Excel spreadsheet.
2 Appendix 1 – Quarterly Operational Requirements, NTO,
CTO and PIPs
i. Fixed Network Access and Coverage Data
Code Data type
100 Fixed telephone lines in operation by access technology 101 Fixed telephone lines in operation by residential / corporate 102 Total capacity of fixed line switch
103 Number of main lines connected to digital exchanges 104 Number of lines connected to analogue exchanges if any 105 Switch capacity of the digital exchange
106 Fixed line network Geographic coverage 107 Payphones number and regional distribution
ii. Fixed Network Traffic & Calls
Code Data type
200 Outgoing - Fixed to own fixed network 201 Outgoing - Fixed to own mobile network 202 Outgoing - Fixed to off net fixed networks 203 Outgoing - Fixed to off net mobile networks 204 Outgoing - Fixed to East African networks
205 Outgoing - Fixed to the rest of the world networks 206 Outgoing - Fixed to Toll Free
207 Outgoing - Fixed to Premium numbers 208 Outgoing - Fixed to Emergency services 209 Outgoing - Dialup minutes
210 Outgoing - International transit traffic 211 Incoming - From other local fixed networks 212 Incoming - From other local mobile networks
213 Incoming - From international to fixed network (Excluding transit traffic) 214 Incoming - International transit traffic
215 IP telephony traffic
iii. Mobile Network Subscribers
Code Data type
301 Active mobile subscribers - Postpaid 302 Active mobile subscribers - Prepaid
303 Active mobile subscribers - Low and medium speed mobile networks if any 304 Active mobile subscribers - 3G
305 Active mobile subscribers - 2.5G (GPRS & EDGE) 306 Active mobile subscribers - Voicemail
Code Data type
400 Outgoing - Mobile to mobile own network 401 Outgoing - Mobile to fixed own network 402 Outgoing - Mobile to off-net fixed networks 403 Outgoing - Mobile to off-net mobile networks 404 Outgoing - Mobile to East African networks 405 Outgoing - Mobile to the rest of the world networks 406 Outgoing - Mobile to Toll Free
407 Outgoing - Mobile to Premium numbers 408 Outgoing - Mobile to Emergency services 409 Outgoing - International Transit
410 Outgoing - Visiting roamers outbound traffic 411 Incoming - From other local mobile operators 412 Incoming - From other local fixed operators
413 Incoming - From international to own mobile network 414 Incoming - International transit
415 Incoming - Visiting roamers inbound traffic 416 Roaming - Own subscribers in other networks 417 IP telephony traffic
v. Mobile data
Code Data type
500 Outgoing - SMS on-net 501 Outgoing - SMS off-net
502 Outgoing - SMS to international 503 Incoming - SMS off-net
504 Incoming - SMS from international 505 Outgoing - MMS on-net
506 Outgoing - MMS off-net
507 Outgoing - MMS to international 508 Incoming - MMS off-net
509 Incoming - MMS from international
510 Number of SMS originated and terminated on a given PIP’s network through a given PSP
511 Number of outgoing SMS from a given NTO/CTO/PIP network terminating on
another local network through the given PSP 512 Mobile internet traffic (volume in Mb)
vi. Internet access
Code Data type
600 Number of fixed internet subscribers by access technology and bandwidth 600a Number of fixed internet subscribers - Residential
600b Number of fixed internet subscribers - Corporate
601 Provide details of non speed based internet access usage e.g. capacity based pricing
602 Distribution of wireless hotspots
603 Number and distribution of public internet access cafes served regardless of access speeds
604 Number and location (by district) of educational institutions served with internet access regardless of access speeds
605a Total international uplink bandwidth 605b Total international downlink bandwidth 605c Total local bandwidth
606 Internet price list
607 Internet usage
vii. Leased lines
Code Data type
700 Retail leased lines price list – local ends (by distance and capacity) 701 Retail leased lines price list – trunk (by distance and capacity)
702 Wholesale leased lines price list – local end (by distance and capacity) 703 Wholesale leased lines price list – trunk (by distance and capacity)
viii. Billing and Complaints
Code Data type
800 %age of postpaid accounts that have been billed in a month 801 Billing complaints as a % age of total bills issued
802 %age of billing complaints resolved within 5 days of receipt
803 %age of billing complaints resolved within 20 days of receipt of complaint 804 %age of billing complaints resolved within 30 days of receipt of complaint 805 Volume and number of non billing complaints received
806 Number of non billing complaints resolved within 1 working day of receipt of complaint
807 Service activation/provisioning time
808 %age of service restoration requests fulfilled within 1 working day. Specify the various services.
809 %age of service restoration requests fulfilled within 2 working days of reporting
ix. Network availability
Code Data type
900 BTS - number, type, distribution, capacity 901 BSC - number, capacity
902 MSC - number, capacity
903 Other platforms (SMS, Voicemail, SGSN, GGSN)
904a Owned transmission - type and total capacity
904b Owned microwave transmission - distribution and capacity (no of E1) 904c Owned fibre transmission - distribution and capacity (no of E1 and km) 905 Leased fibre transmission - distribution and capacity (no of E1 and km)
x. Network performance
Code Data type
1000 TCH Congestion
1001 Call Drop rate 1002 Call Block Rate
1003 Success call rate by service (ASR)
1004 Number of faults on network. Distinguish between faults on the various networks e.g. fixed wire line, GSM network, CDMA network etc
xi. Rates and charges
Code Data type
1100 A list of charges and rates of all services offered by the licensee This should be regardless of whether these rates are for approval or not. Internet and leased lines prices should be included in this disclosure.
xii. Employment
Code Data type
1200 Total full time staff
1201 Number of expatriate staff
1202 Number of female permanent employees 1203 Number of male permanent employees
1204 Number of contract/semi permanent employees
xiii. Revenue
Code Data type
3 Appendix 2 – Quarterly Operational Requirements, NTO,
CTO and PIPs Standard Forms
Operator: Reporting period:
Uganda Communication Commision
I. Fixed Network Access and Coverage Data
100 Fixed telephone lines in operation by access technology 101 Fixed telephone lines in operation by residential / corporate
Fixed lines Copper CDMA Wimax Others Total
Residential
-Corporate
-Total - - - -
-102 Total capacity of fixed line switch
103 Number of main lines connected to digital exchanges 104 Number of lines connected to analogue exchanges if any 105 Switch capacity of the digital exchange
Exchanges Value
Total capacity of fixed line switch
Number of main lines connected to digital exchanges Number of lines connected to analogue exchanges if any Switch capacity of the digital exchange
106 Fixed line network Geographic coverage
Region Fixed lines
Kampala Central Eastern Northern Western Total
-107 Payphones number and regional distribution
County Payphones … … … … … … … … … … … … … … Total
-II. Fixed Network Traffic & Calls
Code Type Traffic (minutes) Calls
200
Outgoing - Fixed to own fixed network 201
Outgoing - Fixed to own mobile network 202
Outgoing - Fixed to off net fixed networks 203
Outgoing - Fixed to off net mobile networks 204
Outgoing - Fixed to East African networks 205
Outgoing - Fixed to the rest of the world networks 206
Outgoing - Fixed to Toll Free 207
Outgoing - Fixed to Premium numbers 208
Outgoing - Fixed to Emergency services 209
Outgoing - Dialup minutes n/a
210
Outgoing - International transit traffic n/a
211
Incoming - From other local fixed networks 212
Incoming - From other local mobile networks 213
Incoming - From international to fixed network (Excluding transit traffic) 214
Incoming - International transit traffic n/a
215
IP telephony traffic n/a
Total outgoing -
-Total incoming -
-Total -
-III. Mobile Network Subscribers
Code Type No subscribers Residential Corporate
300
Active mobile subscribers - Postpaid 301
Active mobile subscribers - Prepaid 302
Active mobile subscribers - Low and medium speed mobile networks if any 303
Active mobile subscribers - 3G (high speed) 304
Active mobile subscribers - 2.5G (GPRS & EDGE) 305
Active mobile subscribers - Voicemail
Total - -
-IV. Mobile Network Traffic & Calls
Code Type Traffic (minutes) Calls
400
Outgoing - Mobile to mobile own network 401
Outgoing - Mobile to fixed own network 402
Outgoing - Mobile to off-net fixed networks 403
Outgoing - Mobile to off-net mobile networks 404
Outgoing - Mobile to East African networks 405
Outgoing - Mobile to the rest of the world networks 406
Outgoing - Mobile to Toll Free 407
Outgoing - Mobile to Premium numbers 408
Outgoing - Mobile to Emergency services 409
Outgoing - International Transit n/a
410
Outgoing - Visiting roamers outbound traffic 411
Incoming - From other local mobile operators 412
Incoming - From other local fixed operators 413
Incoming - From international to own mobile network 414
Incoming - International transit n/a
415
Incoming - Visiting roamers inbound traffic 416
Roaming - Own subscribers in other networks n/a 417
IP telephony traffic
Total outgoing -
-Total incoming -
-V. Mobile data
Code Type Volume
500 Outgoing - SMS on-net 501 Outgoing - SMS off-net 502 Outgoing - SMS to international 503 Incoming - SMS off-net 504
Incoming - SMS from international
Total SMS -505 Outgoing - MMS on-net 506 Outgoing - MMS off-net 507 Outgoing - MMS to international 508 Incoming - MMS off-net 509
Incoming - MMS from international
Total MMS
-510
Number of SMS originated and terminated on a given PIP’s network through a given PSP
511
Number of outgoing SMS from a given NTO/CTO/PIP network terminating on another local network through the given PSP
512
VI. Internet access
600 Number of fixed internet subscribers by access technology and bandwidth 600a Residential Type <=64kbps 64-128kbps 128-192kbps 192-256kbps 256-512kbps >=512kbps ADSL CDMA Wimax VSAT Dial-up ISDN … … … Total 600b Corporate Type <=64kbps 64-128kbps 128-192kbps 192-256kbps 256-512kbps >=512kbps ADSL CDMA Wimax VSAT Dial-up ISDN … … … Total
601 Provide details of non speed based internet access usage e.g. capacity based pricing
………..
602 Distribution of wireless hotspots (location)
Distribution <=64kbps 64-128kbps 128-192kbps 192-256kbps 256-512kbps >=512kbps
603 Number and distribution (locations) of public internet access cafes served regardless of access speeds
Distribution No
604 Number and location (district) of educational institutions served with internet access regardless of access speeds
District No
605 Bandwidth
kbps 605a Total international uplink bandwidth
605b Total international downlink bandwidth 605c Total local bandwidth
606 Internet price list
Service name Bandwidth Unit price … <=64kbps … 64-128kbps … 128-192kbps … 192-256kbps … 256-512kbps … … … … … … 607 Internet usage (Mb) Type Volume (Mb) ADSL CDMA Wimax VSAT Dial-up ISDN … … …
VII. Leased lines
700 Retail leased lines price list – local ends (by distance and capacity)
Price list ...kbps ...kbps ...kbps ...kbps Distance …km …km …km …km
701 Retail leased lines price list – trunk (by distance and capacity)
Price list ...kbps ...kbps ...kbps ...kbps Distance …km …km …km …km
702 Wholesale leased lines price list – local ends (by distance and capacity)
Price list ...kbps ...kbps ...kbps ...kbps Distance …km …km …km …km
703 Wholesale leased lines price list – trunk (by distance and capacity)
Price list ...kbps ...kbps ...kbps ...kbps Distance …km …km …km …km
VIII. Billing and Complaints
Code Type Value
800
%age of postpaid accounts that have been billed in a month 801
Billing complaints as a % age of total bills issued 802
%age of billing complaints resolved within 5 days of receipt 803
%age of billing complaints resolved within 20 days of receipt of complaint 804
%age of billing complaints resolved within 30 days of receipt of complaint 805
Volume and number of non billing complaints received
-806
Number of non billing complaints resolved within 1 working day of receipt of complaint
807
Service activation/provisioning time 808
%age of service restoration requests fulfilled within 1 working day. Specify the various services.
809
IX. Network availability
900 BTS – number, type, distribution, capacity
Region No BTS Sites No BTS No Transceivers
Kampala Central Eastern Northern Western Total - - -901 BSC – number, capacity Region No BSC Max TRX Kampala Central Eastern Northern Western Total - -902 MSC – number, capacity
Region No MSC Max subscribers
Kampala Central Eastern Northern Western Total - -903 Other platforms
Region No platforms Max subscribers
SMS Voicemail SGSN GGSN … Total -
-904a Owned transmission – type and total capacity
Type No E1 Km fibre Capacity Mbps
Microwave n/a n/a
Fibre n/a
904b Owned microwave transmission – distribution and capacity (no of E1) No of E1 BTS-BSC BSC-MSC MSC-MSC Kampala Central Eastern Northern Western
904c Owned fibre transmission – distribution and capacity (no of E1 and km)
No of E1 BTS-BSC BSC-MSC MSC-MSC Kampala Central Eastern Northern Western No of km BTS-BSC BSC-MSC MSC-MSC Kampala Central Eastern Northern Western
905 Leased fibre transmission- distribution and capacity (no of E1 and km)
No of E1 BTS-BSC BSC-MSC MSC-MSC Kampala Central Eastern Northern Western No of km BTS-BSC BSC-MSC MSC-MSC Kampala Central Eastern Northern Western 906 Points of interconnection
No of POI Kampala Central Eastern Northern Western
Operator 1 Operator 2 Operator 3 Operator 4 Operator 5 Operator 6 Operator 7
X. Network performance 1000 TCH Congestion
TCH Congestion
1001 Call Drop rate
Call Drop rate
1002 Call Block Rate
Call Block Rate
1003 Success call rate by service (ASR)
%
Fixed services
200
Outgoing - Fixed to own fixed network 201
Outgoing - Fixed to own mobile network 202
Outgoing - Fixed to off net fixed networks 203
Outgoing - Fixed to off net mobile networks 204
Outgoing - Fixed to East African networks 205
Outgoing - Fixed to the rest of the world networks 206
Outgoing - Fixed to Toll Free 207
Outgoing - Fixed to Premium numbers 208
Outgoing - Fixed to Emergency services 211
Incoming - From other local fixed networks 212
Incoming - From other local mobile networks 213
Incoming - From international to fixed network (Excluding transit traffic)
Mobile services
400
Outgoing - Mobile to mobile own network 401
Outgoing - Mobile to fixed own network 402
Outgoing - Mobile to off-net fixed networks 403
Outgoing - Mobile to off-net mobile networks 404
Outgoing - Mobile to East African networks 405
Outgoing - Mobile to the rest of the world networks 406
Outgoing - Mobile to Toll Free 407
Outgoing - Mobile to Premium numbers 408
Outgoing - Mobile to Emergency services 410
Outgoing - Visiting roamers outbound traffic 411
Incoming - From other local mobile operators 412
Incoming - From other local fixed operators 413
Incoming - From international to own mobile network 415
Incoming - Visiting roamers inbound traffic
1004 Number of faults on network. Distinguish between faults on the various networks e.g. fixed wire line, GSM network, CDMA network etc
Network No of faults
Fixed wireline Fixed CDMA GSM
XI. Rates
XII. Employment
1200 Total full time staff 1201 Number of expatriate staff
1202 Number of female permanent employees 1203 Number of male permanent employees 1204 Number of contract/semi permanent employees
XIII. Revenue
1300 Revenue by service type
Service type Revenue ('000 Shs)
Retail services Fixed services
Connection and rental Calls (usage) Payphones Mobile services
Postpaid - Connection and rental Postpaid - Calls (usage) Prepaid - Connection Prepaid - Calls (usage) Mobile - roaming SMS Mobile internet Handsets SIM Cards Internet Leased lines Other retail services Total retail services Wholesale services Fixed termination
Fixed termination - local Fixed termination - international Mobile termination
Mobile termination - local Mobile termination - international Fixed origination
Mobile origination Transit
International access Infrastructure rentals
Transmission links rentals Site rentals
Wholesale leased lines Other wholesale services Total wholesale services
This document has been prepared for the intended recipients only. To the extent permitted by law, PricewaterhouseCoopers firms do not accept or assume any liability, responsibility or duty of care for any use of or reliance on this document by anyone, other than (i) the intended recipient to the extent agreed in the relevant contract for the matter to which this document relates (if any), or (ii) as expressly agreed by the relevant PricewaterhouseCoopers firm at its sole discretion in writing in advance.
© 2009 PricewaterhouseCoopers. All rights reserved. ‘PricewaterhouseCoopers’ refers to the network of member firms of PricewaterhouseCoopers International Limited, each of which is a separate and independent legal entity.