Page tree

March 2023 Pre-Production (Version 14) vs March 2023 Production (Version 3) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Readme filen/a


All x prefixes removed, and Prod naming convention applied as expected


March 2023 Pre-Production (Version 13) vs March 2023 Pre-Production (Version 14) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Document Type Simple Refset files2

ISRS-1487



MSSP-1678

1 records inactivated +

1 record added

< 0755622e-606e-4677-84d4-a2512e6dde07    20160307    1    11000146104    9631000146108    9981000146102
> 0755622e-606e-4677-84d4-a2512e6dde07    20230331    0    11000146104    9631000146108    9981000146102

> 2f45cd25-d671-4246-b552-227d4d9d9cd1    20230331    1    11000146104    9631000146108    770574001

As expected, due to fixes that myself and WCI applied to reconcile UUID's after NL finally added this refset to the Refset Tool (see ISRS-1487MSSP-1678)

March 2023 Pre-Production (Version 12) vs March 2023 Pre-Production (Version 13) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
n/a

No regression issues found - fixes confirmed as addressing specific problems without unintended impact.

March 2023 Pre-Production (Version 11) vs March 2023 Pre-Production (Version 12) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Dutch Nursing Problem Simple Refset files2

1 record removed, and 1 record re-activated:

< 8068b74c-649d-447a-a973-6fee34d2704b    20200331    0    11000146104    11721000146100    284905001
> 8068b74c-649d-447a-a973-6fee34d2704b    20230331    1    11000146104    11721000146100    284905001

< c088cb26-7645-4755-b432-8e681d76a547    20230331    1    11000146104    11721000146100    284905001

As expected, after WCI had to rebuild ALL NL refsets due to them not having the "reconcile UUID's" flag set to true:

"...the updates to the database have been made and things are ready to go.  Only three refsets required modification:
11721000146100, 99051000146107, and 117721000146102.  All other refset UUIDs matched what's in snowstorm."

Dutch Nursing Intervention Simple Refset files2

1 record removed, and 1 record inactivated:

< acba7434-5eda-b90c-7153-dc8f1c453d45    20190331    1    11000146104    99051000146107    11451000146104
> acba7434-5eda-b90c-7153-dc8f1c453d45    20230331    0    11000146104    99051000146107    11451000146104

< c31c57fc-f47f-4d49-8989-778b050ab025    20230331    0    11000146104    99051000146107    11451000146104

As expected, after WCI had to rebuild ALL NL refsets due to them not having the "reconcile UUID's" flag set to true:

"...the updates to the database have been made and things are ready to go.  Only three refsets required modification:
11721000146100, 99051000146107, and 117721000146102.  All other refset UUIDs matched what's in snowstorm."

Dutch Implants Intensional Simple Refset files4

2 records removed, and 2 records inactivated:

< 5ba5b27f-a0fd-e60d-4a17-9991bebd081d    20220331    1    11000146104    117721000146102    1186653007
> 5ba5b27f-a0fd-e60d-4a17-9991bebd081d    20230331    0    11000146104    117721000146102    1186653007

< 7d883adc-b426-c1a8-d4b0-170eea843c08    20200331    1    11000146104    117721000146102    724419006
> 7d883adc-b426-c1a8-d4b0-170eea843c08    20230331    0    11000146104    117721000146102    724419006

< d99fbb5d-e32d-4e28-8737-1cac1cddd392    20230331    0    11000146104    117721000146102    724419006
< da0a87a4-a16d-4266-8b27-55f57e5def28    20230331    0    11000146104    117721000146102    1186653007

As expected, after WCI had to rebuild ALL NL refsets due to them not having the "reconcile UUID's" flag set to true:

"...the updates to the database have been made and things are ready to go.  Only three refsets required modification:
11721000146100, 99051000146107, and 117721000146102.  All other refset UUIDs matched what's in snowstorm."

March 2023 Pre-Production (Version 10) vs March 2023 Pre-Production (Version 11) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Dutch Non Drug Allergen Simple Refset Snapshot files933MSSP-1905

933 NEW RECORDS ADDED FOR REFSETID: 42931000146101, AS EXPECTED due to intended changes listed in MSSP-1905 to re-instate this refset with just 933 records

WCI have now fixed the issue with the lack of reconciliation of UUID's, so it looks like all records that are totally new are still being added, and all records that were previously inactive in the last published release are now being reconciled and re-activated (instead of being duplicated by being created again as new with new UUID's) (eg) in the Full file the UUID's are the only thing changed:

  • < 12c46189-234f-4c65-a804-f78c9ef8adbe    20230331    1    11000146104    42931000146101    256092002
  • > fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20230331    1    11000146104    42931000146101    256092002

Whereas in the Snapshot the record itself is now being inactivated:

  • < fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20210331    0    11000146104    42931000146101    256092002
  • > fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20230331    1    11000146104    42931000146101    256092002 

This means that in the actual Release package (version11) itself, the Full file now looks historically correct:

fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20170930    1    11000146104    42931000146101    256092002
fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20210331    0    11000146104    42931000146101    256092002
fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20230331    1    11000146104    42931000146101    256092002

And the Snapshot ONLY contains this single latest change for 256092002, instead of the duplicates that were in the previous versions:

fe842740-b0b1-bee1-dcc3-c50aa4fa604e    20230331    1    11000146104    42931000146101    256092002

HOWEVER, the final status of all records will be for the NL NRC to verify themselves during the Pre-Prod testing stage...

March 2023 Pre-Production (Version 9) vs March 2023 Pre-Production (Version 10) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Dutch simple reference set for undefined allergens (260181000146102)8MSSP-1905

8 new records ADDED for this brand new refset, with the CORRECT RefsetID now assigned:

> 0e8f68e2-6111-43a7-8f36-96430c106994    20230331    1    11000146104    260181000146102    46384008
> 2a2bd3e2-6bd1-4820-b16a-144682965b41    20230331    1    11000146104    260181000146102    830076001
> 41e6268b-12f1-461c-809b-c773eb888e87    20230331    1    11000146104    260181000146102    4940008
> 5f125fcc-b3fe-496a-af06-948094887ee2    20230331    1    11000146104    260181000146102    260161000146105
> 71142432-51e5-4c3d-9323-30c403e9259d    20230331    1    11000146104    260181000146102    260201000146103
> 71e46db9-5b76-4523-9425-48ee143ae381    20230331    1    11000146104    260181000146102    111088007
> 774faf59-0f42-4b52-aca8-1be9fb741081    20230331    1    11000146104    260181000146102    260191000146100
> ad9986f7-20c2-4f13-adb6-cbba07cae1da    20230331    1    11000146104    260181000146102    260171000146104

SO NEEDED TO VERIFY THAT REFSET "Dutch simple reference set for undefined allergens" IS NOW PROPERLY FIXED:

  1. THE 8 OLD INVALID RECORDS FOR REFSETID 100491000146109 ARE REMOVED COMPLETELT FOR FULL + SNAPSHOT
    1. Correct for FULL + Correct for Snapshot
  2. THE 8 NEW VALID RECORDS FOR REFSETID 260181000146102 ARE ADDED BACK INTO BOTH FULL + SNAPSHOT
    1. Correct for FULL + Correct for Snapshot
Dutch Non Drug Allergen Simple Refset Snapshot files933MSSP-1905

933 NEW RECORDS ADDED FOR REFSETID: 42931000146101

AS EXPECTED due to intended changes listed in MSSP-1905 to re-instate this refset with just 933 records


HOWEVER THIS CHANGE WAS SUPPOSED TO REPLACE THE ORIGINAL 2000+ INACTIVE RECORDS IN THE OLD REFSET (42931000146101 - Dutch non-drug allergen simple reference set for Dutch clinical building blocks version 2017) WITH 933 ACTIVE RECORDS IN THE NEW REFSET (42931000146101 - Dutch Non Drug Allergen)

SO NEED TO VERIFY THAT THIS REFSET IS FIXED:

  1. THE 2000+ OLD INACTIVE RECORDS (42931000146101****THAT ARE NOT BEING REACTIVATED BY THESE CHANGES)  FOR REFSETID 42931000146101 ARE RETAINED IN SNAPSHOT (AS CURRENT STATUS) + REMAIN IN FULL AS HISTORY
    1. 20220930 - All 2204 records were INACTIVE in the Snapshot - so entire refset was INACTIVATED
    2. 20230331 - ALL 2204 INACTIVE records from the 20220930 Snapshot are included in the 20230331 FULL File, as expected
  2. THE 933 NEW ACTIVE RECORDS FOR REFSETID 42931000146101 ARE ADDED INTO BOTH FULL + SNAPSHOT
    1. FULL FILE
    2. 20220930 - THE FULL FILE CONTAINED 6088 RECORDS IN TOTAL
    3. 20230331 - THE FULL FILE CONTAINS 7021 RECORDS IN TOTAL, SO ALL 933 NEW RECORD HAVE BEEN ADDED, as expected
    4. SNAPSHOT FILE
    5. 20220930 - THE SNAPSHOT FILE CONTAINED 2204 RECORDS IN TOTAL
    6. 20230331 - THE SNAPSHOT FILE CONTAINS 3137 RECORDS IN TOTAL, SO ALL 933 NEW RECORD HAVE BEEN ADDED, as expected
    7. 20230331 - However 2204 INACTIVE records are still retained within the snapshot, as expected
      1. ****UNLESS SOME WERE SUPPOSED TO BE RECONCILED + REINSTATED/REACTIVATED, RATHER THAN JUST BEING REPLACED WITH NEW RECORDS????
      2. XXXXXX SPOT CHECKED SOME, AND WHILST SOME OF THE NEW 933 RECORDS ARE UNIQUE, MANY ARE REFERENCING THE SAME CONCEPT, JUST WITH A NEW UUID - AND THEREFORE IS NOT RECONCILING AND REINSTATING THEM - INSTEAD IT'S DUPLICATING THEM IN THE SNAPSHOT FILE!!!
  3. ANY OF THE 933 NEWLY RE-ACTIVATED RECORDS THAT WERE PREVIOUSLY PART OF THE 2000+ INACTIVE RECORDS ARE ACTUALLY REINSTATED (REPLACED IN THE SNAPSHOT BY ACTIVE RECORDS, INSTEAD OF JUST BEING ADDED IN AMD THEREFORE LEAVING DUPLICATE RECORDS IN THE SNAPSHOT (1X OLD INACTIVE + 1X NEW ACTIVE)
    1. XXXXXX SPOT CHECKED SOME, AND WHILST SOME OF THE NEW 933 RECORDS ARE UNIQUE, MANY ARE REFERENCING THE SAME CONCEPT, JUST WITH A NEW UUID - AND THEREFORE IS NOT RECONCILING AND REINSTATING THEM - INSTEAD IT'S DUPLICATING THEM IN THE SNAPSHOT FILE!!!


RefsetDescriptor files2


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

  • > 1211681b-fa7c-4fda-8809-81f572ccd34e    20230331    1    11000146104    900000000000456007    260181000146102    449608002    900000000000461009    0
    266a268
  • > f79f002d-b7db-4992-a31c-2b1e1aa9b7d8    20230331    1    11000146104    900000000000456007    260131000146101    449608002    900000000000461009    0

Now refsetID's have been fixed by the NRC, this is now correct for 2x new refsets for this cycle:

  • Dutch simple reference set for undefined allergens (260181000146102)
  • Dutch laboratory test method simple reference set (260131000146101)

March 2023 Pre-Production (Version 8) vs March 2023 Pre-Production (Version 9) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Dutch simple reference set for undefined allergens (260181000146102)8MSSP-19058 new records REMOVED for this brand new refset.  

< 0e8f68e2-6111-43a7-8f36-96430c106994    20230331    1    11000146104    100491000146109    46384008
< 2a2bd3e2-6bd1-4820-b16a-144682965b41    20230331    1    11000146104    100491000146109    830076001
< 41e6268b-12f1-461c-809b-c773eb888e87    20230331    1    11000146104    100491000146109    4940008
< 5f125fcc-b3fe-496a-af06-948094887ee2    20230331    1    11000146104    100491000146109    260161000146105
< 71142432-51e5-4c3d-9323-30c403e9259d    20230331    1    11000146104    100491000146109    260201000146103
< 71e46db9-5b76-4523-9425-48ee143ae381    20230331    1    11000146104    100491000146109    111088007
< 774faf59-0f42-4b52-aca8-1be9fb741081    20230331    1    11000146104    100491000146109    260191000146100
< ad9986f7-20c2-4f13-adb6-cbba07cae1da    20230331    1    11000146104    100491000146109    260171000146104

AS EXPECTED due to intended changes listed in MSSP-1905 to fix initial invalid assignment by NL NRC of refsetID to a pre-existing conceptID (100491000146109)

BUT WHY NOT REPLACED WITH NEW REFSETID RECORDS with CORRECT refsetID??? (260181000146102)

BECAUSE THE MANIFEST NEEDS TO BE UPDATED WITH NEW CORRECT REFSETID TOO (FOR BOTH INCORRECT REFSETS).

THEN IN THE NEXT PACAKAGE I NEED TO VERIFY THAT REFSET "Dutch simple reference set for undefined allergens" IS FIXED:

  1. THE 8 OLD INVALID RECORDS FOR REFSETID 100491000146109 ARE REMOVED COMPLETELT FOR FULL + SNAPSHOT
  2. THE 8 NEW VALID RECORDS FOR REFSETID 260181000146102 ARE ADDED BACK INTO BOTH FULL + SNAPSHOT


Dutch Non Drug Allergen Simple Refset Snapshot files933MSSP-1905

933 NEW RECORDS ADDED FOR REFSETID: 42931000146101

AS EXPECTED due to intended changes listed in MSSP-1905 to re-instate this refset with just 933 records


HOWEVER THIS CHANGE WAS SUPPOSED TO REPLACE THE ORIGINAL 2000+ INACTIVE RECORDS IN THE OLD REFSET (42931000146101 - Dutch non-drug allergen simple reference set for Dutch clinical building blocks version 2017) WITH 933 ACTIVE RECORDS IN THE NEW REFSET (42931000146101 - Dutch Non Drug Allergen)

SO NEED TO VERIFY THAT THIS REFSET IS FIXED:

  1. THE 2000+ OLD INACTIVE RECORDS )****THAT ARE NOT BEING REACTIVATED BY THESE CHANGES)  FOR REFSETID 42931000146101 ARE RETAINED IN SNAPSHOT (AS CURRENT STATUS) + REMAIN IN FULL AS HISTORY
  2. THE 933 NEW ACTIVE RECORDS FOR REFSETID 42931000146101 ARE ADDED INTO BOTH FULL + SNAPSHOT
  3. ANY OF THE 933 NEWLY RE-ACTIVATED RECORDS THAT WERE PREVIOUSLY PART OF THE 2000+ INACTIVE RECORDS ARE ACTUALLY REINSTATED (REPLACED IN THE SNAPSHOT BY ACTIVE RECORDS, INSTEAD OF JUST BEING ADDED IN AMD THEREFORE LEAVING DUPLICATE RECORDS IN THE SNAPSHOT (1X OLD INACTIVE + 1X NEW ACTIVE)


March 2023 Pre-Production (Version 4) vs March 2023 Pre-Production (Version 8) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Dutch laboratory test method simple reference set (260131000146101)

2MSSP-1905

2 new records added for this brand new refset.  New files added for this new refset, as expected due to request in MSSP-1905

  • > ./der2_Refset_DutchLaboratoryTestMethodSimpleRefsetFull_NL1000146_20230331.txt
  • > ./der2_Refset_DutchLaboratoryTestMethodSimpleRefsetSnapshot_NL1000146_20230331.txt
Dutch simple reference set for undefined allergens (100491000146109)8MSSP-19058 new records added for this brand new refset.  

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

  • > ./der2_Refset_DutchUndefinedAllergensSimpleRefsetSnapshot_NL1000146_20230331.txt
  • > ./der2_Refset_DutchUndefinedAllergensSimpleRefsetFull_NL1000146_20230331.txt
Readme file

2x New refsets added as expected:

>  xder2_Refset_DutchLaboratoryTestMethodSimpleRefsetFull_NL1000146_20230331.txt
>  xder2_Refset_DutchLaboratoryTestMethodSimpleRefsetSnapshot_NL1000146_20230331.txt
>  xder2_Refset_DutchUndefinedAllergensSimpleRefsetFull_NL1000146_20230331.txt
>  xder2_Refset_DutchUndefinedAllergensSimpleRefsetSnapshot_NL1000146_20230331.txt


September 2022 Published PUBLISHED vs March 2023 Pre-Production (Version 4) traceability

Summary Component Stats report (NL 20220930 - 20230331)https://docs.google.com/spreadsheets/d/1I5kGDtRqk3S1AJnd_x7wZGU1gr21IWLFl0hfuJlGrYg/edit#gid=0

Summary Component Stats report (INT 20220731 - 20230131):  https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA/edit#gid=0

Differences found in package Comparison

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

Updated with new fields as planned - looks good
Readme file

All dates updated, Pre-prod naming conventions added, and x prefixes added, as expected
ModuleDependency filesALL

ISRS-1340


2 NL records updated:

  • < 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20220930    1    11000146104    900000000000534007    900000000000207008    20220930    20220731
    < dcc1637b-9178-424b-9237-bc602a1a6fbf    20220930    1    11000146104    900000000000534007    900000000000012004    20220930    20220731
  • > 7f102c6c-5419-11e6-94a8-7f8b3d911fe5    20230331    1    11000146104    900000000000534007    900000000000207008    20230331    20230131
    > dcc1637b-9178-424b-9237-bc602a1a6fbf    20230331    1    11000146104    900000000000534007    900000000000012004    20230331    20230131

+ 3 INT records updated:

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

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

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

  • > 1244116f-fdb5-5645-afcc-5281288409da    20230131    1    900000000000207008    900000000000534007    900000000000012004    20230131    20230131

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

  • > f6431457-161b-5b46-9217-573c20c00070    20230131    1    449080006    900000000000534007    900000000000012004    20230131    20230131

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

RefsetDescriptor files2


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

  • > 1211681b-fa7c-4fda-8809-81f572ccd34e    20230331    1    11000146104    900000000000456007    260181000146102    449608002    900000000000461009    0
    266a268
  • > f79f002d-b7db-4992-a31c-2b1e1aa9b7d8    20230331    1    11000146104    900000000000456007    260131000146101    449608002    900000000000461009    0

THIS IS INCORRECT - the automatically generated RefsetDescriptor is correctly picking up one refset as new (260131000146101), yet not the other (100491000146109).  It's also picking up a seemingly random refset (260181000146102) which is neither in the NL authoring ticket (https://jira.ihtsdotools.org/browse/MSSP-1905), nor even in the refset tool!

AAT RAISED ISRS-1452 to fix... Issue turned out to be a problem with NL's creation of the refset - the new refset was logged in this ticket with the following ID:

  • 100491000146109 Dutch simple reference set for undefined allergens

BUT This Refset has been created in the Refset tool with the ID 100491000146109, but this ID was a previously published Procedure - 

100491000146109 |Closed reduction of slipped distal humerus epihysis (procedure)|
We had Elze fix the error, and re-assign the refset ID to 260181000146102 as it should have been all along. Therefore the RefsetDescriptor process was actually correct.
Association files6039

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

Getting accurate manual counts:

First need to search diff file for INT active - "1\t900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0\t900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Then need to search diff file for INT active - "1\t900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0\t900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

3956 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above)

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

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

NL EDITION EFFECTIVETIME 20230331:

Getting accurate manual counts:

First need to search diff file for NL active - "1\t11000146104", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active NL records that were REMOVED this release in your count!!)

Next need to search diff file for NL inactive - "0\t11000146104", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive NL records that were REMOVED this release in your count!!)

940 records added/updated plus

1 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 files22339

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

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

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

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

NL EDITION EFFECTIVETIME 20230331:

8973 records added/updated plus

3 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) files39312

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

33612 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above)

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

  • 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 20230331: (in the EN file because they have some acceptabilities in the NL Lang Refset for the EN Descriptions:

652 records added/updated plus

384 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) files64547

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

0 changes as NL only

NL EDITION EFFECTIVETIME 20230331:

42622 records added/updated plus

21925 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

+ ???? records added for PFT Language Refset 15551000146102 + 

+ ???? 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 files5308

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

4278 records added/updated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

1030 records inactivated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

#################################################################################################################

CAN I COMPARE TO INT SUMMARY STATS?????

SO MAYBE DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the MAP files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!!

#################################################################################################################

NO KNOWN NL MAPS FOR NOW.... 

SEND TO NL TO VERIFY ONCE HAVE FINAL VERSION - Just need confirmation from the NL in Pre-Prod validation stage...

Dutch laboratory test method simple reference set (260131000146101)

2MSSP-1905

2 new records added for this brand new refset.  New files added for this new refset, as expected due to request in MSSP-1905

  • > ./der2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetSnapshot_NL1000146_20220331.txt
  • > ./der2_Refset_DutchCausativePathogensInSepsisAndMeningitisSimpleRefsetFull_NL1000146_20220331.txt

MISSING FROM THIS VERSION!!  FIXED IN NEXT VERSION....

Dutch simple reference set for undefined allergens (100491000146109)8MSSP-19058 new records added for this brand new refset.  

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

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

MISSING FROM THIS VERSION!!  FIXED IN NEXT VERSION....

Dutch non-drug allergen simple reference set for Dutch clinical building blocks version 2017 (foundation metadata concept) (42931000146101)



To be reactivated, with 933 members:

MISSING FROM THIS VERSION!!  NEED TO DOWNLOAD ACTIVE SNAPSHOT FILES AND INCLUDE IN NEXT VERSION

***** BUT - THE CHANGES DON'T MAKE SENSE AS THE REFSET ID HAS CHANGED AS WELL, AND SO I'VE ASKED THE QUESTIONS IN MSSP-1905 at 13:50 on 07/03/2023 - IF WE DON'T GET QUICK SATISFACTORY ANSWER THEN WE WILL RECOMMEND REMOVAL OF THIS CHANGE FOR THIS CYCLE.

Document Type Simple Refset files

0


0 changes, NOT confirmed in MSSP-1905. ??????????????????????  However as they've made such a mess of the other refsets we have no time to address this, and so for this cycle Terance agreed we will just assume that this is correct.

Dutch Causes Of Death Statistics Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Contact Allergen Simple Refset files

1


1 records added,

0 inactivated, as confirmed in MSSP-1905

Dutch Food Allergen Simple Refset files

3


2 records added,

1 inactivated, as confirmed in MSSP-1905

Dutch Implant Registry Simple Refset files

17


15 records added,

2 inactivated, as confirmed in MSSP-1905

Dutch Implants Extensional Simple Refset files

0


0 records added,

0inactivated, as confirmed in MSSP-1905

??????? SHOULD HAVE BEEN UPDATED ACCORDING TO TICKET - ASKED NL...... FEIKJE CONFIRMED THIS WAS JUST HUMAN ERROR, AND HAS NOW CONFIRMED THAT THIS REFSET SHOULD REMAIN STATIC FOR THIS CYCLE

Dutch Implants Intensional Simple Refset files

17


15 records added,

2 inactivated, as confirmed in MSSP-1905

Dutch Inhalation Allergen Simple Refset files

1


1 records added,

0 inactivated, as confirmed in MSSP-1905

Dutch Insect Venom Allergen Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Mental Health Procedures Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Microorganism Simple Refset files

26


22 records added,

4 inactivated, as confirmed in MSSP-1905

Dutch Mixed Flora Finding Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Intervention For Delirium Simple Refset files

1


1 records added,

1 inactivated, as confirmed in MSSP-1905

Dutch Nursing Interventions For Fall Risk Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Interventions For Pain Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Interventions For Psychosocial Care Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Interventions For Suicide Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Interventions For Wound Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Intervention Simple Refset files

1


1 records added,

1 inactivated, as confirmed in MSSP-1905

Dutch Nursing Observations For Delirium Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Observations For Fall Risk Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Observations For Suicide Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Observation Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Problem Simple Refset files

2


2 records added,

0 inactivated, as confirmed in MSSP-1905

Dutch Obstetric Procedures Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Occupational Allergen Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Optometric Diagnoses Simple Refset files

2


0 records added,

2 inactivated, as confirmed in MSSP-1905

Dutch Optometric Procedures Simple Refset files

1


0 records added,

1 inactivated, as confirmed in MSSP-1905

Dutch Optometric Reason For Visit Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Pathology Simple Refset files

33


16 records added,

17 inactivated, as confirmed in MSSP-1905

Dutch Radio Allergosorbent Test Result Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Rare Neuromuscular Disorders Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Ordinal Microbial Susceptibility Test Results Simple Refset files

1


1 records added,

0 inactivated, as confirmed in MSSP-1905

Dutch Causative Pathogens In Congenital Infection Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Causative Pathogens In Sepsis And Meningitis Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Total Non Drug Allergen Simple Refset files (98061000146100)

10


9 records added,

1 inactivated, as confirmed in MSSP-1905

Netherlands Microscopic Ordinal Test Result Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Netherlands Ordinal Test Result Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Sections Of ETransfer Of Nursing Data Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Dutch Nursing Problems With Sections Of ETransfer Simple Refset files

0


0 changes, as confirmed in MSSP-1905

Simple Refset SNAPSHOT files


236


212 records added/updated (all for 900000000000207008)

24 inactivated

Unable to validate without manually totally up all previous 6 months INT release counts

Correlated Extended Map files8

6 records added,

2 inactivated, as confirmed in MSSP-1905

ALL records to be INACTIVATED, as this ENTIRE REFSET was intended to be inactivated - see comments in the Refsets tab of MSSP-1905

MISSING FROM THIS VERSION!!  ASKED NL WHERE THE DELTA FOR THESE INACTIVATIONS ARE - THEY CONFIRMED THAT THIS WAS NEVER ACTUALLY PART OF THE PREVIOUS PUBLISHED PACKAGE, AND THEREFORE THERE'S NO CHANGE REQUIRED HERE

Correlated Map files5

4 records added,

1 inactivated, as confirmed in MSSP-1905

++++++++ ACTUAL FORMAT CHANGED:

< id    effectiveTime    active    moduleId    refsetId    referencedComponentId    mapTarget    snomedCtSourceCodeToTargetMapCodeCorrelationValue
---
> id    effectiveTime    active    moduleId    refsetId    referencedComponentId    mapTarget    correlationId

See notes in MSSP-1905 

ALL records to be ACTIVATED, as this ENTIRE REFSET was intended to replace the now-inactivated refset 31441000146107 - see comments in the Refsets tab of MSSP-1905

MISSING FROM THIS VERSION!!  NEED TO ASK NL WHERE THE DELTA FOR THESE INACTIVATIONS ARE???  AGAIN THE COMMENTS IN THIS TICKET ARE NOT ACTUALLY DESCRIBING CHANGES IN THE MAP/REFSETS, BUT JUST IN THE AUTHORING - SO NO IMPACT TO THE RELEASED MAP FILES

SimpleMap files4749

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

4736 records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!

13 records inactivated, plus


NL EDITION EFFECTIVETIME 20230331:

0 records changed, as nothing for NL in this file

This matches the International Edition changes, as looking at the INT Stats report (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above) there were 4712 BRAND NEW Concepts added in this NL dependent cycle, and therefore there should have been that many records added for CTV3.

+ a handful of new/updated records for ICD-0 as expected, gets us to the 4736 number of changes.

Therefore this is the expected result, as we never expect to have NL specific changes in this file.

MRCMAttributeRange files1n/a

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

1 records updated, plus

0 records inactivated, plus

0 new records added,

Unable to validate without manually totally up all previous 6 months INT release counts

NL EDITION EFFECTIVETIME 20230331:

0 records changed, as NL don't update this file so far

MRCMAttributeDomain files0

NL EDITION EFFECTIVETIME 20230331:

0 records updated

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

0 new records added/updated:

Unable to validate without manually totally up all previous 6 months INT release counts

MRCMDomain files1n/a 

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

1 records UPDATED,

Unable to validate without manually totally up all previous 6 months INT release counts

NL EDITION EFFECTIVETIME 20230331:

0 records changed

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

Concept files8569

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

5884 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above)

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

NL EDITION EFFECTIVETIME 20230331:

158 records added/updated plus

94 inactivated

  • As confirmed by the Summary Component Stats Reports above
Description (EN) files

20529


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

16315 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above)

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

NL EDITION EFFECTIVETIME 20230331:

1459 records added/updated plus

386 inactivated

  • AS EXPECTED as close to the counts if you TOTAL UP counts above + Compare to TOTAL OF INT + NL Counts across BOTH of the Summary Component Stats Reports above
Description (NL) files

113390


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

0 records added/updated 

NL EDITION EFFECTIVETIME 20230331:

110309 records added/updated plus

3081 inactivated

  • AS EXPECTED as close to the counts if you TOTAL UP counts above + Compare to TOTAL OF INT + NL Counts across BOTH of the Summary Component Stats Reports above
Stated Relationship files0

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

Relationship files

84344



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

47067 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above)

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

NL EDITION EFFECTIVETIME 20230331:

2943 records added plus

3628 inactivated

  • AS EXPECTED as close to the counts if you TOTAL UP counts above + Compare to TOTAL OF INT + NL Counts across BOTH of the Summary Component Stats Reports above


Relationship Concrete Values files731

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

663 records added/updated, plus as confirmed in new INT only Component Stats Report run by devops - see above

68 records inactivated  as confirmed in new INT only Component Stats Report run by devops - see above

...exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (January 2022)

NL EDITION EFFECTIVETIME 20230331:

0 records changed

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

OwlExpression files20262

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

16934 records added/updated (as confirmed in new INT only Component Stats Report run by devops - see above)

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

NL EDITION EFFECTIVETIME 20230331:

721 records added/updated plus

130 inactivated

  • As confirmed by the Summary Component Stats Report above
TextDefinition (EN) files

443


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

403 records added/updated (as confirmed in new INT only Component Stats Report run by devops from - see above)

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

NL EDITION EFFECTIVETIME 20230331:

3 records added/updated plus

1 inactivated

  • As confirmed by the Summary Component Stats Report above
TextDefinition (NL) files

154


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

0 records added/updated 

NL EDITION EFFECTIVETIME 20230331:

125 records added/updated plus

29 inactivated

  • As confirmed by the Summary Component Stats Report above
  • No labels