‘I am looking to map the dispensing by Appliance contractors by CCG or ICS and I understand you do not hold this information, you do have where the Appliance Contractor is located and i have accessed this data from you site.
You do have the postcode of the prescriber who raised the prescription and the Dispensing Appliance Contractor who submitted it as well as the detail of the line items on the prescription both in volume and name of product by Sku (Line item). I understand the confidentiality concerns and I am only looking for the data at CCG or even ICS level not at postcode level but this would need to be mapped from postcode to CCG or ICS which I could do but with an agreement that the postcode level data is not used and is deleted once the mapping exercise has been done.
My request would be the following:
If I sent you a mapping of postcode to CCG could you do the exercise fro me or
We have an agreement inn place that I would delete the postcode data once the exercise has been done.
The data I would like included would be:
1. Number of packs dispensed
2. Contractor Total NIC by month, Individual sku’s dispensed by month with description, code and value (NIC) for each contractor code.
On 31 May 2022 you clarified the following: Can you provide me the following:
Monthly data for the period April 2020 to March 2022
Dispenser code (As attached)
BNF Code or product code
Total NIC value]’
On 20 June 2022 you further clarified as follows:
‘Yes, rather than Product code I mean Product order number at product level and pack level where available.
I do not require number of packs dispensed just the total NIC by product order code or pack level code.
A copy of the information is attached. Please read the below notes to ensure correct understanding of the data.
NHS Prescription Services process prescriptions for Pharmacy Contractors, Appliance Contractors, Dispensing Doctors and Personal Administration with information then used to make payments to pharmacists and appliance contractors in England for prescriptions dispensed in primary care settings (other arrangements are in place for making payments to Dispensing Doctors and Personal Administration). This involves processing over 1 billion prescription items and payments totalling over £9 billion each year. The information gathered from this process is then used to provide information on costs and trends in prescribing in England and Wales to over 25,000 registered NHS and Department of Health and Social Care users.
The data source was the NHSBSA Information Services Data Warehouse.
The Data excludes:
• Items not dispensed, disallowed and those returned to the contractor for further clarification.
• Prescriptions prescribed and dispensed in Prisons, Hospitals and Private prescriptions.
• Items prescribed but not presented for dispensing or not submitted to NHS Prescription Services by the dispenser.
Please note drugs flagged in our database as Schedule 2 and 3 controlled drugs have been excluded from this dataset for information security reasons to prevent the identification of organisations with high levels of controlled drug dispensing.
April 2020 to March 2022
The data is split into two separate csvs by financial year
No limits are placed on prescribing practice. The symbol (-) is used for dummy practices (for example unidentified doctors or Scottish doctors)
These are the codes supplied as part of your request
The 11 characters at the beginning of a BNF code which specifies a Product (generic or branded) but not its strength or formulation.
PRODUCT_ORDER_NUMBER and PACK_ORDER_NUMBER
If this is not held in our database then it will be blank.
The cost of the supplied item(s) calculated from the reimbursement price held on the NHSBSA master database. Given in Pounds Sterling.
If you have any queries regarding the data provided, or if you plan on publishing the data please contact email@example.com ensuring you quote the above reference. This is important to ensure that the figures are not misunderstood or misrepresented.
If you plan on producing a press or broadcast story based upon the data please contact firstname.lastname@example.org. This is important to ensure that the figures are not misunderstood or misrepresented.
Failure to do so is a breach of the terms of the licence.
Information you receive which is not subject to NHSBSA Copyright continues to be protected by the copyright of the person, or organisation, from which the information originated. Please obtain their permission before reproducing any third party (non NHSBSA Copyright) information.