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
Releases of this item
uk_sctqths_40.2.0_20250604000001
Release 40.2.0, 11 June 2025.
uk_sctqths_40.1.0_20250507000001
Release 40.1.0, 14 May 2025.
uk_sctqths_40.0.0_20250409000001
Release 40.0.0, 16 April 2025.
uk_sctqths_39.6.0_20250312000001
Release 39.6.0, 19 March 2025.
uk_sctqths_39.5.0_20250212000001
Release 39.5.0, 19 February 2025.
uk_sctqths_39.2.0_20241120000001
Release 39.2.0, 27 November 2024.
uk_sctqths_39.0.0_20240925000001
Release 39.0.0, 2 October 2024.
uk_sctqths_38.4.0_20240731000001
Release 38.4.0, 7 August 2024.
uk_sctqths_38.2.0_20240605000001
Release 38.2.0, 12 June 2024.
uk_sctqths_38.0.0_20240410000001
Release 38.0.0, 17 April 2024.
uk_sctqths_37.6.0_20240313000001
Release 37.6.0, 20 March 2024.
uk_sctqths_37.5.0_20240214000001
Release 37.5.0, 21 February 2024.
uk_sctqths_37.2.0_20231122000001
Release 37.2.0, 29 November 2023.
uk_sctqths_37.0.0_20230927000001
Release 37.0.0, 4 October 2023.
uk_sctqths_36.4.0_20230802000001
Release 36.4.0, 9 August 2023.
uk_sctqths_36.2.0_20230607000001
Release 36.2.0, 14 June 2023.
uk_sctqths_36.0.0_20230412000001
Release 36.0.0, 19 April 2023.
uk_sctqths_35.6.0_20230315000001
Release 35.6.0, 22 March 2023.
uk_sctqths_35.5.0_20230215000001
Release 35.5.0, 22 February 2023.
uk_sctqths_35.2.0_20221123000001
Release 35.2.0, 30 November 2022.
uk_sctqths_35.0.0_20220928000001
Release 35.0.0, 5 October 2022.
uk_sctqths_34.1.0_20220803000001
Release 34.1.0, 10 August 2022.
uk_sctqths_34.0.0_20220706000001
Release 34.0.0, 22 July 2022.
uk_sctqths_33.1.0_20220608000001
Release 33.1.0, 15 June 2022.
uk_sctqths_33.0.0_20220511000001
Release 33.0.0, 18 May 2022.
uk_sctqths_32.12.0_20220413000001
Release 32.12.0, 20 April 2022.
uk_sct2qths_32.10.0_20220216000001
Release 32.10.0, 23 February 2022.
uk_sctqths_32.7.0_20211124000001
Release 32.7.0, 1 December 2021.
uk_sctqths_32.6.0_20211027000001
Release 32.6.0, 3 November 2021.
uk_sctqths_32.5.0_20210929000001
Release 32.5.0, 6 October 2021.
uk_sctqths_32.4.0_20210901000001
Out of schedule release 32.4.0, 8 September 2021.
uk_sctqths_32.2.0_20210707000001
Release 32.2.0, 14 July 2021.
uk_sctqths_32.0.0_20210512000001
Release 32.0.0, 19 May 2021.
SCT_QTHS_31.5.0_20210317000001
Release 31.5.0, 24 March 2021.
SCT_QTHS_31.3.0_20210120000001
Release 31.3.0, 27 January 2021.
SCT_QTHS_31.1.0_20201125000001
Release 31.1.0, 2 December 2020.
SCT_QTHS_31.0.0_20201028000001
Release 31.0.0, 11 November 2020.
SCT_QTHS_30.2.0_20200930000001
Release 30.2.0, 7 October 2020.
SCT_QTHS_30.0.0_20200805000001
Release 30.0.0, 5 August 2020.
SCT_QTHS_29.3.0_20200610000001
Release 29.3.0, 17 June 2020.
SCT_QTHS_29.2.0_20200513000001
Release 29.2.0, 13 May 2020.
SCT_QTHS_29.1.0_20200415000001
Release 29.1.0, 15 April 2020.
SCT_QTHS_29.0.0_20200401000001
Release 29.0.0, 1 April 2020.
SCT_QTHS_28.0.0_20191001000001
Release 28.0.0, 1 October 2019.
SCT_QTHS_27.0.0_20190601000001
Release 27.0.0, 4 June 2019.