May 2023 PRODUCTION (PUBLISHED) to June 2023 PRODUCTION (Version 2 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 - INFRA-11149Getting issue details... STATUS raised to fix the MRCM report (as Maria confirmed this is a new issue) | |
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 2 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 |
May 2023 PRODUCTION (PUBLISHED) to June 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability
SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/16KQCXc7z01dsFB5fVC0fvJQ9boCJioEQmLpV9ziXaDE/edit#gid=13
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 | 2173 | 1951 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) 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 | 222 | 216 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. 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 | 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 - INFRA-11149Getting issue details... STATUS raised to fix the MRCM report (as Maria confirmed this is a new issue) | |
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 |