March

September 2023 Pre-Production (Version

14

9) vs

March

September 2023 Production (Version

3

1) traceability

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

Summary Component Stats report (INT 20220731 20230131 - 2023013120230731): https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA1S1vjzO46O-BJvdPg9uxf7RfyMorf61bUbZrRsfz1S-o/edit#gid=013

MSSP Ticket: https://jira.ihtsdotools.org/browse/MSSP-2257

Differences found in package Comparison	Number of RF2 records impacted	Related JIRA ticket(s)	Rationale
Readme file

n/aAll

Prod naming conventions added, and x prefixes removed,

and Prod naming convention applied

as expected

March

September 2023 Pre-Production (Version

13

5) vs

March

September 2023 Pre-Production (Version

14

9) traceability

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

Summary Component Stats report (INT 20220731 20230131 - 2023013120230731): https://docs.google.com/spreadsheets/d/1mAO9EcnOx9vrCx1lknGjmygFS1194Mxjr3X6ZFrolQA1S1vjzO46O-BJvdPg9uxf7RfyMorf61bUbZrRsfz1S-o/edit#gid=013

MSSP Ticket: https://jira.ihtsdotools.org/browse/MSSP-2257

Differences found in package Comparison	Number of RF2 records impacted	Related JIRA ticket(s)	Rationale

Document Type Simple Refset

Correlated Map files

2

ISRS-1487

MSSP-1678

1 records inactivated +

1 record added

8

4 records added/updated,

> 12622fe3-bf59-4803-8159-0357d66f2859 20230930

< 0755622e-606e-4677-84d4-a2512e6dde07 20160307

1 11000146104

9631000146108 9981000146102

32311000146108 288939007 3002 447558009 31511000146105
>

0755622e

2fc47229-

606e

98a2-

4677

4bbe-

84d4

97fd-

a2512e6dde07

b6ae182a5d09

20230331

20230930

0

1 11000146104

9631000146108 9981000146102

32321000146103 47200007 447556008 98321000146109
>

2f45cd25

a78eabb6-

d671

ab0e-

4246

4371-

b552

9fe2-

227d4d9d9cd1

a3dac320b2b7

20230331

20230930 1 11000146104

9631000146108 770574001

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

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

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

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

Differences found in package Comparison

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

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

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

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

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

Differences found in package Comparison

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

1 record removed, and 1 record re-activated:

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

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

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

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

Dutch Nursing Intervention Simple Refset files2

1 record removed, and 1 record inactivated:

< acba7434-5eda-b90c-7153-dc8f1c453d45 20190331 1 11000146104 99051000146107 11451000146104
> acba7434-5eda-b90c-7153-dc8f1c453d45 20230331 0 11000146104 99051000146107 11451000146104
< c31c57fc-f47f-4d49-8989-778b050ab025 20230331 0 11000146104 99051000146107 11451000146104

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

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

Dutch Implants Intensional Simple Refset files4

2 records removed, and 2 records inactivated:

< 5ba5b27f-a0fd-e60d-4a17-9991bebd081d 20220331 1 11000146104 117721000146102 1186653007
> 5ba5b27f-a0fd-e60d-4a17-9991bebd081d 20230331 0 11000146104 117721000146102 1186653007
< 7d883adc-b426-c1a8-d4b0-170eea843c08 20200331 1 11000146104 117721000146102 724419006
> 7d883adc-b426-c1a8-d4b0-170eea843c08 20230331 0 11000146104 117721000146102 724419006

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

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

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

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

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

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

Differences found in package Comparison

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Differences found in package Comparison

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

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

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

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

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

Dutch Non Drug Allergen Simple Refset Snapshot files933MSSP-1905

933 NEW RECORDS ADDED FOR REFSETID: 42931000146101

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

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

SO NEED TO VERIFY THAT THIS REFSET IS FIXED:

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

RefsetDescriptor files2

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

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

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

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

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

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

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

Differences found in package Comparison

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

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

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

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

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

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

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

Dutch Non Drug Allergen Simple Refset Snapshot files933MSSP-1905

933 NEW RECORDS ADDED FOR REFSETID: 42931000146101

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

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

SO NEED TO VERIFY THAT THIS REFSET IS FIXED:

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

32311000146108 47200007 48 447557004 31501000146108
> fd56ff8b-ab7f-480c-bcd9-851b7715e632 20230930 1 11000146104 32321000146103 288939007 b5105 447557004 31491000146103

+ 4 records inactivated:

< b465ed30-a7a8-996b-954e-f12ced76ba0b 20170930 1 11000146104 32311000146108 199312002 48 447557004 31501000146108
> b465ed30-a7a8-996b-954e-f12ced76ba0b 20230930 0 11000146104 32311000146108 199312002 48 447557004 31501000146108

< b88fcf2a-b064-161d-9d2e-24294488799d 20170930 1 11000146104 32321000146103 399122003 b5105 447557004 31491000146103
> b88fcf2a-b064-161d-9d2e-24294488799d 20230930 0 11000146104 32321000146103 399122003 b5105 447557004 31491000146103

< f1af9ca2-467c-2e84-735d-ad9e5310bbf6 20190930 1 11000146104 32321000146103 199312002 447556008 98321000146109
> f1af9ca2-467c-2e84-735d-ad9e5310bbf6 20230930 0 11000146104 32321000146103 199312002 447556008 98321000146109

< ffacf48c-f8ac-9b3b-c456-f76c9be9d6ab 20170930 1 11000146104 32311000146108 399122003 3002 447558009 31511000146105
> ffacf48c-f8ac-9b3b-c456-f76c9be9d6ab 20230930 0 11000146104 32311000146108 399122003 3002 447558009 31511000146105

As expected in MSSP Ticket (above)

Correlated Extended Map files

10

5 records added/updated,

> de9b9056-c5fa-4592-a7af-04bff991e863 20230930 1 11000146104 148521000146104 227408005 447556008
> 51b23baa-a198-4e87-906a-00a2ab10b4d5 20230930 1 11000146104 148521000146104 1259874000 447556008
> 67197566-eb6b-4940-91a1-6839640993e4 20230930 1 11000146104 31451000146105 47200007 00227 447558009
> 6f497502-b207-45fd-93ab-e4aab557234f 20230930 1 11000146104 148521000146104 73892005 447556008
> 88fc3110-7d3c-4fe3-9c73-83c7efdb3e00 20230930 1 11000146104 31451000146105 288939007 00103 447557004

+ 5 records inactivated:

< 49183868-ab2f-2e2b-7d83-45721ebf5983 20170930 1 11000146104 31451000146105 199312002 00227 447558009
> 49183868-ab2f-2e2b-7d83-45721ebf5983 20230930 0 11000146104 31451000146105 199312002 00227 447558009

< 934bcb58-3209-4d13-4ac4-114ca8110caa 20210331 1 11000146104 148521000146104 110031000146102 447556008
> 934bcb58-3209-4d13-4ac4-114ca8110caa 20230930 0 11000146104 148521000146104 110031000146102 447556008

< a2170f0e-0f74-1ef4-3cf4-c09e525922f3 20210331 1 11000146104 148521000146104 412113006 447556008
> a2170f0e-0f74-1ef4-3cf4-c09e525922f3 20230930 0 11000146104 148521000146104 412113006 447556008

< ba688051-9425-d971-a736-717e2eedcc51 20170930 1 11000146104 31451000146105 399122003 00103 447557004
> ba688051-9425-d971-a736-717e2eedcc51 20230930 0 11000146104 31451000146105 399122003 00103 447557004

< c6445b54-f66f-eaca-76c0-7176e9ee51ee 20210331 1 11000146104 148521000146104 91606004 447556008
> c6445b54-f66f-eaca-76c0-7176e9ee51ee 20230930 0 11000146104 148521000146104 91606004 447556008

As expected in MSSP Ticket (above)

September 2023 Pre-Production (Version 4) vs September 2023 Pre-Production (Version 5) traceability

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

Summary Component Stats report (INT 20230131 - 20230731): https://docs.google.com/spreadsheets/d/1S1vjzO46O-BJvdPg9uxf7RfyMorf61bUbZrRsfz1S-o/edit#gid=13

MSSP Ticket: https://jira.ihtsdotools.org/browse/MSSP-2257

Differences found in package Comparison	Number of RF2 records impacted	Related JIRA ticket(s)	Rationale
OWL Expression files	37	ISRS-1651	37 inactivation records reset to previous versions, as expected due to fixes in ISRS-1651 diff_sct2_sRefset_OWLExpressionSnapshot_NL1000146_20230930.txt

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

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

Summary Component Stats report (INT 20230131 - 20230731):

MSSP Ticket: https://jira.ihtsdotools.org/browse/MSSP-2257

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

.JSON file

Updated with new fields as planned - looks good

Readme file

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

ModuleDependency files

ALL

2 NL records updated + 3 INT records updated with new dates for this cycle, as expected

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

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

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

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)RationaleDutch laboratory test method simple reference set (260131000146101)
2MSSP-1905

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

> ./der2_Refset_DutchLaboratoryTestMethodSimpleRefsetFull_NL1000146_20230331.txt
> ./der2_Refset_DutchLaboratoryTestMethodSimpleRefsetSnapshot_NL1000146_20230331.txt

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

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

> ./der2_Refset_DutchUndefinedAllergensSimpleRefsetSnapshot_NL1000146_20230331.txt
> ./der2_Refset_DutchUndefinedAllergensSimpleRefsetFull_NL1000146_20230331.txt

Readme file

2x New refsets added as expected:

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

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

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

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

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale.JSON file Updated with new fields as planned - looks goodReadme fileAll dates updated, Pre-prod naming conventions added, and x prefixes added, as expectedModuleDependency filesALLISRS-1340

2 NL records updated:

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

+ 3 INT records updated:

< 1244116f-fdb5-5645-afcc-5281288409da 20220731 1 900000000000207008 900000000000534007 900000000000012004 20220731 20220731
< 686fe392-d2f7-586d-98aa-078aba426832 20220731 1 449080006 900000000000534007 900000000000207008 20220731 20220731
< f6431457-161b-5b46-9217-573c20c00070 20220731 1 449080006 900000000000534007 900000000000012004 20220731 20220731
> 1244116f-fdb5-5645-afcc-5281288409da 20230131 1 900000000000207008 900000000000534007 900000000000012004 20230131 20230131
> 686fe392-d2f7-586d-98aa-078aba426832 20230131 1 449080006 900000000000534007 900000000000207008 20230131 20230131
> f6431457-161b-5b46-9217-573c20c00070 20230131 1 449080006 900000000000534007 900000000000012004 20230131 20230131

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


RefsetDescriptor files	2		2 records added, as expected

from new NL Refsets being added this cycle (MSSP-1905):

????

< 1bf8ff52-a02e-cf8d-f690-ee739fa2aff7 20170930 1 11000146104 900000000000456007 31451000146105 449608002 900000000000461009 0
> 1bf8ff52-a02e-cf8d-f690-ee739fa2aff7 20230930

> 1211681b-fa7c-4fda-8809-81f572ccd34e 20230331

1 11000146104 900000000000456007

260181000146102

31451000146105

449608002 > f79f002d-b7db-4992-a31c-2b1e1aa9b7d8 20230331

900000000000500006 900000000000461009 0

266a268

< 74b3e5d7-c709-9746-d274-1e6419019e6c    20210331    1    11000146104    900000000000456007   

260131000146101 449608002 900000000000461009 0

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

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

100491000146109 Dutch simple reference set for undefined allergens

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

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

148521000146104 449608002 900000000000461009 0
> 74b3e5d7-c709-9746-d274-1e6419019e6c 20230930 1 11000146104 900000000000456007 148521000146104 900000000000500006 900000000000461009

As these are the 2x NL Map refsets, and the change is from type 449608002 | Referenced component (foundation metadata concept) | to 900000000000500006 | Map source (foundation metadata concept) | these seem like sensible changes.

Association files

6353

INTERNATIONAL EFFECTIVETIME 20230731

Association files6039INTERNATIONAL EFFECTIVETIME 20230131

(or any of interim Monthly releases!):

Info

title	Getting accurate manual counts:

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

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

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

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

3956

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

1142

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

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

NL EDITION EFFECTIVETIME

20230331

20230930:

Info

title	Getting accurate manual counts:

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

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

940

220 records added/updated plus

1

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

22339

20110

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

13282

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

81

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

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

NL EDITION EFFECTIVETIME

20230331

20230930:

8973

8066 records added/updated plus

3

18 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) files	39312		INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!

):

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

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

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

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

652 records added/updated plus

384 inactivated

As confirmed by the

):

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

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

As confirmed by the TOTAL of "900000000000509007|United States of America English language reference set (foundation metadata concept)"

row

+ "900000000000508004|Great Britain English language reference set (foundation metadata concept)" rows in the Language Refsets tab in the 

NL

EN Summary Component Stats Report above

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

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

541

Language (NL) files64547

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

0 changes as NL only

NL EDITION EFFECTIVETIME 20230331:

42622

records added/updated plus

21925

189 inactivated

As confirmed by the "

31000146106|Netherlands Dutch

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+ ???? records added for PFT

Language

Refset 15551000146102 +

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

As confirmed by the matching rows in the

Refsets tab in the NL Summary Component Stats Report above

Just need confirmation from the NL in Pre-Prod validation

stage...

CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!

ExtendedMap files

*stage...*
Language (NL) files	21420

5308

INTERNATIONAL EFFECTIVETIME

20230131 SEND TO NL TO VERIFY ONCE HAVE FINAL VERSION -

20230731 (or any of interim Monthly releases!):

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

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

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

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

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

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

NO KNOWN NL MAPS FOR NOW....

0 changes as NL only

NL EDITION EFFECTIVETIME 20230930:

18768 records added/updated plus

2652 inactivated

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

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

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

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

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

Dutch laboratory test method simple reference set (260131000146101)
2MSSP-1905

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

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

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

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

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

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

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

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

To be reactivated, with 933 members:

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

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

Document Type Simple Refset files

0

CHECK CAREFULLY BECAUSE I SPLIT THESE UP MANUALLY!!
ExtendedMap files	5308	INTERNATIONAL EFFECTIVETIME 20230731 (or any of interim Monthly releases!): 4278 records added/updated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!) 1030 records inactivated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!) ################################################################################################################# CAN I COMPARE TO INT SUMMARY STATS????? SO MAYBE DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the MAP files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!! ################################################################################################################# NO KNOWN NL MAPS FOR NOW.... SEND TO NL TO VERIFY ONCE HAVE FINAL VERSION - Just need confirmation from the NL in Pre-Prod validation stage...
Dutch laboratory test method simple reference set (260131000146101)	0	0 changes, as confirmed in MSSP Ticket
Dutch simple reference set for undefined allergens (260181000146102)	0	0 changes, as confirmed in MSSP Ticket
Dutch non-drug allergen simple reference set for Dutch clinical building blocks version 2017 (foundation metadata concept) (42931000146101)	28	26 records added, 2 inactivated, as confirmed in MSSP Ticket
Document Type Simple Refset files (9631000146108)	0	0 changes, as confirmed in MSSP Ticket

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


Dutch Causes Of Death Statistics Simple Refset files (51000146100)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Contact Allergen Simple Refset files (98051000146103)	1

1

0 records added,

0

1 inactivated, as confirmed in MSSP

-1905

Ticket

Dutch Food Allergen Simple Refset files (98011000146102)

3

31

2

29 records added,

1

2 inactivated, as confirmed in MSSP

-1905

Ticket

Dutch Implant Registry Simple Refset files (52801000146101)

17

12

15

12 records added,

2

0 inactivated, as confirmed in MSSP

-1905

Ticket
Dutch Implants Extensional Simple Refset files (117731000146100)	0		0

records added

changes,

0inactivated,

as confirmed in MSSP

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

Ticket

Dutch Implants Intensional Simple Refset files (117721000146102)

17

12

15

12 records added,

2

0 inactivated, as confirmed in MSSP

-1905

Ticket

Dutch Inhalation Allergen Simple Refset files (98021000146107)

1

1 records added,

0 inactivated, as confirmed in MSSP

-1905

Ticket
Dutch Insect Venom Allergen Simple Refset files (98031000146109)	0		0 changes, as confirmed in MSSP

-19050 changes

Ticket

Dutch Mental Health Procedures Simple Refset files

0

(140741000146104)

2

1 records added,

1 inactivated

, as confirmed in MSSP

-1905

Ticket

Dutch Microorganism Simple Refset files (2581000146104)

26

66

22

20 records added,

4

46 inactivated, as confirmed in MSSP

-1905

Ticket
Dutch Mixed Flora Finding Simple Refset files (145871000146106)	0		0 changes, as confirmed in MSSP

-1905

Ticket

Dutch Nursing Intervention For Delirium Simple Refset files (110891000146105)

1

0

0 changes,

1 records added,

1 inactivated,

as confirmed in MSSP

-1905

Ticket
Dutch Nursing Interventions For Fall Risk Simple Refset files (110881000146108)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Nursing Interventions For Pain Simple Refset files (110861000146100)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Nursing Interventions For Psychosocial Care Simple Refset files (110911000146108)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Nursing Interventions For Suicide Simple Refset files (110901000146106)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Nursing Interventions For Wound Simple Refset files (110871000146106)	0		0 changes, as confirmed in MSSP

-1905

Ticket

Dutch Nursing Intervention Simple Refset files (99051000146107)

1

1 records added,

1 inactivated

0

0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Nursing Observations For Delirium Simple Refset files (140961000146101)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Nursing Observations For Fall Risk Simple Refset files (140981000146109)	0		0 changes, as confirmed in MSSP

-1905

0

0 changes

Ticket

Dutch Nursing Observations For Suicide Simple Refset files

(140971000146107)

4

2 records added,

2 inactivated

, as confirmed in MSSP

-1905

Ticket

Dutch Nursing Observation Simple Refset files

0

0 changes

(140991000146106)

4

2 records added,

2 inactivated

, as confirmed in MSSP

-1905

Ticket

Dutch Nursing Problem Simple Refset files (11721000146100)

2

4

2 records added,

0

2 inactivated, as confirmed in MSSP

-1905

Ticket
Dutch Obstetric Procedures Simple Refset files (146481000146103)	1		0

0 changes

records added,

1 inactivated, as confirmed in MSSP

-1905

Ticket
Dutch Occupational Allergen Simple Refset files (98041000146101)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Optometric Diagnoses Simple Refset files (41000146103)	4		2

0

records added,

2 inactivated, as confirmed in MSSP

-1905

Ticket

Dutch Optometric Procedures Simple Refset files (231000146105)

1

0

records added,1 inactivated

changes, as confirmed in MSSP

-1905

Ticket
Dutch Optometric Reason For Visit Simple Refset files (8721000146106)	0		0 changes, as confirmed in MSSP

-1905

Ticket

Dutch Pathology Simple Refset files (110851000146103)

33

25

16

11 records added,

17

14 inactivated, as confirmed in MSSP

-1905

Ticket
Dutch Radio Allergosorbent Test Result Simple Refset files (55451000146109)	0		0 changes, as confirmed in MSSP

-19050 changes

Ticket

Dutch Rare Neuromuscular Disorders Simple Refset files

0

(2551000146109)

2

1 records added,

1 inactivated

, as confirmed in MSSP

-1905

Ticket

Dutch Ordinal Microbial Susceptibility Test Results Simple Refset files

(140301000146101)

0

1

1 records added,

0

inactivated

changes, as confirmed in MSSP

-1905

Ticket
Dutch Causative Pathogens In Congenital Infection Simple Refset files (210051000146105)	0		0 changes, as confirmed in MSSP

-1905

Ticket
Dutch Causative Pathogens In Sepsis And Meningitis Simple Refset files (210041000146107)	0		0 changes, as confirmed in MSSP

-1905

Ticket

Dutch Total Non Drug Allergen Simple Refset files (98061000146100)

10

28

9

26 records added,

1 inactivated, as confirmed in MSSP-1905

Netherlands Microscopic Ordinal Test Result Simple Refset files

0

0 changes, as confirmed in MSSP-1905

Netherlands Ordinal Test Result Simple Refset files

0

0 changes

2 inactivated, as confirmed in MSSP

-1905Sections Of ETransfer Of Nursing Data

Ticket
Netherlands Microscopic Ordinal Test Result Simple Refset files (97801000146108)	0		0 changes, as confirmed in MSSP

-1905Dutch Nursing Problems With Sections Of ETransfer

Ticket
Netherlands Ordinal Test Result Simple Refset files (46231000146109)	0		0 changes, as confirmed in MSSP

-1905

Simple Refset SNAPSHOT files

236

212 records added/updated (all for 900000000000207008)

24 inactivated

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

Correlated Extended Map files8

Ticket
Sections Of ETransfer Of Nursing Data Simple Refset files (117701000146105)	2		1

6

records added,

2

1 inactivated, as confirmed

in MSSP-1905

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

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

in MSSP Ticket

Dutch Nursing Problems With Sections Of ETransfer Simple Refset files (117711000146107)

8

5 records added,

3

Correlated Map files5

4 records added,

1

inactivated, as confirmed in MSSP

-1905

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

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

See notes in MSSP-1905

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

Ticket
Simple Refset SNAPSHOT files	236	212 records added/updated (all for 900000000000207008) 24 inactivated Unable to validate without manually totally up all previous 6 months INT release counts
Correlated Extended Map files	0	0 records added, 0 inactivated, as confirmed in MSSP Ticket MISSING FROM THIS VERSION!! ASKED NL WHERE THE DELTA FOR THESE INACTIVATIONS ARE - THEY WERE ON THE MSSP TICKET, BUT WERE INVALID (NL NRC had used the same UUID's to manually inactivate records, as they had to manually add in the new replacements - so only one change was applied by the SRS!)
Correlated Map files	0	0 records added, 0 inactivated, as confirmed in MSSP Ticket MISSING FROM THIS VERSION!!

NEED TO ASK

ASKED NL WHERE THE DELTA FOR THESE INACTIVATIONS ARE

??? AGAIN THE COMMENTS IN THIS TICKET ARE NOT ACTUALLY DESCRIBING CHANGES IN THE MAP/REFSETS, BUT JUST IN THE AUTHORING - SO NO IMPACT TO THE RELEASED MAP FILES

- THEY WERE ON THE MSSP TICKET, BUT WERE INVALID (NL NRC had used the same UUID's to manually inactivate records, as they had to manually add in the new replacements - so only one change was applied by the SRS!)
SimpleMap files	4749		INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

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

13 records inactivated, plus

NL EDITION EFFECTIVETIME

20230331

20230930:

0 records changed, as nothing for NL in this file

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

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

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

MRCMAttributeRange files

1

n/a

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

1 records updated, plus

0 records inactivated, plus

0 new records added,

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

NL EDITION EFFECTIVETIME

20230331

20230930:

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

MRCMAttributeDomain files

0

NL EDITION EFFECTIVETIME

20230331

20230930:

0 records updated

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

0 new records added/updated:

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

MRCMDomain files

1

n/a

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

1 records UPDATED,

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

NL EDITION EFFECTIVETIME

20230331

20230930:

0 records changed

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

Concept files

8569

8362

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

5884

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

2433

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

NL EDITION EFFECTIVETIME

20230331

20230930:

158

198 records added/updated plus

94

103 inactivated

As confirmed by the Summary Component Stats Reports above

Description (EN) files

20529

28070

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

16315

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

2357

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

NL EDITION EFFECTIVETIME

20230331

20230930:

1459

6960 records added/updated plus

386

189 inactivated

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

Description (NL) files

113390

21421

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

0 records added/updated

NL EDITION EFFECTIVETIME

20230331

20230930:

110309

18875 records added/updated plus

3081

2546 inactivated

AS EXPECTED as close to the counts if you TOTAL UP counts above + Compare to TOTAL OF INT + NL

Counts across BOTH of the Summary Component Stats Reports above

Counts across BOTH of the Summary Component Stats Reports above
Identifier files	n/a	Headers updated in line with new format, as expected (MSSP-2163) < identifierSchemeId alternateIdentifier effectiveTime active moduleId referencedComponentId > alternateIdentifier effectiveTime active moduleId identifierSchemeId referencedComponentId
Stated Relationship files	0	0 changes as expected! (same as International Edition as well)
Relationship files

84344

78107

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

47067

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

30706

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

NL EDITION EFFECTIVETIME

20230331

20230930:

2943

3209 records added plus

3628

3570 inactivated

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

Relationship Concrete Values files

731

710

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

663

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

68

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

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

NL EDITION EFFECTIVETIME

20230331

20230930:

0 records changed

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

OwlExpression files

20262

19164

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

16934

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

2471

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

NL EDITION EFFECTIVETIME

20230331

20230930:

721

574 records added/updated plus

130

163 inactivated

As confirmed by the Summary Component Stats Report above

TextDefinition (EN) files

443

729

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

403

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

36

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

NL EDITION EFFECTIVETIME

20230331

20230930:

3

0 records added/updated plus

1

0 inactivated

As confirmed by the Summary Component Stats Report above

TextDefinition (NL) files

154

157

INTERNATIONAL EFFECTIVETIME

20230131

20230731 (or any of interim Monthly releases!):

0 records added/updated

NL EDITION EFFECTIVETIME

20230331

20230930:

125

89 records added/updated plus

29

68 inactivated

As confirmed by the Summary Component Stats Report above

Page tree

Versions Compared

Old Version 1

New Version Current

Key

September 2023 Pre-Production (Version

9) vs

September 2023 Production (Version

1) traceability

September 2023 Pre-Production (Version

5) vs

September 2023 Pre-Production (Version

9) traceability

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

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

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

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

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

September 2023 Pre-Production (Version 4) vs September 2023 Pre-Production (Version 5) traceability

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

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

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

Page tree

Page History

Versions Compared

Old Version 1

New Version Current

Key

September 2023 Pre-Production (Version

9) vs

September 2023 Production (Version

1) traceability

September 2023 Pre-Production (Version

5) vs

September 2023 Pre-Production (Version

9) traceability

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

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

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

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

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

September 2023 Pre-Production (Version 4) vs September 2023 Pre-Production (Version 5) traceability

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

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

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