May 2023 PRODUCTION (PUBLISHED) to June 2023 PRODUCTION (Version 1 POST VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING): https://docs.google.com/spreadsheets/d/1mOUruag1aRVHCm3IYO1EBH6GBoFlOnTjB97xx5q3wNc/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 | 406 | 288 records added/updated, plus 118 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 ALMOST exactly with the counts I got above from the RF2 files!! | |||||||||
Attribute Value files | 1491 | 1423 records added/updated, plus 68 inactivated ...as expected as the totals match exactly with Summary Component Stats report | |||||||||
Language refset files | 9639 | 8783 records added/updated, plus 856 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 | 976 | 873 records added/updated, plus 103 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 :
| |||||||||
Simple Refset files | 19 | 15 records added/updated, plus 4 records inactivated
| |||||||||
SimpleMap files | 1254 | 1254 records added/updated, plus 0 records inactivated Confirmed as matches with:
| |||||||||
ModuleDependency files | 3 | 3 records updated, as expected for June 2023 effectiveTimes | |||||||||
Readme file | June 2023 dates updated + Beta "x" prefixes added, as expected | ||||||||||
Concept files | 1535 | 1312 records added/updated, plus 222 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 | 4646 | 4218 records added/updated, plus 428 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 | 12108 | 8580 records added/updated, plus 3267 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 | 130 | 127 records added/updated, plus 3 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 | 2174 | 1952 records added/updated, plus 222 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) NO DISCREPANCY ANYMORE!! - 1952 CHANGES EXPECTED IN SCS Report, AND 1952 CAME THROUGH. | |||||||||
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 | 222 | 220 records added/updated, plus 2 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 | 2 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 | |||||||||
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/1mOUruag1aRVHCm3IYO1EBH6GBoFlOnTjB97xx5q3wNc/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 | 1252 | 1252 new records had their UUID's refreshed, as expected |
June 2023 PRODUCTION (PUBLISHED) to
JuneJuly 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/16KQCXc7z01dsFB5fVC0fvJQ9boCJioEQmLpV9ziXaDE19AqljHDnHzgZYqNSngNoxDq15fZ4BbHYr1VjGmxb1NQ/edit#gid=130
SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1lpP165jktWOipmWLYnBtgywa2u9_YIT8_bjVklmrqyQW3odQhtqsf549EU5jIiWVpm-H9LkWHpB87QTZeyrug/edit#gid=02
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:
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 | 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 :
| |||||||||||
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:
| ||||||||||||
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 | 21731217 | 19511118 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) SMALL DISCREPANCY - 1952 CHANGES EXPECTED IN SCS Report, BUT ONLY 1951 CAME THROUGH... checking with Maria - Maria confirmed she was unconcerned with this minor discrepancy, so we can continue as planned. | |||||||||||
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 | 21626 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. 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: 220 records updated, plus 2 records inactivated | |||||||||||
MRCM AttributeDomain files | 0 | 0 records added/updated as expected | ||||||||||||
MRCM AttributeRange files | 60 | 60 records added/updated as expected | , as match exactly with the MRCM report: https://docs.google.com/spreadsheets/d/1fsZB7COM0kPw0NhIbgrkufUeBwPQFrKaG-U8tXzro9I/edit#gid=0:
Jira | ||||||
---|---|---|---|---|---|---|
|
2 records added/updated as expected, as match exactly with the MRCM report: https://docs.google.com/spreadsheets/d/1fsZB7COM0kPw0NhIbgrkufUeBwPQFrKaG-U8tXzro9I/edit#gid=0:
- < 07225f48-d874-403f-a051-d0fa9d2895e2 20200731 1 900000000000012004 723560006 129125009 << 129125009 |Procedure with explicit context (situation)|: [0..0] 408729009 |Finding context| = *, [0..0] 246090004 |Associated finding| = * 243796009 |Situation with explicit context (situation)| << 243796009 |Situation with explicit context (situation)|: [0..0] 408729009 |Finding context| = *, [0..0] 246090004 |Associated finding| = * [[1..*]] 408730004 |Procedure context| = [[+id(<< 288532009 |Context values for act---
> 07225f48-d874-403f-a051-d0fa9d2895e2 20230630 1 900000000000012004 723560006 129125009 << 129125009 |Procedure with explicit context (situation)| 243796009 |Situation with explicit context (situation)| << 243796009 |Situation with explicit context (situation)| [[1..*]] 363589002 |Associated procedure (attribute)| = [[+id(<< 71388002 |Procedure (procedure)|)]] [[+id(<< 243796009 |Situation with explicit context (situation)|)]]: [[1..*]] { [[1..1]] 363589002 |Associated procedure| = [[+id(<< 71388002 |Proce3c3 - < 0b0b9db5-3be5-44e5-86e8-1389756ec245 20200731 1 900000000000012004 723560006 413350009 << 413350009 |Finding with explicit context (situation)|: [0..0] 408730004 |Procedure context| = *, [0..0] 363589002 |Associated procedure| = * 243796009 |Situation with explicit context (situation)| << 243796009 |Situation with explicit context (situation)|: [0..0] 408730004 |Procedure context| = *, [0..0] 363589002 |Associated procedure| = * [[1..*]] 408729009 |Finding context| = [[+id(<< 410514004 |Finding context va---
> 0b0b9db5-3be5-44e5-86e8-1389756ec245 20230630 1 900000000000012004 723560006 413350009 << 413350009 |Finding with explicit context (situation)| 243796009 |Situation with explicit context (situation)| << 243796009 |Situation with explicit context (situation)| [[1..*]] 246090004 |Associated finding (attribute)| = [[+id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)|)]] [[+id(<< 243796009 |Situation with explicit context (situation)|)]]: [[1..*]] { [[1..1]] 246090004 |Associated fin
0 records added/updated as expected
0 records added/updated as expected