| 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
|
| YEAR_MONTH |
Test |
integer |
-
|
| COMMISSIONER_CODE |
Test |
string |
-
|
| COMMISSIONER_NAME |
Test |
string |
Test
|
| CONTRACT_NUMBER |
|
integer |
-
|
| PROVIDER_NAME |
|
string |
-
|
| LATEST_PPC_ADDRESS_POSTCODE |
|
string |
-
|
| LSOA11_CODE |
|
string |
-
|
| UDA_PERF_TARGET |
|
string |
-
|
| UDA_FIN_VAL |
|
string |
-
|
| UDA_DELIVERED |
|
string |
-
|
| LATE_SUBMITTED_FP17 |
|
string |
-
|
| UDA_DELIVERED_FD |
|
string |
-
|
| BAND_1_DELIVERED |
|
string |
-
|
| BAND_2A_DELIVERED |
|
string |
-
|
| BAND_2B_DELIVERED |
|
string |
-
|
| BAND_2C_DELIVERED |
|
string |
-
|
| BAND_3_DELIVERED |
|
string |
-
|
| BAND_URGENT_DELIVERED |
|
string |
-
|
| BAND_OTHER_DELIVERED |
|
string |
-
|
| CHILD_12M_COUNT |
|
string |
-
|
| ADULT_24M_COUNT |
|
string |
-
|
| GENERAL_DENTAL_FIN_VALUE |
|
string |
-
|