SNOMED International Release Management

Page tree

Versions Compared

Old Version 7

changes.mady.by.user Andrew Atkinson

Saved on

compared with

New Version Current

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

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

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

    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

    April April 13541047 307 26912505 186 111867189 3997 5953 6 (Axiom) files

    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 311

    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 4 searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.
        •  1
    ModuleDependency files

    3


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

    3

    3 records 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 2349(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 files6
    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

    PRE

    POST VERSIONING) traceability

    SUMMARY COMPONENT REPORT (RUN BY MARIA PREDEVOPS POST-VERSIONING):   https://docs.google.com/spreadsheets/d/1FFnCdMS9AcwMXYsck1iAhamF5t2pX1Iw3_mf5X4GQ9Y1rUqO1qBC-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

    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