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
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 | 23082216 records added/updated, plus | 95 53 inactivated ...as expected as the totals match exactly with Summary Component Stats report | ||||||||||
Language refset files | 53255798 | 49624619 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 | 595177 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 :
| 1
| 594
| 1
| 285
| |||
Simple Refset files | 640 | 621 records added/updated, plus | 0 19 records inactivated
| ||||||||||
SimpleMap files | 868555 | 859554 records added/updated, plus | 9 1 records inactivated Confirmed as matches with:
| 853
| 6
| 9
| 09
| 54
| 14 Apr
| 0
| 6
| 9
| |
ModuleDependency files | ModuleDependency files | 3 | 3 records updated, as expected for | April May 2023 effectiveTimes | |||||||||
Readme file | AprilMay 2023 dates updated, as expected | ||||||||||||
Concept files | 13541010 | 1047685 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 | 25052261 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 | 71893647 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 | 53101 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 | 20381218 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 | DomainAttributeRange files | 0 | 0 records added/updated as expected | ||||||||||
MRCM | ModuleScopeDomain 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/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
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 |
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
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
551 new records had their UUID's refreshed, as expected |
April 2023 PRODUCTION (PUBLISHED) to May 2023 PREPRODUCTION (
April 2023 PRODUCTION (PUBLISHED) to May 2023 PRODUCTION (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 files | 0 | 0 records added/updated as expected | ||||||||||
Association Reference files | 1244 | 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:
| 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 | 2269 | 2216 records added/updated, plus 53 inactivated ...as expected as the totals match exactly with Summary Component Stats report | ||||||||||
Language refset files | 5798 | 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 files | 363 | 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 | 1014: | 20 00 on | 14 Apr :
| 1
| 594
| 1
| 285
| |||
Simple Refset files | 40 | 21 records added/updated, plus 19 records inactivated
| ||||||||||
SimpleMap files | 555 | 554 records added/updated, plus 1 records inactivated Confirmed as matches with:
| 853
| 6
| 9
| 09
| 54
| 14 Apr
| 0
| 6
| +
| |
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 files | 1010 | 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 files | 2863 | 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 files | 62575957 | 3647 records added/updated, plus | 2610 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 | 101 | 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) files | 1547 | 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 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 | 64 |
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 |