March 2023 PUBLISHED vs September 2023 Pre-Production (Version 4) traceability
Summary Component Stats report (NL 20230331 - 20230930): https://docs.google.com/spreadsheets/d/1J5G4nZuCp_Fb32IvnLGE-tulJg5UGMGXmF_CgbjpQ7M/edit#gid=0
Summary Component Stats report (INT 20230131 - 20230731):
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| .JSON file | Updated with new fields as planned - looks good | ||
| Readme file | All dates updated, Pre-prod naming conventions added, and x prefixes added, as expected | ||
| ModuleDependency files | ALL | 2 NL records updated + 3 INT records updated with new dates for this cycle, as expected | |
| RefsetDescriptor files | 2 | 2 records added, as expected ????
IS THIS EXPECTED???? | |
| Association files | 6039 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1\t900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!) Next need to search diff file for INT inactive - "0\t900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!) Then need to search diff file for INT active - "1\t900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!) Next need to search diff file for INT inactive - "0\t900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!) 4488 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above) 1638 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus
NL EDITION EFFECTIVETIME 20230930: Getting accurate manual counts: First need to search diff file for NL active - "1\t11000146104", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active NL records that were REMOVED this release in your count!!) Next need to search diff file for NL inactive - "0\t11000146104", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive NL records that were REMOVED this release in your count!!) 220 records added/updated plus 7 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Attribute Value files | 22339 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 11699 records added/updated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!) 327 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus
NL EDITION EFFECTIVETIME 20230930: 8066 records added/updated plus 18 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Language (EN) files | 39312 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 37711 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above) 5541 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus
NL EDITION EFFECTIVETIME 20230930: (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 541 records added/updated plus 189 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Language (NL) files | 64547 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 0 changes as NL only NL EDITION EFFECTIVETIME 20230930: 18768 records added/updated plus 2652 inactivated
+ ???? records added for PFT Language Refset 15551000146102 + + ???? records added for PFT Language Refset 160161000146108
Just need confirmation from the NL in Pre-Prod validation stage...
| |
| ExtendedMap files | 5308 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 4278 records added/updated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!) 1030 records inactivated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!) ################################################################################################################# CAN I COMPARE TO INT SUMMARY STATS????? SO MAYBE DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the MAP files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!! ################################################################################################################# NO KNOWN NL MAPS FOR NOW.... SEND TO NL TO VERIFY ONCE HAVE FINAL VERSION - Just need confirmation from the NL in Pre-Prod validation stage... | |
| Dutch laboratory test method simple reference set (260131000146101) | 0 | 0 changes, as confirmed in MSSP Ticket | |
| Dutch simple reference set for undefined allergens (100491000146109) | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch non-drug allergen simple reference set for Dutch clinical building blocks version 2017 (foundation metadata concept) (42931000146101) | 28 | 26 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Document Type Simple Refset files | 0 | 0 changes, NOT confirmed in MSSP-1905. ?????????????????????? However as they've made such a mess of the other refsets we have no time to address this, and so for this cycle Terance agreed we will just assume that this is correct. | |
Dutch Causes Of Death Statistics Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Contact Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Food Allergen Simple Refset files (98011000146102) | 31 | 29 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Dutch Implant Registry Simple Refset files (52801000146101) | 12 | 12 records added, 0 inactivated, as confirmed in MSSP Ticket | |
Dutch Implants Extensional Simple Refset files | 0 | 0 records added, 0inactivated, as confirmed in MSSP Ticket ??????? SHOULD HAVE BEEN UPDATED ACCORDING TO TICKET - ASKED NL...... FEIKJE CONFIRMED THIS WAS JUST HUMAN ERROR, AND HAS NOW CONFIRMED THAT THIS REFSET SHOULD REMAIN STATIC FOR THIS CYCLE | |
Dutch Implants Intensional Simple Refset files (117721000146102) | 12 | 12 records added, 0 inactivated, as confirmed in MSSP Ticket | |
Dutch Inhalation Allergen Simple Refset files (98021000146107) | 1 | 1 records added, 0 inactivated, as confirmed in MSSP Ticket | |
Dutch Insect Venom Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Mental Health Procedures Simple Refset files (140741000146104) | 2 | 1 records added, 1 inactivated, as confirmed in MSSP Ticket | |
Dutch Microorganism Simple Refset files (2581000146104) | 66 | 20 records added, 46 inactivated, as confirmed in MSSP Ticket | |
Dutch Mixed Flora Finding Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Intervention For Delirium Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Interventions For Fall Risk Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Interventions For Pain Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Interventions For Psychosocial Care Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Interventions For Suicide Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Interventions For Wound Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Intervention Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Observations For Delirium Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Observations For Fall Risk Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Nursing Observations For Suicide Simple Refset files (140971000146107) | 4 | 2 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Dutch Nursing Observation Simple Refset files (140991000146106) | 4 | 2 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Dutch Nursing Problem Simple Refset files (11721000146100) | 4 | 2 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Dutch Obstetric Procedures Simple Refset files (146481000146103) | 1 | 0 records added, 1 inactivated, as confirmed in MSSP Ticket | |
Dutch Occupational Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Optometric Diagnoses Simple Refset files (41000146103) | 4 | 2 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Dutch Optometric Procedures Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Optometric Reason For Visit Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Pathology Simple Refset files (110851000146103) | 25 | 11 records added, 14 inactivated, as confirmed in MSSP Ticket | |
Dutch Radio Allergosorbent Test Result Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Rare Neuromuscular Disorders Simple Refset files (2551000146109) | 2 | 1 records added, 1 inactivated, as confirmed in MSSP Ticket | |
Dutch Ordinal Microbial Susceptibility Test Results Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Causative Pathogens In Congenital Infection Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Causative Pathogens In Sepsis And Meningitis Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Dutch Total Non Drug Allergen Simple Refset files (98061000146100) | 28 | 26 records added, 2 inactivated, as confirmed in MSSP Ticket | |
Netherlands Microscopic Ordinal Test Result Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Netherlands Ordinal Test Result Simple Refset files | 0 | 0 changes, as confirmed in MSSP Ticket | |
Sections Of ETransfer Of Nursing Data Simple Refset files (117701000146105) | 2 | 1 records added, 1 inactivated, as confirmed in MSSP Ticket | |
Dutch Nursing Problems With Sections Of ETransfer Simple Refset files (117711000146107) | 8 | 5 records added, 3 inactivated, as confirmed in MSSP Ticket | |
Simple Refset SNAPSHOT files | 236 | 212 records added/updated (all for 900000000000207008) 24 inactivated Unable to validate without manually totally up all previous 6 months INT release counts | |
| Correlated Extended Map files | 0 | 0 records added, 0 inactivated, as confirmed in MSSP Ticket ALL records to be INACTIVATED, as this ENTIRE REFSET was intended to be inactivated - see comments in the Refsets tab of MSSP-1905 MISSING FROM THIS VERSION!! ASKED NL WHERE THE DELTA FOR THESE INACTIVATIONS ARE - THEY CONFIRMED THAT THIS WAS NEVER ACTUALLY PART OF THE PREVIOUS PUBLISHED PACKAGE, AND THEREFORE THERE'S NO CHANGE REQUIRED HERE | |
| Correlated Map files | 0 | 0 records added, 0 inactivated, as confirmed in MSSP Ticket ++++++++ ACTUAL FORMAT CHANGED: < id effectiveTime active moduleId refsetId referencedComponentId mapTarget snomedCtSourceCodeToTargetMapCodeCorrelationValue See notes in MSSP-1905 ALL records to be ACTIVATED, as this ENTIRE REFSET was intended to replace the now-inactivated refset 31441000146107 - see comments in the Refsets tab of MSSP-1905 MISSING FROM THIS VERSION!! NEED TO ASK NL WHERE THE DELTA FOR THESE INACTIVATIONS ARE??? AGAIN THE COMMENTS IN THIS TICKET ARE NOT ACTUALLY DESCRIBING CHANGES IN THE MAP/REFSETS, BUT JUST IN THE AUTHORING - SO NO IMPACT TO THE RELEASED MAP FILES | |
| SimpleMap files | 4749 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 4736 records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! 13 records inactivated, plus NL EDITION EFFECTIVETIME 20230930: 0 records changed, as nothing for NL in this file This matches the International Edition changes, as looking at the INT Stats report (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) there were 4712 BRAND NEW Concepts added in this NL dependent cycle, and therefore there should have been that many records added for CTV3. + a handful of new/updated records for ICD-0 as expected, gets us to the 4736 number of changes. Therefore this is the expected result, as we never expect to have NL specific changes in this file. | |
| MRCMAttributeRange files | 1 | n/a | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 1 records updated, plus 0 records inactivated, plus 0 new records added, Unable to validate without manually totally up all previous 6 months INT release counts NL EDITION EFFECTIVETIME 20230930: 0 records changed, as NL don't update this file so far |
| MRCMAttributeDomain files | 0 | NL EDITION EFFECTIVETIME 20230930: 0 records updated INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 0 new records added/updated: Unable to validate without manually totally up all previous 6 months INT release counts | |
| MRCMDomain files | 1 | n/a | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 1 records UPDATED, Unable to validate without manually totally up all previous 6 months INT release counts NL EDITION EFFECTIVETIME 20230930: 0 records changed Therefore there are no NL specific changes this cycle ?????????? |
| Concept files | 8362 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 6410 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above) 1650 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus NL EDITION EFFECTIVETIME 20230930: 198 records added/updated plus 103 inactivated
| |
| Description (EN) files | 28070 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 18126 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above) 2795 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus NL EDITION EFFECTIVETIME 20230930: 6960 records added/updated plus 189 inactivated
| |
| Description (NL) files | 21421 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 0 records added/updated NL EDITION EFFECTIVETIME 20230930: 18875 records added/updated plus 2546 inactivated
| |
| Identifier files | n/a | Headers updated in line with new format, as expected (MSSP-2163) < identifierSchemeId alternateIdentifier effectiveTime active moduleId referencedComponentId | |
| Stated Relationship files | 0 | 0 changes as expected! (same as International Edition as well) | |
| Relationship files | 78107 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 44218 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above) 27110 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus NL EDITION EFFECTIVETIME 20230930: 3209 records added plus 3570 inactivated
| |
| Relationship Concrete Values files | 710 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 642 records added/updated, plus as confirmed in new INT only Component Stats Report run by devops - see above 67 records inactivated as confirmed in new INT only Component Stats Report run by devops - see above ...exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (January 2022) NL EDITION EFFECTIVETIME 20230930: 0 records changed Therefore there are no NL specific changes this cycle, as confirmed in the NL Summary Component Stats report above | |
| OwlExpression files | 19164 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 12265 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above) 1662 records inactivated (as confirmed in new INT only Component Stats Report run by devops - see above), plus NL EDITION EFFECTIVETIME 20230930: 574 records added/updated plus 163 inactivated
| |
| TextDefinition (EN) files | 729 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 569 records added/updated (as confirmed in new INT only Component Stats Report run by devops from - see above) 160 records inactivated (as confirmed in new INT only Component Stats Report run by devops from - see above), plus NL EDITION EFFECTIVETIME 20230930: 0 records added/updated plus 0 inactivated
| |
| TextDefinition (NL) files | 157 | INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 0 records added/updated NL EDITION EFFECTIVETIME 20230930: 89 records added/updated plus 68 inactivated
|