April 2023 PRODUCTION (PUBLISHED) to
AprilMay 2023 PRODUCTION (Version 2 POST VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING): https://docs.google.com/spreadsheets/d/1gExRH5ndhBQ929Jt91Sy3IWuQSsg1rUqO1qBC-UdxWu3f2uR0Y0xgtbZaPdZuYqi59e5Db-rti00Dz4mwbSyMQ/edit#gid=0
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1s6S_tnpC2ZpWoOLxnTfCKOeEQRiAD2moMnumn3xLpBY1OqJ7lzsWJone4Ie7W9x5YhpriTD1qV3sQ9YaT9uzxJ4/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 | 14701244 | 1112851 records added/updated, plus | 358 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:
| 6
| 6
| 6
| 0
This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats: |
Makes a total of: |
| records
Which matches ALMOST exactly with the counts I got above from the RF2 files!! | |
Attribute Value files | 24032269 | 2308 2216 records added/updated, plus 95 53 inactivated ...as expected as the totals match exactly with Summary Component Stats report | |||||||||
Language refset files | 53255798 | 4962 4619 records added/updated, plus 363 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 files | 881363 | 595 177 records added/updated, plus 286 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 1014:20 00 on 14 Apr :
| |||||||||
Simple Refset files | 640 | 6 21 records added/updated, plus 0 19 records inactivated
| |||||||||
SimpleMap files | 868555 | 859 554 records added/updated, plus 9 1 records inactivated Confirmed as matches with:
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 | ModuleDependency files | 3 | 3 records updated, as expected for April May 2023 effectiveTimes | ||||||
Readme file | April May 2023 dates updated, as expected | ||||||||||
Concept files | 13541010 | 1047 685 records added/updated, plus 307 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 files | 26912863 | 2505 2261 records added/updated, plus 186 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 files | 111865957 | 7189 3647 records added/updated, plus 3997 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 files | 59101 | 53 101 records added/updated, plus 6 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) files | 23491547 | 2038 1218 records added/updated, plus 311 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 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 | 664 | 56
| 4
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 | MRCM AttributeDomain files | 0 | 0 records added/updated as expected | MRCM AttributeRange files | 0 | 0 records added/updated as expected | |||||
MRCM Domain AttributeRange files | 0 | 0 records added/updated as expected | |||||||||
MRCM ModuleScope Domain files | 0 | 0 records added/updated as expected |
MRCM ModuleScope files | 0 | 0 records added/updated as expected |
May 2023 PREPRODUCTION (Version 1 PRE VERSIONING) to May 2023 PRODUCTION (Version
12 POST VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING): https://docs.google.com/spreadsheets/d/1gExRH5ndhBQ929Jt91Sy3IWuQSsg1rUqO1qBC-UdxWu3f2uR0Y0xgtbZaPdZuYqi59e5Db-rti00Dz4mwbSyM/edit#gid=0
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1s6S_tnpC2ZpWoOLxnTfCKOeEQRiAD2moMnumn3xLpBY/edit#gid=2
Differences found in package Comparison
Number of RF2 records impacted
Related JIRA ticket(s)
Rationale
0 records added/updated as expected
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!!
2308 records added/updated, plus
95 inactivated
...as expected as the totals match exactly with Summary Component Stats report
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 files | 551 | 551 new records had their UUID's refreshed, as expected |
April 2023 PRODUCTION (PUBLISHED) to May 2023 PREPRODUCTION
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)
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
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
859 records added/updated, plus
9 records inactivated
Confirmed as matches with:
- "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
3
3 records updated, as expected for April 2023 effectiveTimes
April 2023 dates updated, as expected
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)
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.
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)
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)
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)
0 records updated, plus
0 records inactivated
As expected due to full migration to OWLExpression file in the July 2019 International Edition
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.
0 records added/updated as expected
0 records added/updated as expected
0 records added/updated as expected
0 records added/updated as expected
(Version 1 PRE VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1OfYhGgisopqAGo3WzCvntMUgs6vZ0Bwxl6oeEqJmDtw1FFnCdMS9AcwMXYsck1iAhamF5t2pX1Iw3_mf5X4GQ9Y/edit#gid=0
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1s6S_tnpC2ZpWoOLxnTfCKOeEQRiAD2moMnumn3xLpBY1OqJ7lzsWJone4Ie7W9x5YhpriTD1qV3sQ9YaT9uzxJ4/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 | 14701244 | 1112 851 records added/updated, plus 358 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:
This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats:
Makes a total of:
Which matches ALMOST exactly with the counts I got above from the RF2 files!! | |||
Attribute Value files | 24032269 | 2308 2216 records added/updated, plus 95 53 inactivated ...as expected as the totals match exactly with Summary Component Stats report | |||
Language refset files | 53255798 | 4962 4619 records added/updated, plus 363 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 files | 881363 | 595 177 records added/updated, plus 286 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 1014:20 00 on 14 Apr :
| |||
Simple Refset files | 640 | 6 21 records added/updated, plus 0 19 records inactivated
| |||
SimpleMap files | 868555 | 859 554 records added/updated, plus 9 1 records inactivated Confirmed as matches with:
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 May 2023 effectiveTimes | |||
Readme file | April May 2023 dates updated + Beta "x" prefixes added, as expected | ||||
Concept files | 13541010 | 1047 685 records added/updated, plus 307 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 files | 26912863 | 2505 2261 records added/updated, plus 186 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 files | 111865957 | 7189 3647 records added/updated, plus 3997 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 files | 59101 | 53 101 records added/updated, plus 6 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) files | 23491547 | 2038 1218 records added/updated, plus 311 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 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 | 6064 | 56
| 4
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.. 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 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 |