SNOMED International Release Management

Page tree

Versions Compared

Old Version 8

changes.mady.by.user Andrew Atkinson

Saved on

compared with

New Version 9

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

14701112 358 6 6 6 0
  • 357 inactivations +
    • 1107
  • 357 inactivations +
    • 1113 records  24032308 95 53254962 363 881595 286 1020 14 Apr  1   594  1   28566 0 868859 9 8536 9 095414 Apr  0   6  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

    3 records April April 13541047 307 26912505 186 111867189 3997 5953 6 23492038 311 656 4 .  So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

    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

    		ModuleDependency files

    3

    updated, as expected for

    May 2023 effectiveTimes

    Readme file

    May 2023 dates updated, 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


    May 2023 PREPRODUCTION (Version 1 PRE VERSIONING) to May 2023 PRODUCTION (Version 2 POST 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

    Readme file

    Beta "x" prefixes removed + Prod naming conventions applied, as expected

    SimpleMap files551

    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

    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