June 2023 PRODUCTION (PUBLISHED) to
JuneJuly 2023 PRODUCTION (Version 1 POST VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING): https://docs.google.com/spreadsheets/d/1mOUruag1aRVHCm3IYO1EBH6GBoFlOnTjB97xx5q3wNc18c8XfmIKmEa3VF4xUSqPPHnR3rbQDIjkbYXkAsjEArg/edit#gid=0
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1lpP_YIT8_bjVklmrqyQW3odQhtqsf549EU5jIi-H9Lk/edit#gid=0
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RefsetDescriptor files | 0 | 0 records added/updated as expected | ||||||||||||||
Association Reference files | 406254 | 288206 records added/updated, plus | 118 48 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:
| 8
| 2
| 10
| 8
| 2
This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats: | 280
| 116
Makes a total of: | 288
| 118
Which matches | ALMOST exactly with the counts I got above from the RF2 files!! | |||
Attribute Value files | 1491830 | 1423816 records added/updated, plus | 68 14 inactivated ...as expected as the totals match exactly with Summary Component Stats report | |||||||||||||
Language refset files | 96394536 | 87833884 records added/updated, plus | 856 652 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 files | 976521 | 873376 records added/updated, plus | 103 45 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 | 12:29 on 09 Jun 10:06 on :
| 0
| 873
| 103
| |||||||||
Simple Refset files | 196 | 152 records added/updated, plus 4 records inactivated
| ||||||||||||||
SimpleMap files | 1254628 | 1254628 records added/updated, plus 0 records inactivated Confirmed as matches with:
| 1252
| 1
| 12
| 00
| 09 Jun
| 0
| ||||||||
ModuleDependency files | 3 | 3 records updated, as expected for | June July 2023 effectiveTimes | |||||||||||||
Readme file | JuneJuly 2023 dates updated + Beta "x" prefixes added, as expected | |||||||||||||||
Concept files | 1535822 | 1312723 records added/updated, plus | 222 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 files | 46462315 | 42181969 records added/updated, plus | 428 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 files | 121087225 | 85805151 records added/updated, plus | 3267 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 files | 13096 | 12779 records added/updated, plus | 3 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) files | 21741217 | 19521118 records added/updated, plus | 222 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 files | 0 | Stated Relationship files | 0 | 0 records updated, plus 0 records inactivated As expected due to full migration to OWLExpression file in the July 2019 International Edition | ||||||||||||
TextDefinition files | 22240 | 22026 records added/updated, plus | 2 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. | NOW MATCHES EXACTLY - MAYBE MY NEWLY UPDATED MAC OS HAS A FIXED COMPARISON APP????|||||||||||||
MRCM AttributeDomain files | 0 | 0 records added/updated as expected | ||||||||||||||
MRCM AttributeRange files | 6 | 6 records added/updated as expected, as match exactly with the MRCM report: https://docs.google.com/spreadsheets/d/1fsZB7COM0kPw0NhIbgrkufUeBwPQFrKaG-U8tXzro9I/edit#gid=0:
Sent to Maria + Yong for cross checking as these are critical changes that can have a wide ranging impact... Maria + Yong signed off via email at 09:48 on 13/6/2023 Yong confirmed that the discrepancy between this and the MRCM Report (which only reported 4 changes) is purely a Reporting issue, as the 6 content changes in the RF2 files are correct - ticket | MRCM Domain files | 2 | 0 | 0 records added/updated as expected | ||||||||||
MRCM Domain files | 0 | 0 records added/updated as expected | Sent to Maria + Yong for cross checking as these are critical changes that can have a wide ranging impact... Maria + Yong signed off via email at 09:48 on 13/6/2023||||||||||||||
MRCM ModuleScope files | 0 | 0 records added/updated as expected |
June 2023 PRODUCTION (Version 2 PRE VERSIONING) to June 2023 PRODUCTION (Version 1 POST VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING): https://docs.google.com/spreadsheets/d/1mOUruag1aRVHCm3IYO1EBH6GBoFlOnTjB97xx5q3wNc18c8XfmIKmEa3VF4xUSqPPHnR3rbQDIjkbYXkAsjEArg/edit#gid=0
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1lpP_YIT8_bjVklmrqyQW3odQhtqsf549EU5jIi-H9Lk/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 files | 1252625 | 1252625 new records had their UUID's refreshed, as expected |
June 2023 PRODUCTION (PUBLISHED) to July 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/19AqljHDnHzgZYqNSngNoxDq15fZ4BbHYr1VjGmxb1NQ/edit#gid=0
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/165jktWOipmWLYnBtgywa2u9_WVpm-WHpB87QTZeyrug/edit#gid=2
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale | ||||||
---|---|---|---|---|---|---|---|---|---|
RefsetDescriptor files | 0 | 0 records added/updated as expected | |||||||
Association Reference files | 254 | 206 records added/updated, plus 48 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:
This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats:
Makes a total of:
Which matches exactly with the counts I got above from the RF2 files!! | |||||||
Attribute Value files | 830 | 816 records added/updated, plus 14 inactivated ...as expected as the totals match exactly with Summary Component Stats report | |||||||
Language refset files | 4536 | 3884 records added/updated, plus 652 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 files | 521 | 376 records added/updated, plus 45 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 | 12:29 on 09 Jun 10:06 on :
| 0
| 873
| 103
| |||
Simple Refset files | 6 | 2 records added/updated, plus 4 records inactivated
| |||||||
SimpleMap files | 628 | 628 records added/updated, plus 0 records inactivated Confirmed as matches with:
| 1252
| 1
| 12
| 00
| 09 Jun
| 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 files | 822 | 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 files | 2315 | 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 files | 7225 | 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 files | 96 | 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) files | 1217 | 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 files | 0 | 0 records updated, plus 0 records inactivated As expected due to full migration to OWLExpression file in the July 2019 International Edition | |||||||
TextDefinition files | 40 | 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 files | 0 | 0 records added/updated as expected | |||||||
MRCM AttributeRange files | 0 | 0 records added/updated as expected | |||||||
MRCM Domain files | 0 | 0 records added/updated as expected | |||||||
MRCM ModuleScope files | 0 | 0 records added/updated as expected |