Additional Info

Field Value
Data last updated unknown
Metadata last updated unknown
Created unknown
Format text/csv
Licence UK Open Government Licence (OGL)

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.

SICBL_CODE SICBL Code string

SICBL code is the unique identifying code attributed to a Sub-ICB Location (SICBL).

CHEMCIAL_SUBSTANCE_CODE BNF Chemical Substance Code string

The first nine digits of the 15-digit BNF Code, which indicate the chemical substance under which the drug or appliance is categorised.

CHEMICAL_SUBSTANCE BNF Chemical Substance string

This is the International Non-proprietary Name (INN) and is the standard registered name for the active constituent of that medicine, for example omeprazole. For compounds the name may be more complex, such as co-magaldrox magnesium/aluminium hydrox). In some cases the name is a collective one for a range of medicines, such as alginic acid compound preparations. For prescriptions in BNF chapters 19 to 23, there is no "chemical" name, as these are dressings and appliances. Therefore, these items are reported under the BNF section name, for example, night drainage bags.

GENDER Gender string

Patient gender has been reported using the latest patient gender information held by the NHSBSA Information Services data warehouse at the time that the data was extracted. This uses information from either the most recent Electronic Prescription Service (EPS) message or from the last time that NHSBSA received data about the patient's gender from NHS Personal Demographics Service. Gender is either: Male, Female, Not Known (where no information is held) or Indeterminate (where information is held which does not confirm either Male or Female).

AGE_BAND Age Band string

Indicates the age band for identifiable patients. If a patient's age has not been able to be verified, the age band will be indicated as unknown.

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.

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)

ITEM_COUNT Items number

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