Additional Info

Field Value
Data last updated unknown
Metadata last updated unknown
Created unknown
Format text/csv
Licence OGL-UK-3.0

Data Dictionary

Column Title Type Description
PERIOD Year and Month as YYYYMM date Example: 201401
BNF_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
BNF_CODE British National Formulary (BNF) Name string The unique code used to refer to a BNF Presentation. For example, 0501013B0AAABAB.
HOSPITAL_TRUST_CODE The Hospital Trust's Organisation Data Service Code (ODS) string The Hospital Trust's Organisation Data Service Code (ODS), for example R1A. Look up files are provided and maintained by NHS Digital, for example see: Trusts under https://digital.nhs.uk/services/organisation-data-service/data-downloads/other-nhs-organisations.
HOSPITAL_TRUST The Hospital Trust's Organisation Name string An NHS Trust is a legal entity, set up by order of the Secretary of State under section 25 of, and Schedule 4 to, the National Health Service Act 2006, to provide goods and services for the purposes of the health service.
QUANTITY Quantity number The quantity of a medicine, dressing or appliance for which an individual item was prescribed and dispensed, for each BNF Presentation. This represents a pseudo pack size, to illustrate the typical range of prescribed quantities of a given presentation. For example, a quantity of 28 for Amoxicillin 500mg capsules means that the pack size dispensed was 28 capsules.
TOTAL_QUANTITY Total Quantity number 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.
TOTAL_ITEMS Total Items number The number of times a product appears on a prescription form. Prescription forms include both paper prescriptions and electronic messages.
TOTAL_ACTUAL_COST Total Actual Cost number The basic cost after adjustment for the national average discount and some payments to the dispenser. The calculation is: Net Ingredient Cost - National Average Discount Percentage + (payment for consumables + out of pocket expenses + payment for containers)
TOTAL_NIC Total Net Ingredient Cost (NIC) number In British Pounds Sterling (GBP). The amount paid using the basic price of the drug, appliance or medical device as stated in Part II Clause 8 of the Drug Tariff

Resources

License OGL-UK-3.0