Page tree

Versions Compared

Key

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

March 2020 Pre-Production (Version1) vs March 2020 Pre-Production (Version2) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
OWL Expression files312

ISRS-704

312 records updated, as confirmed by Gabor thanks to his fixes in ISRS-704

Inferred Relationship files2020

ISRS-704

1173 records inactivated +

160 records added +

687 records updated, as confirmed by Gabor thanks to his fixes in ISRS-704


March 2020 (PUBLISHED) vs September 2020 Pre-Production (Version1) traceability

??????????????? ??????????????

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
ExtendedMap files24096

10961 records updated (10922 MORE than International Edition), plus

1207 records inactivated (1 LESS than International Edition), plus

11928 records added (9176 MORE than International Edition)

Need to verify this with WCI + Kin Wah.... Kin Wah confirmed they don't keep logs!

  • Sept18 - Mar19 Diff = 36,100
  • Setp19 US Extension changes = 18101

So roughly the right amount given the previous number of changes

SEND TO JULIA and KIN WAH TO VERIFY ONCE HAVE FINAL VERSION

AssociationReference files4327

5 records updated, plus

960 records inactivated (??????????? MORE than International Edition), plus

3362 records added (???????? MORE than International Edition)

US Edition specific changes are related to ...

  • Sept18 - Mar19 Diff = 5775 (including 63 US Specific changes)
  • Setp19 US Extension changes = 11

~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:72: > 024df973-4ada-4cd8-a47c-26830e16b145 20200301 1 731000124108 900000000000527005 15744161000119109 774144009
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:106: > 0396d78a-d494-47a3-b787-da24491a9107 20200301 1 731000124108 900000000000527005 429561000124107 816087006
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:1447: > 308c2756-2a39-411d-9da2-08acfa3f9ea6 20200301 1 731000124108 900000000000527005 3591000175103 788005004
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:1961: > 43e7e66d-e3b8-4ca9-b08d-da6cb719e563 20200301 1 731000124108 900000000000527005 12239261000119105 816120008
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:2491: > 54e3a6b5-6c97-4cba-b822-6e87ad4dc310 20200301 1 731000124108 900000000000527005 436581000124106 471300007
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:3032: > 683858a8-665a-4721-b573-4aa701980a12 20200301 1 731000124108 900000000000527005 15746001000119104 774142008
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:3392: > 74f89ee4-624c-4bec-9d3f-e5250ab75083 20200301 1 731000124108 900000000000527005 15744121000119104 774143003
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:4313: > 8fee3fa9-e98a-4451-b251-f69b85ba77a4 20200301 1 731000124108 900000000000527005 3541000175108 788001008
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:4517: > 97abf901-0632-465b-a400-79002b8a258e 20200301 1 731000124108 900000000000527005 449601000124105 788003006
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:4696: > 9f25790f-5077-43aa-a690-694a5c3eb303 20200301 1 731000124108 900000000000527005 8211000175102 789717003
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:5018: > ab06b6c9-a7d5-4934-8a7a-6ff92c531632 20200301 1 731000124108 900000000000527005 15744361000119107 774138005
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:5162: > af1b0176-3606-482a-a813-1358842a2dc6 20200301 1 731000124108 900000000000527005 15676081000119102 781240002
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:5862: > c4a550c8-1cb1-4438-84bb-36a7a082a978 20200301 1 731000124108 900000000000527005 15676121000119100 781239004
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:5903: > c5f00c27-98f9-4122-b48e-6abc3a95eade 20200301 1 731000124108 900000000000527005 15744321000119102 774139002
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:6258: > d04ab24f-fa97-4890-8af2-60f60cc95d9f 20200301 1 731000124108 900000000000527005 12239221000119100 816119002
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:7415: > f7ac9dc9-048b-47b8-8e67-3aa7159d2c9e 20200301 1 731000124108 900000000000527005 430751000124105 621000009105
~/tempUS/target (Sept2019Published vs March2020PreProdVersion1)/c/diff_der2_cRefset_AssociationSnapshot_US1000124_20190901.txt:7461: > f8f9119b-66ce-4d41-94ba-b95664b645b0 20200301 1 731000124108 900000000000527005 3471000175103 789718008

Spot checks look good, with 14 inactivations + 7 equivalencies resolved, as confirmed in Penni's spreadsheet:

https://docs.google.com/spreadsheets/d/1uo__1Ud3WQVKu_gEZoO09Voc29SAUxL2Aj7I0N5viIE/edit#gid=0


RefsetDescriptor filesn/a


0 changes this cycle

Readme file
n/aUpdated to reflect new EffectiveTime as expected + x prefixes added for Pre-Production
ModuleDependency filesALLn/a

6 records updated with latest effectiveTimes, as expected:

< 1244116f-fdb5-5645-afcc-5281288409da 20200131 1 900000000000207008 900000000000534007 900000000000012004 20200131 20200131
< 53773521-fd81-5dde-9a2d-8b87e8803251 20200301 1 5991000124107 900000000000534007 731000124108 20200301 20200131
< 686fe392-d2f7-586d-98aa-078aba426832 20200131 1 449080006 900000000000534007 900000000000207008 20200131 20200131
< 70edb2ac-8a7a-5a94-b385-f8ad80db3858 20200301 1 731000124108 900000000000534007 900000000000012004 20200301 20200131
< 71ae8ceb-7984-550c-b1f5-9a69681b383a 20200301 1 731000124108 900000000000534007 900000000000207008 20200301 20200131
< f6431457-161b-5b46-9217-573c20c00070 20200131 1 449080006 900000000000534007 900000000000012004 20200131 20200131
---
> 1244116f-fdb5-5645-afcc-5281288409da 20200731 1 900000000000207008 900000000000534007 900000000000012004 20200731 20200731
> 53773521-fd81-5dde-9a2d-8b87e8803251 20200901 1 5991000124107 900000000000534007 731000124108 20200901 20200731
> 686fe392-d2f7-586d-98aa-078aba426832 20200731 1 449080006 900000000000534007 900000000000207008 20200731 20200731
> 70edb2ac-8a7a-5a94-b385-f8ad80db3858 20200901 1 731000124108 900000000000534007 900000000000012004 20200901 20200731
> 71ae8ceb-7984-550c-b1f5-9a69681b383a 20200901 1 731000124108 900000000000534007 900000000000207008 20200901 20200731
> f6431457-161b-5b46-9217-573c20c00070 20200731 1 449080006 900000000000534007 900000000000012004 20200731 20200731


SimpleMap files3890

7 records inactivated, plus

3883 records added

This matches the International Edition changes exactly, as 4411 added for CTV3 (as part of the normal authoring cycle updates, exported from the termServer - this is the exact expected amount as it matches exactly the number of new concepts created in the latest authoring cycle)

+ 31 new/updated records for ICD-0 as expected, matching the 31 records in the Delta from mapping tool.

  • Sept18 - Mar19 Diff = 11905 International change, 0 US changes
  • Setp19 US Extension changes = 0

Therefore this is the expected result, as we never have US specific changes in this file

Simple refset files129

68 records inactivated, plus

61 records added

This is as expected from the Lateralizable Refset changes that Yong made in this cycle for the International Edition, with no additional US changes found

  • Sept18 - Mar19 Diff = 172 International change, 0 US changes
  • Setp19 US Extension changes = 0

Therefore this is the expected result, as we never have US specific changes in this file

Concept files7615

1668 records updated (???? 69 MORE than International Edition), plus

2073 records inactivated (???? MORE 13 LESS than International Edition), plus

3874 records added (???? 9 LESS THAN than International Edition!!!!)

US Edition specific changes are related to ...

HOW ARE THERE LESS NEW RECORDS THAN IN THE INT EDITION?!!

Analysis:

These 81 records must have been DONATED from US to International Content - in this way the International Edition will have 81 more "NEW" concepts than the US Edition (as they will now be inactive or had their module updated in the US Edition). Therefore, the fact that the additional updated/inactviated records in the US Edition (as compared to the International) are 33 + 48 = 81, means that this proves that the donated content makes up for the drop in "New" concepts in the US Edition.

Description files

16883


642 records updated (???? 75 MORE than International Edition), plus

2222 records inactivated (???? MORE 30 LESS than International Edition), plus

14199 records added (???? LESS 211 MORE THAN than International Edition!!!!)

US Edition specific changes are related to ...

HOW ARE THERE LESS NEW RECORDS THAN IN THE INT EDITION?!

See Concept discrepancy explanation above for reason behind this (donated content)

OwlExpression files17067

10920 records updated, plus (144 MORE than International Edition), plus

2078 records inactivated (0 MORE than International Edition), plus

5079 records added (6778 991 MORE than International Edition - Michael confirmed this is about the right number - 6776 diff's in US Extension also collaborates this)

Stated Relationship files0

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

Relationship files

77518



3419 records updated (? 3415 MORE than International Edition), plus

27525 records inactivated (? 2448 LESS than International Edition), plus

46574 records added (? 1108 MORE THAN than International Edition!!!!)

US Edition specific changes are related to ...

  • Sept18 - Mar19 Diff = 250,018 International changes + 8512 US changes
  • Setp19 US Extension changes = 7164

These figures are roughly correct as compared to Extension + the previous amount of changes - HOWEVER WE STILL NEED TO CLASSIFY THIS SEPARATELY ON THE COMMAND LINE TO DOUBLE CHECK NO RESULTS...

TextDefinition files161n/a

5 records updated (5 MORE than International Edition), plus

26 records inactivated (0 MORE than International Edition), plus

130 records added (5 MORE than International Edition), as with the International editing cycle.

Therefore there are no US specific changes tis cycle

Attribute Value files12585

378 records updated, plus

850 records inactivated, plus

11358 records added

This is only ???????? changes more than the International Edition - therefore the US specific changes are....

  • Sept18 - Mar19 Diff = 36509 International changes + 214 US changes
  • Setp19 US Extension changes = 64

Spot checks look good, with 14 inactivations + 7 equivalencies resolved, as confirmed in Penni's spreadsheet:

https://docs.google.com/spreadsheets/d/1uo__1Ud3WQVKu_gEZoO09Voc29SAUxL2Aj7I0N5viIE/edit#gid=0

Language files32176

930 records updated (???????? MORE than International Edition), plus

4477 records inactivated (???????? MORE than International Edition), plus

26769 records added (???????? LESS than International Edition (because of Int replacements below))

68 records removed (replaced with Int records??EXPECTED??)

(eg)

< 673037bc-b9e8-5169-a3c0-0a4d3dea1ddf 20160301 1 731000124108 900000000000509007 724031000124115 900000000000548007
> 673037bc-b9e8-5169-a3c0-0a4d3dea1ddf 20190731 1 900000000000207008 900000000000509007 724031000124115 900000000000548007

These were definitely added to Int in the 20190731 release, so makes sense that they then replaced the US content - ONLY questions are :

  1. Do these align with the promoted content (Rory sending me concepts) - Yes, spot checks look good, and Rory sent the final Promoted concepts through: US Promoted concepts.txt - 64 of them roughly matches 68 removed records, and Rory confirmed (in Slack at 18:15 on 26/07/2019) that this was the exact intention in order to fix the UUID promotion issue in ISRS-580
  2. Should the promotion mechanism just update the moduleID (from US to Int) without inactivating the records? (ie) is moduleID mutable? YES, SEE TIG - 5.2.4 Language Reference Set - and Rory confirmed (in Slack at 18:15 on 26/07/2019) that this worked in the exact intended way in order to fix the UUID promotion issue in ISRS-580

+ 38 inactivations + 4 records added

  • Sept18 - Mar19 Diff = 143,110 International changes + 1972 US changes
  • Setp19 US Extension changes = 42
MRCMAttributeDomain files8 records

7 new records:

> 27b235f6-3f3c-4d63-bb54-d3323967fbfb 20200731 1 900000000000012004 723561005 827081001 260787004 0 0..* 0..0 723597001 723596005
> 4de08c79-8e24-44ea-ad52-2dd350b4ca53 20200731 1 900000000000012004 723561005 246196007 260787004 0 0..* 0..0 723597001 723596005
> 89d0a100-7140-4913-bf80-bef3bc3d8495 20200731 1 900000000000012004 723561005 860779006 373873005 1 0..* 0..* 723597001 723596005
> 93aa72d2-efe6-4ff8-b6a2-344c2fe44e1e 20200731 1 900000000000012004 723561005 860781008 373873005 0 0..* 0..0 723597001 723596005
> b3a823ef-aba5-4cf5-be9a-6c9808ad58b9 20200731 1 900000000000012004 723561005 840560000 260787004 0 0..* 0..0 723597001 723596005
> f5a58824-627b-4d4a-ad95-a72ccc2ed396 20200731 1 900000000000012004 723561005 836358009 260787004 0 0..* 0..0 723597001 723596005
> fd19c7fc-10bd-415b-8202-385810466d81 20200731 1 900000000000012004 723561005 840562008 260787004 0 0..1 0..0 723597001 723596005

Plus 1 updated record:

< 66e4ab61-09b8-4488-a2d4-a70adffd685f 20190131 1 900000000000012004 723561005 774081006 123037004 0 0..* 0..0 723597001 723596005
> 66e4ab61-09b8-4488-a2d4-a70adffd685f 20200731 1 900000000000012004 723561005 774081006 123037004 0 0..* 0..0 723597001 723594008

All in line with the International edition changes, as expected.


MRCMAttributeRange files49 recordsn/a

30 records updated (8 LESS than International Edition), plus

0 records inactivated, plus

19 records added (12 MORE than International Edition)

This is due to the following changes to the International Edition:

5 records had the DomainID changed, as expected in ISRS-564

< 2affaf44-9365-4d6d-84d3-31409206a77a 20190131 1 900000000000012004 723562003 774158006 << 774167006 | Product name (product name)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 774158006 |Has product name| = << 774167006 | Product name (product name)| 723597001 723596005
> 2affaf44-9365-4d6d-84d3-31409206a77a 20190731 1 900000000000012004 723562003 774158006 << 774167006 | Product name (product name)| << 781405001 |Medicinal product package (product)|: [0..1] 774158006 |Has product name| = << 774167006 | Product name (product name)| 723597001 723596005

< 355c9063-7238-4409-81a8-13f22b2a8bff 20190131 1 900000000000012004 723562003 774161007 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774161007 |Has pack size| = < 260299005 |Number (qualifier value)| } 723597001 723596005
> 355c9063-7238-4409-81a8-13f22b2a8bff 20190731 1 900000000000012004 723562003 774161007 < 260299005 |Number (qualifier value)| << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 774161007 |Has pack size| = < 260299005 |Number (qualifier value)| } 723597001 723596005

< 608ab6f5-6830-4294-926a-5c3a20b62060 20190131 1 900000000000012004 723562003 774159003 << 774164004 | Supplier (supplier)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 774159003 |Has supplier| = << 774164004 | Supplier (supplier)| 723597001 723596005
> 608ab6f5-6830-4294-926a-5c3a20b62060 20190731 1 900000000000012004 723562003 774159003 << 774164004 | Supplier (supplier)| << 781405001 |Medicinal product package (product)|: [0..1] 774159003 |Has supplier| = << 774164004 | Supplier (supplier)| 723597001 723596005

< e491647d-1793-4b20-b92d-c1180a96b00f 20190131 1 900000000000012004 723562003 774163005 << 767524001 |Unit of measure (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774163005 |Has pack size unit| = << 767524001 |Unit of measure (qualifier value)| } 723597001 723596005
> e491647d-1793-4b20-b92d-c1180a96b00f 20190731 1 900000000000012004 723562003 774163005 << 767524001 |Unit of measure (qualifier value)| << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 774163005 |Has pack size unit| = << 767524001 |Unit of measure (qualifier value)| } 723597001 723596005

< e5945adf-c075-4fb7-8f1b-515a124326cf 20190131 1 900000000000012004 723562003 774160008 << 763158003 |Medicinal product (product)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774160008 |Contains clinical drug| = << 763158003 |Medicinal product (product)| } 723597001 723596005
> e5945adf-c075-4fb7-8f1b-515a124326cf 20190731 1 900000000000012004 723562003 774160008 << 763158003 |Medicinal product (product)| << 781405001 |Medicinal product package (product)|: [1..*] { [1..1] 774160008 |Contains clinical drug| = << 763158003 |Medicinal product (product)| } 723597001 723596005

Plus the other changes made throughout the International editing cycle.

Therefore there are no US specific changes tis cycle


MRCMDomain files17 recordsn/a

17 records updated, plus

0 inactivated, plus

0 new record added, as with the International editing cycle.

Therefore there are no US specific changes tis cycle

Transitive Closure file0

MOVED TO ITS OWN TRANSITIVE CLOSURE PACKAGE - WILL RUN COMPARISONS ON PAGE:


tls_Icd10cmHumanReadableMap_US1000124_20170901.tsv

0

MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10cmMapTechnicalSpecifications_Current-en-US_US1000124_20170901.pdf

0

MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10cmMapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx

0

MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10cmMapReleaseNotes_Current-en-US_US1000124_20170901.pdf

0

MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10MapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx

0

MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE: