Additional Info

Field Value
Data last updated unknown
Metadata last updated unknown
Created unknown
Format text/csv
License Open Data Commons Open Database License (ODbL)

Data Dictionary

Column Title Type Description
YEAR_MONTH Year and Month number

The year and month for which the claim for dispensed items has been submitted to NHSBSA in the format YYYYMM.

PRACTICE_CODE Practice Code string

The ODS code of the organisation which is at the level of Practice/ Cost Centre within the Prescriptions master data hierarchies.

DISPENSER_CODE Dispenser Code string

Dispenser code is the unique identifying code attributed to a dispensing organisation.

BNF_CODE BNF Code integer

The BNF Code is a 15-digit code in which the first seven 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 four pseudo BNF chapters (20 to 23).

PRODUCT_ORDER_NUMBER Product Order Number string

The product order number as held in the NHS dictionary of medicines and devices (dm+d)

PACK_ORDER_NUMBER Pack Order Number string

The pack order number as held in the NHS dictionary of medicines and devices (dm+d)

SNOMED_CONCEPT_ID SNOMED Concept ID string

"SNOMED CT is an internationally recognised coding system for electronic health records, which enables information to be shared between clinical systems in an easy, secure and accurate manner. SNOMED CT contains clinical terms for all aspects of NHS activity, from procedures and symptoms, through to clinical measurements, diagnoses and medications."

VMP_VMPP_AMP_AMPP Product/Pack Flag string

VMP / VMPP / AMP / AMPP indicates if the row of data relates to a virtual (VMP) or actual (AMP) product. With VMP and AMP at presentation level and VMPP and AMPP being at pack level.

NIC_GBP Net Ingredient Cost (NIC (£)) number

Net Ingredient cost (NIC) is the basic price of a drug as stated in Part II Clause 8 of the Drug Tariff but please note that where a price concession for items listed in Part VIII of the Drug Tariff has been agreed between the Department of Health and Social Care (DHSC) and the Pharmaceutical Services Negotiating Committee the NIC will reflect the concession price rather than the Drug Tariff price. NIC is given in Pounds Sterling.

ITEMS Items number

Items shows the number of times a product appears on a prescription form not the quantity prescribed.

TOTAL_QUANTITY Total Quantity number

Total quantity is the number of items multiplied by the quantity prescribed. e.g. 2 items prescribed, one with a quantity of 2 and one with a quantity of 3, the total quantity would show as 5 (1 item x quantity of 2) + (1 item x quantity of 3)

EPD_FLAG EPD Flag string

When this says 'EPD' the data is included in the English Prescribing dataset on our open data portal. This means the prescriptions were prescribed in England by GP practices/cost centres, dispensed in England, Jersey, Guernsey/Alderney, IOM, Wales, Scotland.

DISPENSER_ACCOUNT_TYPE Dispenser Account Type string

Categorises the dispensing contractor according to country and type of contractor.

BNF_APPLIANCE_FLAG BNF Appliance Flag string

Indicates if the presentation is categorised in the BNF chapters 20-23.

EPD_BNF_20_21_22 EPD BNF 20 21 22 string

Indicates that the prescription is included in the English Prescribing dataset and the presentation is categorised in the BNF chapters 20-22.

EPD_BNF_23 EPD BNF 23 string

Indicates that the prescription is included in the English Prescribing dataset and the presentation is categorised in the BNF chapter 23.

ENG_PRESC_BNF20_23 ENG Presc BNF 23 string

Indicates the prescription was prescribed in England, and the presentation is categorised in the BNF chapters 20-23. This is not limited by the type of prescribing organisation or the dispensing location.