Skip to main content Skip to footer

ISP report information

Detailed Prescribing Information (DPI) decommissioned

The prescribing data will now only be available as the English Prescribing Dataset (EPD) available through our Open Data Portal.

One Drug Database (ODD) has been implemented - ​​​​ You can read more about the implementation and how this affects our systems and reports.

You can find out what’s included in each report category and any notes about how the data has been produced, for example, what is and what is not included in the data.

Common information reports

These reports are freely available to the general public.

Prescribing data

Dispensing data

Organisation data

Data download - Now available through Open Data Portal

The data download Detailed Prescribing Information has moved to the Open Data Portal 

English Prescribing Data (EPD) has now replaced the Detailed Prescribing Information and data is available from January 2014 to current within the Open Data Portal.

Important Notice

Detailed Prescribing Information (DPI) – is being decommissioned

The Detailed Prescribing Information (DPI) dataset January 2021 published in March 2021 will be the final dataset to be published via ISP.

Data Download enables you to further manipulate data using a programme of your choice. You can access Data Download on the Information Services Portal.

Our user guide (Word: 414KB) gives details on how to use the Data Download facility. There is also data specification information (Word: 327 KB) available.

When downloading information, standard spreadsheet applications may not be able to handle the volumes of data contained in the monthly data sets. 

 File type

 Approx. download size (zip)

 Approx. uncompressed .csv


 450 MB

 3.5 GB

 Regional Office

 125 MB

 1 GB


 20 MB

 150 MB


 3.5 MB

 25 MB


 100 KB 

 900 KB

If you're downloading large volumes of data, for example, National, Regional Office and some Area Teams, you may need to use a bespoke IT solution or an add-on able to handle larger data sets, for example, the Microsoft PowerPivot add-on for Excel.              

Using Microsoft PowerPivot

The PowerPivot add-on is available from Microsoft.

Once PowerPivot has been installed, to load large files, follow these instructions:

1. Start Excel as normal
2. Click on the PowerPivot tab  
3. Click on the PowerPivot window icon (top left)
4. In the PowerPivot window, click on the 'from other sources' icon
5. In the table import wizard, for example, scroll to the bottom and select 'text file'
6. Browse to the file you want to open and choose the file extension you require, for example '.csv'

Once the data has been imported, you can view it as a table or view and manipulate it as a graph.

Other add-ons are available and you should use whichever add-on or bespoke solution best meets your needs. 


Detailed prescribing information is updated on a monthly basis providing information on a practice’s / cost centre prescribing habits and costs.

The extract includes prescribing data attached to a commissioner/provider and includes unidentified prescribers where we have been able to identify a commissioner/provider.

The data is based on items prescribed on NHS prescriptions that were dispensed in the community, this includes items prescribed in England.

English prescribing data includes items dispensed in England, Scotland, Wales and the Isle of Man.

The data does not include:

  • items where a prescription was issued, but not presented for dispensing or not submitted to NHS Prescription Services by the dispenser
  • items prescribed in Wales, Scotland or Northern Ireland but dispensed in England
  • items prescribed by dentists
  • items prescribed on FP10HP forms by hospitals which are not attributed to a practice/cost centre on our database                                                                       

Items - shows the number of times a product appears on a prescription form, for each unique quantity prescribed.

Quantity - shows the quantity for each of these prescribed items.

For example, in the data below, Amlodipine 10mg tablets have been prescribed once with a quantity of 28 and 4 times with a quantity of 7. In this case, the total number of items is 5, and the total quantity prescribed (quantity * items) is 56.

 BNF Description



  Amlodipine_Tab 10mg



 Amlodipine_Tab 10mg



Net Ingredient cost (NIC) - is the basic price of a drug as stated in Part II, Clause 8 of the Drug Tariff.

Actual Cost - is the basic price of the drug, less the national average discount percentage (NADP), plus Payment for Consumables (previously known container allowance), Out of Pocket Expenses and Payment for Containers (10p for splitting packs). The calculation for the discount amount is the basic price multiplied by the NADP. Actual Cost only relates to England.

ADQ (Average Daily Quantity) - is a measure of prescribing volume based on prescribing behaviour in England. It represents the assumed average maintenance dose per day for a drug used for its main indication in adults. The ADQ is not a recommended dose but an analytical unit to compare prescribing activity. ADQs are reviewed on a regular basis, to reflect any changes in drug use and to include new drugs.

Patient list size data - is updated when a new month’s data is uploaded. The data does not include temporary resident band.

BNF code information - is updated on an annual basis.

The BNF Code is a 15 digit code in which the first 7 digits are allocated according to the categories in the BNF and the last 8 digits represent the medicinal product, form, strength and the link to the generic equivalent product. NHS Prescription Services has created pseudo BNF chapters, which are not published, for items not included in BNF chapters 1 to 15. The majority of such items are dressings and appliances which NHS Prescription Services has classified into the four pseudo BNF chapters 20 - 23.

NB - If a product is a generic product produced by a specific manufacturer, this item is not allocated a BNF code but is assigned a seven-digit 'PPA code'. This is an internal code used to link this product back to the BNF code of the generic product.

Information included in Data Download

Detailed Prescribing Information - provides information on a practice/cost centre’s prescribing habits and costs. The extract includes data for prescriptions which are directly attached to a commissioner/provider.  

Detailed Prescribing Information download data source has changed and the extract is now taken from our Information Services data warehouse there are some subtle changes to the data.

For further information view our guide to the differences (Word: 248KB).

BNF Code Information - allows a user to select from the latest 3 versions of BNF updates.

Patient List Size Information - provides the details of patient list sizes for all practices at the required organisation level. Patient list information can not be downloaded at National Level. To get a national data set download 5 regions.


Guide to differences (Word: 248KB)Information Services Portal user guideGlossary of terms (Excel: 28KB) Electronic Drug Tariff

If you have any queries you can contact the Information Services team on 0191 203 5050 or email us at

Find out about call charges.

Home oxygen therapy - CCG

The Home Oxygen Therapy report is accessed via the Information Services Portal.

These reports are only available to users who have been authorised to view Home Oxygen Reports by their respective Organisations.

The system holds 24 months of data which is updated on a monthly basis. 


Home oxygen therapy payments are made the month following supply. 

What is included in the Home Oxygen Therapy Reports?

CCG Payment Claim - Allow CCGs/Regions to monitor the payments made to the oxygen suppliers for patients registered in their CCG/region. 

This report is split into three data views

  • CCG Payment Claim Summary
  • CCG Payment Claim - In Area Supply
  • CCG Payment Claim - Out of Area Supply

This report will detail the Claim to CCGs for the oxygen supplied by their home regions as well as any out of area Supply


Information Services Portal user guidesGlossary of terms (Excel: 28KB) Frequently Asked Questions (Word:439KB)

If you have any queries you can contact the Information Services team on 0191 203 5050 or email us at

Find out about call charges.

Home Oxygen Therapy Reports

Home Oxygen Therapy Adjustment Notification Form

This form should only be used to make adjustments to payments claimed by the supplier who has the contract for your CCG area.

The form should clearly state the Supplier Name and Address, the region, CCG name and CCG code. 
Please indicate if the amount is to be PAID to the supplier or DEDUCTED from the supplier. 
All amounts stated should be excluding VAT.

The form should be signed by an authorised signatory. If you are unsure who the signatories for Home Oxygen Therapy Adjustments are for your organisation please contact the Customer Payment Team on 0191 244 6488.

Find out about call charges.

The Home Oxygen Therapy Adjustment Form is available in both PDF and Word format and can be downloaded below:

Adjustment Form (Word: 234KB)Adjustment Form (PDF: 117KB)

Home Oxygen Therapy Out of Area Adjustment Notification Form

This form should only be used to make adjustments to payments that have been claimed by suppliers for Home Oxygen Therapy supplied to patients when they have been out of the CCG area.

The form should clearly state the

  • Supplier name and address
  • Region
  • CCG name
  • CCG code.

Please indicate if the amount is to be PAID to the supplier or DEDUCTED from the supplier. All amounts stated should be excluding VAT.

The form should be signed by an authorised signatory. If you are unsure who the signatories for Home Oxygen Therapy Adjustments are for your organisation please contact the Customer Payment Team on 0191 244 6488.

Find out about call charges.

Please note that the forms are designed to accommodate up to four adjustments on one notification, please ensure that the values are totalled correctly. Where possible complete each notification in full rather than submit multiple notifications with one value on each, please retain a copy of the authorised notification for your records.

The forms are accepted by fax or post, in order to reduce the risk of processing twice there is no requirement to post originals after they have been faxed. NHS Prescription Services processes the payment however, there is no payment monitoring performed by NHS Prescription Services.

If you require confirmation that the adjustments have been processed, the CCG can check the reports on the system, where an adjustment is received towards the end of a month, it may not be processed until the following month.

Out of Area Adjustment Form (Word: 251KB)Out of Area Adjustment Form (PDF: 195KB)

Management Information Spreadsheet (MIS) report

Access to this report is restricted to authorised users only.

This report consists of a management information file detailing monthly Community Pharmacy and Appliance Payments by type of payment and contractor account. Payments include all drug costs, fees, patient charges, locally authorised payments, etc. Other details such as the numbers of items dispensed, patients charges collected are also included.

The management information files reflect the contractor's payment and prescription data associated with the STP structure at the relevant payment date.

This information is provided to fulfil a number of requirements including:-

  • Pharmacy and appliance contractor payment monitoring 
  • Contract management 
  • Reconciling payments 
  • Audit 
  • Fraud prevention 

NHSBSA has enhanced the support it currently offers to NHS England regional teams to manage the performance of pharmacy contracts by providing enriched information, analysis and insight on contractor payment and prescription data.

MIS Glossary (Excel: 71KB)LPC Levy Calculation From Mar 2020 Prescriptions (Excel: 36KB)LPC Levy Calculation Prior to December 2016 Prescriptions (Excel: 31KB)Guidelines to help answer some common queries (Word:31KB)