September 2024 Pre-Production Release (Version 11) vs November (due to delays getting internal sign off!) 2024 Production Release (Version 12) traceability
View file | ||||
---|---|---|---|---|
|
CONCLUSION: Should be NO Changes as expected ...
Only change is MDRS record getting refreshed with new UUID as expected:
- < bdc64303-3c29-40e9-b54e-a5c25008188a 20240701 1 1237620007 900000000000534007 900000000000207008 20240701 20240701
- > 5631e98a-d635-4b74-90a0-9bad0e692967 20240701 1 1237620007 900000000000534007 900000000000207008 20240701 20240701
September 2024 Pre-Production Release (Version 10) vs September 2024 Pre-Production Release (Version 11) traceability
View file | ||||
---|---|---|---|---|
|
CONCLUSION: Changes as expected -
- Annotations Headers updated as planned:
- The column "languageCode" has been changed to "languageDialectCode".
- Component Annotations (1292992004)
- OLD: id effectiveTime active moduleId refsetId referencedComponentId languageCode typeId value
- NEW: id effectiveTime active moduleId refsetId referencedComponentId languageDialectCode typeId value
- Member Annotations (1292995002)
- OLD: id effectiveTime active moduleId refsetId referencedComponentId referencedMemberId languageCode typeId value
- NEW: id effectiveTime active moduleId refsetId referencedComponentId referencedMemberId languageDialectCode typeId value
- Component Annotations (1292992004)
- The column "languageCode" has been changed to "languageDialectCode".
- New MDRS record had UUID refreshed as expected
May 2024 Pre-Production Release (Version 8) vs September 2024 Pre-Production Release (Version 10) traceability
View file | ||||
---|---|---|---|---|
|
CONCLUSION: Changes as expected - all new Metadata added from INT Edition (with new effectiveTime assigned + EDQM module replacing the original INT module):
- SimpleMap records - NOW HAVE:
- 14 new records + 2 (brand) new records (since the May cycle) +
- 4 records inactivated
- Matches as per Kai's confirmation via email at 09:43 on 5/8/2024
- ModuleDependency record updated with new July date as expected:
> 22c59a9e-821b-423c-8275-3e1a05fd2f10 20240701 1 1237620007 900000000000534007 900000000000207008 20240701 20240701
- Concept records updated with new July date as expected:
> 1237620007 20240701 1 1237620007 900000000000074008 > 1237627005 20240701 1 1237620007 900000000000074008
- Description records updated with new July date as expected:
> 5159420018 20240701 1 1237620007 1237620007 en 900000000000013009 European Directorate for the Quality of Medicines & Healthcare module 900000000000017005 > 5159421019 20240701 1 1237620007 1237620007 en 900000000000013009 EDQM module 900000000000017005 > 5159422014 20240701 1 1237620007 1237620007 en 900000000000003001 European Directorate for the Quality of Medicines & Healthcare module (core metadata concept) 900000000000017005 > 5159423016 20240701 1 1237620007 1237627005 en 900000000000003001 European Directorate for the Quality of Medicines & Healthcare pharmaceutical dose forms to SNOMED CT simple map with correlation reference set (foundation metadata concept) 900000000000017005 > 5159424010 20240701 1 1237620007 1237627005 en 900000000000013009 EDQM pharmaceutical dose forms to SNOMED CT simple map with correlation reference set 900000000000017005 > 5159425011 20240701 1 1237620007 1237627005 en 900000000000013009 European Directorate for the Quality of Medicines & Healthcare pharmaceutical dose forms to SNOMED CT simple map with correlation reference set 900000000000017005
- Language refset records updated with new July date as expected:
> 186157f0-dac6-4a6d-87fb-8d16edd02d49 20240701 1 1237620007 900000000000508004 5159425011 900000000000549004 > 3d2138b3-1631-4b9a-bff1-1c2aaab124bc 20240701 1 1237620007 900000000000509007 5159424010 900000000000548007 > 5f5da9cd-d1f5-425c-a751-0b8353e8f018 20240701 1 1237620007 900000000000508004 5159424010 900000000000548007 > 63f64cdf-80f8-4d74-a046-9b13fff1aabb 20240701 1 1237620007 900000000000509007 5159422014 900000000000548007 > 7061f764-21c6-4c33-80c7-24f8ef6efa1f 20240701 1 1237620007 900000000000508004 5159422014 900000000000548007 > 77208375-f42b-4ed1-b4a1-e1d8f287ae40 20240701 1 1237620007 900000000000508004 5159421019 900000000000548007 > 8e5a1874-aebf-476f-989f-57771cbcfaf4 20240701 1 1237620007 900000000000508004 5159423016 900000000000548007 > 9ae18432-4137-43c3-9308-01a36050b746 20240701 1 1237620007 900000000000509007 5159420018 900000000000549004 > a2f6b14c-8fb9-445d-b2e4-836be149ca50 20240701 1 1237620007 900000000000508004 5159420018 900000000000549004 > b87f73f4-f550-44e0-9011-b1d90068e759 20240701 1 1237620007 900000000000509007 5159421019 900000000000548007 > e20e57c4-f6a7-4358-9161-e7522fdf0421 20240701 1 1237620007 900000000000509007 5159423016 900000000000548007 > ec5e95a9-f311-4930-9703-5fc194d67b79 20240701 1 1237620007 900000000000509007 5159425011 900000000000549004
- Relationship records updated with new July date as expected:
> 15472517029 20240701 1 1237620007 1237620007 900000000000445007 0 116680003 900000000000011006 900000000000451002 > 15472518023 20240701 1 1237620007 1237627005 1193543008 0 116680003 900000000000011006 900000000000451002
- OwlExpression records updated with new July date as expected:
- > 1ae84548-6cd5-4230-b6e6-1b07efff8486 20240701 1 1237620007 733073007 1237620007 SubClassOf(:1237620007 :900000000000445007)
- > 1eb7986c-3c45-489f-b532-8335888ac339 20240701 1 1237620007 733073007 1237627005 SubClassOf(:1237627005 :1193543008)
- BUT
- NO Annotations Header changes as expected!!
OLD JAN CYCLE (still 2024 release though)
May 2024 Pre-Production Release (Version 7) vs May 2024 Pre-Production Release (Version 8) traceability
View file | ||||
---|---|---|---|---|
|
CONCLUSION: Changes as expected - all new Metadata added from INT Edition (with new effectiveTime assigned + EDQM module replacing the original INT module):
- ModuleDependency record:
> 22c59a9e-821b-423c-8275-3e1a05fd2f10 20240101 1 1237620007 900000000000534007 900000000000207008 20240101 20240101
- Concept records:
> 1237620007 20240101 1 1237620007 900000000000074008 > 1237627005 20240101 1 1237620007 900000000000074008
- Description records:
> 5159420018 20240101 1 1237620007 1237620007 en 900000000000013009 European Directorate for the Quality of Medicines & Healthcare module 900000000000017005 > 5159421019 20240101 1 1237620007 1237620007 en 900000000000013009 EDQM module 900000000000017005 > 5159422014 20240101 1 1237620007 1237620007 en 900000000000003001 European Directorate for the Quality of Medicines & Healthcare module (core metadata concept) 900000000000017005 > 5159423016 20240101 1 1237620007 1237627005 en 900000000000003001 European Directorate for the Quality of Medicines & Healthcare pharmaceutical dose forms to SNOMED CT simple map with correlation reference set (foundation metadata concept) 900000000000017005 > 5159424010 20240101 1 1237620007 1237627005 en 900000000000013009 EDQM pharmaceutical dose forms to SNOMED CT simple map with correlation reference set 900000000000017005 > 5159425011 20240101 1 1237620007 1237627005 en 900000000000013009 European Directorate for the Quality of Medicines & Healthcare pharmaceutical dose forms to SNOMED CT simple map with correlation reference set 900000000000017005
- Language refset records:
> 186157f0-dac6-4a6d-87fb-8d16edd02d49 20240101 1 1237620007 900000000000508004 5159425011 900000000000549004 > 3d2138b3-1631-4b9a-bff1-1c2aaab124bc 20240101 1 1237620007 900000000000509007 5159424010 900000000000548007 > 5f5da9cd-d1f5-425c-a751-0b8353e8f018 20240101 1 1237620007 900000000000508004 5159424010 900000000000548007 > 63f64cdf-80f8-4d74-a046-9b13fff1aabb 20240101 1 1237620007 900000000000509007 5159422014 900000000000548007 > 7061f764-21c6-4c33-80c7-24f8ef6efa1f 20240101 1 1237620007 900000000000508004 5159422014 900000000000548007 > 77208375-f42b-4ed1-b4a1-e1d8f287ae40 20240101 1 1237620007 900000000000508004 5159421019 900000000000548007 > 8e5a1874-aebf-476f-989f-57771cbcfaf4 20240101 1 1237620007 900000000000508004 5159423016 900000000000548007 > 9ae18432-4137-43c3-9308-01a36050b746 20240101 1 1237620007 900000000000509007 5159420018 900000000000549004 > a2f6b14c-8fb9-445d-b2e4-836be149ca50 20240101 1 1237620007 900000000000508004 5159420018 900000000000549004 > b87f73f4-f550-44e0-9011-b1d90068e759 20240101 1 1237620007 900000000000509007 5159421019 900000000000548007 > e20e57c4-f6a7-4358-9161-e7522fdf0421 20240101 1 1237620007 900000000000509007 5159423016 900000000000548007 > ec5e95a9-f311-4930-9703-5fc194d67b79 20240101 1 1237620007 900000000000509007 5159425011 900000000000549004
- Relationship records:
> 15472517029 20240101 1 1237620007 1237620007 900000000000445007 0 116680003 900000000000011006 900000000000451002 > 15472518023 20240101 1 1237620007 1237627005 1193543008 0 116680003 900000000000011006 900000000000451002
- OwlExpression records:
> 1ae84548-6cd5-4230-b6e6-1b07efff8486 20240101 1 1237620007 733073007 1237620007 SubClassOf(:1237620007 :900000000000445007) > 1eb7986c-3c45-489f-b532-8335888ac339 20240101 1 1237620007 733073007 1237627005 SubClassOf(:1237627005 :1193543008)
May 2023 Production (PUBLISHED) vs May 2024 Pre-Production Release (Version 7) traceability
View file | ||||
---|---|---|---|---|
|
CONCLUSION: Changes as expected - including addition of Annotations refsets + MedDRA Metadata Components, as planned
EDQM map files match expected changes as provided by KAI in input files ??????????????????????
- 14 new/updated records +
- 4 records inactivated
BUT WE'RE MISSING ALL OF THE EDQM METADATA FROM THE INTERNATIONAL EDITION PACKAGE THAT WE'RE SUPPOSED TO BE INCLUDING FROM NOW ON
HAVE ASKED KAI TO ADD TO THE BRANCH SO WE CAN RE-BUILD..
PREPRODUCTION (May 2023) VERSION 3 vs PRODUCTION (May 2023) VERSION 1 traceability
Differences found in package Comparison
3 brand new records had their UUID's refreshed as expected
2 brand new records had their UUID's refreshed as expected
All x prefixes removed, and Production naming conventions applied as expected
No changes (not even having their UUID's refreshed) as expected, as UUID's etc were versioned in the snowstorm branch before passing to SRS.
ALPHA (December 2022) PUBLISHED vs PREPRODUCTION (May 2023) VERSION 3 traceability
Differences found in package Comparison
3 records updated, just had their UUID's refreshed + effectiveTimes updated to Jan 2023 as expected:
< 103e395c-1851-4807-bda6-954fa26a04b0 20221231 1 1237620007 900000000000456007 1237627005 900000000000505001 900000000000461009 0
< 1c77dece-34c0-47f1-8e6a-79c6763578de 20221231 1 1237620007 900000000000456007 1237627005 1193546000 900000000000461009 2
< 279e15e4-ce00-47ae-9f1b-6d6e96457617 20221231 1 1237620007 900000000000456007 1237627005 900000000000500006 900000000000465000 1
---
> 5a460ef1-4c95-4c5b-963c-853299fb6f92 20230131 1 1237620007 900000000000456007 1237627005 900000000000505001 900000000000461009 0
> a04b731d-cb06-4043-9f41-80866a7734bd 20230131 1 1237620007 900000000000456007 1237627005 1193546000 900000000000461009 2
> c27b5333-cbf4-41e1-add5-9f6c4a094e3c 20230131 1 1237620007 900000000000456007 1237627005 900000000000500006 900000000000465000 1
286 records updated to have their UUID's refreshed + effectiveTimes updated to Jan 2023 as expected.
Plus 24 records added in new, making a total of 310 records in the first Production release Snapshot file.
Looks good initially and all spots checks complete - just need to double check figures with Alejandro...
ModuleDependency files
2 records updated, just had their UUID's refreshed + effectiveTimes updated to Jan 2023 as expected:
< 88bff011-8437-4153-b7ea-53ae8d9bc9b9 20221231 1 1237620007 900000000000534007 900000000000207008 20221231 20221231
< 8d2cbbab-69e8-469f-b888-15495785356e 20221231 1 1237620007 900000000000534007 900000000000012004 20221231 20221231
---
> 7496845b-7d08-4f01-aa12-9a352737f8fb 20230131 1 1237620007 900000000000534007 900000000000012004 20230131 20230131
> 811d5ac6-ecfa-4fae-a435-2e6755ecaed0 20230131 1 1237620007 900000000000534007 900000000000207008 20230131 20230131
Updated with January 2023 INT Edition dependency, plus ALPHA disclaimers removed, as expected.
Package name also updated to new May 2023 date.