September 2022 Production (Version 1) vs September 2022 Production (Version 2) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Correlated Map files | 4 | 2 records inactivated, plus < 3059c377-2d38-22ae-393d-923e2acae8e5 20210331 1 11000146104 148521000146104 147381000146109 78735 447561005 < 6187106f-b126-50fa-4212-14c4ef6eed5d 20210331 1 11000146104 148521000146104 767425002 38474 447557004 2 records added > e11d274e-f9ef-4f13-985b-a6c00fece34e 20220930 1 11000146104 148521000146104 50040111000188102 78735 447558009 As expected due to the Manually curated Delta file uploaded to MSSP-1678 by the NL NRC |
September 2022 Pre-Production (Version 23) vs September 2022 Production (Version 1) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Readme file | All x prefixes removed, and Production naming conventions applied, as expected |
September 2022 Pre-Production (Version 21) vs September 2022 Pre-Production (Version 23) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Description (EN) files | 2 | NL EDITION EFFECTIVETIME 20220930: 0 new records added/updated plus 2 inactivated
As expected, due to fixes Peter confirmed he implemented in order to resolve | |
| Description (NL) files | 0 | ISRS-1318 | 0 changes |
| Language (EN) files | 2 | ISRS-1318 | NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 0 new records added/updated plus 2 inactivated
As expected, due to fixes Peter confirmed he implemented in order to resolve |
| Language (NL) files | 0 | ISRS-1318 | 0 changes |
| ModuleDependency files | 1 | 1x ModuleDependency records re-instated to retain the original UUID:
Manual checks look good now! | |
| AttributeValue files | 2 | ISRS-1318 | 2 new records added:
As expected, due to fixes Peter confirmed he implemented in order to resolve |
September 2022 Pre-Production (Version 21) vs September 2022 Pre-Production (Version 22) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| ModuleDependency files | 2 | Latest Sept 22 fixes REMOVED!!! < 7f102c6c-5419-11e6-94a8-7f8b3d911fe5 20220930 1 11000146104 900000000000534007 900000000000207008 20220930 20220731 This is because the only fixes expected for ISRS-1329 are to fix the validation results, so all we've done by running this test against the NLFIX-16 branch is to lose the latest fixes in Version 21 that are on the Project branch (NLFIX)! |
September 2022 Pre-Production (Version 18) vs September 2022 Pre-Production (Version 21) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Description (EN) FULL + SNAPSHOT files | 249 | ISRS-1333 | NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 0 new records added/updated plus 249 records removed completely, as per fixes implemented in ISRS-1333 RVF assertion now clean as well, as planned:
|
September 2022 Pre-Production (Version 17) vs September 2022 Pre-Production (Version 18) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Description (EN) FULL file | 2 | ISRS-1338 | NL EDITION EFFECTIVETIME 20220930: 0 new records added/updated plus 2 inactivated
As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338 |
| Language (EN) FULL file | 2 | ISRS-1338 | NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 0 new records added/updated plus 2 inactivated
As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338 |
| Description (EN) SNAPSHOT file | 2 | ISRS-1338 | NL EDITION EFFECTIVETIME 20220930: 0 new records added/updated plus 2 inactivated
As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338 |
| Language (EN) SNAPSHOT file | 2 | ISRS-1338 | NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 0 new records added/updated plus 2 inactivated
As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338 |
| Language (NL) FULL file | 0 | ISRS-1338 | 0 changes |
| Language (NL) SNAPSHOT file | 0 | ISRS-1338 | 0 changes |
| ModuleDependency FULL file | 2 |
NEED TO MANUALLY CHECK MODULEDEPENDENCY FILES ARE ALL CORRECT NOW!!! NOT CORRECT YET!! Not picking up the previous record and retaining the UUID!!! Raised ISRS-1340 to fix ASAP... | |
| ModuleDependency SNAPSHOT files | ALL |
NEED TO MANUALLY CHECK MODULEDEPENDENCY FILES ARE ALL CORRECT NOW!!! NOT CORRECT YET!! Not picking up the previous record and retaining the UUID!!! Raised ISRS-1340 to fix ASAP... | |
| AttributeValue files | 2 | ISRS-1338 | 2 new records added:
As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338 |
| OWL Axiom files | 1 | ISRS-1338 | 1 record inactivated:
As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338 |
September 2022 Pre-Production (Version 14) vs September 2022 Pre-Production (Version 17) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| RefsetDescriptor files | 4 | Final issues resolved, as 4 duplicate records removed as part of fixes in ISRS-1339:
This just leaves the following 2 records in the new refsetDescriptor Snapshot file for these two new refsets, as expected:
|
March 2022 Published FIXED vs September 2022 Pre-Production (Version 14) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale | |||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Readme file added!!???!!!! | > ./Readme_en_20220331.txt This can be ignored, it's just because we must have accidentally removed the Readme file from the "FIXED" PreviouslyPublishedPackage! | |||||||||||||||||||||||||||||||||||||
| .JSON file | Updated with new fields as planned - looks good | |||||||||||||||||||||||||||||||||||||
| ModuleDependency files | ALL | 2 new NL records added + 1 record udpated:
+ 3 INT records updated:
NEED TO MANUALLY CHECK MODULEDEPENDENCY FILES ARE ALL CORRECT NOW!!! NOT CORRECT YET!! Not picking up the previous record and retaining the UUID!!! Raised ISRS-1340 to fix ASAP... | ||||||||||||||||||||||||||||||||||||
| RefsetDescriptor files | 16 | 16 records added, as expected from new NL Refsets being added this cycle (MSSP-1678):
HOWEVER, THE RECORDS ABOVE ARE DUPLICATED??? NEED TO MANUALLY EDIT THIS FILE??? RAISED FRI-519 TO TRY TO GET IT FIXED QUICKLY... Also as expected from new NL PFT refsets added this cycle: > 47afffa8-96ac-4978-aca6-e8cec0fd07fc 20220930 1 11000146104 900000000000456007 15551000146102 900000000000510002 900000000000462002 0 As expected from all INT changes between Feb - July 2022:
| ||||||||||||||||||||||||||||||||||||
| Association files | 9085 | INTERNATIONAL EFFECTIVETIME 20220731 (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 900000000000012004", 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 900000000000012004", 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!!) 4731 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 1499 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above)
NL EDITION EFFECTIVETIME 20220930: 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!!) 2841 records added/updated plus 9 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | ||||||||||||||||||||||||||||||||||||
| Attribute Value files | 26889 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 1304 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 16664 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!)
NL EDITION EFFECTIVETIME 20220930: 8696 records added/updated plus 225 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | ||||||||||||||||||||||||||||||||||||
| Language (EN) files | 58241 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 7594 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 49076 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above)
NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 1250 records added/updated plus 321 inactivated
Just need confirmation from the NL in Pre-Prod validation stage...
So the figures look about right (impossible to reconcile exactly because of number of updated confusing both other totals), but best thing is none of the new totals (-en + -nl) are less than the original counts, so we've just added to the original totals, which is as expected | ||||||||||||||||||||||||||||||||||||
| Language (NL) files | 28663 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 0 changes as NL only NL EDITION EFFECTIVETIME 20220930: 14454 records added/updated plus 4367 inactivated
+ 9307 records added for PFT Language Refset 15551000146102 + + 535 records added for PFT Language Refset 160161000146108
Just need confirmation from the NL in Pre-Prod validation stage...
| ||||||||||||||||||||||||||||||||||||
| ExtendedMap files | 4253 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 4249 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!) 1855 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 Causative Pathogens In Sepsis And Meningitis Simple Refset (210041000146107) | 24 | MSSP-1678 | 24 new records added for this brand new refset. New files added for this new refset, as expected due to request in MSSP-1678
| |||||||||||||||||||||||||||||||||||
| Dutch Causative Pathogens In Congenital Infection Simple Refset (210051000146105) | 7 | MSSP-1678 | 7 new records added for this brand new refset. New files added for this new refset, as expected due to request in MSSP-1678
| |||||||||||||||||||||||||||||||||||
Document Type Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Causes Of Death Statistics Simple Refset files | 2 | 2 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Non Drug Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Contact Allergen Simple Refset files | 5 | 3 records added, 2 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Food Allergen Simple Refset files | 3 | 1 records added, 2 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Implant Registry Simple Refset files | 13 | 13 records added, 0 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Implants Extensional Simple Refset files | 14 | 0 records added, 14 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Implants Intensional Simple Refset files | 13 | 13 records added, 0 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Inhalation Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Insect Venom Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Mental Health Procedures Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Microorganism Simple Refset files | 30 | 25 records added, 5 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Mixed Flora Finding Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Intervention For Delirium Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Interventions For Fall Risk Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Interventions For Pain Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Interventions For Psychosocial Care Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Interventions For Suicide Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Interventions For Wound Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Intervention Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Observations For Delirium Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Observations For Fall Risk Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Observations For Suicide Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Observation Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Problem Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Obstetric Procedures Simple Refset files | 2 | 1 records added, 1 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Occupational Allergen Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Optometric Diagnoses Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Optometric Procedures Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Optometric Reason For Visit Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Pathology Simple Refset files | 50 | 23 records added, 27 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Radio Allergosorbent Test Result Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Rare Neuromuscular Disorders Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Ordinal Microbial Susceptibility Test Results Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Causative Pathogens In Congenital Infection Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Causative Pathogens In Sepsis And Meningitis Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Total Non Drug Allergen Simple Refset files | 8 | 4 records added, 4 inactivated, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Netherlands Microscopic Ordinal Test Result Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Netherlands Ordinal Test Result Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Sections Of ETransfer Of Nursing Data Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Dutch Nursing Problems With Sections Of ETransfer Simple Refset files | 0 | 0 changes, as confirmed in MSSP-1678 | ||||||||||||||||||||||||||||||||||||
Simple Refset SNAPSHOT files | 472 | 442 records added/updated (all for 900000000000207008) 30 inactivated As expected when add up all Feb - July 2022 INT changes for Simple Refset files BUT ZERO REMOVED AS EXPECTED, AS ONLY CONTAIN DIFFERENCES BETWEEN REFSET FILES FOR SEPT 2022 CHANGES, AS I MANUALLY ADDED PREVIOUSLY PUBLISHED REFSETS TO THIS FIXED MARCH PACKAGE - SO We're COMPARING AGAINST "FIXED" PreviouslyPublishedPackage, WHERE I'VE ALREADY SPLIT OUT NL REFSETS INTO SEPARATE FILES! | ||||||||||||||||||||||||||||||||||||
Simple Refset FULL files | 472 | 442 records added/updated (all for 900000000000207008) 30 inactivated As expected when add up all Feb - July 2022 INT changes for Simple Refset files BUT ZERO REMOVED AS EXPECTED, AS ONLY CONTAIN DIFFERENCES BETWEEN REFSET FILES FOR SEPT 2022 CHANGES, AS I MANUALLY ADDED PREVIOUSLY PUBLISHED REFSETS TO THIS FIXED MARCH PACKAGE - SO We're COMPARING AGAINST "FIXED" PreviouslyPublishedPackage, WHERE I'VE ALREADY SPLIT OUT NL REFSETS INTO SEPARATE FILES! | ||||||||||||||||||||||||||||||||||||
| Correlated Extended Map files | 0 | 0 records added as expected, as these files are agreed to remain static from last published release (see confirmation from NL NRC in MSSP-1678) | ||||||||||||||||||||||||||||||||||||
| Correlated Map files | 0 | 0 records added as expected, as these files are agreed to remain static from last published release (see confirmation from NL NRC in MSSP-1678) | ||||||||||||||||||||||||||||||||||||
| SimpleMap files | 5234 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2 records inactivated, plus 5232 records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! NL EDITION EFFECTIVETIME 20220930: 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 5214 BRAND NEW Concepts added in this NL dependent cycle, and therefore there should have been 5214 records added for CTV3. + a handful of new/updated records for ICD-0 as expected, gets us to the 5234 number of changes. Therefore this is the expected result, as we never expect to have NL specific changes in this file. | ||||||||||||||||||||||||||||||||||||
| MRCMAttributeRange files | 3 | n/a | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2 records updated, plus 0 records inactivated, plus 1 new records added, These match! As they're exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (July 2022) Confirmed this NL Edition is based on the July 2022 INT Edition, and therefore as there were no MRCM changes between Feb + June 2022 monthly releases, the ONLY MRCM changes in this Sept 2022 NL Edition are expected to be those in the July 2022 release - therefore this is as expected NL EDITION EFFECTIVETIME 20220930: 0 records changed, as NL don't update this file so far | |||||||||||||||||||||||||||||||||||
| MRCMAttributeDomain files | 5 | NL EDITION EFFECTIVETIME 20220930: 0 records updated INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 1 new records added:
Plus 2 records updated:
Plus 2 records inactivated:
These match! As they're exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (July 2022) Confirmed this NL Edition is based on the July 2022 INT Edition, and therefore as there were no MRCM changes between Feb + June 2022 monthly releases, the ONLY MRCM changes in this Sept 2022 NL Edition are expected to be those in the July 2022 release - therefore this is as expected | ||||||||||||||||||||||||||||||||||||
| MRCMDomain files | 4 | n/a | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 4 records UPDATED, These match! As they're exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (July 2022) Confirmed this NL Edition is based on the July 2022 INT Edition, and therefore as there were no MRCM changes between Feb + June 2022 monthly releases, the ONLY MRCM changes in this Sept 2022 NL Edition are expected to be those in the July 2022 release - therefore this is as expected NL EDITION EFFECTIVETIME 20220930: 0 records changed Therefore there are no NL specific changes this cycle ?????????? | |||||||||||||||||||||||||||||||||||
| Concept files | 9929 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2696 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 6711 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 388 records added/updated plus 134 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | ||||||||||||||||||||||||||||||||||||
| Description (EN) files | 27796 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 3857 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 22153 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 1430 records added/updated plus 330 inactivated
So the figures look about right (impossible to reconcile exactly because of number of updated confusing both other totals), but best thing is none of the new totals (-en + -nl) are less than the original counts, so we've just added to the original totals, which is as expected | ||||||||||||||||||||||||||||||||||||
| Description (NL) files | 20732 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 0 records added/updated NL EDITION EFFECTIVETIME 20220930: 16408 records added/updated plus 4319 inactivated
| ||||||||||||||||||||||||||||||||||||
| Stated Relationship files | 0 | 0 changes as expected! (same as International Edition as well) | ||||||||||||||||||||||||||||||||||||
| Relationship files | 92172 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 33557 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 50072 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 4213 records added plus 4330 inactivated
| ||||||||||||||||||||||||||||||||||||
| Relationship Concrete Values files | 2799 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2392 records updated, plus as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above 407 records inactivated as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above ...exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (January 2022) NL EDITION EFFECTIVETIME 20220930: 0 records changed Therefore there are no NL specific changes this cycle, as confirmed in the NL Summary Component Stats report above | ||||||||||||||||||||||||||||||||||||
| OwlExpression files | 17927 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2708 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 13635 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 1047 records added/updated plus 537 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | ||||||||||||||||||||||||||||||||||||
| TextDefinition (EN) files | 1103 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 36 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 1066 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 1 records added/updated plus 0 inactivated
So the figures look about right (impossible to reconcile exactly because of number of updated confusing both other totals), but best thing is none of the new totals (-en + -nl) are less than the original counts, so we've just added to the original totals, which is as expected | ||||||||||||||||||||||||||||||||||||
| TextDefinition (NL) files | 4354 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 0 records added/updated NL EDITION EFFECTIVETIME 20220930: 4331 records added/updated plus 23 inactivated
|
March 2022 Published ORIGINAL vs September 2022 Pre-Production (Version 13) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Simple Refset file (SNAPSHOT) | SHOULD SHOW ALL REFSET FILES AS BRAND NEW, AS THEY USED TO BE COMBINED INTO THE ONE SIMPLEREFSET FILE IN THIS ORIGINAL PUBLISHED PACKAGE... records removed, and manually added into new separate Refset files instead | ||
| Simple Refset file (FULL) | SHOULD SHOW ALL REFSET FILES AS BRAND NEW, AS THEY USED TO BE COMBINED INTO THE ONE SIMPLEREFSET FILE IN THIS ORIGINAL PUBLISHED PACKAGE... records removed, and manually added into new separate Refset files instead |
September 2022 Pre-Production (Version 12) vs September 2022 Pre-Production (Version 13) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Simple Refset file (SNAPSHOT) | 18103 records removed, and manually added into new separate Refset files instead BUT WHY NO NEW RECORDS ADDED (as I also added Delta files to S3) - NEED TO RUN COMPARISON TO ORIGINAL MARCH 2022 PreviousPublishedPackage instead.... | ||
| Simple Refset file (FULL) | 22527 records removed, and manually added into new separate Refset files instead BUT WHY NO NEW RECORDS ADDED (as I also added Delta files to S3) - NEED TO RUN COMPARISON TO ORIGINAL MARCH 2022 PreviousPublishedPackage instead.... | ||
| Readme file | 82 records added for Full + Snapshot files for 41 refset files added (separated out from previousPublishedPackages which combined them all into one SimpleRefset file!! > xder2_Refset_DocumentTypeSimpleRefsetFull_NL1000146_20220930.txt |
September 2022 Pre-Production (Version 11) vs September 2022 Pre-Production (Version 12) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Readme file | Complex maps added as expected: > xder2_scRefset_CorrelatedMapTypeReferenceSetFull_NL1000146_20220930.txt | ||
| Correlated Extended Map files | ALL | 315 records added as expected, as these files are added as new to this version of the PreProd release, BUT have been agreed to remain static from last published release (see confirmation from NL NRC in MSSP-1678) - so these new records are all historical | |
| Correlated Map files | ALL | 858 records added as expected, as these files are added as new to this version of the PreProd release, BUT have been agreed to remain static from last published release (see confirmation from NL NRC in MSSP-1678) - so these new records are all historical |
September 2022 Pre-Production (Version 10) vs September 2022 Pre-Production (Version 11) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| Complex Map files (x2) | NEITHER of the two new Complex map files that I added to the Manifest have been added to the package?!! I added the files to the NLFIX repo in S3 as well, but nothing came through Need to investigate and resolve... | ||
| ModuleDependency SNAPSHOT files | 16 | 16 invalid (different UUID's) records removed: < 0b4e1466-2c3f-9f32-41bb-d3da113da1e0 20220331 1 11000146104 900000000000534007 900000000000207008 20220331 20220131 Plus 1 correct record (Snapshot for latest status) replaced them: > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5 20220331 1 11000146104 900000000000534007 900000000000207008 20220331 20220131 | |
| ModuleDependency FULL files | 16 | 16 invalid (different UUID's) records removed: < 0b4e1466-2c3f-9f32-41bb-d3da113da1e0 20220331 1 11000146104 900000000000534007 900000000000207008 20220331 20220131 Plus 16 correct records replaced them: > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5 20140731 1 11000146104 900000000000534007 900000000000207008 20140731 20140731 |
September 2022 Pre-Production (Version 8) vs September 2022 Pre-Production (Version 10) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| ModuleDependency files | ALL | HOWEVER, THERE APPEARS TO BE A MUCH BIGGER PROBLEM HERE, AS TERMMED HAVE SCREWED UP THE MDRS FILE IN PREVIOUS RELEASES, BY INCLUDING ALL THE INTERIM RECORDS IN THE SNAPSHOT AS WELL AS THE FULL FILE, BY NOT RETAINING THE UUID's!!! (eg)
SO I NEED TO a) Check if I can fix this by adding in all the interim records with the same UUID's, then REMOVING THE OLD INVALID RECORDS!! b) If I can achieve this somehow, I'll need to GO BACK TO NL TO CONFIRM THAT THEY'RE HAPPY WITH THIS SOLUTION AS IT'S TECHNICALLY CHANGING HISTORY WHICH WE DON'T NORMALLY ALLOW!!... | |
| ModuleDependency files | 1 | FRI-515 - Getting issue details... STATUS | 1 record removed, as planned in order to resolve FRI-515:
|
| RefsetDescriptor files | 7 | FRI-514 - Getting issue details... STATUS | NL EDITION EFFECTIVETIME 20220930: 7 records removed intentionally, in order to resolve the issues in FRI-514 - Getting issue details... STATUS :
AS DISCOVERED IN Version 8 these were DUPLICATE RECORDS which we reported in FRI-514:
So now looking good, as for these PFT Lang Refsets (160161000146108 + 15551000146102), the final records remaining in version 10 are now:
As expected, therefore issue is resolved - no further refsetDescriptor changes expected this NL cycle. |
September 2022 Pre-Production (Version 7) vs September 2022 Pre-Production (Version 8) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| .JSON file | Added into new package including NL refsets from previous published package (plus new PFT lang refsets): "id" : "31000146106", As confirmed in the Readme file: > release_package_information.json | ||
| Language (NL) files (both Full + Snapshot) | 9842 | 9307 records added for PFT Language Refset 15551000146102 + 535 records added for PFT Language Refset 160161000146108
|
March 2022 (PUBLISHED BY TERMMED (BEFORE TRANSITION TO MANAGED SERVICE!)) vs September 2022 Pre-Production (Version 7) traceability
Summary Component Stats report (NL 20220301 - 20220901): https://docs.google.com/spreadsheets/d/1g1fekgqvJoaos5TBtwNlNe8D5BYyU4qdDsLZGnd350o/edit#gid=0
Summary Component Stats report (INT 20220131 - 20220731): https://docs.google.com/spreadsheets/d/1UV2VSa5fxO3heLYIcOtDu70M850Ob57cgHa2Hs9rLKc/edit#gid=13
Differences found in package Comparison | Number of RF2 records impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| .JSON file | Missing from new package! Need to add in including NL refsets from previous published package: "id" : "31000146106", | ||
| ExtendedMap files | 7104 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for ICD-10 (INT) - "1 449080006", 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 ICD-10CM records that were REMOVED this release in your count!!) Next need to search diff file for ICD-10 (INT) - "0 449080006", 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 ICD-10CM records that were REMOVED this release in your count!!) Then need to search diff file for INT active - "1 900000000000012004", 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 900000000000012004", 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!!) 4249 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!) 1855 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... | |
| ModuleDependency files | ALL | 2 new NL records added + 1 record udpated:
+ 3 INT records updated:
HOWEVER, THERE APPEARS TO BE A MUCH BIGGER PROBLEM HERE, AS TERMMED HAVE SCREWED UP THE MDRS FILE IN PREVIOUS RELEASES, BY INCLUDING ALL THE INTERIM RECORDS IN THE SNAPSHOT AS WELL AS THE FULL FILE, BY NOT RETAINING THE UUID's!!! (eg)
SO I NEED TO a) Check if I can fix this by adding in all the interim records with the same UUID's, then REMOVING THE OLD INVALID RECORDS!! b) If I can achieve this somehow, I'll need to GO BACK TO NL TO CONFIRM THAT THEY'RE HAPPY WITH THIS SOLUTION AS IT'S TECHNICALLY CHANGING HISTORY WHICH WE DON'T NORMALLY ALLOW!!... | |
| Association files | 9085 | INTERNATIONAL EFFECTIVETIME 20220731 (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 900000000000012004", 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 900000000000012004", 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!!) 4731 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 1499 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above)
NL EDITION EFFECTIVETIME 20220930: 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!!) 2841 records added/updated plus 9 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Attribute Value files | 10954 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1 900000000000207008", 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 900000000000207008", 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 900000000000012004", 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 900000000000012004", 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!!) 1304 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 16664 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!)
NL EDITION EFFECTIVETIME 20220930: 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!!) 8696 records added/updated plus 225 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| RefsetDescriptor files | 23 | FRI-514 - Getting issue details... STATUS | NL EDITION EFFECTIVETIME 20220930: 17 records added:
THESE REFSETS DON'T APPEAR TO BE VALID CONCEPTID's - CAN'T FIND THEM ANYWHERE IN THE "All Editions" Browser?!!
HOWEVER, THEY ARE INCLUDED IN THE MSSP TICKET () AS "New Refsets to be added in this NL cycle"!! 210041000146107 Dutch simple reference set of causative pathogens in sepsis and meningitis So I need to ask the NL NRC to provide the refsets to add into the Release Package... THESE ARE ALL NL PATIENT FRIENDLY REFSET (15551000146102) RECORDS - SHOULD THESE BE INCLUDED? YES RDA confirmed on 9/9/22 that the PFT Language refsets should all be included, so the refsetDescriptor file is correct - we just need to fix the manifest to include the Language refset records in the release package...
BUT 3x DUPLICATE RECORDS INCLUDED FOR SOME REASON?!! RAISED FRI-514 - Getting issue details... STATUS ..... THESE ARE ALL NL PATIENT FRIENDLY REFSET (160161000146108) RECORDS - SHOULD THESE BE INCLUDED? YES RDA confirmed on 9/9/22 that the PFT Language refsets should all be included, so the refsetDescriptor file is correct - we just need to fix the manifest to include the Language refset records in the release package...
BUT 4x DUPLICATE RECORDS INCLUDED FOR SOME REASON?!! RAISED FRI-514 - Getting issue details... STATUS ..... Only way to validate this is by manually going back through the past 6 months' worth of dependent INT Edition Traceability matrices, and checking the changes match! ***** THESE RECORDS MATCH THE PRODUCTION INTERNATIONAL EDITION CHANGES FOR THE MONTHLY RELEASES BETWEEN THE DEPENDENT INT EDITION RELEASES (20220228 - 20220630) - the changes above are identical to those INT changes made in the 20220228 INT Edition release, as requested by Linda (see International Edition Traceability matrix (February 2022)). NOTE - whilst the inactivation records are identical, the UUID of the new replacement record is different from the first INT Edition build (PreProd version 9), but thankfully this UUID was refreshed in the final Feb 2022 Prod release (version 1), and matched the one above. There were no other refsetDescriptor changes between 20220228 - 20220630, so the above changes are valid and expected. |
| Readme file | n/a | Readme file added as wasn't in previous Published Package at all! | |
| SimpleMap files | 5234 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2 records inactivated, plus 5232 records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! NL EDITION EFFECTIVETIME 20220930: 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 5214 BRAND NEW Concepts added in this NL dependent cycle, and therefore there should have been 5214 records added for CTV3. + a handful of new/updated records for ICD-0 as expected, gets us to the 5234 number of changes. Therefore this is the expected result, as we never expect to have NL specific changes in this file. | |
| Simple refset files | 796 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1 900000000000207008", 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 900000000000207008", 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 900000000000012004", 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 900000000000012004", 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!!) 30 records inactivated, plus 766 records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly Lateralizable counts! ################################################################################################################# SO MAYBE DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the Simple files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!! ################################################################################################################# NL EDITION EFFECTIVETIME 20220930: 0 records changed as nothing for NL in this file
| |
| Concept files | 11439 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1 900000000000207008", 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!!) First need to search diff file for INT active - "1 900000000000012004", 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 900000000000207008", 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!!) Next need to search diff file for INT inactive - "0 900000000000012004", 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!!) 2696 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 6711 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 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!!) 388 records added/updated plus 134 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Description (EN) files | 31988 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): First need to search diff file for INT active - "1 900000000000207008", 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!!) First need to search diff file for INT active - "1 900000000000012004", 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 900000000000207008", 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!!) Next need to search diff file for INT inactive - "0 900000000000012004", 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!!) 3857 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 22153 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 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!!) 1430 records added/updated plus 330 inactivated ***** AS EXPECTED TO HAVE NL MODULE DESCRIPTIONS IN DESCRIPTION EN FILE??? (check internally first as we're the ones who split out the EN + NL files!!) *****
| |
| Description (NL) files | 25248 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 0 records added/updated NL EDITION EFFECTIVETIME 20220930: 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!!) 16408 records added/updated plus 4319 inactivated
| |
| OwlExpression files | 26597 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1 900000000000207008", 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!!) First need to search diff file for INT active - "1 900000000000012004", 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 900000000000207008", 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!!) Next need to search diff file for INT inactive - "0 900000000000012004", 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!!) 2708 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 13635 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 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!!) 1047 records added/updated plus 537 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Stated Relationship files | 0 | 0 changes as expected! (same as International Edition as well) | |
| Relationship files | 90078 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1 900000000000207008", 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!!) First need to search diff file for INT active - "1 900000000000012004", 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 900000000000207008", 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!!) Next need to search diff file for INT inactive - "0 900000000000012004", 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!!) 33557 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 50072 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 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!!) 4213 records added plus 4330 inactivated
| |
| Relationship Concrete Values files | 2799 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): Getting accurate manual counts: First need to search diff file for INT active - "1 900000000000207008", 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 900000000000207008", 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!!) 2392 records updated, plus as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above 407 records inactivated as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above ...exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (January 2022) NL EDITION EFFECTIVETIME 20220930: 0 records changed Therefore there are no NL specific changes this cycle, as confirmed in the NL Summary Component Stats report above | |
| TextDefinition (EN) files | 1103 | n/a | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): First need to search diff file for INT active - "1 900000000000207008", 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 900000000000207008", 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!!) 36 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 1066 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) NL EDITION EFFECTIVETIME 20220930: 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!!) 1 records added/updated plus ***** WHY HAS THIS TEXTDEFINITION RECORD BEEN ADDED TO THE NL MODULE RATHER THAN INTERNATIONAL? (given that the term is in English) - INTENTIONAL ????? ***** 0 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... |
| TextDefinition (NL) files | 4354 | n/a | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 0 records added/updated NL EDITION EFFECTIVETIME 20220930: 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!!) 4331 records added/updated plus 23 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... |
| Language (EN) files | 63305 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): First need to search diff file for INT active - "1 900000000000207008", 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!!) First need to search diff file for INT active - "1 900000000000012004", 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 900000000000207008", 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!!) Next need to search diff file for INT inactive - "0 900000000000012004", 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!!) 7594 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus 49076 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above)
NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions: 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!!) 1250 records added/updated plus 321 inactivated
Just need confirmation from the NL in Pre-Prod validation stage... | |
| Language (NL) files | 19093 | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 0 changes as NL only NL EDITION EFFECTIVETIME 20220930: 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!!) 14454 records added/updated plus 4367 inactivated
**** BUT NO MENTION OF EITHER THE
THESE ARE ALL NL PATIENT FRIENDLY REFSET (15551000146102 + 160161000146108) RECORDS - SHOULD THESE BE INCLUDED? YES RDA confirmed on 9/9/22 that the PFT Language refsets should all be included, so the refsetDescriptor file is correct - we just need to fix the manifest to include the Language refset records in the release package... Just need confirmation from the NL in Pre-Prod validation stage... | |
| MRCMAttributeDomain files | 5 | NL EDITION EFFECTIVETIME 20220930: 0 records updated INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 1 new records added:
Plus 2 records updated:
Plus 2 records inactivated:
These match! As they're exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (July 2022) Confirmed this NL Edition is based on the July 2022 INT Edition, and therefore as there were no MRCM changes between Feb + June 2022 monthly releases, the ONLY MRCM changes in this Sept 2022 NL Edition are expected to be those in the July 2022 release - therefore this is as expected | |
| MRCMAttributeRange files | 3 | n/a | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 2 records updated, plus 0 records inactivated, plus 1 new records added, These match! As they're exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (July 2022) Confirmed this NL Edition is based on the July 2022 INT Edition, and therefore as there were no MRCM changes between Feb + June 2022 monthly releases, the ONLY MRCM changes in this Sept 2022 NL Edition are expected to be those in the July 2022 release - therefore this is as expected NL EDITION EFFECTIVETIME 20220930: 0 records changed, as NL don't update this file so far |
| MRCMDomain files | 4 | n/a | INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!): 4 records UPDATED, These match! As they're exactly the same as with the International editing cycle. See here for confirmation: International Edition Traceability matrix (July 2022) Confirmed this NL Edition is based on the July 2022 INT Edition, and therefore as there were no MRCM changes between Feb + June 2022 monthly releases, the ONLY MRCM changes in this Sept 2022 NL Edition are expected to be those in the July 2022 release - therefore this is as expected NL EDITION EFFECTIVETIME 20220930: 0 records changed Therefore there are no NL specific changes this cycle ?????????? |