July

September 2023 PRODUCTION (PUBLISHED) to

September

October 2023 PRODUCTION (Version

1

2 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):

SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1t2thATnI6JWDQnrM7gFjJunHS-sP00mgpY1qcMjsTM0/edit#gid=0

Differences found in package Comparison	Number of RF2 records impacted	Rationale
RefsetDescriptor files	0	0 records added/updated as expected
Association Reference files	621	402 records added/updated, plus 219 records inactivated ...as expected as the totals ALMOST match exactly with Summary Component Stats report, but you also need to incorporate SEP changes: In order to get an accurate comparison, we have to ALSO INCLUDE the SEP refset (734138000 + 734139008) totals from the RF2 files (manually tallied from the new Association Snapshot files) and add them to the "Hist Assoc" tab in the Summary Component Report: SEP (from RF2 diff files) = 10 changes: 0 inactivations (734139008) + 0 inactivations (734139008) 4 new/updated records (734138000) + 4 new records (734138000) Confirmed as matches exactly with data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page) - see report above Report shows 8 changes - 4 new records + 4 inactivations + 0 updates This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats: 202 new/updated records + 44 inactivations Makes a total of: 206 new/updated records + 48 inactivations Which matches exactly with the counts I got above from the RF2 files!!
Attribute Value files	3968	3929 records added/updated, plus 39 inactivated ...as expected as the totals match exactly with Summary Component Stats report
Language refset files	15247	10143 records added/updated, plus 5104 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)
ExtendedMap files	855	591 records added/updated, plus 264 records inactivated Which matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 10:06 on 07 Jul 2023 : "added/updated" counts from diff report matches to total of WCI report lines: Total Changed mapped entries (new) this release 1 + Total New mapped entries this release 375 Total Changed mapped entries (modified) this release 0 "inactivated" counts from diff report matches to total of WCI report lines: Total Changed mapped entries (retired) this release 0 + Total Retired mapped entries this release 45
Simple Refset files	6	2 records added/updated, plus 4 records inactivated Confirmed as matches exactly with Lateralizable refset (723264001) data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page) - see report above
SimpleMap files	628	857 records added/updated, plus 0 records inactivated Confirmed as matches with: firstly the number of CTV3 records (900000000000497000) - which in this release is 625 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see "Concepts" tab in the Summary Component Stats report above) PLUS the manual counts of ICD-0 records (446608001) - here 3 new + 0 inactivations, in the SimpleMap diff file, which also matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 09:39 on 07 Jul 2023 "added/updated" counts from diff report matches to total of WCI report lines: Total Changed mapped entries (new) this release 1 + Total New mapped entries this release 2 "inactivated" counts from diff report matches to total of WCI report lines: Total Changed mapped entries (retired) this release 0 + Total Retired mapped entries this release 0
ModuleDependency files	3	3 records updated, as expected for July 2023 effectiveTimes
Readme file		July 2023 dates updated + Beta "x" prefixes added, as expected
Concept files	822	723 records added/updated, plus 99 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)
Description files	2315	1969 records added/updated, plus 346 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) NOTE: Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256. This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms. So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.
Relationship files	7225	5151 records added/updated, plus 2074 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)
Relationship Concrete Values files	96	79 records added/updated, plus 17 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)
OwlExpression (Axiom) files	1217	1118 records added/updated, plus 99 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)
Stated Relationship files	0	0 records updated, plus 0 records inactivated As expected due to full migration to OWLExpression file in the July 2019 International Edition
TextDefinition files	40	26 records added/updated, plus 14 records inactivated Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) NOTE: Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256. This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms. So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.
MRCM AttributeDomain files	0	0 records added/updated as expected
MRCM AttributeRange files	0	0 records added/updated as expected
MRCM Domain files	0	0 records added/updated as expected
MRCM ModuleScope files	0	0 records added/updated as expected

September 2023 PRODUCTION (Version 2 PRE VERSIONING) to September 2023 PRODUCTION (Version 1 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):

SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1t2thATnI6JWDQnrM7gFjJunHS-sP00mgpY1qcMjsTM0/edit#gid=0

Differences found in package Comparison	Number of RF2 records impacted	Related JIRA ticket(s)	Rationale
Readme file			Beta "x" prefixes removed + Prod naming conventions applied, as expected
SimpleMap files	857		857 new records had their UUID's refreshed, as expected

July 2023 PRODUCTION (PUBLISHED) to September 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1kq8j74z3f2yfE5in6IF9DwC_GPGqyoQ3aCNu3MLnkek/edit#gid=0

SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1t2thATnI6JWDQnrM7gFjJunHS-sP00mgpY1qcMjsTM0/edit#gid=0

621402 219 39683929 39 1524710143 5104 855591 264 62 4 857857 0 13871111 276 65523900 2652

9519 records added/updated, plus

6091 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/Relationship Concrete Values 405352 53 2607 277

1 records added/updated as expected

See the same change applied in the Domain template here (for the same concept 1142142004):

< 0867d3ba-1849-4de1-9812-dedcd18a561c 20210731 1 900000000000012004 723560006 781405001 << 781405001 |Medicinal product package (product)| 373873005 |Pharmaceutical / biologic product (product)| << 781405001 |Medicinal product package (product)| [[+id(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+int(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+id(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+id(<< 767524001 |Unit of measure (qualifier value)|)]] } [[+scg(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+int(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+scg(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+scg(<< 767524001 |Unit of measure (qualifier value)|)]] } http://snomed.org/dom781405001
---
> 0867d3ba-1849-4de1-9812-dedcd18a561c 20230901 1 900000000000012004 723560006 781405001 << 781405001 |Medicinal product package (product)| 373873005 |Pharmaceutical / biologic product (product)| << 781405001 |Medicinal product package (product)| [[+id(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+dec(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+id(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+id(<< 767524001 |Unit of measure (qualifier value)|)]] } [[+scg(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+dec(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+scg(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+scg(<< 767524001 |Unit of measure (qualifier value)|)]] } http://snomed.org/dom781405001

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

RefsetDescriptor files

0

0 records added/updated as expected

Association Reference files

729

423 records added/updated, plus

306 records inactivated

...as expected as the totals ALMOST match exactly with Summary Component Stats report, but you also need to incorporate SEP changes:

In order to get an accurate comparison, we have to ALSO INCLUDE the SEP refset (734138000 + 734139008) totals from the RF2 files (manually tallied from the new Association Snapshot files) and add them to the "Hist Assoc" tab in the Summary Component Report:

SEP (from RF2 diff files) = 10 changes:

Refset: 734138000
1 new/updated records + 2 inactivated records
Refset: 734139008
0 new/updated records + 0 inactivated records
Confirmed as matches exactly with data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page) - see report above
- Report shows 3 changes - 1 new records + 2 inactivations + 0 updates

This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats:

401 new/updated records +
217 inactivations

Makes a total of:

402 new/updated records +
219 inactivations

Which matches exactly with the counts I got above from the RF2 files!!

Attribute Value files

1920

1882 records added/updated, plus

38 inactivated

...as expected as the totals match exactly with Summary Component Stats report

Language refset files

7418

6467 records added/updated, plus

949 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

ExtendedMap files

1028

727 records added/updated, plus

301 records inactivated

Which matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 11:18 on 11 Aug 2023 :

"added/updated" counts from diff report matches to total of WCI report lines:
- Total Changed mapped entries (new) this release 176 +
- Total New mapped entries this release 380
- Total Changed mapped entries (modified) this release 35
"inactivated" counts from diff report matches to total of WCI report lines:
- Total Changed mapped entries (retired) this release 126 +
- Total Retired mapped entries this release 138

Simple Refset files

209

177 records added/updated, plus

32 records inactivated

Confirmed as matches exactly with Lateralizable refset (723264001) data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page) - see report above

SimpleMap files

911

910 records added/updated, plus

1 records inactivated

Confirmed as matches with:

firstly the number of CTV3 records (900000000000497000) - which in this release is 857 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see "Concepts" tab in the Summary Component Stats report above) PLUS
the manual counts of ICD-0 records (446608001) - here 0 new + 0 inactivations, in the SimpleMap diff file, which also matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 10:50 on 11 Aug 2023
- "added/updated" counts from diff report matches to total of WCI report lines:
  - Total Changed mapped entries (new) this release 0 +
  - Total New mapped entries this release 0
- "inactivated" counts from diff report matches to total of WCI report lines:
  - Total Changed mapped entries (retired) this release 0 +
  - Total Retired mapped entries this release 0

ModuleDependency files

3

3 records updated, as expected for September October 2023 effectiveTimes (we're skipping August this time due to the move to 1st of the month releases)

Readme file

Sept October 2023 dates updated + Beta "x" prefixes added, as expected

Concept files

1419

1164 records added/updated, plus

255 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

Description files

3653

3161 records added/updated, plus

492 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

NOTE: Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256. This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms. So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

Identifier files

0

n/a

Just the headers changed for this file, as per the planned change to the format of the file in FRI-658 + ISRS-1562 + ISRS-1563 + the new specs here: https://confluence.ihtsdotools.org/mag/snomed-international-proposal-to-change-the-rf2-identifier-file-specification

< identifierSchemeId alternateIdentifier effectiveTime active moduleId referencedComponentId
---
> alternateIdentifier effectiveTime active moduleId identifierSchemeId referencedComponentId

0 records added/updated as expected

Relationship files

11436

8027 records added/updated, plus

3409 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

Relationship Concrete Values files

18

18 records added/updated, plus

0 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/

Relationship files

15610

updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

OwlExpression (Axiom) files

2531

2276 records added/updated, plus

255 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

OwlExpression (Axiom) files

2884

Stated Relationship files

0

0 records updated, plus

0 records inactivated

As expected due to full migration to OWLExpression file in the July 2019 International Edition

TextDefinition files

21

20 records added/updated, plus

1 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

Stated Relationship files

0

0 records updated, plus

0 records inactivated

As expected due to full migration to OWLExpression file in the July 2019 International Edition

TextDefinition files

28

28 records added/updated, plus

0 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

NOTE: Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256. This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms. So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

MRCM AttributeDomain files

0

0 records added/updated as expected

NOTE: Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256. This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms. So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

MRCM AttributeDomain files

2

2 records added/updated as expected:

> e8cee440-5eda-7717-505f-69d3727b855b 20231001 1 900000000000012004 723561005 246454002 71388002 1 0..* 0..1 723597001 723596005
< ad00a6fd-be74-4974-96ab-8049ed543aad 20170731 1 900000000000012004 723561005 410675002 433590000 1 0..* 0..1 723597001 723596005
> ad00a6fd-be74-4974-96ab-8049ed543aad 20231001 1 900000000000012004 723561005 410675002 1285465008 1 0..* 0..1 723597001 723596005

MRCM AttributeRange files

2

2 records added/updated as expected

< 47e35159-6db8-41f2-a4cd-4fa79ea0e03b 20200731 1 900000000000012004 723562003 246454002 << 282032007 |Periods of life (qualifier value)| (<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)|): [0..*] { [0..1] 246454002 |Occurrence| = << 282032007 |Periods of life (qualifier value)| } 723597001 723596005
> 47e35159-6db8-41f2-a4cd-4fa79ea0e03b 20231001 1 900000000000012004 723562003 246454002 << 282032007 |Periods of life (qualifier value)| (<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|): [0..*] { [0..1] 246454002 |Occurrence| = << 282032007 |Periods of life (qualifier value)| } 723597001 723596005
< 5db62b65-c29f-4e28-8061-b31683d581e4 20170731 1 900000000000012004 723562003 410675002 << 284009009 |Route of administration value (qualifier value)| << 433590000 |Administration of substance via specific route (procedure)|: [0..*] { [0..1] 410675002 |Route of administration| = << 284009009 |Route of administration value (qualifier value)| } 723597001 723596005
> 5db62b65-c29f-4e28-8061-b31683d581e4 20231001 1 900000000000012004 723562003 410675002 << 284009009 |Route of administration value (qualifier value)| << 1285465008 |Administration via specific route (procedure)|: [0..*] { [0..1] 410675002 |Route of administration| = << 284009009 |Route of administration value (qualifier value)| } 723597001 723596005

MRCM Domain files

5

4 records added/updated as expected, plus

1 records inactivated

MRCM AttributeRange files

1

1 records added/updated as expected

Just the one record changed, to allow the Range for concept 1142142004 to be updated from an Integer to a Decimal:

< e96eade2-42ce-4c5c-8585-ad80b8dd7b41 20210731 1 900000000000012004 723562003 1142142004 int(>#0..) << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 1142142004 |Has pack size| > #0 } 723597001 723596005
---
> e96eade2-42ce-4c5c-8585-ad80b8dd7b41 20230901 1 900000000000012004 723562003 1142142004 dec(>#0..) << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 1142142004 |Has pack size| > #0 } 723597001 723596005

For details see Briefing Note attached to

Jira

server	IHTSDO JIRA
serverId	b202d822-d767-33be-b234-fec5accd5d8c
key	INFRA-11294

(attached to the Content Handover Meeting minutes here: Content Handover Meeting minutes - September 2023 International Edition)

MRCM Domain files

1

MRCM ModuleScope files

0

0 records added/updated as expected

Page tree

Versions Compared

Old Version 1

New Version 2

Key

September 2023 PRODUCTION (PUBLISHED) to

October 2023 PRODUCTION (Version

2 POST VERSIONING) traceability

September 2023 PRODUCTION (Version 2 PRE VERSIONING) to September 2023 PRODUCTION (Version 1 POST VERSIONING) traceability

July 2023 PRODUCTION (PUBLISHED) to September 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability

Page tree

Page History

Versions Compared

Old Version 1

New Version 2

Key

September 2023 PRODUCTION (PUBLISHED) to

October 2023 PRODUCTION (Version

2 POST VERSIONING) traceability

September 2023 PRODUCTION (Version 2 PRE VERSIONING) to September 2023 PRODUCTION (Version 1 POST VERSIONING) traceability

July 2023 PRODUCTION (PUBLISHED) to September 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability