• Home
  • Contact us
  • Create an account
  • Log in
Search help

Home SNOMED CT derivative products

SNOMED CT UK Query Table and History Substitution Table

Releases of this item contain 2 related derivatives of the SNOMED CT UK Edition to aid the processing of inactive content within systems and data repositories.

The History Substitution Table provides a single table identifying valid substitutions for concepts that are now inactive, along with metadata about that substitution; it is computed using the historical relationships within the main SNOMED CT release but presented as a simpler look-up table.

The Query Table is an extension to a normal SNOMED CT transitive closure table, taking into account the History Substitutions Table and other data. It provides a mechanism to achieve optimal data retrieval, regardless of inactive and active concept status in data or query definitions. The Query Table is recommended as a mechanism for ensuring inactive content is still returned in searches, and is specifically recommended by the Joint GP IT Committee for use in primary care systems.

Status: Supported


  • Licences (2)

Releases of this item

uk_sctqths_35.6.0_20230315000001

Release 35.6.0, 22 March 2023.


Released on 22 March 2023.

uk_sctqths_35.5.0_20230215000001

Release 35.5.0, 22 February 2023.


Released on 22 February 2023.

uk_sctqths_35.2.0_20221123000001

Release 35.2.0, 30 November 2022.


Released on 30 November 2022.

uk_sctqths_35.0.0_20220928000001

Release 35.0.0, 5 October 2022.


Released on 5 October 2022.

uk_sctqths_34.1.0_20220803000001

Release 34.1.0, 10 August 2022.


Released on 10 August 2022.

uk_sctqths_34.0.0_20220706000001

Release 34.0.0, 22 July 2022.


Released on 22 July 2022.

uk_sctqths_33.1.0_20220608000001

Release 33.1.0, 15 June 2022.


Released on 15 June 2022.

uk_sctqths_33.0.0_20220511000001

Release 33.0.0, 18 May 2022.


Released on 18 May 2022.

uk_sctqths_32.12.0_20220413000001

Release 32.12.0, 20 April 2022.


Released on 20 April 2022.

uk_sct2qths_32.10.0_20220216000001

Release 32.10.0, 23 February 2022.


Released on 23 February 2022.

uk_sctqths_32.7.0_20211124000001

Release 32.7.0, 1 December 2021.


Released on 1 December 2021.

uk_sctqths_32.6.0_20211027000001

Release 32.6.0, 3 November 2021.


Released on 3 November 2021.

uk_sctqths_32.5.0_20210929000001

Release 32.5.0, 6 October 2021.


Released on 6 October 2021.

uk_sctqths_32.4.0_20210901000001

Out of schedule release 32.4.0, 8 September 2021.


Released on 8 September 2021.

uk_sctqths_32.2.0_20210707000001

Release 32.2.0, 14 July 2021.


Released on 14 July 2021.

uk_sctqths_32.0.0_20210512000001

Release 32.0.0, 19 May 2021.


Released on 19 May 2021.

SCT_QTHS_31.5.0_20210317000001

Release 31.5.0, 24 March 2021.


Released on 24 March 2021.

SCT_QTHS_31.3.0_20210120000001

Release 31.3.0, 27 January 2021.


Released on 27 January 2021.

SCT_QTHS_31.1.0_20201125000001

Release 31.1.0, 2 December 2020.


Released on 2 December 2020.

SCT_QTHS_31.0.0_20201028000001

Release 31.0.0, 11 November 2020.


Released on 11 November 2020.

SCT_QTHS_30.2.0_20200930000001

Release 30.2.0, 7 October 2020.


Released on 7 October 2020.

SCT_QTHS_30.0.0_20200805000001

Release 30.0.0, 5 August 2020.


Released on 5 August 2020.

SCT_QTHS_29.3.0_20200610000001

Release 29.3.0, 17 June 2020.


Released on 17 June 2020.

SCT_QTHS_29.2.0_20200513000001

Release 29.2.0, 13 May 2020.


Released on 13 May 2020.

SCT_QTHS_29.1.0_20200415000001

Release 29.1.0, 15 April 2020.


Released on 15 April 2020.

SCT_QTHS_29.0.0_20200401000001

Release 29.0.0, 1 April 2020.


Released on 1 April 2020.

SCT_QTHS_28.0.0_20191001000001

Release 28.0.0, 1 October 2019.


Released on 1 October 2019.

SCT_QTHS_27.0.0_20190601000001

Release 27.0.0, 4 June 2019.


Released on 4 June 2019.

Category filters

  • All categories
  • Classification products
  • NHS Data Model and Dictionary
  • Terminology products

Categories

  • All items
  • Clinical Imaging Procedures
  • Data Set Development Services extract XML Schemas
  • Data Set Development Services tools
  • Interoperability Toolkit (ITK)
  • ITK Release Candidates
  • Message Specifications
  • NHS Classifications ICD-10
  • NHS Classifications ICD-10 and OPCS-4 eVersion
  • NHS Classifications OPCS-4
  • NHS Data Model and Dictionary XML Schemas
  • NHS Logical Record Architecture
  • NHS National Laboratory Medicine Catalogue
  • NHS UK Read Codes
  • NHSBSA dictionary of medicines and devices
  • Organisation Data Service and Spine Directory Service
  • Pathology
  • SNOMED CT derivative products
  • SNOMED CT education and training resources
  • SNOMED CT subset members in spreadsheet view
  • SNOMED CT subsets in development
  • SNOMED CT UK Edition
  • SNOMED International
  • Terminology browsers and tools
Data and technology that improves lives
  • Accessibility
  • API
  • Cookies
  • Licences
  • Privacy policy
  • Terms and conditions