Page tree

Versions Compared

Key

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

November 2021 PREPRODUCTION (Version 5) vs November 2021 PREPRODUCTION (Version 6) traceability

Readme file3559 records refreshed with new UUID's as expected, due to final number of January 2021 concept changes after last minute vaccines changes and other fixes.

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
All filesn/aRemoved the Member Release warning, as this is the final production releaseRefsetDescriptor files9

9 new records had their UUID's refreshed, as expected

SimpleMap files3559
0 changes as expected


October 2021 PRODUCTION (PUBLISHED) to November 2021 PREPRODUCTION (Version 6) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
RefsetDescriptor files

9 records added for new expression refsets as expected - see email from Linda + Kai at 02:37 on  

> 0aee0539-4dab-4ece-ba63-df08a347fb2c 20210131 1 900000000000012004 900000000000456007 1119417006 449608002 1119460002 0
> 1d472f20-d375-4b15-bccb-fff42ae145ce 20210131 1 900000000000012004 900000000000456007 1119468009 449608002 1119460002 0
> 29d8e58d-ed48-46f9-ad3f-ba1f4f01302e 20210131 1 900000000000012004 900000000000456007 1119468009 1119454002 1119437005 1
> 673ec076-149d-4df0-9bb0-9faac6479377 20210131 1 900000000000012004 900000000000456007 1119435002 1119436001 1119437005 1
> 74023db2-c222-475f-a97f-3a98250e5d04 20210131 1 900000000000012004 900000000000456007 1119417006 1119456000 1119461003 2
> 8f6aa174-31a6-471f-af95-1418194ed6e0 20210131 1 900000000000012004 900000000000456007 1119435002 733616009 1119461003 2
> c5e6e15c-97c5-4a74-ac82-a432590e3cb7 20210131 1 900000000000012004 900000000000456007 1119468009 1119457009 1119461003 2
> f09f2c8a-2007-4226-9df6-e5fcb20edb1e 20210131 1 900000000000012004 900000000000456007 1119417006 1119454002 1119437005 1
> f61db339-44bd-498b-90ca-a2c47b2a4b16 20210131 1 900000000000012004 900000000000456007 1119435002 449608002 1119460002 0



0 changes as expected

Concept files909

151

Lateralizable Refset (Simple refset) files169 

152 new records

plus 17 inactivated records

As expected as matches Yong's intentions, which he sent in email at 16:29 on  ...

Which again matches the 169 records in the Delta file downloaded from the Refset Tool...

Concept files89581901

records updated, plus

3512

210 records inactivated, plus

3545

548 records added,

...as expected as the added (3545) + inactivated (3512) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0

...plus the updated total (1901) matches exactly with the total records in the Concepts Changed report (5413): https://docs.google.com/spreadsheets/d/1QhxK1cja523C8CADBK75wzJ4qeXgIKSOfxgSPCR6E8g/edit#gid=0

MINUS the total number of inactivations (3512) - therefore 5413-3512 = 1901

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on  )

Description files
24523
2874
8004

98 records updated, plus

3568

495 records inactivated, plus

12951

2281 records added

...as expected as the added (12951) + inactivated (3568) + updated (8004) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0

****** THE PROBLEM HERE IS THAT MY COMPARISON REPORTS USE THE ">" and "<" symbols, which are also present in nearly 3000 Descriptions themselves!   Therefore MY TOTALS are definitely wrong!  We therefore have to trust the reports from now on..

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on  )

Relationship files
94725
10892
3402

356 records updated, plus

40147

3681 records inactivated, plus

51176

6855 records added

...as expected as the added (51176) + inactivated (40147) the updated (3402) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on  )

Relationship Concrete Values files43

0 records updated, plus

1 records inactivated, plus

42 records added

...as expected as the added (365) + inactivated (116) the re-activated (0) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/16498MA0R3E3NHwFk4Eo3YLu4ScGOote2s-pcH1p_Lfw/edit#gid=0

(plus confirmed by Maria/Yong to be as expected in email trail at 07:31 + 17:24 on  + )

OwlExpression files
20050
2923
12476

2281 records updated, plus

3568

212 records inactivated, plus

4006

430 records added

...as expected as the added (4006) + inactivated (3568) the updated (12476) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on  )

Stated Relationship files0

0 records updated, plus

0 records inactivated, plus

0 records added

As expected due to full migration to OWLExpression file in the last July 2019 International Edition

TextDefinition files
771
104

0 records updated, plus

100

9 records inactivated, plus

671

95 records added

...as expected as the added (671) + inactivated (100) + updated (0) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0

****** THE PROBLEM HERE IS THAT MY COMPARISON REPORTS USE THE ">" and "<" symbols, which are also present in nearly 20 Text Definitions themselves!   Therefore MY TOTALS are definitely wrong!  We therefore have to trust the reports from now on..

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on  )

SimpleMap files
3547
568

0 records updated, plus

0

4 records inactivated for ICD-0 (446608001)

3547

564 records added, as expected as:

  • 3545 added for CTV3 (900000000000497000) 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
  • + 2 new/updated records for ICD-0 (446608001) as expected, matching the 2 records in the Delta from mapping tool + the figures in the icd0stats.txt file from WCI.
ExtendedMap files
5474
529
9

0 records updated, plus

3276

98 records inactivated, plus

2189

431 records added,

as expected from the 2189 additions + 3276 inactivations + 9 updates in the ICD-10 map (449080006) Delta file that WCI sent us from the mapping tool export + NOT the figures in the icd10stats.txt file from WCI (WHICH CANNOT CURRENTLY BE USED FOR VALIDATION PURPOSES DUE TO THE EXTENDED MAP ALLOWING MULTIPLE MAP RECORDS PER CONCEPT, AND US ONLY BEING ABLE OT VALIDATE NUMBER OF MAP RECORDS (not number of concepts) ADDED/INACTIVATED IN THIS CYCLE - HAVE ASKED RICK HOW EASY IT'D BE TO UPDATE THE REPORT TO INCLUDE THESE STATS INSTEAD OF/AS WELL AS THE CURRENT Concept level STATS....

Simple Refset files
169
84

0 records updated, plus

17

30 records inactivated, plus

152

54 records added, as expected from the Lateralizable Refset changes (723264001) that Yong made in this cycle, exported in a Delta file from the Refset tool

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 on  )

ModuleDependency files

3


3 records updated, as expected for

January

November 2021 effectiveTimes

Readme file
January


November 2021 dates updated + Beta "x" prefixes added, as expected

MRCM AttributeDomain files2

2 new records added:

> 02f30651-d535-40d1-83be-3e73bacb0c20 20210131 1 900000000000012004 723561005 320081000221109 373873005 0 0..1 0..0 723597001 723596005
> 5c0fcb70-c87f-4058-9ee5-02d3756faace 20210131 1 900000000000012004 723561005 320091000221107 373873005 0 0..1 0..0 723597001 723596005

as confirmed by Maria/Yong to be as expected in email trail at 12:18 on  

MRCM AttributeRange files5

2 records added, plus

> 47eced5c-af89-41ec-95a4-cbcb992438c3 20210131 1 900000000000012004 723562003 320081000221109 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 320081000221109 |Unit of presentation size quantity| = < 260299005 |Number (qualifier value)| 723597001 723596005
> 5c1e3361-3410-460e-87e3-3c8b76e00c39 20210131 1 900000000000012004 723562003 320091000221107 << 767524001 |Unit of measure (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 320091000221107 |Unit of presentation size unit| = << 767524001 |Unit of measure (qualifier value)| 723597001 723596005

3 records updated:

< 3385133c-0886-4c6f-9e6d-2f1d216c9f91 20170731 1 900000000000012004 723562003 370133003 << 105590001 |Substance (substance)| << 123038009 |Specimen (specimen)|: [0..*] { [0..1] 370133003 |Specimen substance| = << 105590001 |Substance (substance)| } 723597001 723596005
> 3385133c-0886-4c6f-9e6d-2f1d216c9f91 20210131 1 900000000000012004 723562003 370133003 << 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| << 123038009 |Specimen (specimen)|: [0..*] { [0..1] 370133003 |Specimen substance| = (<< 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)|) } 723597001 723596005

< adbbf064-83a0-4125-85a5-6409dc352888 20200731 1 900000000000012004 723562003 370130000 << 118598001 |Property of measurement (qualifier value)| (<< 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|): [0..1] { [0..1] 370130000 |Property| = << 118598001 |Property of measurement (qualifier value)| } 723597001 723596005
> adbbf064-83a0-4125-85a5-6409dc352888 20210131 1 900000000000012004 723562003 370130000 << 118598001 |Property (qualifier value)| (<< 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|): [0..1] { [0..1] 370130000 |Property| = << 118598001 |Property (qualifier value)| } 723597001 723596005

< f58d75aa-599a-42e7-9f35-31a9c8a7d6d9 20200131 1 900000000000012004 723562003 246501002 << 272394005 |Technique (qualifier value)| OR << 273249006 |Assessment scales (assessment scale)| << 363787002 |Observable entity (observable entity)|: [0..*] { [0..1] 246501002 |Technique| = (<< 272394005 |Technique (qualifier value)| OR << 273249006 |Assessment scales (assessment scale)|) } 723597001 723596005
> f58d75aa-599a-42e7-9f35-31a9c8a7d6d9 20210131 1 900000000000012004 723562003 246501002 << 254291000 |Staging and scales (staging scale)| OR << 272394005 |Technique (qualifier value)| << 363787002 |Observable entity (observable entity)|: [0..*] { [0..1] 246501002 |Technique| = (<< 254291000 |Staging and scales (staging scale)| OR << 272394005 |Technique (qualifier value)|) } 723597001 723596005


As confirmed by 
Maria/Yong to be as expected in email trail at 12:18 on  

MRCM Domain files5

5 records updated, plus

0 inactivated, plus

0 new record added

As confirmed by Maria/Yong to be as expected in email trail at 12:18 on  

Association Reference files
12791
850
2

6 records updated, plus

4488

128 records inactivated, plus

8301

716 records added

...as expected as the added (8301) + inactivated (4488) + updated (2) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0


Yong confirmed that this is not quite what he expected in email trail at 12:18 on   inactivation for the 734138000|Anatomy structure and entire association reference set (foundation metadata concept)|

Attribute Value files
37275
1524
4791

30 records updated, plus

3186

82 records inactivated,

29298

1412 records added

As confirmed by Maria/Yong to be as expected in email trail at 12:18 on  

Language refset files
33475
5891
456

351 records updated, plus

6970

992 records inactivated, plus

26049

4548 records added

...as expected as the added (26049) + inactivated (6970) the updated (456) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1-XU7byTRnBJUYaDhvlXdzFpHlFxDV746o5F2Msa1Olk/edit#gid=0

As confirmed by Maria/Yong to be as expected in email trail at 12:18 on