SNOMED International Release Management

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Andrew Atkinson

Saved on

compared with

New Version 2

changes.mady.by.user Andrew Atkinson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

April 2022 Production (PUBLISHED) vs October 2022 PreProduction (version 1) traceability 

Summary Component Stats report:  https://docs.google.com/spreadsheets/d/1_TRKc-p_GlY8N3t2wNHvoZCeP68ilsF5aiRZcVekjyw/edit#gid=0

9292 :  

https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

34273427 0 :  https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=022

> 77eb3095-93d3-41d6-9d33-ed71fb184ee1 20220415 1 51000202101 900000000000456007 47351000202107 900000000000510002 900000000000462002

> 78be0ae0-dfee-4f0d-b540-e1bb6a396128 20220415 1 51000202101 900000000000456007 47351000202107 900000000000511003 900000000000461009

April 2022 records added 20211015 1 51000202101 900000000000534007 900000000000012004 20211015 20210731
> 1d64b026-d4c9-4605-896f-d09049aacad3 20220415 1 51000202101 900000000000534007 900000000000012004 20220415 20220131

< c5fe4d54-95ce-472f-bb09-00a62164d16c 20211015 1 51000202101 900000000000534007 900000000000207008 20211015 20210731
> c5fe4d54-95ce-472f-bb09-00a62164d16c 20220415 1 51000202101 900000000000534007 900000000000207008 20220415 20220131

HOWEVER, An additional 6 records added unexpectedly???????????

> 20220415 1 57101000202106 900000000000534007 51000202101 20220415 20220415
> 8d548426-6073-415d-992d-c7f7193e3af9 20220415 1 57091000202101 900000000000534007 900000000000207008 20220415 20220131
> 90fda181-0910-4ef8-a5a3-7151f4baf127 20220415 1 57091000202101 900000000000534007 900000000000012004 20220415 20220131
> 9569aa3d-4136-4e7a-b2c7-dfd1f6b2165e 20220415 1 57101000202106 900000000000534007 900000000000012004 20220415 20220131
> bb2febb1-41a7-4fe4-987f-381cd5c08287 20220415 1 57101000202106 900000000000534007 900000000000207008 20220415 20220131
>

FOUND IN VERSION 7 WHEN NO NRC FINALLY TOLD US ABOUT THE NEW MODULES THAT THEY HAVE ADDED IN THIS CYCLE!  (57091000202101 + 57101000202106) 

So this now makes sense, as there are 3 records per new module, one for the dependency on the core NO Extension module (51000202101), and then one each for the (non-transitive) dependencies on the 2x INT Modules (900000000000207008 + 900000000000012004):

  • > f0961b9c-3f11-43e0-aa03-923df6a87e56 20220415 1 57091000202101 900000000000534007 51000202101 20220415 20220415
  • > 8d548426-6073-415d-992d-c7f7193e3af9 20220415 1 57091000202101 900000000000534007 900000000000207008 20220415 20220131
    • > 90fda181-0910-4ef8-a5a3-7151f4baf127 20220415 1 57091000202101 900000000000534007 900000000000012004 20220415 20220131 20220415 1 57091000202101 900000000000534007 51000202101 20220415 20220415 20220415 1 57101000202106 900000000000534007 51000202101 20220415 20220415
  • > 9569aa3d-4136-4e7a-b2c7-dfd1f6b2165e 20220415 1 57101000202106 900000000000534007 900000000000012004 20220415 20220131
  • > bb2febb1-41a7-4fe4-987f-381cd5c08287 20220415 1 57101000202106 900000000000534007 900000000000207008 20220415 20220131

    • SO NOW MAKES SENSE, BUT WE NEED A NEW STEP ADDING INTO THE MS PROCESS TO ASK FOR CONFIRMATION FROM THE MS USERS AS TO WHETHER OR NOT THEY'VE ADDED/UPDATED NEW MODULES IN THE CURRENT CYCLE, SO THAT WE CAN 

    a)  Ensure that the Summary Component Stats report (which was wrong for ages because of this) is run with the correct config, including ALL relevant extension modules,

    b)  Expect the new modules + all related content to come through in the RF2 files, and add the relevant metadata in without wasting time working out what they've done!130,336128760

    968 records inactivated + 

    608 records updated

    the 

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    :  236 11 inactivated + 

    6 records updated

    the 

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    :  2978729781 8 the 

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    :  

    Differences found in package Comparison

    		Number of RF2 records impactedRelated JIRA ticket(s)Rationale
    Readme file

    Dates updated for April 2022 as expected +

    ALL Delta files removed as planned...

    BUT ALSO HAS DENMARK WORDING ADDED IN!!  SO RAD CONFIG HAS GOTTEN CORRUPTED SOMEHOW - NEED TO FIX!!

    Association files215

    214 new records added +

    1 record inactivated

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle

    (see above)  

    AttributeValue files3708

    3707 new records created +

    1 records inactivated

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle

    (see above)  

    RefsetDescriptor files8

    8 new records ??????????? as expected ???????????

    > 00c32a7f-fdb3-444c-bd45-09884d0624b2    20221015    1    51000202101    900000000000456007    237331000202105    900000000000505001    900000000000465000    1
    > 09efd446-3738-4223-8c42-08d8096c4541    20221015    1    51000202101    900000000000456007    188001000202106    900000000000511003    900000000000461009    1
    > 53f0030d-d672-4d07-92d8-30fec3bca100    20221015    1    51000202101    900000000000456007    237331000202105    447247004    900000000000461009    4
    > 5bfdfebe-0490-4003-b653-0d44f5d61d34    20221015    1    51000202101    900000000000456007    188001000202106    900000000000510002    900000000000462002    0
    > 74489c9c-18c4-4370-a155-37e01c892f07    20221015    1    51000202101    900000000000456007    237331000202105    706999006    707000009    2
    > b8a7284b-61ff-4b84-85d7-9e8b93f5513b    20221015    1    51000202101    900000000000456007    237331000202105    705116007    900000000000461009    5
    > e6a716ea-456f-4cf1-a6b0-25fa1aa99cd7    20221015    1    51000202101    900000000000456007    237331000202105    734867002    900000000000461009    3
    > f4b85acb-2c6d-475e-b103-a6deb17782f6    20221015    1    51000202101    900000000000456007    237331000202105    449608002    900000000000461009    0

    (LAST CYCLE - FOUND IN VERSION 7 WHEN NO FINALLY TOLD US ABOUT THE NEW GP CONTEXT SPECIFIC REFSET THAT THEY'D ADDED!)

    ModuleDependency files8

    MSSP-1419


    All 8 records updated for October 2022 dates as expected:

    < 1d64b026-d4c9-4605-896f-d09049aacad3

       20220415    1    51000202101    900000000000534007    900000000000012004    20220415    20220131
    < 273000d9-dc5d-4a12-a1de-b53abad87daf    20220415    1    57091000202101    900000000000534007    900000000000207008    20220415    20220131
    < 378115f9-737d-41d4-ba08-98f6a9f9f07a    20220415    1    57091000202101    900000000000534007    900000000000012004    20220415    20220131
    < 3ac200a9-e3ca-4228-ad1c-83ebbff442a7

       20220415    1    57101000202106    900000000000534007    51000202101    20220415    20220415
    < 46f06445-1c74-4a76-a44d-732594718cd4    20220415    1    57101000202106    900000000000534007    900000000000207008    20220415    20220131
    < b2efb306-77fa-4de4-bb69-46854075e10e    20220415    1    57101000202106    900000000000534007    900000000000012004    20220415    20220131
    < c5fe4d54-95ce-472f-bb09-00a62164d16c    20220415    1    51000202101    900000000000534007    900000000000207008    20220415    20220131
    < f0961b9c-3f11-43e0-aa03-923df6a87e56

       20220415    1    57091000202101    900000000000534007    51000202101    20220415    20220415
    ---
    > 1d64b026-d4c9-4605-896f-d09049aacad3    20221015    1    51000202101    900000000000534007    900000000000012004    20221015    20220831
    > 273000d9-dc5d-4a12-a1de-b53abad87daf    20221015    1    57091000202101    900000000000534007    900000000000207008    20221015    20220831
    > 378115f9-737d-41d4-ba08-98f6a9f9f07a    20221015    1    57091000202101    900000000000534007    900000000000012004    20221015    20220831


    > 3ac200a9-e3ca-4228-ad1c-83ebbff442a7

       20221015    1    57101000202106    900000000000534007    51000202101    20221015    20221015
    > 46f06445-1c74-4a76-a44d-732594718cd4    20221015    1    57101000202106    900000000000534007    900000000000207008    20221015    20220831
    > b2efb306-77fa-4de4-bb69-46854075e10e    20221015    1    57101000202106    900000000000534007    900000000000012004    20221015    20220831
    > c5fe4d54-95ce-472f-bb09-00a62164d16c    20221015    1    51000202101    900000000000534007    900000000000207008    20221015    20220831
    > f0961b9c-3f11-43e0-aa03-923df6a87e56    20221015    1    57091000202101    900000000000534007    51000202101    20221015    20221015

    Concept files15225

    14804 new records created, +

    414 records inactivated + 

    7 records updated

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle :  

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    (see above)  

    Description (EN) files29791

    29781 new records created, +

    8 records inactivated + 

    2 records updated

    ...as expected, as SUM OF EN + NO DESCRIPTIONS almost matches exactly with Summary Component Stats report for this NO cycle : 

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    (see above)  


    **** Be careful here as 4613 records shown with ">" indicator (suggesting 4613 new records), BUT ONLY 4608 with 20211015\t1\t effective time + status.  

    So looks like some of the NO descriptions may now also have ">" characters in the terms, leading to potential confusion with the reconciliation of the Traceability Matrix!  Yes, found them for future reference there are 5 of them:

    • > 1515851000202116 20211015 1 51000202101 57981000202102 en 900000000000013009 Cytochrome P450 family 2 subfamily D member 6 *1/*1 >2 ultra-rapid metabolizer 900000000000020002
    • > 1515861000202118 20211015 1 51000202101 57981000202102 en 900000000000003001 Cytochrome P450 family 2 subfamily D member 6 *1/*1 >2 ultra-rapid metabolizer (finding) 900000000000020002
    • > 1516151000202117 20211015 1 51000202101 57981000202102 en 900000000000013009 CYP2D6 *1/*1 >2 ultra-rapid metaboliser 900000000000020002
    • > 1516161000202119 20211015 1 51000202101 57981000202102 en 900000000000013009 Cytochrome P450 family 2 subfamily D member 6 *1/*1 >2 ultra-rapid metaboliser 900000000000020002
    • > 1516171000202111 20211015 1 51000202101 57981000202102 en 900000000000013009 CYP2D6 *1/*1 >2 ultra-rapid metabolizer 900000000000020002
    Description (NO) files129748

    128770 records added, +

    967 records inactivated + 

    11 records updated

    ...as expected, as SUM OF EN + NO DESCRIPTIONS almost matches exactly with Summary Component Stats report for this NO cycle :  https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0(see above)  

    **** Be careful here as 19186 records shown with ">" indicator (suggesting 19186 new records), BUT ONLY 19185 with 20211015\t1\t effective time + status.  

    So looks like some of the NO descriptions may now also have ">" characters in the terms, leading to potential confusion with the reconciliation of the Traceability Matrix!  Yes, found them for future reference there is 1 of them:

    • > 1515871000202110 20211015 1 51000202101 57981000202102 no 900000000000013009 cytokrom P450 familie 2 subfamilie D medlem 6 *1/*1 >2 ultra-rapid metabolizer 900000000000020002
    Language (NB) files86952

    85137 new records added/updated + 

    1815 records inactivated 

    ...as expected, as matches with the "Norwegian Bokmål language reference set" totals in the "Refsets" tab in the Summary Component Stats report for this NO cycle (see above)  

    BUT MISSING SOME DATA VS the TOTAL of the NN + NB + EN - So missing a Language Refset somehow??  FOUND IN VERSION 7 WHEN NO FINALLY TOLD US ABOUT THE NEW GP CONTEXT SPECIFIC REFSET THAT THEY'D ADDED!

    Language (NB-GP) files2912

    2819 new records added/updated + 

    93 records inactivated 

    ...as expected, as matches with the "Norwegian Bokmål language reference set" totals in the "Refsets" tab in

    the Summary Component Stats report for this NO cycle

    (see above)  

    BUT MISSING SOME DATA VS the TOTAL of the NN + NB + EN - So missing a Language Refset somehow??  FOUND IN VERSION 7 WHEN NO FINALLY TOLD US ABOUT THE NEW GP CONTEXT SPECIFIC REFSET THAT THEY'D ADDED!

    Language (NN) files143

    142 new records created/updated, +

    1 records

    inactivated 

    ...

    as expected, as matches with the "Norwegian Nynorsk language reference set" totals in the "Refsets" tab in

    the Summary Component Stats report for this NO cycle

    (see above)  

    BUT MISSING SOME DATA VS the TOTAL of the NN + NB + EN - So missing a Language Refset somehow??  FOUND IN VERSION 7 WHEN NO FINALLY TOLD US ABOUT THE NEW GP CONTEXT SPECIFIC REFSET THAT THEY'D ADDED!

    Language (EN) files8816

    8806 new records created + 

    10 records inactivated

    ...as expected, as matches with the "United States of America English language reference set" totals in the "Refsets" tab in

    the Summary Component Stats report for this NO cycle

    (see above)  

    BUT MISSING SOME DATA VS the TOTAL of the NN + NB + EN - So missing a Language Refset somehow??  FOUND IN VERSION 7 WHEN NO FINALLY TOLD US ABOUT THE NEW GP CONTEXT SPECIFIC REFSET THAT THEY'D ADDED!

    Relationship files48760

    46085 records added +

    2675 records inactivated

    ...as expected, as matches almost exactly with Summary Component Stats report for this NO cycle :  https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0(see above)  

    Relationship Concrete Values files13011

    13011 new records added

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle :  

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    (see above)  

    OWL Axiom files15258

    14804 new records created, +

    414 records inactivated + 

    40 records updated

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle :  

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    (see above)  

    TextDefinition (EN) files 0

    0 changes

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle :  

    https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0

    (see above)  

    TextDefinition (NO) files 4

    0 new records added +

    4 records inactivated

    ...as expected, as matches exactly with Summary Component Stats report for this NO cycle :  https://docs.google.com/spreadsheets/d/1z-o5S2pjG2UTGzaRTmnXrCcgLRE_9z403wrYSRzZOOY/edit#gid=0(see above)