Hospital Prescribing Data Extract

From April 2013, prescribing data by Hospital will be made available at presentation level. The information is obtained from our prescribing and dispensing information systems.

The data covers prescriptions that are prescribed in Wales through Hospitals that are then dispensed in the community within Wales or England. The data includes all prescribed medicines, dressings and appliances that are dispensed each month. If a patient does not take a prescription to the pharmacy for dispensing, then the information will not be included in the dataset.

The data does not include private prescriptions.

Data will be published on the 1st working day of each month and will be available for the current and two complete financial years. Each compressed file will contain three individual files which can be viewed in applications such as Microsoft WordPad and Excel.

Prescribing data requires careful interpretation and should not be used in isolation.

Each month a compressed file containing three files will be available to download.

HospitalDataFileCCYYMM

This is the main data file containing every item prescribed and dispensed at presentation level. The BNF class (15 characters) is included.

ChemSubstance

This provides the chemical substance using the first 9 characters of the BNF code included in the main GP data file.

Address File

This file will provide the name and address of each Hospital.

This data is available for use and re-use under the Open Government Licence (OGL). Please ensure that you understand the terms of the OGL before using our data.

Please refer to the documents below for information on the individual files.

*from May 2017, the format of the Address file has been slightly amended to ensure the hospital name appears correctly.

FAQs

How do I contact you?

You can contact us by phone, email or post. Visit our Contact Us page for further information

Why have we moved to automated prescription processing?

Automated processing allows us to improve the accuracy of reimbursement to contractors by reducing the potential for human error. Our accuracy rate has improved from 99.15% to 99.54% since the introduction of automated processing.

It also improves our efficiency, making a significant contribution to: -

Our ability to continue to reimburse contractors in accordance with SLA timescales in the face of ever increasing prescription volumes
Our ability to release funds to be reinvested in front line NHS services. We process 47% more prescription items with 53% fewer staff since the inception of our automation programme.

Medicines Use Review & Prescription Interventions - what is the difference?

A number of queries have been raised by pharmacists regarding the differentiation between MURs and prescription intervention MURs. To clarify the matter Welsh Government has confirmed that there is only one service (i.e. the MUR service) but the service may be prompted in different ways.

Regular MURs can be prompted pro-actively by identification of a certain group of patients that subsequently lead to an invitation for a Medicines Use Review.

A prescription intervention MUR is more reactive, in the sense that it is the response to a significant adherence problem with a person's medication that subsequently leads to an MUR being conducted. This is distinct from pharmacists making clinical interventions on prescriptions (e.g. where an interaction is identified and there is a need to get a prescription amended) which are required by the terms of service for all pharmacy contractors.

Get in Touch

If you have a query for our Primary Care Services. Please contact us below: