Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
March 2022 Published FIXED

September 2022 Production (Version 1) vs September 2022

Pre-

Production (Version

13

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 impactedRelated 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 goodDutch Causative Pathogens In Congenital Infection Simple RefsetMSSP-1678

New files added for this new refset, as expected due to request in MSSP-1678

  • > ./der2_Refset_DutchCausativePathogensInCongenitalInfectionSimpleRefsetFull_NL1000146_20220331.txt
  • > ./der2_Refset_DutchCausativePathogensInCongenitalInfectionSimpleRefsetSnapshot_NL1000146_20220331.txt
Correlated Map files4

MSSP-1678

2 records inactivated, plus

< 3059c377-2d38-22ae-393d-923e2acae8e5    20210331    1    11000146104    148521000146104    147381000146109    78735    447561005
> 3059c377-2d38-22ae-393d-923e2acae8e5    20220930    0    11000146104    148521000146104    147381000146109    78735    447561005

< 6187106f-b126-50fa-4212-14c4ef6eed5d    20210331    1    11000146104    148521000146104    767425002    38474    447557004
> 6187106f-b126-50fa-4212-14c4ef6eed5d    20220930    0    11000146104    148521000146104    767425002    38474    447557004

2 records added

> e11d274e-f9ef-4f13-985b-a6c00fece34e

Dutch Causative Pathogens In Sepsis And Meningitis Simple RefsetMSSP-1678

New files added for this new refset, as expected due to request in MSSP-1678

  • > ./der2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetSnapshot_NL1000146_20220331.txt
  • > ./der2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetFull_NL1000146_20220331.txt
RefsetDescriptor files16

FRI-519

MSSP-1678

16 records added, as expected from new NL Refsets being added this cycle (MSSP-1678):

  • > 1777b6d1-cee6-40d2-b053-ff52c3248a99    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
  • > 3c11958c-4ccd-458d-9c7f-74bc6a615a90    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
  • > d7fcbff2-a825-41bc-8d5e-b616289ff48b    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
  • > 66372402-c261-4a60-8e9a-08d8c55d3a53

       20220930    1    11000146104  

     900000000000456007

     148521000146104  

     210041000146107

     50040111000188102  

     449608002

     78735  

     900000000000461009    0

     447558009
    >

    98b35fad

    e2ac48d5-

    4982

    b139-

    4975

    40d7-

    beb4

    8af0-

    bc53d70197d1

    2c8f5ee1a543    20220930    1    11000146104  

     900000000000456007

     148521000146104  

     210041000146107

     108895000  

     449608002

     38474  

     900000000000461009    0
  • > a8b90974-3be8-4fbd-a243-a3b51e88d9c6    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
  • 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
    > 191c0108-0ec7-494b-9af1-23e490cc5d0f    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    > 3db9f99e-a27c-4c52-96d7-774d38e2cf2d    20220930    1    11000146104    900000000000456007    160161000146108

     447557004

    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 impactedRelated 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 impactedRelated JIRA ticket(s)Rationale
    Description (EN) files2

    ISRS-1318

    NL EDITION EFFECTIVETIME 20220930:

    0 new records added/updated plus

    2 inactivated

    • < 4222731000146118    20190331    1    11000146104    69131000146100    en    900000000000003001    Chondroid syringoma (morphologic abnormality)    900000000000448009
      > 4222731000146118    20220930    0    11000146104    69131000146100    en    900000000000003001    Chondroid syringoma (morphologic abnormality)    900000000000448009


    • < 4222741000146114    20190331    1    11000146104    69131000146100    en    900000000000013009    Chondroid syringoma    900000000000448009
      > 4222741000146114    20220930    0    11000146104    69131000146100    en    900000000000013009    Chondroid syringoma    900000000000448009

    As expected, due to fixes Peter confirmed he implemented in order to resolve 

    Description (NL) files0ISRS-1318

    0 changes 

    Language (EN) files2ISRS-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

    • < 90e6f163-fba3-e3b4-2677-3f4e1a63759a    20190331    1    11000146104    900000000000509007    4222731000146118    900000000000548007
      > 90e6f163-fba3-e3b4-2677-3f4e1a63759a    20220930    0    11000146104    900000000000509007    4222731000146118    900000000000548007


    • < b9520261-3bc7-9669-edf6-01198f0a139f    20190331    1    11000146104    900000000000509007    4222741000146114    900000000000548007
      > b9520261-3bc7-9669-edf6-01198f0a139f    20220930    0    11000146104    900000000000509007    4222741000146114    900000000000548007

    As expected, due to fixes Peter confirmed he implemented in order to resolve 

    Language (NL) files0ISRS-1318

    0 changes 

    ModuleDependency files1

    ISRS-1340


    1x ModuleDependency records re-instated to retain the original UUID:

    • < a862bfc8-6168-4a06-8601-8a6c348c41c0    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
      > dcc1637b-9178-424b-9237-bc602a1a6fbf    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731

    Manual checks look good now!

    AttributeValue files2ISRS-1318

    2 new records added:

    • > 45b034f6-e702-4ccc-8b29-ed6436c9509c    20220930    1    11000146104    900000000000490003    4222741000146114    723277005
    • > 63f21817-a9bf-46ad-90c6-89812a48ac53    20220930    1    11000146104    900000000000490003    4222731000146118    723277005

    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 impactedRelated JIRA ticket(s)Rationale
    ModuleDependency files2

    ISRS-1329

    Latest Sept 22 fixes REMOVED!!!

    < 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
    < a862bfc8-6168-4a06-8601-8a6c348c41c0    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131

    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 impactedRelated JIRA ticket(s)Rationale
    Description (EN) FULL + SNAPSHOT files249ISRS-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:

    • testCategory: "file-centric-validation",

    • testType: "SQL",

    • assertionUuid: "3be8c763-a5bc-404b-af9f-a2cb681f6f3d",

    • assertionText: "ID is unique in DESCRIPTION snapshot.",

    • failureCount: 0


    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 impactedRelated JIRA ticket(s)Rationale
    Description (EN) FULL file2ISRS-1338

    NL EDITION EFFECTIVETIME 20220930:

    0 new records added/updated plus

    2 inactivated

    • > 610951000146110    20220930    0    11000146104    34131000146109    en    900000000000003001    Injuries of multiple sites of lower limb (disorder)    900000000000020002
    • > 610961000146113    20220930    0    11000146104    34131000146109    en    900000000000013009    Injuries of multiple sites of lower limb    900000000000020002

    As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338

    Language (EN) FULL file2ISRS-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

    • > 23c699d3-a88f-e9c6-a167-7defb2c826e4    20220930    0    11000146104    900000000000509007    610961000146113    900000000000548007
    • > 9ddd9050-53d7-ec2f-71ae-18aa552c8bc1    20220930    0    11000146104    900000000000509007    610951000146110    900000000000548007

    As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338

    Description (EN) SNAPSHOT file2ISRS-1338

    NL EDITION EFFECTIVETIME 20220930:

    0 new records added/updated plus

    2 inactivated

    • < 610951000146110    20170930    1    11000146104    34131000146109    en    900000000000003001    Injuries of multiple sites of lower limb (disorder)    900000000000020002
      > 610951000146110    20220930    0    11000146104    34131000146109    en    900000000000003001    Injuries of multiple sites of lower limb (disorder)    900000000000020002


    • < 610961000146113    20170930    1    11000146104    34131000146109    en    900000000000013009    Injuries of multiple sites of lower limb    900000000000020002
      > 610961000146113    20220930    0    11000146104    34131000146109    en    900000000000013009    Injuries of multiple sites of lower limb    900000000000020002

    As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338

    Language (EN) SNAPSHOT file2ISRS-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

    • < 23c699d3-a88f-e9c6-a167-7defb2c826e4    20170930    1    11000146104    900000000000509007    610961000146113    900000000000548007
      > 23c699d3-a88f-e9c6-a167-7defb2c826e4    20220930    0    11000146104    900000000000509007    610961000146113    900000000000548007

    • < 9ddd9050-53d7-ec2f-71ae-18aa552c8bc1    20170930    1    11000146104    900000000000509007    610951000146110    900000000000548007
      > 9ddd9050-53d7-ec2f-71ae-18aa552c8bc1    20220930    0    11000146104    900000000000509007    610951000146110    900000000000548007

    As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338

    Language (NL) FULL file0ISRS-1338

    0 changes 

    Language (NL) SNAPSHOT file0ISRS-1338

    0 changes 

    ModuleDependency FULL file2

    ISRS-1340


    • 2x ModuleDependency records in the Full file updated to new UUID's:
    •  
      • < 8066372e-dfd9-4b29-8037-0c9b553403d0    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
      • > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
      • > dcc1637b-9178-424b-9237-bc602a1a6fbf    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
      • < bdfe6eef-08d6-4fb1-a935-6ce0859e5e19    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731


    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 filesALL

    ISRS-1340


    • 1x ModuleDependency records in the Snapshot file updated to new dates:
    • < 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131
    • > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731


    • 1x ModuleDependency records in the Snapshot file updated to new dates + new UUID:
    • < bdfe6eef-08d6-4fb1-a935-6ce0859e5e19    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
    • > dcc1637b-9178-424b-9237-bc602a1a6fbf    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731


    • 1x ModuleDependency records in the Snapshot file removed completely:
    • < 8066372e-dfd9-4b29-8037-0c9b553403d0    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731


    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 files2ISRS-1338

    2 new records added:

    • > 33d06578-d958-492e-a2ae-3756c67e8d2a    20220930    1    11000146104    900000000000490003    610951000146110    723277005
    • > 98fa6dc7-b56d-4c0c-87e7-549c90d85cf0    20220930    1    11000146104    900000000000490003    610961000146113    723277005

    As expected, due to fixes Peter confirmed he implemented in order to resolve ISRS-1338

    OWL Axiom files1ISRS-1338

    1 record inactivated:

    • > 8cf67be9-85a3-9eb7-4dbf-2be31238e676    20220930    0    11000146104    733073007    34131000146109    EquivalentClasses(:34131000146109 ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:116676008 :12835000) ObjectSomeValuesFrom(:363698007 :61685007))) ObjectSomeValuesFrom(:609096000 ObjectSomeValuesFrom(:42752001 :773760007))))

    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 impactedRelated JIRA ticket(s)Rationale
    RefsetDescriptor files4

    ISRS-1339

    Final issues resolved, as 4 duplicate records removed as part of fixes in ISRS-1339:

    • < 3c11958c-4ccd-458d-9c7f-74bc6a615a90    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • < 98b35fad-4982-4975-beb4-bc53d70197d1    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • < a8b90974-3be8-4fbd-a243-a3b51e88d9c6    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • < d7fcbff2-a825-41bc-8d5e-b616289ff48b    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0

    This just leaves the following 2 records in the new refsetDescriptor Snapshot file for these two new refsets, as expected:

    • 1777b6d1-cee6-40d2-b053-ff52c3248a99    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • 66372402-c261-4a60-8e9a-08d8c55d3a53    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0



    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 impactedRelated 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 filesALL

    ISRS-1340


    2 new NL records added + 1 record udpated:

    • > bdfe6eef-08d6-4fb1-a935-6ce0859e5e19    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
      • This is as expected, as it's adding in the explicit dependency on the Component Model Module
    • > 8066372e-dfd9-4b29-8037-0c9b553403d0    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
      • This is as expected, as it's adding in the latest version of the MDRS record, as this is the SNAPSHOT comparison

    + 3 INT records updated:

    • < 1244116f-fdb5-5645-afcc-5281288409da    20220131    1    900000000000207008    900000000000534007    900000000000012004    20220131    20220131
      > 1244116f-fdb5-5645-afcc-5281288409da    20220731    1    900000000000207008    900000000000534007    900000000000012004    20220731    20220731

    • < 686fe392-d2f7-586d-98aa-078aba426832    20220131    1    449080006    900000000000534007    900000000000207008    20220131    20220131
      > 686fe392-d2f7-586d-98aa-078aba426832    20220731    1    449080006    900000000000534007    900000000000207008    20220731    20220731

    • < f6431457-161b-5b46-9217-573c20c00070    20220131    1    449080006    900000000000534007    900000000000012004    20220131    20220131
      > f6431457-161b-5b46-9217-573c20c00070    20220731    1    449080006    900000000000534007    900000000000012004    20220731    20220731

      • These are as expected, as it's adding in the latest version of the MDRS record, as this is the SNAPSHOT comparison

    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 files16

    FRI-519


    MSSP-1678

    16 records added, as expected from new NL Refsets being added this cycle (MSSP-1678):

    • > 1777b6d1-cee6-40d2-b053-ff52c3248a99    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • > 3c11958c-4ccd-458d-9c7f-74bc6a615a90    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • > d7fcbff2-a825-41bc-8d5e-b616289ff48b    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • > 66372402-c261-4a60-8e9a-08d8c55d3a53    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • > 98b35fad-4982-4975-beb4-bc53d70197d1    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • > a8b90974-3be8-4fbd-a243-a3b51e88d9c6    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0

    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
    > 191c0108-0ec7-494b-9af1-23e490cc5d0f    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    > 3db9f99e-a27c-4c52-96d7-774d38e2cf2d    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    > d174dabc-c6c5-494d-b3bb-77f732b47667    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0

    As expected from all INT changes between Feb - July 2022:

    • > 48a3c317-795d-4d45-8cab-0cf385849422    20220228    0    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000465000    1
    • > a3e46ae7-0da5-461e-8e33-913cd6ae4d20    20220228    1    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000461009    1
    • > 379db3c2-0cae-4f26-ad80-f097e983af3c    20220731    1    900000000000207008    900000000000456007    1186921001    900000000000532006    900000000000460005    0
    • > 39390a5a-830a-4e0b-a023-d3312d2d6aa6    20220731    1    900000000000207008    900000000000456007    1186924009    900000000000532006    900000000000460005    0
    • > c73c609c-e3fe-457e-8cb3-f7e8d220a0ab    20220731    1    900000000000207008    900000000000456007    1186924009    900000000000533001    900000000000460005    1
    • > e3394b4a-2617-4e67-8f2b-ac706ba60400    20220731    1    900000000000207008    900000000000456007    1186921001    900000000000533001    900000000000460005    1
    Association files9085

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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)

    • As confirmed by the TOTAL of all Association Refset rows in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • As confirmed by the TOTAL of all Association Refset rows in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Attribute Value files26889

    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!)

    • As confirmed by the TOTAL of all AttributeValue Refset rows in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930:

    8696 records added/updated plus

    225 inactivated

    • As confirmed by the TOTAL of all AttributeValue Refset rows in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage... 

    Language (EN) files58241

    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)

    • As confirmed by the TOTAL of "900000000000509007|United States of America English language reference set (foundation metadata concept)" + "900000000000508004|Great Britain English language reference set (foundation metadata concept)" rows in the Language Refsets tab in the EN Summary Component Stats Report 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

    • As confirmed by the "900000000000509007|United States of America English language reference set (foundation metadata concept)"  row in the Language Refsets tab in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!

                                                                          

     1    9000000000002070080    900000000000207008  1    11000146104 0    11000146104
    Language Full (original) 2998489599276100839078218
    Language Snap (original)246034456082291379077825
    Language Full-en (Sept 2022)3047603606872360642931
    Language Full-nl (Sept 2022) 0099787279975
    Language Snap-en (Sept 2022) 2496727568378319392910
    Language Snap-nl (Sept 2022) 0090235679589


    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) files28663

    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

    • As confirmed by the "31000146106|Netherlands Dutch language reference set (foundation metadata concept)" row in the Language Refsets tab in the NL Summary Component Stats Report above

    + 9307 records added for PFT Language Refset 15551000146102 + 

    + 535 records added for PFT Language Refset 160161000146108

    • As confirmed by the matching rows in the Refsets tab in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!
    ExtendedMap files4253

    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)

    24MSSP-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

    • > ./der2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetSnapshot_NL1000146_20220331.txt
    • > ./der2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetFull_NL1000146_20220331.txt
    Dutch Causative Pathogens In Congenital Infection Simple Refset (210051000146105)7MSSP-16787 new records added for this brand new refset.  

    New files added for this new refset, as expected due to request in MSSP-1678

    • > ./der2_Refset_DutchCausativePathogensInCongenitalInfectionSimpleRefsetFull_NL1000146_20220331.txt
    • > ./der2_Refset_DutchCausativePathogensInCongenitalInfectionSimpleRefsetSnapshot_NL1000146_20220331.txt

    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

       900000000000511003    900000000000461009    1
    > d174dabc-c6c5-494d-b3bb-77f732b47667    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0

    As expected from all INT changes between Feb - July 2022:

    • > 48a3c317-795d-4d45-8cab-0cf385849422    20220228    0    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000465000    1
    • > a3e46ae7-0da5-461e-8e33-913cd6ae4d20    20220228    1    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000461009    1
    • > 379db3c2-0cae-4f26-ad80-f097e983af3c    20220731    1    900000000000207008    900000000000456007    1186921001    900000000000532006    900000000000460005    0
    • > 39390a5a-830a-4e0b-a023-d3312d2d6aa6    20220731    1    900000000000207008    900000000000456007    1186924009    900000000000532006    900000000000460005    0
    • > c73c609c-e3fe-457e-8cb3-f7e8d220a0ab    20220731    1    900000000000207008    900000000000456007    1186924009    900000000000533001    900000000000460005    1
    • > e3394b4a-2617-4e67-8f2b-ac706ba60400    20220731    1    900000000000207008    900000000000456007    1186921001    900000000000533001    900000000000460005    1
    Association files9085

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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)

    • As confirmed by the TOTAL of all Association Refset rows in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • As confirmed by the TOTAL of all Association Refset rows in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Attribute Value files26889

    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!)

    • As confirmed by the TOTAL of all AttributeValue Refset rows in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930:

    8696 records added/updated plus

    225 inactivated

    • As confirmed by the TOTAL of all AttributeValue Refset rows in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage... 

    Language (EN) files58241

    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)

    • As confirmed by the TOTAL of "900000000000509007|United States of America English language reference set (foundation metadata concept)" + "900000000000508004|Great Britain English language reference set (foundation metadata concept)" rows in the Language Refsets tab in the EN Summary Component Stats Report 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

    • As confirmed by the "900000000000509007|United States of America English language reference set (foundation metadata concept)"  row in the Language Refsets tab in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!

                                                                          

     1    9000000000002070080    900000000000207008  1    11000146104 0    11000146104
    Language Full (original) 2998489599276100839078218
    Language Snap (original)246034456082291379077825
    Language Full-en (Sept 2022)3047603606872360642931
    Language Full-nl (Sept 2022) 0099787279975
    Language Snap-en (Sept 2022) 2496727568378319392910
    Language Snap-nl (Sept 2022) 0090235679589

    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) files28663

    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

    • As confirmed by the "31000146106|Netherlands Dutch language reference set (foundation metadata concept)" row in the Language Refsets tab in the NL Summary Component Stats Report above

    + 9307 records added for PFT Language Refset 15551000146102 + 

    + 535 records added for PFT Language Refset 160161000146108

    • As confirmed by the matching rows in the Refsets tab in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!
    ExtendedMap files4253

    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...

    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   NOT IN COMPARISON???

    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

    0

    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 

     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

    0

    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 files0
    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 files0

    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 files5234

    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 files3n/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 files5

    NL EDITION EFFECTIVETIME 20220930:

    0 records updated

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    1 new records added:

    • > a720e7af-e728-7c08-8433-72a84ed387bc    20220731    1    900000000000012004    723561005    1230370004    123037004    0    0..*    0..0    723597001    723594008

    Plus 2 records updated:

    • < 8d066b27-118d-4a84-886a-14dabceba155    20170731    1    900000000000012004    723561005    363698007    404684003    1    0..*    0..*    723597001    723596005
      > 8d066b27-118d-4a84-886a-14dabceba155    20220731    1    900000000000012004    723561005    363698007    404684003    1    0..*    0..1    723597001    723596005


    • < 351405be-c515-4997-a9cb-a55d83e66ecb    20170731    1    900000000000012004    723561005    116676008    404684003    1    0..*    0..*    723597001    723596005
      > 351405be-c515-4997-a9cb-a55d83e66ecb    20220731    1    900000000000012004    723561005    116676008    404684003    1    0..*    0..1    723597001    723596005

    Plus 2 records inactivated:

    • < 04a6c94d-879d-44ea-bc39-6207bc92b2b6    20170731    1    900000000000012004    723561005    363698007    404684003    1    0..*    0..1    723597001    723593002
      > 04a6c94d-879d-44ea-bc39-6207bc92b2b6    20220731    0    900000000000012004    723561005    363698007    404684003    1    0..*    0..1    723597001    723593002


    • < 3e984ab7-c9e6-4919-bd3a-0c2cd3e205a6    20170731    1    900000000000012004    723561005    116676008    404684003    1    0..*    0..1    723597001    723593002
      > 3e984ab7-c9e6-4919-bd3a-0c2cd3e205a6    20220731    0    900000000000012004    723561005    116676008    404684003    1    0..*    0..1    723597001    723593002

    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 files4n/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 ??????????

    0 records changed

    Therefore there are no NL specific changes this cycle ??????????

    Concept files9929

    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

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Description (EN) files

    27796

    ModuleDependency filesALL

    2 new NL records added + 1 record udpated:

    • > bdfe6eef-08d6-4fb1-a935-6ce0859e5e19    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
      • This is as expected, as it's adding in the explicit dependency on the Component Model Module
    • > 8066372e-dfd9-4b29-8037-0c9b553403d0    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
      • This is as expected, as it's adding in the latest version of the MDRS record, as this is the SNAPSHOT comparison

    + 3 INT records updated:

    • < 1244116f-fdb5-5645-afcc-5281288409da    20220131    1    900000000000207008    900000000000534007    900000000000012004    20220131    20220131
      > 1244116f-fdb5-5645-afcc-5281288409da    20220731    1    900000000000207008    900000000000534007    900000000000012004    20220731    20220731

    • < 686fe392-d2f7-586d-98aa-078aba426832    20220131    1    449080006    900000000000534007    900000000000207008    20220131    20220131
      > 686fe392-d2f7-586d-98aa-078aba426832    20220731    1    449080006    900000000000534007    900000000000207008    20220731    20220731

    • < f6431457-161b-5b46-9217-573c20c00070    20220131    1    449080006    900000000000534007    900000000000012004    20220131    20220131
      > f6431457-161b-5b46-9217-573c20c00070    20220731    1    449080006    900000000000534007    900000000000012004    20220731    20220731

      • These are as expected, as it's adding in the latest version of the MDRS record, as this is the SNAPSHOT comparison

    NEED TO MANUALLY CHECK MODULEDEPENDENCY FILES ARE ALL CORRECT NOW!!!

    Concept files9929


    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    2696

    3857 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus

    6711

    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:

    388

    1430 records added/updated plus

    134

    330 inactivated

    As confirmed
    • ?????????EXACTLY AS EXPECTED by the Summary Component Stats Report
    above

    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

    • ?????????EXACTLY AS EXPECTED by the Summary Component Stats Report above  
    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!
    • above  
    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!

     1    9000000000002070080    900000000000207008  1    11000146104 0    11000146104
    Description Full (original) 243846228616497333577638
    Description Snap (original)126420927951689180277234
    Description Full-en (Sept 2022)2460606290022414749212
    Description Full-nl (Sept 2022) 0094944473064
    Description Snap-en (Sept 2022) 1282102283356321499191
    Description Snap-nl (Sept 2022) 0087266772625

    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

    • ????????AS EXPECTED by the Summary Component Stats Report above  
    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!
    Stated Relationship files0

    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

    • AS EXPECTED as close to the counts in the Summary Component Stats Reports above


    Relationship Concrete Values files2799

    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

    0 records changed

    Therefore there are no NL specific changes this cycle, as confirmed in the NL Summary Component Stats report above

    OwlExpression files17927

    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

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    TextDefinition (EN) files

    1103

    OwlExpression files17927


    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    2708

    36 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above), plus

    13635 )

    NL EDITION EFFECTIVETIME 20220930:

    1047 records added/updated plus

    537 inactivated

    • As confirmed by the Summary Component Stats Report above

    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

    • ?????????EXACTLY AS EXPECTED by the Summary Component Stats Report above  
    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!

    1066 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131 - 20220731- see above

    20220131 - 20220731- see above)


    NL EDITION EFFECTIVETIME 20220930:

    1 records added/updated plus

    0 inactivated

    • ?????????EXACTLY AS EXPECTED by the Summary Component Stats Report above  
    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!

     1    9000000000002070080    900000000000207008  1    11000146104 0    11000146104
    TextDefinition Full (original) 86214243627387
    TextDefinition Snap (original)81444233239387
    TextDefinition Full-en (Sept 2022)96874605110
    TextDefinition Full-nl (Sept 2022) 007908400
    TextDefinition Snap-en (Sept 2022) 91744594110
    TextDefinition Snap-nl (Sept 2022) 007507400

    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

    • ????????AS EXPECTED by the Summary Component Stats Report above  
    • CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!


    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 impactedRelated 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 impactedRelated 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
    >                     xder2_Refset_DocumentTypeSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchCausativePathogensInCongenitalInfectionSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchCausativePathogensInCongenitalInfectionSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchCausesOfDeathStatisticsSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchCausesOfDeathStatisticsSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchContactAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchContactAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchFoodAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchFoodAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchImplantRegistrySimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchImplantRegistrySimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchImplantsExtensionalSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchImplantsExtensionalSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchImplantsIntensionalSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchImplantsIntensionalSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchInhalationAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchInhalationAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchInsectVenomAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchInsectVenomAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchMentalHealthProceduresSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchMentalHealthProceduresSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchMicroorganismSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchMicroorganismSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchMixedFloraFindingSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchMixedFloraFindingSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNonDrugAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNonDrugAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionForDeliriumSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionForDeliriumSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForFallRiskSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForFallRiskSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForPainSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForPainSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForPsychosocialCareSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForPsychosocialCareSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForSuicideSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForSuicideSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForWoundSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingInterventionsForWoundSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationsForDeliriumSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationsForDeliriumSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationsForFallRiskSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationsForFallRiskSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationsForSuicideSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingObservationsForSuicideSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingProblemSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingProblemSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingProblemsWithSectionsOfETransferSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchNursingProblemsWithSectionsOfETransferSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchObstetricProceduresSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchObstetricProceduresSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOccupationalAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOccupationalAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOptometricDiagnosesSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOptometricDiagnosesSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOptometricProceduresSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOptometricProceduresSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOptometricReasonForVisitSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOptometricReasonForVisitSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOrdinalMicrobialSusceptibilityTestResultsSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchOrdinalMicrobialSusceptibilityTestResultsSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchPathologySimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchPathologySimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchRadioAllergosorbentTestResultSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchRadioAllergosorbentTestResultSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchRareNeuromuscularDisordersSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchRareNeuromuscularDisordersSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_DutchTotalNonDrugAllergenSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_DutchTotalNonDrugAllergenSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_NetherlandsMicroscopicOrdinalTestResultSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_NetherlandsMicroscopicOrdinalTestResultSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_NetherlandsOrdinalTestResultSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_NetherlandsOrdinalTestResultSimpleRefsetSnapshot_NL1000146_20220930.txt
    >                     xder2_Refset_SectionsOfETransferOfNursingDataSimpleRefsetFull_NL1000146_20220930.txt
    >                     xder2_Refset_SectionsOfETransferOfNursingDataSimpleRefsetSnapshot_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 impactedRelated JIRA ticket(s)Rationale
    Readme file

    Complex maps added as expected:

    >                     xder2_scRefset_CorrelatedMapTypeReferenceSetFull_NL1000146_20220930.txt
    >                     xder2_scRefset_CorrelatedMapTypeReferenceSetSnapshot_NL1000146_20220930.txt
    >                     xder2_sccRefset_CorrelatedExtendedMapTypeReferenceSetFull_NL1000146_20220930.txt
    >                     xder2_sccRefset_CorrelatedExtendedMapTypeReferenceSetSnapshot_NL1000146_20220930.txt

    Correlated Extended Map filesALL
    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 filesALL

    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 impactedRelated 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 files16

    16 invalid (different UUID's) records removed:

    < 0b4e1466-2c3f-9f32-41bb-d3da113da1e0    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131
    < 0f938c9d-6c38-f3fc-97f6-c9d2236071d3    20200930    1    11000146104    900000000000534007    900000000000207008    20200930    20200731
    < 18318846-73e6-375a-6ffd-01b17f6aa82c    20210331    1    11000146104    900000000000534007    900000000000207008    20210331    20210131
    < 5843de36-69d9-c8fb-f2e4-284a0aa19722    20210930    1    11000146104    900000000000534007    900000000000207008    20210930    20210731
    < 5ff4ddf0-cead-28a1-a2c2-68234bef9da5    20180930    1    11000146104    900000000000534007    900000000000207008    20180930    20180731
    < 6c6fcbc2-f491-9389-0fc7-c2dd9f87e2f9    20190930    1    11000146104    900000000000534007    900000000000207008    20190930    20190731
    < 6ca74444-8e94-ab52-6516-3848258bfeff    20190331    1    11000146104    900000000000534007    900000000000207008    20190331    20190131
    < 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20140131    1    11000146104    900000000000534007    900000000000207008    20140131    20140131
    < 8f2c4b76-5419-11e6-94a8-7f8b3d911fe5    20140731    1    11000146104    900000000000534007    900000000000207008    20140731    20140731
    < 995dfa9a-5419-11e6-94a8-7f8b3d911fe5    20150331    1    11000146104    900000000000534007    900000000000207008    20150331    20150131
    < a09e4a26-5419-11e6-94a8-7f8b3d911fe5    20150916    1    11000146104    900000000000534007    900000000000207008    20150916    20150731
    < a7a6d62b-2f9a-4fa5-a43c-59337476a74f    20170930    1    11000146104    900000000000534007    900000000000207008    20170930    20170731
    < b02ee7bb-7ab7-4dec-ec64-af3d0c1a49b6    20200331    1    11000146104    900000000000534007    900000000000207008    20200331    20200309
    < b0cc0389-0cdf-49cb-9c75-96bc75406b85    20160307    1    11000146104    900000000000534007    900000000000207008    20160307    20160131
    < ccab98d8-d879-f3cb-d00f-88d670322995    20180331    1    11000146104    900000000000534007    900000000000207008    20180331    20180131
    < e86357d0-cb2b-f0e4-9b6d-ba1b3ea6e9ec    20170331    1    11000146104    900000000000534007    900000000000207008    20170331    20170131

    Plus 1 correct record (Snapshot for latest status) replaced them:

    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131 

    ModuleDependency FULL files16

    16 invalid (different UUID's) records removed:

    < 0b4e1466-2c3f-9f32-41bb-d3da113da1e0    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131
    < 0f938c9d-6c38-f3fc-97f6-c9d2236071d3    20200930    1    11000146104    900000000000534007    900000000000207008    20200930    20200731
    < 18318846-73e6-375a-6ffd-01b17f6aa82c    20210331    1    11000146104    900000000000534007    900000000000207008    20210331    20210131
    < 5843de36-69d9-c8fb-f2e4-284a0aa19722    20210930    1    11000146104    900000000000534007    900000000000207008    20210930    20210731
    < 5ff4ddf0-cead-28a1-a2c2-68234bef9da5    20180930    1    11000146104    900000000000534007    900000000000207008    20180930    20180731
    < 6c6fcbc2-f491-9389-0fc7-c2dd9f87e2f9    20190930    1    11000146104    900000000000534007    900000000000207008    20190930    20190731
    < 6ca74444-8e94-ab52-6516-3848258bfeff    20190331    1    11000146104    900000000000534007    900000000000207008    20190331    20190131
    < 8066372e-dfd9-4b29-8037-0c9b553403d0    20160930    1    11000146104    900000000000534007    900000000000207008    20160930    20160731
    < 8f2c4b76-5419-11e6-94a8-7f8b3d911fe5    20140731    1    11000146104    900000000000534007    900000000000207008    20140731    20140731
    < 995dfa9a-5419-11e6-94a8-7f8b3d911fe5    20150331    1    11000146104    900000000000534007    900000000000207008    20150331    20150131
    < a09e4a26-5419-11e6-94a8-7f8b3d911fe5    20150916    1    11000146104    900000000000534007    900000000000207008    20150916    20150731
    < a7a6d62b-2f9a-4fa5-a43c-59337476a74f    20170930    1    11000146104    900000000000534007    900000000000207008    20170930    20170731
    < b02ee7bb-7ab7-4dec-ec64-af3d0c1a49b6    20200331    1    11000146104    900000000000534007    900000000000207008    20200331    20200309
    < b0cc0389-0cdf-49cb-9c75-96bc75406b85    20160307    1    11000146104    900000000000534007    900000000000207008    20160307    20160131
    < ccab98d8-d879-f3cb-d00f-88d670322995    20180331    1    11000146104    900000000000534007    900000000000207008    20180331    20180131
    < e86357d0-cb2b-f0e4-9b6d-ba1b3ea6e9ec    20170331    1    11000146104    900000000000534007    900000000000207008    20170331    20170131

    Plus 16 correct records replaced them:

    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20140731    1    11000146104    900000000000534007    900000000000207008    20140731    20140731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20150331    1    11000146104    900000000000534007    900000000000207008    20150331    20150131
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20150916    1    11000146104    900000000000534007    900000000000207008    20150916    20150731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20160307    1    11000146104    900000000000534007    900000000000207008    20160307    20160131
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20160930    1    11000146104    900000000000534007    900000000000207008    20160930    20160731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20170331    1    11000146104    900000000000534007    900000000000207008    20170331    20170131
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20170930    1    11000146104    900000000000534007    900000000000207008    20170930    20170731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20180331    1    11000146104    900000000000534007    900000000000207008    20180331    20180131
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20180930    1    11000146104    900000000000534007    900000000000207008    20180930    20180731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20190331    1    11000146104    900000000000534007    900000000000207008    20190331    20190131
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20190930    1    11000146104    900000000000534007    900000000000207008    20190930    20190731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20200331    1    11000146104    900000000000534007    900000000000207008    20200331    20200309
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20200930    1    11000146104    900000000000534007    900000000000207008    20200930    20200731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20210331    1    11000146104    900000000000534007    900000000000207008    20210331    20210131
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20210930    1    11000146104    900000000000534007    900000000000207008    20210930    20210731
    > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131



    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 impactedRelated JIRA ticket(s)Rationale
    ModuleDependency filesALL

    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)

    • 0b4e1466-2c3f-9f32-41bb-d3da113da1e0    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131
      0f938c9d-6c38-f3fc-97f6-c9d2236071d3    20200930    1    11000146104    900000000000534007    900000000000207008    20200930    20200731
      18318846-73e6-375a-6ffd-01b17f6aa82c    20210331    1    11000146104    900000000000534007    900000000000207008    20210331    20210131
      5843de36-69d9-c8fb-f2e4-284a0aa19722    20210930    1    11000146104    900000000000534007    900000000000207008    20210930    20210731
      5ff4ddf0-cead-28a1-a2c2-68234bef9da5    20180930    1    11000146104    900000000000534007    900000000000207008    20180930    20180731
      6c6fcbc2-f491-9389-0fc7-c2dd9f87e2f9    20190930    1    11000146104    900000000000534007    900000000000207008    20190930    20190731
      6ca74444-8e94-ab52-6516-3848258bfeff    20190331    1    11000146104    900000000000534007    900000000000207008    20190331    20190131
      7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20140131    1    11000146104    900000000000534007    900000000000207008    20140131    20140131
      8066372e-dfd9-4b29-8037-0c9b553403d0    20160930    1    11000146104    900000000000534007    900000000000207008    20160930    20160731
      8f2c4b76-5419-11e6-94a8-7f8b3d911fe5    20140731    1    11000146104    900000000000534007    900000000000207008    20140731    20140731
      995dfa9a-5419-11e6-94a8-7f8b3d911fe5    20150331    1    11000146104    900000000000534007    900000000000207008    20150331    20150131
      a09e4a26-5419-11e6-94a8-7f8b3d911fe5    20150916    1    11000146104    900000000000534007    900000000000207008    20150916    20150731
      a7a6d62b-2f9a-4fa5-a43c-59337476a74f    20170930    1    11000146104    900000000000534007    900000000000207008    20170930    20170731
      b02ee7bb-7ab7-4dec-ec64-af3d0c1a49b6    20200331    1    11000146104    900000000000534007    900000000000207008    20200331    20200309
      b0cc0389-0cdf-49cb-9c75-96bc75406b85    20160307    1    11000146104    900000000000534007    900000000000207008    20160307    20160131
      ccab98d8-d879-f3cb-d00f-88d670322995    20180331    1    11000146104    900000000000534007    900000000000207008    20180331    20180131
      e86357d0-cb2b-f0e4-9b6d-ba1b3ea6e9ec    20170331    1    11000146104    900000000000534007    900000000000207008    20170331    20170131

    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 files1

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyFRI-515


    1 record removed, as planned in order to resolve FRI-515:

    • < f2dd5f3d-4d7b-f135-0083-5228998e1147    20220930    1    11000146104    900000000000534007    11000146104    20220930    20220930
    RefsetDescriptor files7

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyFRI-514

    NL EDITION EFFECTIVETIME 20220930:

    7 records removed intentionally, in order to resolve the issues in

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyFRI-514
    :

    • < 56147182-88f8-4931-85fc-78b20d0ef318    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    • < 5855a601-df43-4a43-b3bf-7d4220aec268    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • < b0cde552-02ae-11e7-a12f-83e4ef013404    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    • < c9dc169d-3516-4eb1-82c5-bcf5386cc162    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • < d88b1a4c-907e-4e04-b45d-ee30c27e61bb    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • < e63253ed-852d-4f9b-9bb6-d01f321c856e    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • < f006309d-8cda-4e8d-be81-1b97a06a59ad    20220930    1    11000146104    900000000000456007    15551000146102    900000000000510002    900000000000462002    0

    AS DISCOVERED IN Version 8 these were DUPLICATE RECORDS which we reported in FRI-514:

    • > 5855a601-df43-4a43-b3bf-7d4220aec268    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • > c9dc169d-3516-4eb1-82c5-bcf5386cc162    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • > d88b1a4c-907e-4e04-b45d-ee30c27e61bb    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • > e63253ed-852d-4f9b-9bb6-d01f321c856e    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • > f006309d-8cda-4e8d-be81-1b97a06a59ad    20220930    1    11000146104    900000000000456007    15551000146102    900000000000510002    900000000000462002    0
    • > b0cde552-02ae-11e7-a12f-83e4ef013404    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    • > 56147182-88f8-4931-85fc-78b20d0ef318    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1

    So now looking good, as for these PFT Lang Refsets (160161000146108 + 15551000146102), the final records remaining in version 10 are now:

    • d174dabc-c6c5-494d-b3bb-77f732b47667    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • 3db9f99e-a27c-4c52-96d7-774d38e2cf2d    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • 47afffa8-96ac-4978-aca6-e8cec0fd07fc    20220930    1    11000146104    900000000000456007    15551000146102    900000000000510002    900000000000462002    0
    • 191c0108-0ec7-494b-9af1-23e490cc5d0f    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1

    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 impactedRelated JIRA ticket(s)Rationale
    .JSON file

    Added into new package including NL refsets from previous published package (plus new PFT lang refsets):

        "id" : "31000146106",
        "term" : "Nederlandse taalreferentieset"
        "id" : "900000000000509007",
        "term" : "Amerikaans-Engelse taalreferentieset"
        "id" : "900000000000508004",
        "term" : "Brits-Engelse taalreferentieset"

    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

    • As confirmed by the matching rows in the Refsets tab in the NL Summary Component Stats Report above


    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 impactedRelated JIRA ticket(s)Rationale
    .JSON file

    Missing from new package!  Need to add in including NL refsets from previous published package:

        "id" : "31000146106",
        "term" : "Nederlandse taalreferentieset"
        "id" : "900000000000509007",
        "term" : "Amerikaans-Engelse taalreferentieset"
        "id" : "900000000000508004",
        "term" : "Brits-Engelse taalreferentieset"

    ExtendedMap files7104

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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 filesALL



    2 new NL records added + 1 record udpated:

    • > bdfe6eef-08d6-4fb1-a935-6ce0859e5e19    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
      • This is as expected, as it's adding in the explicit dependency on the Component Model Module
    • > f2dd5f3d-4d7b-f135-0083-5228998e1147    20220930    1    11000146104    900000000000534007    11000146104    20220930    20220930
      • This is WRONG - circular dependency!!  RAISED
        Jira
        serverIHTSDO JIRA
        serverIdb202d822-d767-33be-b234-fec5accd5d8c
        keyFRI-515
    • < 8066372e-dfd9-4b29-8037-0c9b553403d0    20160930    1    11000146104    900000000000534007    900000000000207008    20160930    20160731
      > 8066372e-dfd9-4b29-8037-0c9b553403d0    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
      • This is as expected, as it's adding in the latest version of the MDRS record, as this is the SNAPSHOT comparison

    + 3 INT records updated:

    • < 1244116f-fdb5-5645-afcc-5281288409da    20220131    1    900000000000207008    900000000000534007    900000000000012004    20220131    20220131
      > 1244116f-fdb5-5645-afcc-5281288409da    20220731    1    900000000000207008    900000000000534007    900000000000012004    20220731    20220731

    • < 686fe392-d2f7-586d-98aa-078aba426832    20220131    1    449080006    900000000000534007    900000000000207008    20220131    20220131
      > 686fe392-d2f7-586d-98aa-078aba426832    20220731    1    449080006    900000000000534007    900000000000207008    20220731    20220731

    • < f6431457-161b-5b46-9217-573c20c00070    20220131    1    449080006    900000000000534007    900000000000012004    20220131    20220131
      > f6431457-161b-5b46-9217-573c20c00070    20220731    1    449080006    900000000000534007    900000000000012004    20220731    20220731

      • These are as expected, as it's adding in the latest version of the MDRS record, as this is the SNAPSHOT comparison


    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)

    • 0b4e1466-2c3f-9f32-41bb-d3da113da1e0    20220331    1    11000146104    900000000000534007    900000000000207008    20220331    20220131
      0f938c9d-6c38-f3fc-97f6-c9d2236071d3    20200930    1    11000146104    900000000000534007    900000000000207008    20200930    20200731
      18318846-73e6-375a-6ffd-01b17f6aa82c    20210331    1    11000146104    900000000000534007    900000000000207008    20210331    20210131
      5843de36-69d9-c8fb-f2e4-284a0aa19722    20210930    1    11000146104    900000000000534007    900000000000207008    20210930    20210731
      5ff4ddf0-cead-28a1-a2c2-68234bef9da5    20180930    1    11000146104    900000000000534007    900000000000207008    20180930    20180731
      6c6fcbc2-f491-9389-0fc7-c2dd9f87e2f9    20190930    1    11000146104    900000000000534007    900000000000207008    20190930    20190731
      6ca74444-8e94-ab52-6516-3848258bfeff    20190331    1    11000146104    900000000000534007    900000000000207008    20190331    20190131
      7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20140131    1    11000146104    900000000000534007    900000000000207008    20140131    20140131
      8066372e-dfd9-4b29-8037-0c9b553403d0    20160930    1    11000146104    900000000000534007    900000000000207008    20160930    20160731
      8f2c4b76-5419-11e6-94a8-7f8b3d911fe5    20140731    1    11000146104    900000000000534007    900000000000207008    20140731    20140731
      995dfa9a-5419-11e6-94a8-7f8b3d911fe5    20150331    1    11000146104    900000000000534007    900000000000207008    20150331    20150131
      a09e4a26-5419-11e6-94a8-7f8b3d911fe5    20150916    1    11000146104    900000000000534007    900000000000207008    20150916    20150731
      a7a6d62b-2f9a-4fa5-a43c-59337476a74f    20170930    1    11000146104    900000000000534007    900000000000207008    20170930    20170731
      b02ee7bb-7ab7-4dec-ec64-af3d0c1a49b6    20200331    1    11000146104    900000000000534007    900000000000207008    20200331    20200309
      b0cc0389-0cdf-49cb-9c75-96bc75406b85    20160307    1    11000146104    900000000000534007    900000000000207008    20160307    20160131
      ccab98d8-d879-f3cb-d00f-88d670322995    20180331    1    11000146104    900000000000534007    900000000000207008    20180331    20180131
      e86357d0-cb2b-f0e4-9b6d-ba1b3ea6e9ec    20170331    1    11000146104    900000000000534007    900000000000207008    20170331    20170131

    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 files9085

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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)

    • As confirmed by the TOTAL of all Association Refset rows in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • As confirmed by the TOTAL of all Association Refset rows in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Attribute Value files10954

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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!)

    • As confirmed by the TOTAL of all AttributeValue Refset rows in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • As confirmed by the TOTAL of all AttributeValue Refset rows in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage... 

    RefsetDescriptor files23

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyFRI-514

    NL EDITION EFFECTIVETIME 20220930:

    17 records added:

    • > 1777b6d1-cee6-40d2-b053-ff52c3248a99    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • > 3c11958c-4ccd-458d-9c7f-74bc6a615a90    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
    • > 66372402-c261-4a60-8e9a-08d8c55d3a53    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • > 98b35fad-4982-4975-beb4-bc53d70197d1    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • > a8b90974-3be8-4fbd-a243-a3b51e88d9c6    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
    • > d7fcbff2-a825-41bc-8d5e-b616289ff48b    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0

    THESE REFSETS DON'T APPEAR TO BE VALID CONCEPTID's - CAN'T FIND THEM ANYWHERE IN THE "All Editions" Browser?!!  

    • 210051000146105
    • 210041000146107

    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
    210051000146105    Dutch simple reference set of causative pathogens in congenital infection

    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...

    • > 191c0108-0ec7-494b-9af1-23e490cc5d0f    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    • > f006309d-8cda-4e8d-be81-1b97a06a59ad    20220930    1    11000146104    900000000000456007    15551000146102    900000000000510002    900000000000462002    0
    • > b0cde552-02ae-11e7-a12f-83e4ef013404    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1
    • > 47afffa8-96ac-4978-aca6-e8cec0fd07fc    20220930    1    11000146104    900000000000456007    15551000146102    900000000000510002    900000000000462002    0
    • > 56147182-88f8-4931-85fc-78b20d0ef318    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    900000000000461009    1

    BUT 3x DUPLICATE RECORDS INCLUDED FOR SOME REASON?!!  RAISED

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyFRI-514
    .....

    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...

    • > 3db9f99e-a27c-4c52-96d7-774d38e2cf2d    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • > 5855a601-df43-4a43-b3bf-7d4220aec268    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • > c9dc169d-3516-4eb1-82c5-bcf5386cc162    20220930    1    11000146104    900000000000456007    160161000146108    900000000000511003    900000000000461009    1
    • > d174dabc-c6c5-494d-b3bb-77f732b47667    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • > d88b1a4c-907e-4e04-b45d-ee30c27e61bb    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
    • > e63253ed-852d-4f9b-9bb6-d01f321c856e    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0

    BUT 4x DUPLICATE RECORDS INCLUDED FOR SOME REASON?!!  RAISED

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyFRI-514
    .....

    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 files5234

    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 files796

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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


    • Just need confirmation from NL in Pre-Prod validation stage...

    Concept files11439

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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:

    Info
    titleGetting 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

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Description (EN) files

    31988


    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info

    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:

    Info

    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!!) *****

    • EXACTLY AS EXPECTED by the Summary Component Stats Report above  


    Description (NL) files

    25248


    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    0 records added/updated 

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • AS EXPECTED by the Summary Component Stats Report above  
    OwlExpression files26597

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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:

    Info
    titleGetting 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

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Stated Relationship files0

    0 changes as expected! (same as International Edition as well)

    Relationship files

    90078



    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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:

    Info
    titleGetting 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

    • AS EXPECTED as close to the counts inthe Summary Component Stats Reports above


    Relationship Concrete Values files2799

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info
    titleGetting 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) files1103n/a

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    Info

    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:

    Info

    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

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    TextDefinition (NL) files4354n/a

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    0 records added/updated

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Language (EN) files63305

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):


    Info

    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)

    • As confirmed by the TOTAL of "900000000000509007|United States of America English language reference set (foundation metadata concept)" + "900000000000508004|Great Britain English language reference set (foundation metadata concept)" rows in the Language Refsets tab in the EN Summary Component Stats Report above

    NL EDITION EFFECTIVETIME 20220930 (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions:

    Info

    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

    • As confirmed by the "900000000000509007|United States of America English language reference set (foundation metadata concept)"  row in the Language Refsets tab in the NL Summary Component Stats Report above

    Just need confirmation from the NL in Pre-Prod validation stage...

    Language (NL) files19093

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    0 changes as NL only

    NL EDITION EFFECTIVETIME 20220930:

    Info
    titleGetting 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

    • As confirmed by the "31000146106|Netherlands Dutch language reference set (foundation metadata concept)" row in the Language Refsets tab in the NL Summary Component Stats Report above

    **** BUT NO MENTION OF EITHER THE

    1. 9307 NL PATIENT FRIENDLY B1 REFSET (160161000146108) RECORDS COUNTED IN THE NL COMPONENT STATS REPORT ****
    2. 535 NL PATIENT FRIENDLY REFSET (15551000146102) RECORDS COUNTED IN THE NL COMPONENT STATS REPORT ****

    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 files5

    NL EDITION EFFECTIVETIME 20220930:

    0 records updated

    INTERNATIONAL EFFECTIVETIME 20220731 (or any of interim Monthly releases!):

    1 new records added:

    • > a720e7af-e728-7c08-8433-72a84ed387bc    20220731    1    900000000000012004    723561005    1230370004    123037004    0    0..*    0..0    723597001    723594008

    Plus 2 records updated:

    • < 8d066b27-118d-4a84-886a-14dabceba155    20170731    1    900000000000012004    723561005    363698007    404684003    1    0..*    0..*    723597001    723596005
      > 8d066b27-118d-4a84-886a-14dabceba155    20220731    1    900000000000012004    723561005    363698007    404684003    1    0..*    0..1    723597001    723596005


    • < 351405be-c515-4997-a9cb-a55d83e66ecb    20170731    1    900000000000012004    723561005    116676008    404684003    1    0..*    0..*    723597001    723596005
      > 351405be-c515-4997-a9cb-a55d83e66ecb    20220731    1    900000000000012004    723561005    116676008    404684003    1    0..*    0..1    723597001    723596005

    Plus 2 records inactivated:

    • < 04a6c94d-879d-44ea-bc39-6207bc92b2b6    20170731    1    900000000000012004    723561005    363698007    404684003    1    0..*    0..1    723597001    723593002
      > 04a6c94d-879d-44ea-bc39-6207bc92b2b6    20220731    0    900000000000012004    723561005    363698007    404684003    1    0..*    0..1    723597001    723593002


    • < 3e984ab7-c9e6-4919-bd3a-0c2cd3e205a6    20170731    1    900000000000012004    723561005    116676008    404684003    1    0..*    0..1    723597001    723593002
      > 3e984ab7-c9e6-4919-bd3a-0c2cd3e205a6    20220731    0    900000000000012004    723561005    116676008    404684003    1    0..*    0..1    723597001    723593002

    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 files3n/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 files4n/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 ??????????