Prescription Cost Analysis (PCA) - Financial Year 2020/21

This resource view is not available at the moment. Click here for more information.

Download resource

Additional Info

Field Value
Data last updated June 8, 2021
Metadata last updated June 8, 2021
Created June 8, 2021
Format text/csv
License Open Government Licence 2.0 (United Kingdom)

Data Dictionary

Column Title Type Description
YEAR_DESC Year description string

The financial year or calendar year the data relates to. In the format YYYY/YYYY for financial year or YYYY for calendar year.

REGION_NAME Regional Office Name string

The name given to a geographical region by NHS England. Each region supports local systems to provide more joined up and care for patients.

REGION_CODE Regional Office Code string

The unique code used to refer to a Regional Office.

STP_NAME Sustainability and Transformation Partnership (STP) Name string

The name given to a geographical area by NHS England that is a smaller division of a Region.

STP_CODE Sustainability and Transformation Partnership (STP) Code string

The unique code used to refer to an STP.

BNF_PRESENTATION_CODE British National Formulary (BNF) Code string

The unique code used to refer to a BNF Presentation. For example, 0501013B0AAABAB.

BNF_PRESENTATION_NAME British National Formulary (BNF) Name string

The name given to the specific type, strength, and formulation of a drug. Or the specific type of an appliance. For example, Amoxicillin 500mg capsules.

SNOMED_CODE Presentation SNOMED Code string

SNOMED CT (Systemised Nomenclature of Medicine Clinical Terms) is a clinical vocabulary readable by computers. The SNOMED code contained within the data is a unique identifier for each Medicinal Product (both VMP and AMP level). The identifier will not be re-used and or allocated to another presentation.

SUPPLIER_NAME Supplier Name string

The manufacturer, supplier, or wholesaler of the AMP. For example, Teva UK Ltd.

UNIT_OF_MEASURE Unit of Measure string

The pharmaceutical form or unit that is used to measure a single unit of quantity of the given presentation. For example, tablet.

GENERIC_BNF_EQUIVALENT_CODE Generic Equivalent BNF Code string

The unique code used to refer to the generic equivalent of the BNF Presentation.

GENERIC_BNF_EQUIVALENT_NAME Generic Equivalent BNF Name string

The name given to the generic equivalent BNF Presentation.

BNF_CHEMICAL_SUBSTANCE_CODE BNF Chemical Substance Code string

A unique code used to refer to a BNF Chemical Substance. For example, 0501013B0.

BNF_CHEMICAL_SUBSTANCE BNF Chemical Substance Name string

The name of the main active ingredient in a drug or the type of an appliance. Determined by the British National Formulary (BNF) for drugs, or the NHS BSA for appliances. For example, Amoxicillin.

BNF_PARAGRAPH_CODE BNF Paragraph Code string

The unique code used to refer to the British National Formulary (BNF) paragraph.

BNF_PARAGRAPH BNF Paragraph Name string

The name given to the British National Formulary (BNF) paragraph. This level of grouping of the BNF Therapeutical classification system sits below BNF section.

BNF_SECTION_CODE BNF Section Code string

The unique code used to refer to the British National Formulary (BNF) section.

BNF_SECTION BNF Section Name string

The name given to a British National Formulary (BNF) section. This is the next broadest grouping of the BNF therapeutical classification system after chapter.

BNF_CHAPTER_CODE BNF Chapter Code string

The unique code used to refer to the British National Formulary (BNF) chapter.

BNF_CHAPTER BNF Chapter Name string

The name given to a British National Formulary (BNF) chapter. This is the broadest grouping of the BNF therapeutical classification system.

PREP_CLASS Preparation Class string

The NHSBSA specifies and maintains the preparation classes of drugs, appliances, and medical devices to more easily distinguish between generic, proprietary, and appliance products.

PRESCRIBED_PREP_CLASS Prescribed Preparation Class string

The preparation class of the prescribed presentation. Can be used to determine if an item was prescribed generically.

ITEMS Items integer

The number of times a product appears on a prescription form. Prescription forms include both paper prescriptions and electronic messages.

TOTAL_QUANTITY Total Quantity integer

The total quantity of a drug or appliance that was prescribed. This is calculated by multiplying the prescribed Quantity by Items. For example, if 2 items of Amoxicillin 500mg capsules with a Quantity of 28 were prescribed, Total Quantity will be 56.

NIC Net Ingredient Cost (NIC) number

In British Pounds Sterling (GBP). The amount that would be paid using the basic price of the prescribed drug or appliance and the quantity prescribed. Sometimes called the 'Net Ingredient Cost' (NIC). The basic price is given either in the Drug Tariff or is determined from prices published by manufacturers, wholesalers or suppliers. Basic price is set out in Parts VIII and IX of the Drug Tariff. For any drugs or appliances not in Part VIII, the price is usually taken from the manufacturer, wholesaler or supplier of the product.

NIC_PER_ITEM Cost per Item number

The average cost per item for a presentation. Calculated by dividing NIC by ITEMS.

NIC_PER_QUANTITY Cost per Quantity (Unit Cost) number

The average cost per quantity, or unit cost, for a presentation. Calculated by dividing NIC by TOTAL_QUANTITY.

QUANTITY_PER_ITEM Quantity per Item integer

The average quantity per item for a presentation. Calculated by dividing TOTAL_QUANTITY by ITEMS.