SNOMED International Release Management

Page tree

Versions Compared

Old Version 14

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.

September 2023 PRODUCTION (PUBLISHED) to October 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/1t2thATnI6JWDQnrM7gFjJunHS-sP00mgpY1qcMjsTM0/edit#gid=0

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 files621

402 records added/updated, plus

219 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) = 10 changes:

  • 0 inactivations (734139008) + 0 inactivations (734139008)
  • 4 new/updated records (734138000) + 4 new records (734138000)

  • 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 8 changes - 4 new records + 4 inactivations + 0 updates

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

  • 202 new/updated records +
  • 44 inactivations 

Makes a total of:

  • 206 new/updated records +
  • 48 inactivations 

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

Attribute Value files3968

3929 records added/updated, plus

39 inactivated

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

Language refset files15247


10143 records added/updated, plus

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

591 records added/updated, plus

264 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:06 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     375
    • 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     45
Simple Refset files6

2 records added/updated, plus

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

857 records added/updated, plus

0 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 625 (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 + 0 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:39 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     0
ModuleDependency files

3


3 records updated, as expected for July 2023 effectiveTimes

Readme file

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

Concept files822

723 records added/updated, plus

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

1969 records added/updated, plus

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

5151 records added/updated, plus

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

79 records added/updated, plus

17 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) files1217

1118 records added/updated, plus

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

26 records added/updated, plus

14 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


October 2023 PRODUCTION (Version 1 POST VERSIONING) to October 2023 PRODUCTION (Version 2 POST VERSIONING) traceability

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

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

MRCM AttributeDomain files2

INFRA-11609

1 records added/updated as expected, plus

1 records inactivated

  • > 0ef2a9f6-5794-11ee-8c99-0242ac120002    20231001    1    900000000000012004    723561005    410675002    1285465008    1    0..*    0..1    723597001    723596005
  • < ad00a6fd-be74-4974-96ab-8049ed543aad    20231001    1    900000000000012004    723561005    410675002    1285465008    1    0..*    0..1    723597001    723596005
    > ad00a6fd-be74-4974-96ab-8049ed543aad    20231001    0    900000000000012004    723561005    410675002    433590000    1    0..*    0..1    723597001    723596005

Needs Chris/Michael to verify that this is as planned...emailed them for confirmation on 22/9/23....

Michael confirmed all good via Slack on  

Chris confirmed all good via Slack on  


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

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

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

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 files903

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


September 2023 PRODUCTION (PUBLISHED) to October 2023 PRODUCTION (Version 2 POST VERSIONING) traceability

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

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

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 files729

423 records added/updated, plus

306 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) = 127 changes:

  • Refset: 734138000
  • 110 new/updated records + 16 inactivated records
  • Refset: 734139008
  • 1 new/updated records + 0 inactivated records

  • 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 3 changes - 1 new records + 2 inactivations + 0 updates

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

  • 312 new/updated records +
  • 290 inactivations 

Makes a total of:

  • 423 new/updated records +
  • 306 inactivations 

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

Attribute Value files1920

1882 records added/updated, plus

38 inactivated

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

Language refset files7418


6467 records added/updated, plus

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

727 records added/updated, plus

301 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 11:29 on :

  • "added/updated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (new) this release     185          +
    • Total New mapped entries this release     508
    • Total Changed mapped entries (modified) this release    34
  • "inactivated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (retired) this release     136        +
    • Total Retired mapped entries this release     165
Simple Refset files209

177 records added/updated, plus

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

910 records added/updated, plus

1 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 903 (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 7 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 10:57 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     7
    • "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 October 2023 effectiveTimes

Readme file

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

Concept files1419

1164 records added/updated, plus

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

3161 records added/updated, plus

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

Identifier files0

0 records added/updated as expected

Relationship files11436

8027 records added/updated, plus

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

18 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) files2531

2276 records added/updated, plus

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

20 records added/updated, plus

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

2 records added/updated as expected:

  • > e8cee440-5eda-7717-505f-69d3727b855b    20231001    1    900000000000012004    723561005    246454002    71388002    1    0..*    0..1    723597001    723596005
  • < ad00a6fd-be74-4974-96ab-8049ed543aad    20170731    1    900000000000012004    723561005    410675002    433590000    1    0..*    0..1    723597001    723596005
    > ad00a6fd-be74-4974-96ab-8049ed543aad    20231001    1    900000000000012004    723561005    410675002    1285465008    1    0..*    0..1    723597001    723596005

As expected due to the manual counts + MRCM changed report (https://docs.google.com/spreadsheets/d/114B51X8HokMEX-5ZW-0-9bPwQSi1MTkU8g6M5l-1tRY/edit#gid=0) in the Content Handover Notes for this release:  Content Handover Meeting minutes - October 2023 International Edition

MRCM AttributeRange files2


2 records added/updated as expected

  • < 47e35159-6db8-41f2-a4cd-4fa79ea0e03b    20200731    1    900000000000012004    723562003    246454002    << 282032007 |Periods of life (qualifier value)|    (<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)|): [0..*] { [0..1] 246454002 |Occurrence| = << 282032007 |Periods of life (qualifier value)| }    723597001    723596005
    > 47e35159-6db8-41f2-a4cd-4fa79ea0e03b    20231001    1    900000000000012004    723562003    246454002    << 282032007 |Periods of life (qualifier value)|    (<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|): [0..*] { [0..1] 246454002 |Occurrence| = << 282032007 |Periods of life (qualifier value)| }    723597001    723596005
  • < 5db62b65-c29f-4e28-8061-b31683d581e4    20170731    1    900000000000012004    723562003    410675002    << 284009009 |Route of administration value (qualifier value)|    << 433590000 |Administration of substance via specific route (procedure)|: [0..*] { [0..1] 410675002 |Route of administration| = << 284009009 |Route of administration value (qualifier value)| }    723597001    723596005
    > 5db62b65-c29f-4e28-8061-b31683d581e4    20231001    1    900000000000012004    723562003    410675002    << 284009009 |Route of administration value (qualifier value)|    << 1285465008 |Administration via specific route (procedure)|: [0..*] { [0..1] 410675002 |Route of administration| = << 284009009 |Route of administration value (qualifier value)| }    723597001    723596005

As expected due to the manual counts + MRCM changed report (https://docs.google.com/spreadsheets/d/114B51X8HokMEX-5ZW-0-9bPwQSi1MTkU8g6M5l-1tRY/edit#gid=0) in the Content Handover Notes for this release:  Content Handover Meeting minutes - October 2023 International Edition

MRCM Domain files5


4 records added/updated as expected, plus

1 records inactivated

As expected due to the manual counts + MRCM changed report (https://docs.google.com/spreadsheets/d/114B51X8HokMEX-5ZW-0-9bPwQSi1MTkU8g6M5l-1tRY/edit#gid=0) in the Content Handover Notes for this release:  Content Handover Meeting minutes - October 2023 International Edition

MRCM ModuleScope files0

0 records added/updated as expected