Wholesale Calls Product Handbook v4.1
British Telecommunications plc Page 40 of 47
March 2009
9. SERVICE PROVIDER HIGH USAGE REPORTS
The SPHUR (Service Provider High Usage Reports) service allows access to a “High
Roller” reporting system that will enable CPs to identify potential fraud risks, threats
and bad debt. This enables Communications Providers to take positive action to
reduce potential revenue loss. The service is suitable for CPs with a daily CDR
volume of c. 750k.
SPHUR facilitates the analysis of end user call data records (CDRs) to:
• Identify highest usage CLIs (by volume, cost or duration)
• Investigate call traffic for any CLI
• Drill down to individual calls
• Provide daily and *cumulative periodic summary of call spend
CDRs are categorised by the following call types:
• Premium Rate
• International
• Mobile
• Miscellaneous
* Typically, CPs can expect to obtain up to 90 days cumulative call spend.
The TV Quiz Alerts included with the SPHUR service will allow CPs to monitor and
take action in near real time, end user TV Quiz call traffic. Calls made to ”TV Quiz”
Premium Rate Service (PRS) numbers (as identified and managed by BT) will be
‘monitored’ and every time 30 calls are made from a specific CLI, an email alert will
be sent to the CP’s mailbox. During the ‘early hours’ this can be approx 30 minutes
after the 30
th
call. This will vary at other times of the day.
In addition to the basic SPHUR package, CPs may subscribe to a number of
additional modules.
The Express Data Feed will, in addition to the daily report, provide access to
Pseudo-rated CDR reports that will allow visibility of end user calls at least 12 hours
earlier than the Daily Priced data, thereby allowing analysis of call traffic by the CP in
a more timely fashion. This data feed does not contain Operator Assistance,
Transfer Charge and Text Direct calls. CPs who subscribe to the Express Data Feed
service must also subscribe to the basic SPHUR package.
The CSV Extract Files module will provide CPs with an Automated FTP file giving a
(cumulative daily summary) High Usage Report of their customers Pseudo Rated
calls each time a ‘4 hourly’ file is produced. Each file is limited to the CP’s ‘top’
10,000 customers. This file is offered as an option for the CP who wishes to
integrate these files into their own systems. CPs who subscribe to the CSV Extract
Files module must also subscribe to the Express Data Feed module.
SPHUR is a web based application and can therefore be accessed over ADSL or any
other Internet connection. Access is via BT’s iDesk and CPs will be required to sign
an IT Legal Agreement prior to access to this facility. Support is available Monday-
