Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 51 Next »

March 2022 Published FIXED 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
Readme file added!!???!!!!

> ./Readme_en_20220331.txt
Dutch Causative Pathogens In Congenital Infection Simple Refset
MSSP-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
Dutch Causative Pathogens In Sepsis And Meningitis Simple Refset
MSSP-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
Simple Refset file (SNAPSHOT)

SHOULD ONLY CONTAIN DIFFERENCES BETWEEN REFSET FILES FOR SEPT 2022 CHANGES, AS I MANUALLY ADDED PREVIOUSLY PUBLISHED REFSETS TO THIS FIXED MARCH PACKAGE...

 records removed, and manually added into new separate Refset files instead


Simple Refset file (FULL)

SHOULD ONLY CONTAIN DIFFERENCES BETWEEN REFSET FILES FOR SEPT 2022 CHANGES, AS I MANUALLY ADDED PREVIOUSLY PUBLISHED REFSETS TO THIS FIXED MARCH PACKAGE...

 records removed, and manually added into new separate Refset files instead


RefsetDescriptor files16

16 records added:

> 1777b6d1-cee6-40d2-b053-ff52c3248a99    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
> 191c0108-0ec7-494b-9af1-23e490cc5d0f    20220930    1    11000146104    900000000000456007    15551000146102    900000000000511003    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
> 3c11958c-4ccd-458d-9c7f-74bc6a615a90    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    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
> 48a3c317-795d-4d45-8cab-0cf385849422    20220228    0    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000465000    1
> 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
> a3e46ae7-0da5-461e-8e33-913cd6ae4d20    20220228    1    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000461009    1
> a8b90974-3be8-4fbd-a243-a3b51e88d9c6    20220930    1    11000146104    900000000000456007    210041000146107    449608002    900000000000461009    0
> c73c609c-e3fe-457e-8cb3-f7e8d220a0ab    20220731    1    900000000000207008    900000000000456007    1186924009    900000000000533001    900000000000460005    1
> d174dabc-c6c5-494d-b3bb-77f732b47667    20220930    1    11000146104    900000000000456007    160161000146108    900000000000510002    900000000000462002    0
> d7fcbff2-a825-41bc-8d5e-b616289ff48b    20220930    1    11000146104    900000000000456007    210051000146105    449608002    900000000000461009    0
> e3394b4a-2617-4e67-8f2b-ac706ba60400    20220731    1    900000000000207008    900000000000456007    1186921001    900000000000533001    900000000000460005    1

Association files9085

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

Getting accurate manual counts:

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

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

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

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

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

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

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

NL EDITION EFFECTIVETIME 20220930:

Getting accurate manual counts:

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

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

2841 records added/updated plus

9 inactivated

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

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

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 files


472


442 records added/updated (all for 900000000000207008)

30 inactivated

BUT ZERO REMOVED AS EXPECTED, AS 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


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






























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 agreed to remain static from last published release (see confirmation from NL NRC in MSSP-1678)
Correlated Map filesALL

858 records added as expected, as these files are agreed to remain static from last published release (see confirmation from NL NRC in MSSP-1678)

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

FRI-515 - Getting issue details... STATUS


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

FRI-514 - Getting issue details... STATUS

NL EDITION EFFECTIVETIME 20220930:

7 records removed intentionally, in order to resolve the issues in FRI-514 - Getting issue details... STATUS :

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

Getting accurate manual counts:

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

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

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

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

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

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

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

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

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

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


NO KNOWN NL MAPS FOR NOW.... 


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

ModuleDependency 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 FRI-515 - Getting issue details... STATUS
  • < 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!):

Getting accurate manual counts:

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

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

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

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

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

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

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

NL EDITION EFFECTIVETIME 20220930:

Getting accurate manual counts:

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

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

2841 records added/updated plus

9 inactivated

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

Getting accurate manual counts:

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

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

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

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

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

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

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

NL EDITION EFFECTIVETIME 20220930:

Getting accurate manual counts:

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

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

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

FRI-514 - Getting issue details... STATUS

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 FRI-514 - Getting issue details... STATUS .....

THESE ARE ALL NL PATIENT FRIENDLY REFSET (160161000146108) RECORDS - SHOULD THESE BE INCLUDED?  YES RDA confirmed on 9/9/22 that the PFT Language refsets should all be included, so the refsetDescriptor file is correct - we just need to fix the manifest to include the Language refset records in the release package...

  • > 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 FRI-514 - Getting issue details... STATUS .....

Only way to validate this is by manually going back through the past 6 months' worth of dependent INT Edition Traceability matrices, and checking the changes match!

***** THESE RECORDS MATCH THE PRODUCTION INTERNATIONAL EDITION CHANGES FOR THE MONTHLY RELEASES BETWEEN THE DEPENDENT INT EDITION RELEASES (20220228 - 20220630) - the changes above are  identical to those INT changes made in the 20220228 INT Edition release, as requested by Linda (see International Edition Traceability matrix (February 2022)).  NOTE - whilst the inactivation records are identical, the UUID of the new replacement record is different from the first INT Edition build (PreProd version 9), but thankfully this UUID was refreshed in the final Feb 2022 Prod release (version 1), and matched the one above.   There were no other refsetDescriptor changes between 20220228 - 20220630, so the above changes are valid and expected.

Readme file
n/a

Readme file added as wasn't in previous Published Package at all!

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

Getting accurate manual counts:

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

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

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

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

30 records inactivated, plus

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

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

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

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


NL EDITION EFFECTIVETIME 20220930:

0 records changed as nothing for NL in this file


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

Concept files11439

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

Getting accurate manual counts:

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

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

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

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

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

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

NL EDITION EFFECTIVETIME 20220930:

Getting accurate manual counts:

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

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

388 records added/updated plus

134 inactivated

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

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

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

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

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

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

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


NL EDITION EFFECTIVETIME 20220930:

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

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

1430 records added/updated plus

330 inactivated

***** AS EXPECTED TO HAVE NL MODULE DESCRIPTIONS IN DESCRIPTION EN FILE??? (check internally first as we're the ones who split out the EN + NL files!!) *****

  • 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:

Getting accurate manual counts:

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

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

16408 records added/updated plus

4319 inactivated

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

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

Getting accurate manual counts:

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

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

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

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

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

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

NL EDITION EFFECTIVETIME 20220930:

Getting accurate manual counts:

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

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

1047 records added/updated plus

537 inactivated

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

Getting accurate manual counts:

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

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

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

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

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

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

NL EDITION EFFECTIVETIME 20220930:

Getting accurate manual counts:

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

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

4213 records added plus

4330 inactivated

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

Getting accurate manual counts:

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

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

2392 records updated, plus as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above

407 records inactivated  as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220731- see above

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

NL EDITION EFFECTIVETIME 20220930:

0 records changed

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

TextDefinition (EN) files1103n/a

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

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

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


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

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


NL EDITION EFFECTIVETIME 20220930:

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

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

1 records added/updated plus

***** WHY HAS THIS TEXTDEFINITION RECORD BEEN ADDED TO THE NL MODULE RATHER THAN INTERNATIONAL? (given that the term is in English) - INTENTIONAL ????? *****

0 inactivated

  • 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:

Getting accurate manual counts:

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

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

4331 records added/updated plus

23 inactivated

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


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:

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:

Getting accurate manual counts:

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

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

14454 records added/updated plus

4367 inactivated

  • 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 ??????????


  • No labels