Skip to content
Return to search

Prescribing Information System (PIS)

Description

The Prescribing Information System (PIS) is the definitive data source for all prescribing relating to all medicines and their costs that are prescribed and dispensed in the community in Scotland.

Related tags

Technical information

A JSON file is available with further technical information. This can include details of variables and data classes contained in the dataset.

Preview of JSON file

[{"id": "", "description": "BNF codes in PIS are a coding/classification system developed by NHS England and based around the document numbering system of the BNF and extended to give unique codes down to preparation level. \ne.g. BNF item code 0601011A0BBADAC \n \nChapter 6: Endocrine System \nSection 1: Drugs used in diabetes \nSubsection 1: Insulins \nParagraph 1: Short-acting insulins \nUnique code: In this case gives the information that this is insulin aspart, Novorapid\u00ae Flexpen\u00ae, prefilled disposable injection device, 100 units/ml, 3mls \nThe BNF hierarchy in use is based upon the BNF edition published in the preceding September.  Codes are updated in line with that but codes/hierarchies that no longer appear in the published BNF are retained in the BNF classification that we use.  In addition, the hierarchy is built into the code and so, where there are a large number of drugs and preparations within a particular area of the hierarchy, there can be too many to be coded into that hierarchy.  In these cases, additional codes and hierarchies not actually present in the published BNF can be created. Items found in the appendices of the BNF (e.g. nutritional supplements) will usually appear in additional chapters created in the BNF hierarchy.", "name": "BNF - British National Formulary Drug Codes", "dataElementsCount": 11, "dataElements": [{"id": "", "description": "Item description, detailing the chemical substance", "name": "BNF Root Drug Description", "type": "PrimitiveType"}, {"id": "", "description": "The chapter in which the item appears", "name": "BNF Chapter Description", "type": "PrimitiveType"}, {"id": "", "description": "The section in which the item appears", "name": "BNF Section Description", "type": "PrimitiveType"}, {"id": "", "description": "The paragraph in which the item appears can be used to derive BNF chapter, section and subsection", "name": "BNF Paragraph Code", "type": "PrimitiveType"}, {"id": "", "description": "The sub-section in which the item appears", "name": "BNF Sub Section Description", "type": "PrimitiveType"}, {"id": "", "description": "A 15 digit code. 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", "name": "BNF Item Code", "type": "PrimitiveType"}, {"id": "", "description": "The sub-section in which the item appears", "name": "BNF Sub Section Code", "type": "PrimitiveType"}, {"id": "", "description": "Item description, detailing the product name, formulation and strength", "name": "BNF Item Description", "type": "PrimitiveType"}, {"id": "", "description": "The section in which the item appears", "name": "BNF Section Code", "type": "PrimitiveType"}, {"id": "", "description": "The paragraph in which the item appears", "name": "BNF Paragraph Description", "type": "PrimitiveType"}, {"id": "", "description": "The chapter in which the item appears", "name": "BNF Chapter Code", "type": "PrimitiveType"}]}, {"id": "", "description": "Details relating to the location where the dispensing took place", "name": "Dispenser Location", "dataElementsCount": 2, "dataElements": [{"id": "", "description": "Unique code of the organisation where the dispensing took place. If this cannot be released due to Information Governance (IG) constraints, and anonymised version can be created. If the nonanonymised version is released, information relating to Community Pharmacies can be matched on from the list published by the Practitioner Services Division.", "name": "Dispenser Location Code", "type": "PrimitiveType"}, {"id": "", "description": "Code representing the type of organisation where the dispensing took place e.g. CP = Community Pharmacy, DD = Dispensing Doctor. Description to match the code can be provided as metadata.", "name": "Dispenser Location Type", "type": "PrimitiveType"}]}, {"id": "", "description": "Exemption types associated with prescription form", "name": "Exemption Type", "dataElementsCount": 3, "dataElements": [{"id": "", "description": "Exemption Type Description captured from back of prescription form. Incomplete after the abolition of prescription charges (April 2011). Please note while more than one exemption category may apply/have been ticked on the form, only one will be recorded here. Also, the exemption category applies to the form, so where a form had more than one item, the recorded exemption category may not apply to all items on the form e.g. \ncontraceptive (exempt) and two other items on the form", "name": "Exemption Type Description", "type": "PrimitiveType"}, {"id": "", "description": "Exemption category as listed on the back of a prescription form. Incomplete after the abolition of prescription charges (April 2011). Please note while more than one exemption category may apply/have been ticked on the form, only one will be recorded here. Also, the exemption category applies to the form, so where a form had more than one item, the recorded exemption category may not apply to all items on the form e.g. \ncontraceptive (exempt) and two other items on the form", "name": "Exemption Identifier", "type": "PrimitiveType"}, {"id": "", "description": "Exemption code captured from back of prescription form. Incomplete after the abolition of prescription charges (April 2011). Please note while more than one exemption category may apply/have been ticked on the form, only one will be recorded here. Also, the exemption category applies to the form, so where a form had more than one item, the recorded exemption category may not apply to all items on the form e.g. \ncontraceptive (exempt) and two other items on the form", "name": "Exemption Type Code", "type": "PrimitiveType"}]}, {"id": "", "description": "Prescription form types", "name": "Form Type", "dataElementsCount": 2, "dataElements": [{"id": "", "description": "Unique Form Type description \u2013 description to match the code above.", "name": "Form Type Description", "type": "PrimitiveType"}, {"id": "", "description": "Unique Form Type code e.g. GP10 = GP standard prescription form, GP10N = Nurse prescription form, GP14 = Dentist prescription form", "name": "Form Type Code", "type": "PrimitiveType"}]}, {"id": "", "description": "See ISD website for further details of the different geographical or organisational areas and codes. \n\nPlease select the geographical details below, and indicate which location you would like them in relation to: \n\u2022\tLocation in which the prescribing took place \n\u2022\tLocation in which the dispensing took place \n\u2022\tThe patient\u2019s home residence - geography details relating to the home address of the patient are \u2018time stamped\u2019 so that the relevant address information can be applied to the prescribing or dispensing activity of interest", "name": "Geography", "dataElementsCount": 17, "dataElements": [{"id": "", "description": "Council Area Code", "name": "Council Area Code", "type": "PrimitiveType"}, {"id": "", "description": "The more detailed fields can be used to derive the less detailed. If possible please only select one option to reduce file size.", "name": "Postcode District", "type": "PrimitiveType"}, {"id": "", "description": "Scottish Constituency", "name": "Scottish Constituency", "type": "PrimitiveType"}, {"id": "", "description": "The more detailed fields can be used to derive the less detailed. If possible please only select one option to reduce file size.", "name": "Postcode Area", "type": "PrimitiveType"}, {"id": "", "description": "Postcode", "name": "Postcode", "type": "PrimitiveType"}, {"id": "", "description": "Scottish Constituency Description", "name": "Scottish Constituency Description", "type": "PrimitiveType"}, {"id": "", "description": "Electoral Ward", "name": "Electoral Ward", "type": "PrimitiveType"}, {"id": "", "description": "Electoral Ward Description", "name": "Electoral Ward Description", "type": "PrimitiveType"}, {"id": "", "description": "UK Constituency", "name": "UK Constituency", "type": "PrimitiveType"}, {"id": "", "description": "Council Area Description", "name": "Council Area Description", "type": "PrimitiveType"}, {"id": "", "description": "Local Government District Description", "name": "Local Government District Description", "type": "PrimitiveType"}, {"id": "", "description": "The more detailed fields can be used to derive the less detailed. If possible please only select one option to reduce file size.", "name": "Postcode Sector", "type": "PrimitiveType"}, {"id": "", "description": "Please specify whether you would like the 2, 3, 6 or 8-fold classification and which release you would prefer (2013/14, 2011/12 etc.)", "name": "Urban Rural Description", "type": "PrimitiveType"}, {"id": "", "description": "Please specify whether you would like the 2, 3, 6 or 8-fold classification and which release you would prefer (2013/14, 2011/12 etc.)", "name": "Urban Rural Code", "type": "PrimitiveType"}, {"id": "", "description": "Datazone", "name": "Datazone", "type": "PrimitiveType"}, {"id": "", "description": "Local Government District", "name": "Local Government District", "type": "PrimitiveType"}, {"id": "", "description": "UK Constituency Description", "name": "UK Constituency Description", "type": "PrimitiveType"}]}, {"id": "", "description": "used to identify prescribable items with specific attributes", "name": "Indicators", "dataElementsCount": 18, "dataElements": [{"id": "", "description": "Numeric code representing the charge payable by a patient for the prescribable item. These fields relate to the drug/appliance, rather than the exemption status of the patient (e.g. some contraceptive drugs were provided free of charge). Therefore this information is still present after the abolition of prescription charges (April 2011), but is of questionable relevance, as the classifications are potentially not being updated.", "name": "Charge Type Code", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is sugar free. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Sugar Free Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Prescribable item's controlled drug classification", "name": "Controlled Drug Schedule", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if the item is a mixture. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Combination Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is wheat free. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Wheat Free Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is low protein. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Low Protein Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Description detailing prescribable item's borderline status . In certain conditions some foods (and toilet preparations) have characteristics of drugs and the Advisory Committee on Borderline Substances (ACBS) advises as to the circumstances in which such substances may be regarded as drugs. For further information see the PSD website.", "name": "Borderline Item Description", "type": "PrimitiveType"}, {"id": "", "description": "Code representing prescribable item's borderline status . In certain conditions some foods (and toilet preparations) have characteristics of drugs and the Advisory Committee on Borderline Substances (ACBS) advises as to the circumstances in which such substances may be regarded as drugs. For further information see the PSD website.", "name": "Borderline Item Code", "type": "PrimitiveType"}, {"id": "", "description": "Code identifying whether the item is a drug or appliance (e.g. dressings, blood glucose testing strips, compression hosiery)", "name": "Prescribable Item Type", "type": "PrimitiveType"}, {"id": "", "description": "Indicates whether a drug is liable for misuse. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Liable To Misuse Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is gluten free. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Gluten Free Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Description of the charge payable by a patient for the prescribable item. These fields relate to the drug/appliance, rather than the exemption status of the patient (e.g. some contraceptive drugs were provided free of charge). Therefore this information is still present after the abolition of prescription charges (April 2011), but is of questionable relevance, as the classifications are potentially not being updated.", "name": "Charge Type Description", "type": "PrimitiveType"}, {"id": "", "description": "Flag indicating an Oxygen Item", "name": "Oxygen Flag", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if the item is a contraceptive. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Contraceptive Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is ChlorofluroCarbon (CFC) free (inhalers only) . Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "CFC Free Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is a refill. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Refill Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if item is reconstituted. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Reconstituted Indicator", "type": "PrimitiveType"}, {"id": "", "description": "Identifies if the item is enteric coated. Of these indicators, combination, contraceptive, enteric-coated, reconstituted, refill and sugar-free are reliably maintained. Others should be checked before use.", "name": "Enteric Coated Indicator", "type": "PrimitiveType"}]}, {"id": "", "description": "Please select the NHS organisation details below, and indicate which location you would like them in relation to: \n\u2022\tLocation in which the prescribing took place \n\u2022\tLocation in which the dispensing took place \n\u2022\tThe patient\u2019s home residence - geography details relating to the home address of the patient are \u2018time stamped\u2019 so that the relevant address information can be applied to the prescribing or dispensing activity of interest", "name": "NHS Organisation", "dataElementsCount": 6, "dataElements": [{"id": "", "description": "Note: Community Health Partnerships (CHPs) were formed on 1st April 2006 and historic data from 1st April 2002 have been mapped to CHPs. This also applies to Sub CHPs.", "name": "Community Health Partnership Name", "type": "PrimitiveType"}, {"id": "", "description": "Note: Argyll and Clyde Health Board was dissolved in April 2006. Argyll and Bute was incorporated into Highland; Renfrew and Inverclyde was incorporated into Glasgow and Clyde.", "name": "Health Board Nine-digit Code (14 Health Board 2014 areaboundary configuration)", "type": "PrimitiveType"}, {"id": "", "description": "Note: Community Health Partnerships (CHPs) were formed on 1st April 2006 and historic data from 1st April 2002 have been mapped to CHPs. This also applies to Sub CHPs.", "name": "Sub CHP Name", "type": "PrimitiveType"}, {"id": "", "description": "Would recommend 9 character Health Board code to tie in with other datasets. Note: Argyll and Clyde Health Board was dissolved in April 2006. Argyll and Bute was incorporated into Highland; Renfrew and Inverclyde was incorporated into Glasgow and Clyde.", "name": "Health Board Name", "type": "PrimitiveType"}, {"id": "", "description": "Note: Community Health Partnerships (CHPs) were formed on 1st April 2006 and historic data from 1st April 2002 have been mapped to CHPs. This also applies to Sub CHPs.", "name": "Community Health Partnership Code", "type": "PrimitiveType"}, {"id": "", "description": "Note: Community Health Partnerships (CHPs) were formed on 1st April 2006 and historic data from 1st April 2002 have been mapped to CHPs. This also applies to Sub CHPs.", "name": "Sub CHP Code", "type": "PrimitiveType"}]}, {"id": "", "description": "Patient attributes", "name": "Patient attributes", "dataElementsCount": 5, "dataElements": [{"id": "", "description": "Patient's Date of Birth. Can provide at level approved by PBPP, e.g. year and month. Can be used to derive age bands.", "name": "Patient Date of Birth", "type": "PrimitiveType"}, {"id": "", "description": "Flag indicating if the patient is resident in a care-home (\u2018Y\u2019, \u2018N\u2019). This flag applies to all care homes (both residential and nursing), not just those for the elderly. The care home flag is assigned to a patient through linking of the CHI on prescription to the CHI database. The way in which it is derived means it is not directly linked to any other information on the prescription such as date of prescription. The flag is assigned to a patient based on their address at a particular point in time during a month, therefore all prescriptions for a patient within a particular month will either be assigned a flag Y or N. If a patient gets multiple scripts in a month during which they have moved into/out of a home you may find some scripts are not correctly assigned the flag.", "name": "Patient Care Home Residency Flag", "type": "PrimitiveType"}, {"id": "", "description": "Description of patient's gender \u2013 description to match the code above", "name": "Patient Gender Description", "type": "PrimitiveType"}, {"id": "", "description": "The age of the patient as at a date defined by researcher (the same defined date is used for all records for all patients). Please note patient age as at prescribed/dispensed/paid date is listed in section 5.3. Can be grouped into age bands if requested for summary tables or required for disclosure reasons", "name": "Patient Age (at prompted date)", "type": "PrimitiveType"}, {"id": "", "description": "Code indicating a patient's gender, derived from CHI. 1 = Male, 2 = Female", "name": "Patient Gender Code", "type": "PrimitiveType"}]}, {"id": "", "description": "Information relating to the prescribable item", "name": "Prescribable Item Details", "dataElementsCount": 7, "dataElements": [{"id": "", "description": "The name of the prescribable item (can be generic or proprietary)", "name": "Prescribable Item Name", "type": "PrimitiveType"}, {"id": "", "description": "Prescribable item formulation e.g. CREAM, DROPS, TABS etc.", "name": "Drug Formulation", "type": "PrimitiveType"}, {"id": "", "description": "Additional detail about the item such as flavour of nutritional supplements or sizes of appliances, e.g. apple 100ml, beige 50mm . Can sometimes contain information relating to the product strength.", "name": "Product Description", "type": "PrimitiveType"}, {"id": "", "description": "Detail required in addition to name, formulation and strength to identify a preparation, e.g. 'Effervescent' .Can sometimes contain information relating to the product strength.", "name": "Item Description", "type": "PrimitiveType"}, {"id": "", "description": "Factor by which the quantity should be divided to give the number of Defined Daily Doses . \u00a0 please advise if you require this for one drug, a group of drugs, or all prescribing", "name": "Daily Dose Conversion", "type": "PrimitiveType"}, {"id": "", "description": "Prescribable item's approved name. chemical name only - brand name found under Prescribable item name", "name": "Approved Name", "type": "PrimitiveType"}, {"id": "", "description": "Prescribable item's strength and units of measure (UOM), e.g. 1.2 MG, 1G, 160 MG/ML etc. In a small number of cases this information will be present in the Item or Product Description field instead. If you are interested in a particular drug/group of drugs, your Research Coordinator can check whether you will need these additional fields.", "name": "Item Strength / UOM", "type": "PrimitiveType"}]}, {"id": "", "description": "This class contains measures and flags relating to prescribed, dispensed or paid information", "name": "Prescribed/Dispensed/Paid Items", "dataElementsCount": 8, "dataElements": [{"id": "", "description": "Flag to indicate under what sub service under the new pharmacy contract the prescription form belongs. For those services which are not subdivided, the sub service flag will have the same entry as the service flag. E.g EHC = Emergency Hormonal Contraception NRT = Nicotin Replacement Therapy. Some service and subservice flags have been linked to prescriber types/prescriber location types in a potentially misleading manner, e.g. items flagged as PHS, a service provide by community pharmacie, have been atrributed to GPs. This is due to budgeting links for these services.", "name": "Sub Service Flag", "type": "PrimitiveType"}, {"id": "", "description": "The age of the Patient when the prescription was prescribed / dispensed / paid. Can be grouped into age bands if requested for summary tables or required for disclosure reasons.", "name": "Patient Age at Prescribed / Dispensed / Paid Date", "type": "PrimitiveType"}, {"id": "", "description": "Paid Gross Ingredient Cost (GIC) (Excluding claims for broken bulk (BB)).  (2) - Cost of the drug at manufacturer list price. Should you be working with organisations using English data, please note Net Ingredient Cost (NIC) in England is equivalent to GIC in Scotland, and vice versa. (3) -\n Broken Bulk is a facility that allows a contractor to claim a complete pack where a prescription is received for a product which comes in a larger pack and there is a risk of no further prescriptions for the product before the stock expires. GIC excluding BB is a fair reflection of what has been legitimately paid for items prescribed.", "name": "GIC(2) excluding BB (3)", "type": "PrimitiveType"}, {"id": "", "description": "Count of prescription items. Only of use in summary tables", "name": "Number of items", "type": "PrimitiveType"}, {"id": "", "description": "Flag to indicate under what service under the new pharmacy contract the prescription form belongs. e.g. A = Acute Medication Service Electronic Prescription M = Minor Ailments Service Electronic Prescription . Some service and subservice flags have been linked to prescriber types/prescriber location types in a potentially misleading manner, e.g. items flagged as PHS, a service provide by community pharmacie, have been atrributed to GPs. This is due to budgeting links for these services.", "name": "Service Flag", "type": "PrimitiveType"}, {"id": "", "description": "When drug information cannot be linked from the scaned prescription form to coding from the internally used drug dictionary (unlicensed medicines and medicines in short supply (4)), keyers in PSD have to manually entern the drug information.  These items will have an Approved Name of 'Dummy' or 'Dummy Rejected'. Dispensed data is available from June 2010; Paid data is available from October 2011. (4) - Product shortages can occur within the healthcare system. Where there is a proven shortage, a system override has to take place. This is a concession agreed between the Scottish Government and Community Pharmacy Scotland. See the Community Pharmacy Website for more information.", "name": "Dummy Dispensed", "type": "PrimitiveType"}, {"id": "", "description": "Number of times a dispensing was made for the item dispensed (multiple dispensings can take place where instalment dispensing were made for patient, or where the item is short life). This does not refer to repeat prescriptions", "name": "Number of dispensings", "type": "PrimitiveType"}, {"id": "", "description": "Quantity of srug / appliance. Quantity prescribed / dispensed / paid may differ", "name": "Quantity", "type": "PrimitiveType"}]}, {"id": "", "description": "Details relating to the prescribing individual", "name": "Prescriber - Presciber Individual", "dataElementsCount": 7, "dataElements": [{"id": "", "description": "Type of prescribing individual \u2013 description to match the code above", "name": "Prescriber Type Description", "type": "PrimitiveType"}, {"id": "", "description": "Prescribing individual's year of birth (Format: YYYY). Caution - completeness can range from 60-75%. Entries not quality checked.", "name": "Prescriber Year of Birth", "type": "PrimitiveType"}, {"id": "", "description": "Sub-type of prescribing individual \u2013 description to match the code above", "name": "Prescriber Sub Type Description", "type": "PrimitiveType"}, {"id": "", "description": "Code representing the gender of the prescribing individual. Caution - completeness can range from 60-75%. Entries not quality checked.", "name": "Prescriber Gender", "type": "PrimitiveType"}, {"id": "", "description": "General Medical Council code, General Dental Council code or individual PIN assigned to the prescribing individual. If this cannot be released due to IG constraints, an anonymised version can be created.", "name": "Prescriber Professional Number", "type": "PrimitiveType"}, {"id": "", "description": "Code relating to the type of prescribing individual e.g. GP = General Practice, NUR = Nurse, DEN = Dentist", "name": "Prescriber Type", "type": "PrimitiveType"}, {"id": "", "description": "Code relating to the sub-type of prescribing individual e.g. REG = Registrar, OPT = Optometrist, DN = District Nurse", "name": "Prescriber Sub Type", "type": "PrimitiveType"}]}, {"id": "", "description": "This class contains information about the prescriber", "name": "Prescriber - Presciber Location", "dataElementsCount": 5, "dataElements": [{"id": "", "description": "Code representing the type of location where the prescribing took place e.g. GPPRA = GP Practice, DENPRA = Dental Practice. Description to match the code can be provided as metadata.", "name": "Prescriber Location Type", "type": "PrimitiveType"}, {"id": "", "description": "Number of patients based on GP practice list size. Any numbers produced will be the mean value for the specified time period, unless otherwise requested.", "name": "List Size Number of Patients", "type": "PrimitiveType"}, {"id": "", "description": "Unique code representing the organisation where the prescribing took place. If this cannot be released due to Information Governance (IG) constraints, and anonymised version can be created. If the nonanonymised version is released, information relating to GP practices can be matched on from the list published by the ISD General Practice team.", "name": "Prescriber Location Code", "type": "PrimitiveType"}, {"id": "", "description": "The age ranges at which patient totals can be viewed: 0-4, 5-14, 15-24, 25-44, 45-64, 65-74, 75-84 and 85+", "name": "List Size Age Band", "type": "PrimitiveType"}, {"id": "", "description": "Description showing the gender of patients in list size", "name": "List Size Gender", "type": "PrimitiveType"}]}, {"id": "", "description": "This is available as prescribed, dispensed or paid date, as described below. Please indicate which date type you would like for each variable selected. \n\u2022\tPrescribed date: If an electronic message was used by PSD for payment purposes, then the actual date the e-prescription was written will be stored. If an electronic message was not used then the prescribed date will be defaulted to be the same as the \u2018Paid Date\u2019.  \n\u2022\tDispensed date: If an electronic message was used by PSD for payment purposes, then the actual date the e-prescription was dispensed will be stored. If an electronic message was not used then the dispensed date will be defaulted to be the same as the \u2018Paid Date\u2019.  \n\u2022\tPaid date: The date on which the prescription item was submitted for payment to PSD (always the last day of the month).", "name": "Prescription Date", "dataElementsCount": 12, "dataElements": [{"id": "", "description": "can also be derived from date", "name": "Financial Year", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Calendar Month No", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Financial Quarter", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Financial Year Name (starting 1st April)", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Calendar Quarter Month Range", "type": "PrimitiveType"}, {"id": "", "description": "will vary according to PBPP approval", "name": "Date", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Calendar Quarter", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Calendar Year", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Calendar Month Name", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Financial Quarter Month Range", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Calendar Month and Year", "type": "PrimitiveType"}, {"id": "", "description": "can also be derived from date", "name": "Financial Month", "type": "PrimitiveType"}]}, {"id": "", "description": "Details from 1992 until March 2004. Only summaries are available - CHI was not captured in this time period so the data is not linkable.", "name": "Prescription Summaries Time objects", "dataElementsCount": 11, "dataElements": [{"id": "", "description": "The month in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Calendar Month Name", "type": "PrimitiveType"}, {"id": "", "description": "The month and year in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Calendar Month and Year", "type": "PrimitiveType"}, {"id": "", "description": "The year (starting 1st April) in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Financial Year Name", "type": "PrimitiveType"}, {"id": "", "description": "The calendar quarter in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Quarter Month Range", "type": "PrimitiveType"}, {"id": "", "description": "The financial year (starting 1st April) month in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Financial Month", "type": "PrimitiveType"}, {"id": "", "description": "The last day of the month in which the prescription form was processed for payment by PSD. Can provide at level approved by PBPP, e.g. full or just year and month. Can be used to derive higher level time periods, e.g. quarters, years.", "name": "Prescription Summaries Time Date", "type": "PrimitiveType"}, {"id": "", "description": "The calendar year in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Calendar Year", "type": "PrimitiveType"}, {"id": "", "description": "The calendar month in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Calendar Month No", "type": "PrimitiveType"}, {"id": "", "description": "The calendar quarter in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Calendar Quarter", "type": "PrimitiveType"}, {"id": "", "description": "The financial year (starting 1st April) in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Financial Year", "type": "PrimitiveType"}, {"id": "", "description": "The financial year (starting 1st April) quarter in which the prescription item was processed for payment by PSD. can also be derived from date", "name": "Prescription Summaries Time Financial Quarter Month Range", "type": "PrimitiveType"}]}, {"id": "", "description": "Details from 1992 until March 2004. Only summaries are available - CHI was not captured in this time period so the data is not linkable.", "name": "Prescription Summaries measures", "dataElementsCount": 6, "dataElements": [{"id": "", "description": "Paid Gross Ingredient Cost (excluding claims for broken bulk)", "name": "Paid GIC Excl BB", "type": "PrimitiveType"}, {"id": "", "description": "The number of defined daily doses dispensed based on a yearly update from the business authority in England", "name": "Number of Defined Daily Doses", "type": "PrimitiveType"}, {"id": "", "description": "Number of times a dispensing was made for the item dispensed (multiple dispensings can take place where instalment dispensings were made for patient, or where the item is short life). This does not refer to repeat prescriptions.", "name": "Number of dispensings", "type": "PrimitiveType"}, {"id": "", "description": "Quantity of drug/appliance paid. May be different from what was prescribed or dispensed.", "name": "Paid Quantity", "type": "PrimitiveType"}, {"id": "", "description": "Unique code to identify a prescriber. Codes are banded according to Health Board. Please note this is different from the identifier provided in the data for April 2004 onwards.", "name": "Prescriber Code", "type": "PrimitiveType"}, {"id": "", "description": "Count of the prescription items paid. only of use in summary tables", "name": "Number of paid items", "type": "PrimitiveType"}]}, {"id": "", "description": "The index is an area based measure, calculated at data zone level and has seven domains (income, employment, education, housing, health, crime and geographical access). These have been combined into an overall index. Please note that SIMD values may appear for records prior to 1999, however ISD recommendations are to use SIMD for trend analyses from 1999 onwards. For trend analyses back to 1991, use the 2001 census based Carstairs deprivation. \nFor trend analyses back to before 1991, use the 1991 census based Carstairs deprivation. See the ISD website for further information. \nPlease indicate which SIMD version you would like for each selected variable. \n \nNote on change in ordering of quintiles and deciles \nFollowing the release of the SIMD 2009, ISD changed their ordering of quintiles and deciles to fit with the method that is used by the Scottish Government \n(SG). For SIMD 2009, SIMD 2012 and future releases, the method is now: 1 = MOST deprived, 5 or 10 = LEAST deprived \n \n ISD analyses based on SIMD 2006 or SIMD 2004 will be left in their current format:  1 = LEAST deprived; 5 or 10 = MOST deprived.  \nTo avoid confusion, deprivation categories should always be fully labelled. For example, for SIMD 2012, 'decile 1 (most deprived)'\u2026 'decile 10 (least deprived)'. \nFor time trend analyses combining SIMD 2004/2006 with SIMD 2009/2012 it is important to treat all deciles and quintiles in the same way. SIMD 2004/2006 deciles/quintiles should be reversed from 1=LEAST deprived, 5 or 10=MOST deprived to 1=MOST deprived, 5 or 10=LEAST deprived in order to keep the same convention for the deciles and quintiles throughout the analysis.", "name": "Scottish Index of Multiple Deprivation (SIMD)", "dataElementsCount": 9, "dataElements": [{"id": "", "description": "The higher the score, the more deprived the area. Please note this is contrary to the ordering for deciles and quintiles from version 2009 onwards, where the highest number indicates the least deprived area.", "name": "SIMD Score", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the population of each CHP into ten equal categories based on the range of SIMD scores so that 10% of the population falls into each decile (population weighted). See note above regarding the ordering of deciles.", "name": "SIMD CHP Decile", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the Scottish population into ten equal categories based on the range of SIMD scores so that 10% of the population falls into each decile (population weighted). See note above regarding the ordering of deciles.", "name": "SIMD Scotland Decile", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the population of each Health Board into ten equal categories based on the range of SIMD scores so that 10% of the population falls into each decile (population weighted). See note above regarding the ordering of deciles.", "name": "SIMD Health Board Decile", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the population of each Health Board into five equal categories based on the range of SIMD scores so that 20% of the population falls into each quintile (population weighted). See note above regarding the ordering of quintiles.", "name": "SIMD Health Board Quintile", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the Scottish population into five equal categories based on the range of SIMD scores so that 20% of the population falls into each quintile (population weighted). See note above regarding the ordering of quintiles.", "name": "SIMD Scotland Quintile", "type": "PrimitiveType"}, {"id": "", "description": "A marker (1=yes, 0=no) to determine whether the data zone is amongst the top 15%", "name": "SIMD Top 15% Marker", "type": "PrimitiveType"}, {"id": "", "description": "A marker (1=yes, 0=no) to determine whether the data zone is amongst the bottom 15%", "name": "SIMD Bottom 15% Marker", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the population of each CHP into five equal categories based on the range of SIMD scores so that 20% of the population falls into each quintile (population weighted). See note above regarding the ordering of quintiles.", "name": "SIMD CHP Quintile", "type": "PrimitiveType"}]}, {"id": "", "description": "The Carstairs Deprivation Score is an area based measure, calculated at postcode sector level and is derived from four 1991/2001 census variables: overcrowding, male unemployment, social class and car ownership. See the ISD website for further information. \nPlease indicate which Carstairs version you would like for each selected variable. The higher the score, the more deprived the area. \t2 digits", "name": "The Carstairs Deprivation Index", "dataElementsCount": 5, "dataElements": [{"id": "", "description": "A categorisation which divides the population of each Health Board into five equal categories based on the range of Carstairs deprivation scores so that 20% of the population falls into each quintile (population weighted). Quintile 1 is the least deprived, quintile 5 the most deprived.", "name": "Carstairs Health Board Quintile", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the population of each Health Board into ten equal categories based on the range of Carstairs deprivation scores so that 10% of the population falls into each decile (population weighted). Decile 1 is the least deprived, decile 10 the most deprived.", "name": "Carstairs Health Board Decile", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the Scottish population into five equal categories based on the range of Carstairs deprivation scores so that 20% of the population falls into each quintile (population weighted). Quintile 1 is the least deprived, quintile 5 the most deprived.", "name": "Carstairs Scotland Quintile", "type": "PrimitiveType"}, {"id": "", "description": "The Deprivation Category is derived by dividing the Deprivation Score into seven categories, ranging from very high deprivation (category 7) to very low (category 1). The Scottish population is unevenly Not available distributed between these seven categories with the middle range (3 & 4) holding a greater proportion than the extremes", "name": "Carstairs Category", "type": "PrimitiveType"}, {"id": "", "description": "A categorisation which divides the Scottish population into ten equal categories based on the range of  Carstairs deprivation scores so that 10% of the population falls into each decile (population weighted). Decile 1 is the least deprived, decile 10 the most deprived.", "name": "Carstairs Scotland Decile", "type": "PrimitiveType"}]}, {"id": "", "description": "from December 2009 onwards. Only available where the prescription has an eDispensed message", "name": "e-Dispensed Items", "dataElementsCount": 4, "dataElements": [{"id": "", "description": "Instructions for the use of the native drug prescribed. Contains dose, frequency, and usage information as freely typed text.  Free text is present in the raw data and in some cases has been found to contain disclosive information.  This field must either have the dose, frequency, and usage information extracted and held as structured data ready for analysis or the text processed using a \u2018data scrubber\u2019 to remove the disclosive data.", "name": "eDispensed Presc Native Dose Instructions", "type": "PrimitiveType"}, {"id": "", "description": "Fields showing ePrescribed time and drug details are available but not listed here. It is recommended you request these fields from the scanned class unless you only require prescribing data on items that were electronically dispensed.", "name": "eDispensed time fields", "type": "PrimitiveType"}, {"id": "", "description": "Instructions for use for the drug dispensed. Contains dose, frequency, and usage information as freely typed text. Can be amended by Dispenser. Free text is present in the raw data and in some cases has been found to contain disclosive information.  This field must either have the dose, frequency, and usage information extracted and held as structured data ready for analysis or the text processed using a \u2018data scrubber\u2019 to remove the disclosive data.", "name": "eDispensed Dispensed Dose Instructions", "type": "PrimitiveType"}, {"id": "", "description": "Fields showing ePrescribed time and drug details are available but not listed here. It is recommended you request these fields from the scanned class unless you only require prescribing data on items that were electronically dispensed.", "name": "eDispensed drug fields", "type": "PrimitiveType"}]}, {"id": "", "description": "from April 2009 onwards. Only available where the prescription has an ePrescribed message.", "name": "e-Prescribed Items", "dataElementsCount": 3, "dataElements": [{"id": "", "description": "Fields showing ePrescribed time and drug details are available but not listed here. It is recommended you request these fields from the scanned class unless you only require prescribing data on items that were electronically prescribed.", "name": "ePrescribed drug fields", "type": "PrimitiveType"}, {"id": "", "description": "Instructions for the use of the native drug prescribed. Contains dose, frequency, and usage information as freely typed text. ePrescribed drug fields", "name": "ePrescribed Native Dose Instructions", "type": "PrimitiveType"}, {"id": "", "description": "Fields showing ePrescribed time and drug details are available but not listed here. It is recommended you request these fields from the scanned class unless you only require prescribing data on items that were electronically prescribed.", "name": "ePrescribed time fields", "type": "PrimitiveType"}]}]
Download

Copied to clipboard

Additional information

  • Documentation
    Documentation
  • Language
    English
  • Geographic Area
    Scotland

Related resources

Available resource files can be downloaded below.

File name

Prescribing Information System - variables

Type

PDF

Requesting access to this data

This is a secure dataset that can only be accessed by researchers from approved organisations.

  • Publisher
    Public Health Scotland / National Records Scotland
  • Contact
    phs.edris@phs.scot
  • Privacy tags
    ---

Find out how to apply to access this dataset

Key Details

  • Activity that generated the dataset
    No information available
  • Conforms to
    No information available
  • Creator
    malcolmi
  • Documentation
    The information is supplied by Practitioner & Counter Fraud Services Division (P&CFS) who is responsible for the processing and pricing of all prescriptions dispensed in Scotland. These data are augmented with information on prescriptions written in Scotland that were dispensed elsewhere in the United Kingdom. GP’s write the vast majority of these prescriptions, with the remainder written by other authorised prescribers such as nurses and dentists. Also included in the dataset are prescriptions written in hospitals that are dispensed in the community. Note that prescriptions dispensed within hospitals are not included. Data includes CHI number, prescriber and dispenser details for community prescribing, costs and drug information. Data on practices (e.g. list size), organisational structures (e.g. practices within Community Health Partnerships (CHPs) and NHS Boards), prescribable items (e.g. manufacturer, formulation code, strength) are also included. Around 100 million data items are loaded per annum.
  • End time period of data covered by this dataset
    No information available
  • Formal release or publication date
    2021-09-08
  • Geographic Area
  • Landing page
  • Language
    English
  • Provenance
    No information available
  • Start time period of data covered by this dataset
    2009-01-01
  • The dataset type
    dataset
  • Theme/category
    No information available
  • Update frequency
    monthly

Versions and updates

  • A description of the differences between this version and a previous version of the dataset
    No information available
  • The most recent data on which the dataset was changed or modified
    No information available
  • Version
    No information available

Further details

  • A related dataset from which this dataset is derived
    No information available
  • Other identifiers
    No information available
  • Qualified attribution
    No information available
  • Qualified relation
    No information available
  • Sample distribution of the dataset
    No information available
  • The minimum spacial separation resolvable in the dataset, measured in meters
    No information available
  • The minimum time period resolvable in the dataset
    No information available