International Edition Traceability matrix (May 2023)

International Edition Traceability matrix (May 2023)

April 2023 PRODUCTION (PUBLISHED) to May 2023 PRODUCTION (Version 2 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):  https://docs.google.com/spreadsheets/d/1rUqO1qBC-UdxWu3f2uR0Y0xgtbZaPdZuYqi59e5Db-Q/edit#gid=0

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

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

1244



851 records added/updated, plus

393 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) = 36 changes:

  • 0 inactivations (734138000) + 0 inactivations (734139008)

  • 17 new/updated records (734138000) + 0 new records (734139008)

  • 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 27 changes - 17 new records + 10 inactivations + 0 updates

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

  • 834 new/updated records +

  • 383 inactivations 

Makes a total of:

  • 851 new/updated records +

  • 393 inactivations 

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

Attribute Value files

2269



2216 records added/updated, plus

53 inactivated

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

Language refset files

5798



4619 records added/updated, plus

1179 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

363



177 records added/updated, plus

186 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 14:00 on May 12, 2023 :

  • "added/updated" counts from diff report matches to total of WCI report lines:

    • Total Changed mapped entries (new) this release     3            +

    • Total New mapped entries this release     174

    • 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     186

Simple Refset files

40



21 records added/updated, plus

19 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

555



554 records added/updated, plus

1 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 551 (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 + 1 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 13:31 on May 12, 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     1

ModuleDependency files

3



3 records updated, as expected for May 2023 effectiveTimes

Readme file





May 2023 dates updated, as expected

Concept files

1010



685 records added/updated, plus

325 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

2863



2261 records added/updated, plus

602 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

5957



3647 records added/updated, plus

2310 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

101



101 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)  

OwlExpression (Axiom) files

1547



1218 records added/updated, plus

329 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

64



59 records added/updated, plus

5 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.

DOESN'T QUITE MATCH - DUE TO MY UPDATED VERSION OF MAC OS with a broken COMPARISON APP (you can tell when this is happened as the "c" file in the Comparison script output does NOT end with a carriage return, but just in the middle of a row) - ACTUAL FIGURES ARE:

131 records updated, plus

6 records inactivated

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

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

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):   https://docs.google.com/spreadsheets/d/1rUqO1qBC-UdxWu3f2uR0Y0xgtbZaPdZuYqi59e5Db-Q/edit#gid=0

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

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

551



551 new records had their UUID's refreshed, as expected

April 2023 PRODUCTION (PUBLISHED) to May 2023 PREPRODUCTION (Version 1 PRE VERSIONING) traceability

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

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

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

1244



851 records added/updated, plus

393 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) = 36 changes:

  • 0 inactivations (734138000) + 0 inactivations (734139008)

  • 17 new/updated records (734138000) + 0 new records (734139008)

  • 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 27 changes - 17 new records + 10 inactivations + 0 updates

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

  • 834 new/updated records +

  • 383 inactivations 

Makes a total of:

  • 851 new/updated records +

  • 393 inactivations 

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

Attribute Value files

2269



2216 records added/updated, plus

53 inactivated

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

Language refset files

5798



4619 records added/updated, plus

1179 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

363



177 records added/updated, plus

186 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 14:00 on May 12, 2023 :

  • "added/updated" counts from diff report matches to total of WCI report lines:

    • Total Changed mapped entries (new) this release     3            +

    • Total New mapped entries this release     174

    • 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     186

Simple Refset files

40



21 records added/updated, plus

19 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

555



554 records added/updated, plus

1 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 551 (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 + 1 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 13:31 on May 12, 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     1

ModuleDependency files

3



3 records updated, as expected for May 2023 effectiveTimes

Readme file





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

Concept files

1010



685 records added/updated, plus

325 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

2863



2261 records added/updated, plus

602 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

5957



3647 records added/updated, plus

2310 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

101



101 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)  

OwlExpression (Axiom) files

1547



1218 records added/updated, plus

329 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

64



59 records added/updated, plus

5 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.

DOESN'T QUITE MATCH - DUE TO MY UPDATED VERSION OF MAC OS with a broken COMPARISON APP (you can tell when this is happened as the "c" file in the Comparison script output does NOT end with a carriage return, but just in the middle of a row) - ACTUAL FIGURES ARE:

131 records updated, plus

6 records inactivated

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

Copyright © 2025, SNOMED International