SNOMED International Release Management

Page tree

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

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

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

RefsetDescriptor files0

0 records added/updated as expected

Association Reference files1470

1112 records added/updated, plus

358 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)
  • 6 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 6 changes - 6 new records + 0 inactivations + 0 updates

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

  • 357 inactivations +
  • 1107 new/updated records

Makes a total of:

  • 357 inactivations +
  • 1113 new/updated records  

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

Attribute Value files2403

2308 records added/updated, plus

95 inactivated

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

Language refset files5325


4962 records added/updated, plus

363 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 files881

595 records added/updated, plus

286 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:20 on :

  • "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     594
    • 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     1        +
    • Total Retired mapped entries this release     285
Simple Refset files6

6 records added/updated, plus

0 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 files868

859 records added/updated, plus

9 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 853 (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 6 new + 9 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:54 on
    • "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     6
    • "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     9

So this also tallies with the issue raised in the last release cycle in INFRA-10658 whereby 7 records were still not inactivated when they should have been -

Asked Rick in INFRA-10766 to confirm that the conceptID's all match with the fixed records to confirm this fix has worked as expected...CONFIRMED


ModuleDependency files

3


3 records updated, as expected for April 2023 effectiveTimes

Readme file

April 2023 dates updated, as expected

Concept files1354

1047 records added/updated, plus

307 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 files2691

2505 records added/updated, plus

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

7189 records added/updated, plus

3997 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 files59

53 records added/updated, plus

6 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) files2349

2038 records added/updated, plus

311 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 files0

0 records updated, plus

0 records inactivated

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

TextDefinition files6

56 records added/updated, plus

4 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 files0

0 records added/updated as expected

MRCM AttributeRange files0


0 records added/updated as expected

MRCM Domain files0


0 records added/updated as expected

MRCM ModuleScope files0

0 records added/updated as expected

March 2023 PRODUCTION (PUBLISHED) to April 2023 PRODUCTION (Version 1 POST VERSIONING) traceability

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

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

RefsetDescriptor files0

0 records added/updated as expected

Association Reference files1470

1112 records added/updated, plus

358 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)
  • 6 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 6 changes - 6 new records + 0 inactivations + 0 updates

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

  • 357 inactivations +
  • 1007 new/updated records

Makes a total of:

  • 357 inactivations +
  • 1113 new/updated records  

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

Attribute Value files2403

2308 records added/updated, plus

95 inactivated

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

Language refset files5325


4962 records added/updated, plus

363 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 files881

595 records added/updated, plus

286 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:20 on :

  • "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     594
    • 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     1        +
    • Total Retired mapped entries this release     285
Simple Refset files6

6 records added/updated, plus

0 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 files868

859 records added/updated, plus

9 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 853 (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 6 new + 9 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:54 on
    • "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     6
    • "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     9

So this also tallies with the issue raised in the last release cycle in INFRA-10658 whereby 7 records were still not inactivated when they should have been -

Asked Rick in INFRA-10766 to confirm that the conceptID's all match with the fixed records to confirm this fix has worked as expected...CONFIRMED


ModuleDependency files

3


3 records updated, as expected for April 2023 effectiveTimes

Readme file

April 2023 dates updated, as expected

Concept files1354

1047 records added/updated, plus

307 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 files2691

2505 records added/updated, plus

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

7189 records added/updated, plus

3997 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 files59

53 records added/updated, plus

6 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) files2349

XXXXXX2037 records added/updated - CONFIRMED THIS IS AN ISSUE WITH THE NEW VERSION OF THE APPLE DIFF TOOL (in Mac OS Ventura v13.3.1) - RE-RAN COMPARISON FROM SEVERAL MACHINES STILL ON MONTEREY AND EVERYTHING WORKED AS EXPECTED in VERSION 2:

2038 records added/updated, plus

311 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 files0

0 records updated, plus

0 records inactivated

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

TextDefinition files6

XXXXXXX3 records added/updated - CONFIRMED THIS IS AN ISSUE WITH THE NEW VERSION OF THE APPLE DIFF TOOL (in Mac OS Ventura v13.3.1) - RE-RAN COMPARISON FROM SEVERAL MACHINES STILL ON MONTEREY AND EVERYTHING WORKED AS EXPECTED in VERSION 2:

56 records added/updated, plus

4 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 files0

0 records added/updated as expected

MRCM AttributeRange files0


0 records added/updated as expected

MRCM Domain files0


0 records added/updated as expected

MRCM ModuleScope files0

0 records added/updated as expected

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

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

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

RefsetDescriptor files0

0 records added/updated as expected

Association Reference files1470

1112 records added/updated, plus

358 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)
  • 6 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 6 changes - 6 new records + 0 inactivations + 0 updates

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

  • 357 inactivations +
  • 1007 new/updated records

Makes a total of:

  • 357 inactivations +
  • 1113 new/updated records  

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

Attribute Value files2403

2308 records added/updated, plus

95 inactivated

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

Language refset files5325


4962 records added/updated, plus

363 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 files881

595 records added/updated, plus

286 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:20 on :

  • "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     594
    • 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     1        +
    • Total Retired mapped entries this release     285
Simple Refset files6

6 records added/updated, plus

0 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 files868

859 records added/updated, plus

9 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 853 (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 6 new + 9 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:54 on
    • "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     6
    • "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     9

So this also tallies with the issue raised in the last release cycle in INFRA-10658 whereby 7 records were still not inactivated when they should have been -

Asked Rick in INFRA-10766 to confirm that the conceptID's all match with the fixed records to confirm this fix has worked as expected...CONFIRMED


ModuleDependency files

3


3 records updated, as expected for April 2023 effectiveTimes

Readme file

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

Concept files1354

1047 records added/updated, plus

307 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 files2691

2505 records added/updated, plus

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

7189 records added/updated, plus

3997 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 files59

53 records added/updated, plus

6 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) files2349

2038 records added/updated, plus

311 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 files0

0 records updated, plus

0 records inactivated

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

TextDefinition files60

56 records added/updated, plus

4 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 files0

0 records added/updated as expected

MRCM AttributeRange files0


0 records added/updated as expected

MRCM Domain files0


0 records added/updated as expected

MRCM ModuleScope files0

0 records added/updated as expected

  • No labels