SNOMED International Release Management

Page tree

Versions Compared

Old Version 4

changes.mady.by.user Andrew Atkinson

Saved on

compared with

New Version 5

changes.mady.by.user Andrew Atkinson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

April 2023 PRODUCTION (PUBLISHED) to May 2023 PRODUCTION (Version 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/1OqJ7lzsWJone4Ie7W9x5YhpriTD1qV3sQ9YaT9uzxJ4/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


April 2023 PRODUCTION (PUBLISHED) to May 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/1OqJ7lzsWJone4Ie7W9x5YhpriTD1qV3sQ9YaT9uzxJ4/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


April 2023 PRODUCTION (PUBLISHED) to May 2023 PRODUCTION (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

6 6 6 0
  • 357 inactivations +
    • 1007
  • 357 inactivations +
    • 1113 records   1020 14 Apr  1   594  1   285 8536 9 095414 Apr  0   6 this release     0        +
  • Total Retired mapped entries this release     9
    • So also tallies with the issue raised in the last 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

    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 files1244

    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 files2269

    2216 records added/updated, plus

    53 inactivated

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

    Language refset files5798


    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 files363

    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

    :

    • "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 files40

    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 files555

    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
      • "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 files1010

    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 files2863

    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 files5957

    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 files101

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

    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 files0

    0 records updated, plus

    0 records inactivated

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

    TextDefinition files64

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