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.0.0_20250409000001

Release 40.0.0, 16 April 2025.

Released on 16 April 2025.

uk_sctqths_39.6.0_20250312000001

Release 39.6.0, 19 March 2025.

Released on 19 March 2025.

uk_sctqths_39.5.0_20250212000001

Release 39.5.0, 19 February 2025.

Released on 19 February 2025.

uk_sctqths_39.2.0_20241120000001

Release 39.2.0, 27 November 2024.

Released on 27 November 2024.

uk_sctqths_39.0.0_20240925000001

Release 39.0.0, 2 October 2024.

Released on 2 October 2024.

uk_sctqths_38.4.0_20240731000001

Release 38.4.0, 7 August 2024.

Released on 7 August 2024.

uk_sctqths_38.2.0_20240605000001

Release 38.2.0, 12 June 2024.

Released on 12 June 2024.

uk_sctqths_38.0.0_20240410000001

Release 38.0.0, 17 April 2024.

Released on 17 April 2024.

uk_sctqths_37.6.0_20240313000001

Release 37.6.0, 20 March 2024.

Released on 20 March 2024.

uk_sctqths_37.5.0_20240214000001

Release 37.5.0, 21 February 2024.

Released on 21 February 2024.

uk_sctqths_37.2.0_20231122000001

Release 37.2.0, 29 November 2023.

Released on 29 November 2023.

uk_sctqths_37.0.0_20230927000001

Release 37.0.0, 4 October 2023.

Released on 4 October 2023.

uk_sctqths_36.4.0_20230802000001

Release 36.4.0, 9 August 2023.

Released on 9 August 2023.

uk_sctqths_36.2.0_20230607000001

Release 36.2.0, 14 June 2023.

Released on 14 June 2023.

uk_sctqths_36.0.0_20230412000001

Release 36.0.0, 19 April 2023.

Released on 19 April 2023.

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.