RETIRED - Secondary Care Medicines Data (SCMD)

##This dataset is retired
<p>This now retired dataset provides Secondary Care Medicines data on processed pharmacy stock control data in NHS Trusts across England.</p>
<p>For regularly updated data which includes indicative costs, users can instead access the <a href="https://opendata.nhsbsa.net/dataset/secondary-care-medicines-data-indicative-price">Secondary Care Medicines Data (SCMD) with Indicative Price</a>&nbsp;or the&nbsp;<a href="Finalised%20Secondary%20Care%20Medicines%20Data%20with%20Indicative%20Price">Finalised Secondary Care Medicines Data with Indicative Price.</a></p>
<details class="nhsuk-details nhsuk-expander">
  <summary class="nhsuk-details__summary">
    <span class="nhsuk-details__summary-text">
      Retired SCMD Data Information - Reference Only
    </span>
  </summary>
  <div class="nhsuk-details__text">
    <p>We are making changes to the Secondary Care Medicines data (SCMD). No new monthly data files will be added to this page.</p>
    <p>We currently publish Secondary Care Medicines Data in two locations on the Open Data Portal. We are consolidating this so that we will only provide one version of the SCMD. The version that we will continue to publish is the SCMD with an <a href="https://opendata.nhsbsa.net/dataset/secondary-care-medicines-data-indicative-price">indicative price metric</a>. The dataset with indicative price was in the Experiment Area theme and has been moved into the Hospital & Provider Medicines theme. This dataset page will then be retired.</p>
    <p>Secondly, the data we publish has been in a monthly provisional format. We hold a yearly and validated final version of this data in our data warehouse. We will be removing all of the provisional monthly files for previous years and will publish the finalised monthly files instead. For example, all 12 provisional monthly files from 2020 will be removed and will be replaced with 12 final monthly files for the whole of 2020.</p>
    <p>Provisional monthly files will continue to be published for the current year until the finalised yearly file is available.</p>
    <h4>In summary:</h4>
    <ul>
      <li>We now publish only one SCMD, and it is the version with indicative price included.</li>
      <li>We will remove all provisional monthly files for previous years and publish the finalised monthly files instead.</li>
      <li>We continue to publish provisional files for the current year until we receive the finalised yearly file.</li>
    </ul>
  </div>
</details>


##Dataset Description

<p>The retired dataset contains the following key components:</p>
<ol>
<li><strong>Quantities of Medicines Issued</strong>:<br /> Details the total quantities of medicines stock control via NHS Secondary Care services.</li>
<li><strong>Standardisation with SNOMED CT and dm+d</strong>:</li>
<ul>
<li><strong>SNOMED CT (Systematised Nomenclature of Medicine - Clinical Terms)</strong> is used to enhance the dataset&rsquo;s compatibility with electronic health record systems and clinical decision support tools. SNOMED CT is a globally recognised coding system that provides precise definitions for clinical terms, ensuring interoperability across healthcare systems.</li>
<li><strong>NHS Dictionary of Medicines and Devices, dm+d</strong> codes are used for medicines standardisation, offering a structured format for identifying medicines and their associated attributes (e.g., strength, form, route of administration).<br /> Together, SNOMED CT and dm+d enable seamless integration of this dataset with clinical systems and improve the dataset&rsquo;s usability for healthcare providers and researchers.</li>
</ul>
<li><strong>Trust-Level Data</strong>:<br /> Data is broken down by individual NHS Trusts, enabling regional comparisons, benchmarking, and targeted analysis of specific Trusts.</li>
<li><strong>Medicine Identification:</strong></li>
</ol>
<p>Medicines in the dataset are identified using Virtual Medicinal Product (VMP) codes from the Dictionary of Medicines and Devices (dm+d):</p>
<p>VMP_PRODUCT_NAME: The name of the Virtual Medicinal Product (VMP) as defined by the dm+d, which includes key details about the product. For example: Paracetamol 500mg tablets.</p>
<p>VMP_SNOMED_CODE: The code for the Virtual Medicinal Product (VMP), providing a unique identifier for each product. For example: 42109611000001109 represents Paracetamol 500mg tablets.</p>
</ul>
<p>By making this data publicly available, the NHSBSA aims to enhance transparency, accountability, and the effective use of NHS resources.

<h2>Overview of Service</h2>
<p>Information about our NHSBSA Prescriptions Data service can be found here - <a href="https://www.nhsbsa.nhs.uk/prescription-data">Prescription data | NHSBSA</a></p>
<ul>
<li>The NHS Business Services Authority (NHSBSA) publishes this dataset, provided by RX Info, which contains information about pharmacy stock control in NHS secondary care settings across England on behalf of NHS England. It includes data from NHS Trusts and is standardised using the Dictionary of Medicines and Devices (dm+d) format. &nbsp;</li>
</ul>
<p>For further context about the <strong>Secondary Care Medicines Data</strong>, you can explore the following resources:</p>
<p><a href="https://github.com/NHSBSA-Open-Data/ODP/raw/ab57824f4e723f9b2057d1aef750d92f85d6136c/Secondary%20Care%20Medicines%20Data%20Release%20Guidance%20v0.5.docx">Secondary Care Medicines Data Release Guidance v0.5</a> (Word: 78.3KB)</p>
<p>RX Info: RX Info is the provider of the data related to pharmacy stock control medicines issued in NHS Secondary Care settings, which is&nbsp;made available by NHSBSA. <a href="https://www.rx-info.co.uk">Visit RX Info's website for more details</a>.</p>

<h2>Dataset Details</h2>
<!-- Expander 1 -->
<details class="nhsuk-details">
    <summary class="nhsuk-details__summary">
        <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Data Source</span>
    </summary>
    <div class="nhsuk-details__text">
<p>The data is sourced from NHS Trusts' pharmacy stock control systems which capture detailed records of medicines issued, including quantities.
<p>The data is provided to NHSBSA by RX Info, a data provider that supplies records on medicines issued in NHS Secondary Care settings.
<p>Data quality controls are in place to exclude transactions flagged as outliers, non-standardised items and zero activity. No personal or patient-identifiable information is included, ensuring compliance with data protection regulations.</p>
</div>
</details>

<!-- Expander 2 -->
<details class="nhsuk-details">
    <summary class="nhsuk-details__summary">
        <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Data Collection</span>
    </summary>
    <div class="nhsuk-details__text">
       <p>Data is from NHS England sites only and provided under the agreement entered into by Trusts and Rx-Info (Define) facilitated by NHS England. The data owners and data controllers are the respective NHS Trusts.</p>
    </div>
</details>

<!-- Expander 3 -->
<details class="nhsuk-details">
    <summary class="nhsuk-details__summary">
        <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Time Periods</span>
    </summary>
    <div class="nhsuk-details__text">
        <p>Monthly files covering January 2019 to December 2022.</p>
</details>

<!-- Expander 4 -->
<details class="nhsuk-details">
    <summary class="nhsuk-details__summary">
        <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Geography</span>
    </summary>
    <div class="nhsuk-details__text">
        <p>NHS Trusts in England.</p>
    </div>
</details>

<!-- Expander Statistics -->
<details class="nhsuk-details">
    <summary class="nhsuk-details__summary">
        <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Statistical Classification</span>
    </summary>
   <div class="nhsuk-details__text">
<p>Management Information – This is not an official statistic.</p>
    </div>
</details>
<!-- Expander Statistics -->
<details class="nhsuk-details">
    <summary class="nhsuk-details__summary">
        <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Related Data and Statistics</span>
    </summary>
   <div class="nhsuk-details__text">
<p>Our&nbsp;<a href="https://www.nhsbsa.nhs.uk/statistical-collections/prescribing-costs-hospitals-and-community-england">Prescribing Costs in Hospitals and the Community</a>&nbsp;official statistics publication also includes Secondary Care Medicines data with actual cost, broken down by British National Formulary (BNF) Section.</p>
    </div>
</details>


<h2>Caveats</h2>
<div class="nhsuk-inset-text">
  <h3 class="nhsuk-u-font-size-32">Data Guidance and Scope for Secondary Care Medicines</h3>
  <p>Further understanding of the information provided can be found in the guidance:</p>
<ul>
<li><a href="https://github.com/NHSBSA-Open-Data/ODP/raw/ab57824f4e723f9b2057d1aef750d92f85d6136c/Secondary%20Care%20Medicines%20Data%20Release%20Guidance%20v0.5.docx">Secondary Care Medicines Data Release Guidance v0.5</a>&nbsp;(Word: 78.3KB)</li>
</ul>
<p><strong>Exclusions</strong>: The dataset does not include medicines prescribed in primary care (e.g., GP surgeries) or private healthcare providers, or NHS prescriptions supplied by hospitals dispensed in community pharmacy.</p>
<p>NHS Business Services are publishing this data on behalf of NHS England and are not able to provide analytical support or interpretation of the data which is provided by individual NHS Trusts into the Rx-Info system.</p>
</div>

<h2>Enquiries</h2>
<!---Who can I contact Section-->
<details class="nhsuk-details">
  <summary class="nhsuk-details__summary">
    <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Who can I contact if I have queries relating to the data?</span>
  </summary>
  <div class="nhsuk-details__text">
    <p>If you have any queries regarding the data provided, or if you plan on publishing the data, please contact <a href="mailto: DataServicesSupport@nhsbsa.nhs.uk">DataServicesSupport@nhsbsa.nhs.uk</a> ensuring you quote the name of the dataset for reference. This is important to ensure that the figures are not misunderstood or misrepresented.</p>
  </div>
</details>
<h2>Citing and Reusing This Data</h2>
<!---Reusing the data and copyright Section-->
<details class="nhsuk-details">
  <summary class="nhsuk-details__summary">
    <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Important information regarding reusing the data and copyright</span>
  </summary>
  <div class="nhsuk-details__text">
    <p>If you plan on producing a press or broadcast story based upon the data, please contact <a href="mailto:communicationsteam@nhsbsa.nhs.uk">communicationsteam@nhsbsa.nhs.uk</a>. This is important to ensure that the figures are not misunderstood or misrepresented.</p>
    <p>The information supplied to you continues to be protected by the Copyright, Designs and Patents Act 1988 and/or other applicable law. You may use the data freely, provided that you attribute the source.</p>
  </div>
</details>

<!---Citation-->
<details class="nhsuk-details">
  <summary class="nhsuk-details__summary">
    <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Citation
    </span>
  </summary>
  <div class="nhsuk-details__text">
<p>NHS Business Services Authority. "RETIRED - Secondary Care Medicines Data (SCMD).” NHS Business Services Authority Open Data. Accessed **[Date Accessed]**. URL: <a href=" https://opendata.nhsbsa.net/dataset/secondary-care-medicines-data"> https://opendata.nhsbsa.net/dataset/secondary-care-medicines-data</a></p>
</div>
</details>


Tags: Hospital Medicines Data, Secondary Care Medicines Data
Organization: Hospital & Provider Medicines