SNOMED International Release Management

Page tree

Versions Compared

Old Version 27

changes.mady.by.user Andrew Atkinson

Saved on

compared with

New Version 28

changes.mady.by.user Andrew Atkinson

Saved on

Key

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

July 2021 Beta (Version 6) to July 2021 Beta (Version 7) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Simple Map files4431

4431 records updated (with ID changes only), as expected due to 4431 Simple Map records from previous version having their UUID's refreshed


January 2021 PRODUCTION (PUBLISHED) to July 2021 Beta (Version 6) traceability

Differences found in package Comparison

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

0 records added for new expression refsets as expected - see email from Linda + Kai at 23:53 on  

+ subsequent confirmation from all stakeholders in email trail at 13:45 on  

Concept files13966

1514 records updated, plus

8021 records inactivated, plus

4431 records added,

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

...plus the total updated records matches exactly with the total records in the columns "Changed DefnStatus" (1475) + "Reactivated" (39) in the Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Description files17909

301 records updated, plus

2637 records inactivated, plus

14971 records added

...as expected as the added (14958) + inactivated (2637) + updated (256+29) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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..

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Relationship files121123

ISRS-1057

3272 records updated, plus

69727 records inactivated, plus

48124 records added

...as expected as the added (48124) + inactivated (69727) the updated (3272) totals match exactly with the "Relationships" tab (which now excludes the Concrete Values Relationships which are now held in the new "Concrete Rels" tab) in the Summary Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

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

Relationship Concrete Values files29740

ISRS-1057

29740 new records (identical in each Full, Snapshot + Delta file), as these are brand new files for this release!

...as expected as the added (29740) + inactivated (0) the updated (0) totals match exactly with the new "Concrete Rels" tab in the Summary Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

Also NOT quite confirmed as slightly different to total in Michael's "intended changes spreadsheet" - see tab "Prod_CDI_Conversion_Change_stats" here:

https://docs.google.com/spreadsheets/d/1EKrInwdYBdZiy-QIQAXP9Ivp5NHismZl2CR46je2eOc/edit#gid=1908071861

Michael confirmed this was just because of new records being added after the initial CDI conversion was done back at the end of April - he was expecting Toni to add a few more after the conversion was completed and reviewed, so this checks out.

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

OwlExpression files39195

26586 records updated, plus

8039 records inactivated, plus

4570 records added

...as expected as the added (4570) + inactivated (8039) the updated (26586) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 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 July 2019 International Edition

TextDefinition files464

2 records updated, plus

41 records inactivated, plus

421 records added

...as expected as the added (423) + inactivated (41) + updated (0) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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..

(eg)

  • > 4565218012 20210731 1 900000000000207008 128091003 en 900000000000550004 An autoimmune coagulation disorder characterized by isolated thrombocytopenia (a platelet count <100,000/microL), in the absence of any underlying disorder that may be associated with thrombocytopenia. 900000000000017005
  • > 4565220010 20210731 1 900000000000207008 128091003 en 900000000000550004 An autoimmune coagulation disorder characterised by isolated thrombocytopenia (a platelet count <100,000/microL), in the absence of any underlying disorder that may be associated with thrombocytopenia. 900000000000017005

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

SimpleMap (ICD-0) files4547

48 inactivated records (all ICD-0) +

1 updated record (all ICD-0) + 

4498 added records (4431 CTV3 records + 67 ICD-0 records)

  • 4431 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
  • + 68 new/updated records + 48 inactivated records for ICD-0 (446608001) as expected, matching the records in the Delta from mapping tool + the figures in the icd0stats.txt file from WCI.
ExtendedMap (ICD-10) files5798

2629 records added plus

3160 records inactivated plus

9 records updated

...as expected due to the ICD-10 delta files authored by Donna's team and provided by WCI via email at 20:39 on  

as expected from the 2638 additions/updates + 3160 inactivations 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 (Lateralizable Refset) files 161

125 records added plus

36 records inactivated

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

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

ModuleDependency files

3


3 records updated, as expected for July 2021 effectiveTimes

Readme file

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

Plus 3 new Concrete Domains files added:

> xsct2_RelationshipConcreteValues_Delta_INT_20210731.txt
> xsct2_RelationshipConcreteValues_Full_INT_20210731.txt
> xsct2_RelationshipConcreteValues_Snapshot_INT_20210731.txt

MRCM AttributeDomain files29

17 new records added, plus

12 records inactivated

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

MRCM AttributeRange files30

12 inactivated, plus

1 records updated, plus

37 records added NOT AS EXPECTED

****** THE PROBLEM HERE IS THAT THE COMPARISON REPORTS USE THE ">" and "<" symbols, which are also NOW present in multiple MRCM AttributeRange records themselves!   Therefore OUR TOTALS are definitely wrong!  We therefore have to either just trust the reports from now on, or manually reconcile:

The reason being, that the new Concrete Domains attribute also have ">" characters in the expressions, and so throw out the automated counts in the traceability!  (eg) dec(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 1142135004 |Has presentation strength numerator value| > #0 }


As NOT confirmed by Maria/Yong to be as expected in email trail at 12:18 on  - YONG DISAGREED WITH COUNTS, SO AAT RECONCILED MANUALLY:

12 inactivated:

< 0cdffdf5-2698-4fbf-9456-a72eb6a455de 20200731 1 900000000000012004 723562003 840562008 << 362981000 |Qualifier value (qualifier value)| << 260787004 |Physical object (physical object)|: [0..1] 840562008 |Has device characteristic| = << 362981000 |Qualifier value (qualifier value)| 723597001 723596005
> 0cdffdf5-2698-4fbf-9456-a72eb6a455de 20210731 0 900000000000012004 723562003 840562008 << 362981000 |Qualifier value (qualifier value)| << 260787004 |Physical object (physical object)|: [0..1] 840562008 |Has device characteristic| = << 362981000 |Qualifier value (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
> 355c9063-7238-4409-81a8-13f22b2a8bff 20210731 0 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

< 356cdb90-dca6-4d46-834f-c961ad863906 20180731 1 900000000000012004 723562003 766954007 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 766954007 |Count of base and modification pair| = < 260299005 |Number (qualifier value)| 723597001 723596005
> 356cdb90-dca6-4d46-834f-c961ad863906 20210731 0 900000000000012004 723562003 766954007 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 766954007 |Count of base and modification pair| = < 260299005 |Number (qualifier value)| 723597001 723596005

< 3afe6bd3-16b5-4c19-a221-07c07f57f0ff 20190731 1 900000000000012004 723562003 784276002 < 260299005 |Number (qualifier value)| << 781405001 |Medicinal product package (product)|: [1..1] 784276002 |Count of clinical drug type| = < 260299005 |Number (qualifier value)| 723597001 723596005
> 3afe6bd3-16b5-4c19-a221-07c07f57f0ff 20210731 0 900000000000012004 723562003 784276002 < 260299005 |Number (qualifier value)| << 781405001 |Medicinal product package (product)|: [1..1] 784276002 |Count of clinical drug type| = < 260299005 |Number (qualifier value)| 723597001 723596005

< 2eff1e91-c17a-4da3-8675-fb584a837893 20170731 1 900000000000012004 723562003 732946004 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 732946004 |Has presentation strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005
> 2eff1e91-c17a-4da3-8675-fb584a837893 20210731 0 900000000000012004 723562003 732946004 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 732946004 |Has presentation strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005

< 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
> 47eced5c-af89-41ec-95a4-cbcb992438c3 20210731 0 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

< 94605782-de4e-4008-a074-39091e81d223 20180731 1 900000000000012004 723562003 766953001 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 766953001 |Count of active ingredient| = < 260299005 |Number (qualifier value)| 723597001 723596005
> 94605782-de4e-4008-a074-39091e81d223 20210731 0 900000000000012004 723562003 766953001 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 766953001 |Count of active ingredient| = < 260299005 |Number (qualifier value)| 723597001 723596005

< a06e87f3-69a4-49cd-bd3f-c70500b9da3d 20180131 1 900000000000012004 723562003 733724008 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733724008 |Has concentration strength numerator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005
> a06e87f3-69a4-49cd-bd3f-c70500b9da3d 20210731 0 900000000000012004 723562003 733724008 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733724008 |Has concentration strength numerator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005

< bf881b47-cb67-4b60-98a8-395de889503b 20200731 1 900000000000012004 723562003 246196007 << 106234000 |General adjectival modifier (qualifier value)| << 260787004 |Physical object (physical object)|: [0..*] 246196007 |Has surface characteristic| = << 106234000 |General adjectival modifier (qualifier value)| 723597001 723596005
> bf881b47-cb67-4b60-98a8-395de889503b 20210731 0 900000000000012004 723562003 246196007 << 106234000 |General adjectival modifier (qualifier value)| << 260787004 |Physical object (physical object)|: [0..*] 246196007 |Has surface characteristic| = << 106234000 |General adjectival modifier (qualifier value)| 723597001 723596005

< c9fff1b3-a8e3-486a-8931-8c569c75cf54 20180131 1 900000000000012004 723562003 733723002 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733723002 |Has concentration strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005
> c9fff1b3-a8e3-486a-8931-8c569c75cf54 20210731 0 900000000000012004 723562003 733723002 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733723002 |Has concentration strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005

< d0ec4014-bba6-4544-b4f2-151c076b25a5 20170731 1 900000000000012004 723562003 732944001 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 732944001 |Has presentation strength numerator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005
> d0ec4014-bba6-4544-b4f2-151c076b25a5 20210731 0 900000000000012004 723562003 732944001 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 732944001 |Has presentation strength numerator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005

< f0657b2a-271c-4d82-962f-af5b7b3ec5c0 20180731 1 900000000000012004 723562003 766952006 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 766952006 |Count of base of active ingredient| = < 260299005 |Number (qualifier value)| 723597001 723596005
> f0657b2a-271c-4d82-962f-af5b7b3ec5c0 20210731 0 900000000000012004 723562003 766952006 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 766952006 |Count of base of active ingredient| = < 260299005 |Number (qualifier value)| 723597001 723596005

1 updated:

< 9883dd72-0fdc-47bf-89d0-4f206ca7800c 20170731 1 900000000000012004 723562003 363713009 << 260245000 |Finding values (qualifier value)| OR << 263714004 |Colors (qualifier value)| << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 363713009 |Has interpretation| = (<< 260245000 |Finding values (qualifier value)| OR << 263714004 |Colors (qualifier value)|) } 723597001 723596005
> 9883dd72-0fdc-47bf-89d0-4f206ca7800c 20210731 1 900000000000012004 723562003 363713009 << 260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)| << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 363713009 |Has interpretation| = (<< 260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|) } 723597001 723596005


BUT only 17 records added:

> 17eec929-cccc-4713-a71d-4d9f422117c5 20210731 1 900000000000012004 723562003 1142135004 dec(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 1142135004 |Has presentation strength numerator value| > #0 } 723597001 723596005

> 2c46fdc1-d5c8-40ff-b705-4d18135c8117 20210731 1 900000000000012004 723562003 1148793005 dec(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 1148793005 |Unit of presentation size quantity| > #0 723597001 723596005

> 39f5f1fc-d2e4-45b0-9643-d6ce66a871d6 20210731 1 900000000000012004 723562003 1142139005 int(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 1142139005 |Count of base of active ingredient| > #0 723597001 723596005

> 4816c1c3-3299-48ce-998b-f70a1d03bbdf 20210731 1 900000000000012004 723562003 1142138002 dec(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 1142138002 |Has concentration strength numerator value| > #0 } 723597001 723596005

> 4cdeb624-40b2-4c3e-9bf6-69ce2d529aa3 20210731 1 900000000000012004 723562003 1142143009 int(>#0..) << 781405001 |Medicinal product package (product)|: [1..1] 1142143009 |Count of clinical drug type| > #0 723597001 723596005

> 5980c5af-f7ea-405b-837b-217a185c648a 20210731 1 900000000000012004 723562003 1148969005 860574003 |Bioabsorbable (qualifier value)| OR 863965006 |Nonbioabsorbable (qualifier value)| OR 863968008 |Partially bioabsorbable (qualifier value)| << 260787004 |Physical object (physical object)|: [0..1] 1148969005 |Has absorbability| = (860574003 |Bioabsorbable (qualifier value)| OR 863965006 |Nonbioabsorbable (qualifier value)| OR 863968008 |Partially bioabsorbable (qualifier value)|) 723597001 723596005

> 6ed3cdaa-c373-43dc-b9a5-d934fa7f2973 20210731 1 900000000000012004 723562003 1149366004 < 1149484003 |Ingredient qualitative strength (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 1149366004 |Has ingredient qualitative strength| = < 1149484003 |Ingredient qualitative strength (qualifier value)| } 723597001 723596005

> a552640a-76b4-4839-95d6-93ef42e9d149 20210731 1 900000000000012004 723562003 1142137007 dec(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 1142137007 |Has concentration strength denominator value| > #0 } 723597001 723596005

> c91edb18-4e91-4dfe-98a0-49a4184e2fe4 20210731 1 900000000000012004 723562003 1142136003 dec(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 1142136003 |Has presentation strength denominator value| > #0 } 723597001 723596005

> de1e359a-9fad-4769-be27-e12b161a51ca 20210731 1 900000000000012004 723562003 1148965004 31874001 |True (qualifier value)| OR 64100000 |False (qualifier value)| << 260787004 |Physical object (physical object)|: [0..1] 1148965004 |Is sterile| = (31874001 |True (qualifier value)| OR 64100000 |False (qualifier value)|) 723597001 723596005

> e4cb759c-6723-414c-857d-70f11c88498a 20210731 1 900000000000012004 723562003 1142141006 int(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 1142141006 |Count of base and modification pair| > #0 723597001 723596005

> e96eade2-42ce-4c5c-8585-ad80b8dd7b41 20210731 1 900000000000012004 723562003 1142142004 int(>#0..) << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 1142142004 |Has pack size| > #0 } 723597001 723596005

> f2578aa6-665f-461e-9ad1-48658d36c711 20210731 1 900000000000012004 723562003 1148968002 82280004 |Smooth (qualifier value)| OR 860647008 |Textured (qualifier value)| << 260787004 |Physical object (physical object)|: [0..*] 1148968002 |Has surface texture| = (82280004 |Smooth (qualifier value)| OR 860647008 |Textured (qualifier value)|) 723597001 723596005

> f926dadf-6918-432a-b029-597186d86238 20210731 1 900000000000012004 723562003 1148967007 < 105590001 |Substance (substance)| << 260787004 |Physical object (physical object)|: [0..1] 1148967007 |Has coating material| = < 105590001 |Substance (substance)| 723597001 723596005

> fbac216b-4025-4ed9-9eeb-bcd47f5715a2 20210731 1 900000000000012004 723562003 1142140007 int(>#0..) << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 1142140007 |Count of active ingredient| > #0 723597001 723596005

> fcbe4dee-2694-4aa1-8c6d-bbe5c5b03120 20210731 1 900000000000012004 723562003 1003703000 << 123037004 |Body structure (body structure)| << 363787002 |Observable entity (observable entity)|: [0..*] { [0..1] 1003703000 |Process extends to| = << 123037004 |Body structure (body structure)| } 723597001 723596005

> 96d077d2-d331-4fb6-bf38-474bd0cdfc09 20210731 1 900000000000012004 723562003 1149367008 < 27821000087106 |Product target population (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 1149367008 |Has target population| = < 27821000087106 |Product target population (qualifier value)| 723597001 723596005

The reason being, that the new Concrete Domains attribute also have ">" characters in the expressions, and so throw out the automated counts in the traceability!

Something that we'll have to watch out for permanently going forward....

So the real counts are: 

12 inactivated, plus

1 records updated, plus

37 17 records added, as expected

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 17:14 on 

Association Reference (SE + SP Refset + Association Refset) files10320

2 records updated, plus

1276 records inactivated, plus

9042 records added

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

...BUT SLIGHTLY MORE EXPECTED IF YOU TAKE THE SUM OF THE COUNTS IN BOTH THE "Hist Assoc" + "Desc Assoc" tabs:

added (8933) + inactivated (1236) + updated (1) - so now totals match ALMOST EXACTLY!

(these totals are also confirmed in the "Refsets" tab right at the end of the report)

THIS SEEMS TO TALLY UP EXACTLY IF YOU ASSUME THAT THE REPORT DOES NOT CONSIDER SE + SP REFSETS IN ITS TOTALS (see RP-432 where Peter confirms that they are currently not in scope of the SummaryComponentStats report):

Report added (8933) + SEP added (109) = 9042 (matches my added counts from RF2 Association ref files)

Report inactivated (1236) + SEP inactivated (40) = 1276 (matches my added counts from RF2 Association ref files)

Report updated (1) + SEP added (1) = 2 (matches my added counts from RF2 Association ref files)

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Attribute Value files35481

311 records updated, plus

1335 records inactivated,

33835 records added

...as expected as the added (34144) + inactivated (1335) + updated (2) totals match exactly with Component Stats report - AS LONG AS YOU TAKE THE SUM OF THE COUNTS IN BOTH THE "Inactivations" + "Desc Inact" tabs (+ remember that the report for these stats totals "New / Reactivated" (even though there's also a separate column for reactivated!  So my 33835(added)+311(updated)=34146 which matches the "34144+2" in the report)  :  https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

(these totals are also confirmed in the "Refsets" tab right at the end of the report)

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Language refset files37163

2385 records updated, plus

5306 records inactivated, plus

29472 records added

...as expected as the added (29472) + inactivated (5305) the updated (2326+59) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on  


July 2021 Beta (Version 4) to July 2021 Beta (Version 6) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Association Reference files150

110 records added

Plus 40 records inactivated

....as expected due to the 149 SE refset (734138000) changes + 1 SP refset (734139008) change authored by Yong in the July 2021 editing cycle - see Delta files provided by Yong via email on 24/05/2021 at 09:28

Simple Map files4547

67 new records (because the other 4431 new CTV3 records were already added in version4!) plus

48 records inactivated plus

4480 records updated (because this includes the refresh of UUID's for both 4431 new CTV3 records so actually only 49 changes since version4 - 48 inactivated ICD-0 records + 1 updated ICD-0 record)

  • 4431 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??????
  • + 68 new/updated records + 48 inactivated records for ICD-0 (446608001) as expected, matching the records in the Delta from mapping tool + the figures in the icd0stats.txt file from WCI.


*Between Jan21Published + Version6 we had:

4547 total changes:

  • 48 inactivated records (all ICD-0) +
  • 1 updated record (all ICD-0) + 
  • 4498 added records (4431 CTV3 records + 67 ICD-0 records)
  • ALL AS EXPECTED!!
Extended Map files5798

2629 records added plus

3160 records inactivated plus

9 records updated

...as expected due to the ICD-10 delta files authored by Donna's team and provided by WCI via email at 20:39 on  

as expected from the 2638 additions/updates + 3160 inactivations 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 files161

125 records added plus

36 records inactivated

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

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

ModuleDependency files3

3 records updated, as expected for July 2021 effectiveTimes

Readme file

Updated to state BETA instead of (now deprecated) ALPHA


January 2021 PRODUCTION (PUBLISHED) to July 2021 Beta (Version 4) traceability

Differences found in package Comparison

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

0 records added for new expression refsets as expected - see email from Linda + Kai at 23:53 on  


Concept files13966

1514 records updated, plus

8021 records inactivated, plus

4431 records added,

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

...plus the total matches exactly with the total records in the columns "Changed DefnStatus" (1475) + "Reactivated" (39) in the Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0


...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Description files17909

301 records updated, plus

2637 records inactivated, plus

14971 records added

...as expected as the added (14958) + inactivated (2637) + updated (256+29) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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..

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Relationship files121123

3272 records updated, plus

69727 records inactivated, plus

48124 records added

...as expected as the added (48124) + inactivated (69727) the updated (3272) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Relationship Concrete Values files29740

29740 new records (identical in each Full, Snapshot + Delta file), as these are brand new files for this release!

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

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

OwlExpression files39195

26586 records updated, plus

8039 records inactivated, plus

4570 records added

...as expected as the added (4570) + inactivated (8039) the updated (26586) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 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 July 2019 International Edition

TextDefinition files464

2 records updated, plus

41 records inactivated, plus

421 records added

...as expected as the added (423) + inactivated (41) + updated (0) totals ALMOST match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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..

(eg)

  • > 4565218012 20210731 1 900000000000207008 128091003 en 900000000000550004 An autoimmune coagulation disorder characterized by isolated thrombocytopenia (a platelet count <100,000/microL), in the absence of any underlying disorder that may be associated with thrombocytopenia. 900000000000017005
  • > 4565220010 20210731 1 900000000000207008 128091003 en 900000000000550004 An autoimmune coagulation disorder characterised by isolated thrombocytopenia (a platelet count <100,000/microL), in the absence of any underlying disorder that may be associated with thrombocytopenia. 900000000000017005

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

SimpleMap (ICD-0) files0

4431 new (900000000000497000) records - as expected as 4431 new concepts so need new CTV3 records for each one.

HOWEVER, NOT as expected as missing ICD-0 records - need to add Delta in once received from WCI

ExtendedMap (ICD-10) files0

NOT as expected - ONLY CHANGES TO DELTA?!!  need to add in WCI delta files when receive them!

Simple Refset (Lateralizable Refset) files 0

NOT as expected - ONLY CHANGES TO DELTA?!!  need to add Lateralizable refset delta in as soon as receive from Yong

ModuleDependency files

0


0 records updated, as expected for January 2021 effectiveTimes

Readme file

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

Plus 3 new Concrete Domains files added:

> xsct2_RelationshipConcreteValues_Delta_INT_20210731.txt
> xsct2_RelationshipConcreteValues_Full_INT_20210731.txt
> xsct2_RelationshipConcreteValues_Snapshot_INT_20210731.txt

MRCM AttributeDomain files29

17 new records added, plus

12 records inactivated

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

MRCM AttributeRange files50

37 records added, plus

12 inactivated, plus

1 records updated

< c9fff1b3-a8e3-486a-8931-8c569c75cf54 20180131 1 900000000000012004 723562003 733723002 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733723002 |Has concentration strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005
---
> c9fff1b3-a8e3-486a-8931-8c569c75cf54 20210731 0 900000000000012004 723562003 733723002 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733723002 |Has concentration strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005


...as NOT confirmed by Maria/Yong to be as expected in email trail at 17:14 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 17:14 on 

Association Reference (SE + SP Refset + Association Refset) files10170

2 records updated, plus

1238 records inactivated, plus

8930 records added

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

...BUT SLIGHTLY MORE EXPECTED IF YOU TAKE THE SUM OF THE COUNTS IN BOTH THE "Hist Assoc" + "Desc Assoc" tabs:

added (8933) + inactivated (1236) + updated (1) - so now totals match ALMOST EXACTLY!

(these totals are also confirmed in the "Refsets" tab right at the end of the report)

Attribute Value files35481

311 records updated, plus

1335 records inactivated,

33835 records added

...as expected as the added (34144) + inactivated (1335) + updated (2) totals ALMOST match exactly with Component Stats report - AS LONG AS YOU TAKE THE SUM OF THE COUNTS IN BOTH THE "Inactivations" + "Desc Inact" tabs: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

(these totals are also confirmed in the "Refsets" tab right at the end of the report)

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Language refset files37163

2385 records updated, plus

5306 records inactivated, plus

29472 records added

...as expected as the added (29472) + inactivated (5305) the updated (2326+59) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on n  



July 2021 Beta (Version 2) to July 2021 Beta (Version 4) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Association Reference files3

1 record added:

> fbd18704-db21-46e7-93af-9b550137e05c 20210731 1 900000000000207008 900000000000527005 232824004 78788008

Plus 2 records inactivated

< 6149587c-9fc1-4000-96fb-291c435677d8 20210131 1 900000000000207008 900000000000523009 16818451000119104 364758005
> 6149587c-9fc1-4000-96fb-291c435677d8 20210731 0 900000000000207008 900000000000523009 16818451000119104 364758005

< b05fd952-fd04-4ce3-aac5-2971f8feb6ab 20210131 1 900000000000207008 900000000000523009 312668007 289437007
> b05fd952-fd04-4ce3-aac5-2971f8feb6ab 20210731 0 900000000000207008 900000000000523009 312668007 289437007

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

Attribute Value files12

4 records added plus

8 records inactivated

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

Language Refset137

99 new records, plus

8 records inactivated, plus

30 records updated

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

Concept files30

23 new records

> 1157335009 20210731 1 900000000000207008 900000000000074008
> 1157336005 20210731 1 900000000000207008 900000000000074008
> 1157337001 20210731 1 900000000000207008 900000000000074008
> 1157338006 20210731 1 900000000000207008 900000000000074008
> 1157339003 20210731 1 900000000000207008 900000000000074008
> 1157340001 20210731 1 900000000000207008 900000000000074008
> 1157341002 20210731 1 900000000000207008 900000000000074008
> 1157342009 20210731 1 900000000000207008 900000000000074008
> 1157343004 20210731 1 900000000000207008 900000000000074008
> 1157344005 20210731 1 900000000000207008 900000000000074008
> 1157345006 20210731 1 900000000000207008 900000000000074008
> 1157346007 20210731 1 900000000000207008 900000000000074008
> 1157347003 20210731 1 900000000000207008 900000000000074008
> 1157348008 20210731 1 900000000000207008 900000000000074008
> 1157349000 20210731 1 900000000000207008 900000000000074008
> 1157350000 20210731 1 900000000000207008 900000000000074008
> 1157351001 20210731 1 900000000000207008 900000000000074008
> 1157352008 20210731 1 900000000000207008 900000000000074008
> 1157354009 20210731 1 900000000000207008 900000000000074008
> 1157356006 20210731 1 900000000000207008 900000000000073002
> 1157357002 20210731 1 900000000000012004 900000000000074008
> 1157358007 20210731 1 900000000000012004 900000000000074008
> 1157359004 20210731 1 900000000000012004 900000000000074008

1 removed completely:

< 29091000087106 20210731 1 900000000000207008 900000000000074008

3 updated:

< 131010002 20210731 1 900000000000207008 900000000000073002
> 131010002 20020131 1 900000000000207008 900000000000074008

< 178571003 20080131 1 900000000000207008 900000000000074008
> 178571003 20210731 1 900000000000207008 900000000000073002

< 472797003 20130131 1 900000000000207008 900000000000074008
> 472797003 20210731 1 900000000000207008 900000000000073002

1 inactivated:

< 232824004 20210731 1 900000000000207008 900000000000073002
> 232824004 20210731 0 900000000000207008 900000000000074008

2 reactivated:

< 16818451000119104 20210131 0 900000000000207008 900000000000074008
> 16818451000119104 20210731 1 900000000000207008 900000000000073002

< 312668007 20210131 0 900000000000207008 900000000000074008
> 312668007 20210731 1 900000000000207008 900000000000073002

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

Description files57

41 new records added plus

13 records updated

3 records inactivated

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

Inferred Relationship files158

100 new records added?

28 inactivated

30 re-activated

116 records removed completely?

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

Relationship Concrete Values files1

1 new record added:

> 13866340024 20210731 1 900000000000207008 1157356006 #1 0 1142139005 900000000000011006 900000000000451002

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

OWL Expression files45

24 added

1 inactivated

20 updated

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

TextDefinition files12

12 records updated

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"

MRCM Attribute Range1

INFRA-6871

1 record updated, as expected due to fix in INFRA-6871:

< 9883dd72-0fdc-47bf-89d0-4f206ca7800c 20210731 1 900000000000012004 723562003 363713009 << 260245000 |Finding values (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)| << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 363713009 |Has interpretation| = (<< 260245000 |Finding values (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|) } 723597001 723596005

---
> 9883dd72-0fdc-47bf-89d0-4f206ca7800c 20210731 1 900000000000012004 723562003 363713009 << 260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)| << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 363713009 |Has interpretation| = (<< 260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|) } 723597001 723596005

MRCM Domain files1 

INFRA-6871

1 record updated, as expected due to fix in INFRA-6871:

  • < f1136b12-f2bd-46db-b9fb-be484129e40c 20210731 1 900000000000012004 723560006 404684003 << 404684003 |Clinical finding (finding)| << 404684003 |Clinical finding (finding)| [[+id(<< 404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..*]] 116676008 |Associated morphology| = [[+id(<< 49755003 |Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]] 246075003 |Causative agent| = [[+id(<< 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR << 410607006 |Organism (organism)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 246112005 |Severity| = [[+id(<< 272141005 |Severities (qualifier value)|)]], [[0..1]] 246454002 |Occurrence| = [[+id(<< 282032007 |Periods of life (qualifier value)|)]], [[0..1]] 246456000 |Episodicity| = [[+id(<< 288526004 |Episodicities (qualifier value)|)]], [[0..1]] 255234002 |After| = [[+id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+id(<< 288524001 |Courses (qualifier value)|)]], [[0..1]] 288556008 |Before| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..*]] 363698007 |Finding site| = [[+id(<< 442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]] 363713009 |Has interpretation| = [[+id(<< 260245000 |Finding values (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|)]], [[0..1]] 363714003 |Interprets| = [[+id(<< 108252007 |Laboratory procedure (procedure)| OR << 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|)]], [[0..1]] 370135005 |Pathological process| = [[+id(<< 308490002 |Pathological developmental process (qualifier value)| OR << 441862004 |Infectious process (qualifier value)| OR << 472963003 |Hypersensitivity process (qualifier value)| OR << 769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 418775008 |Finding method| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 419066007 |Finding informer| = [[+id(<< 419358007 |Subject of record or other provider of history (person)| OR << 420158005 |Performer of method (person)| OR << 444018008 |Person with characteristic related to subject of record (person)|)]], [[0..1]] 42752001 |Due to| = [[+id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..*]] 47429007 |Associated with| = [[+id(<< 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR << 71388002 |Procedure (procedure)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 719722006 |Has realization| = [[+id(<< 719982003 |Process (qualifier value)|)]], [[0..*]] 726633004 |Temporally related to| = [[+id(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] } [[+scg(<< 404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..*]] 116676008 |Associated morphology| = [[+scg(<< 49755003 |Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]] 246075003 |Causative agent| = [[+scg(<< 105590001 |Substance (substance)| OR 138875005 |SNOMED CT Concept (SNOMED RT+CTV3)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR << 410607006 |Organism (organism)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 246112005 |Severity| = [[+scg(<< 272141005 |Severities (qualifier value)|)]], [[0..1]] 246454002 |Occurrence| = [[+scg(<< 282032007 |Periods of life (qualifier value)|)]], [[0..1]] 246456000 |Episodicity| = [[+scg(<< 288526004 |Episodicities (qualifier value)|)]], [[0..1]] 255234002 |After| = [[+scg(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+scg(<< 288524001 |Courses (qualifier value)|)]], [[0..1]] 288556008 |Before| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..*]] 363698007 |Finding site| = [[+scg(<< 442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]] 363713009 |Has interpretation| = [[+scg(<< 260245000 |Finding values (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|)]], [[0..1]] 363714003 |Interprets| = [[+scg(<< 108252007 |Laboratory procedure (procedure)| OR << 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|)]], [[0..1]] 370135005 |Pathological process| = [[+scg(<< 308490002 |Pathological developmental process (qualifier value)| OR << 441862004 |Infectious process (qualifier value)| OR << 472963003 |Hypersensitivity process (qualifier value)| OR << 769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 418775008 |Finding method| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 419066007 |Finding informer| = [[+scg(<< 419358007 |Subject of record or other provider of history (person)| OR << 420158005 |Performer of method (person)| OR << 444018008 |Person with characteristic related to subject of record (person)|)]], [[0..1]] 42752001 |Due to| = [[+scg(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..*]] 47429007 |Associated with| = [[+scg(<< 105590001 |Substance (substance)| OR 138875005 |SNOMED CT Concept (SNOMED RT+CTV3)| OR << 260787004 |Physical object (physical object)| OR << 272379006 |Event (event)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR << 404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR << 71388002 |Procedure (procedure)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 719722006 |Has realization| = [[+scg(<< 719982003 |Process (qualifier value)|)]], [[0..*]] 726633004 |Temporally related to| = [[+scg(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] } http://snomed.org/dom404684003
  • > f1136b12-f2bd-46db-b9fb-be484129e40c 20210731 1 900000000000012004 723560006 404684003 << 404684003 |Clinical finding (finding)| << 404684003 |Clinical finding (finding)| [[+id(<< 404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..*]] 116676008 |Associated morphology| = [[+id(<< 49755003 |Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]] 246075003 |Causative agent| = [[+id(<< 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR << 410607006 |Organism (organism)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 246112005 |Severity| = [[+id(<< 272141005 |Severities (qualifier value)|)]], [[0..1]] 246454002 |Occurrence| = [[+id(<< 282032007 |Periods of life (qualifier value)|)]], [[0..1]] 246456000 |Episodicity| = [[+id(<< 288526004 |Episodicities (qualifier value)|)]], [[0..1]] 255234002 |After| = [[+id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+id(<< 288524001 |Courses (qualifier value)|)]], [[0..1]] 288556008 |Before| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..*]] 363698007 |Finding site| = [[+id(<< 442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]] 363713009 |Has interpretation| = [[+id(<< 260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|)]], [[0..1]] 363714003 |Interprets| = [[+id(<< 108252007 |Laboratory procedure (procedure)| OR << 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|)]], [[0..1]] 370135005 |Pathological process| = [[+id(<< 308490002 |Pathological developmental process (qualifier value)| OR << 441862004 |Infectious process (qualifier value)| OR << 472963003 |Hypersensitivity process (qualifier value)| OR << 769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 418775008 |Finding method| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 419066007 |Finding informer| = [[+id(<< 419358007 |Subject of record or other provider of history (person)| OR << 420158005 |Performer of method (person)| OR << 444018008 |Person with characteristic related to subject of record (person)|)]], [[0..1]] 42752001 |Due to| = [[+id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..*]] 47429007 |Associated with| = [[+id(<< 105590001 |Substance (substance)| OR << 260787004 |Physical object (physical object)| OR << 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR << 71388002 |Procedure (procedure)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 719722006 |Has realization| = [[+id(<< 719982003 |Process (qualifier value)|)]], [[0..*]] 726633004 |Temporally related to| = [[+id(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] } [[+scg(<< 404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..*]] 116676008 |Associated morphology| = [[+scg(<< 49755003 |Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]] 246075003 |Causative agent| = [[+scg(<< 105590001 |Substance (substance)| OR 138875005 |SNOMED CT Concept (SNOMED RT+CTV3)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR << 410607006 |Organism (organism)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 246112005 |Severity| = [[+scg(<< 272141005 |Severities (qualifier value)|)]], [[0..1]] 246454002 |Occurrence| = [[+scg(<< 282032007 |Periods of life (qualifier value)|)]], [[0..1]] 246456000 |Episodicity| = [[+scg(<< 288526004 |Episodicities (qualifier value)|)]], [[0..1]] 255234002 |After| = [[+scg(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+scg(<< 288524001 |Courses (qualifier value)|)]], [[0..1]] 288556008 |Before| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..*]] 363698007 |Finding site| = [[+scg(<< 442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]] 363713009 |Has interpretation| = [[+scg(<< 260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location)|)]], [[0..1]] 363714003 |Interprets| = [[+scg(<< 108252007 |Laboratory procedure (procedure)| OR << 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|)]], [[0..1]] 370135005 |Pathological process| = [[+scg(<< 308490002 |Pathological developmental process (qualifier value)| OR << 441862004 |Infectious process (qualifier value)| OR << 472963003 |Hypersensitivity process (qualifier value)| OR << 769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 418775008 |Finding method| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..1]] 419066007 |Finding informer| = [[+scg(<< 419358007 |Subject of record or other provider of history (person)| OR << 420158005 |Performer of method (person)| OR << 444018008 |Person with characteristic related to subject of record (person)|)]], [[0..1]] 42752001 |Due to| = [[+scg(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..*]] 47429007 |Associated with| = [[+scg(<< 105590001 |Substance (substance)| OR 138875005 |SNOMED CT Concept (SNOMED RT+CTV3)| OR << 260787004 |Physical object (physical object)| OR << 272379006 |Event (event)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR << 404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR << 71388002 |Procedure (procedure)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]] 719722006 |Has realization| = [[+scg(<< 719982003 |Process (qualifier value)|)]], [[0..*]] 726633004 |Temporally related to| = [[+scg(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] } http://snomed.org/dom404684003
Simple Map files4431

4409 records updated (presumably with ID changes only??), plus

22 records added....

Maria confirmed that this is as expected via Slack at 20:08 on 24/05/2021:

"...editing was still open on 12 May, it didn’t close until 13 May and promotion was allowed until close of business that day and so I would expect the team were still promoting changes up until that deadline.  I don’t see anything untoward in the report, the changes appear to be expected as editing was still allowed"


July 2021 Beta (Version 1) to July 2021 Beta (Version 2) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Attribute Value files1

1 record added:

> fe5611b7-ac30-4237-8c0e-b691cdc658e1 20210731 1 900000000000207008 900000000000490003 2161646012 723277005

Language Refset9

4 new records

> 03be68e4-18e3-45f9-a141-8fedea3f891c 20210731 1 900000000000207008 900000000000508004 4580410012 900000000000548007
> f8da56d4-2dc4-4e4d-a791-6a63ecc8c732 20210731 1 900000000000207008 900000000000508004 4580409019 900000000000548007
> 2eda542e-155d-4814-8643-fb084a0be1c4 20210731 1 900000000000207008 900000000000509007 4580409019 900000000000548007
> fb949f8a-ab32-468c-8099-ebf942aa288e 20210731 1 900000000000207008 900000000000509007 4580410012 900000000000548007

2 records inactivated:

< a8d6e7eb-ec30-5585-a408-f11709a7be8c 20040131 1 900000000000207008 900000000000509007 2161646012 900000000000549004
> a8d6e7eb-ec30-5585-a408-f11709a7be8c 20210731 0 900000000000207008 900000000000509007 2161646012 900000000000549004

< be04f7d7-497a-5f39-b653-f77a899bc943 20040131 1 900000000000207008 900000000000508004 2161646012 900000000000549004
> be04f7d7-497a-5f39-b653-f77a899bc943 20210731 0 900000000000207008 900000000000508004 2161646012 900000000000549004

3 records updated

< d2b340b4-2eff-5c64-8354-779d840b3057 20100131 1 900000000000207008 900000000000509007 2837292010 900000000000548007
> d2b340b4-2eff-5c64-8354-779d840b3057 20210731 1 900000000000207008 900000000000509007 2837292010 900000000000549004

< d5ea477a-b7e5-4eee-9535-36497d8a0c56 20210731 1 900000000000207008 900000000000509007 4580021013 900000000000548007
< 2226bf4d-2226-4eb8-9920-f763b037c76a 20210731 1 900000000000207008 900000000000508004 4580021013 900000000000548007

< a42aa5f1-5072-5cae-b9c6-0034d6169098 20100131 1 900000000000207008 900000000000508004 2837292010 900000000000548007
> a42aa5f1-5072-5cae-b9c6-0034d6169098 20210731 1 900000000000207008 900000000000508004 2837292010 900000000000549004

Description files

2 records added

> 4580409019 20210731 1 900000000000207008 388393002 en 900000000000013009 Sus - pigs 900000000000017005
> 4580410012 20210731 1 900000000000207008 106996007 en 900000000000013009 Suidae - pigs 900000000000017005

1 record inactivated

< 2161646012 20170731 1 900000000000207008 106996007 en 900000000000013009 Pig 900000000000448009
> 2161646012 20210731 0 900000000000207008 106996007 en 900000000000013009 Pig 900000000000448009

1 record removed

< 4580021013 20210731 1 900000000000207008 388393002 en 900000000000013009 Pigs 900000000000448009

Simple Map files4409
4409 records added


January 2021 PRODUCTION (PUBLISHED) to July 2021 Beta (Version 1) traceability

Differences found in package Comparison

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

0 records added for new expression refsets as expected - see email from Linda + Kai at 23:53 on  


Lateralizable Refset (Simple refset) files0 

Need LAteralizable delta from Yong asap...

Concept files13941

1512 records updated, plus

8020 records inactivated, plus

4409 records added,

...as expected as the added (3545) + inactivated (3512) totals match exactly with Component Stats report: https://docs.google.com/spreadsheets/d/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Description files17867

293 records updated, plus

2637 records inactivated, plus

14937 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/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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..

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Relationship files121139

3266 records updated, plus

69729 records inactivated, plus

48144 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/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

OwlExpression files39160

26576 records updated, plus

8038 records inactivated, plus

4546 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/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 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 July 2019 International Edition

TextDefinition files464

0 records updated, plus

41 records inactivated, plus

423 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/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/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..

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

SimpleMap files0

NOT as expected as missing ICD-0 records - need to add Delta in once received from WCI

ExtendedMap files0

NOT as expected - need to add in WCI delta files when receive them!

Simple Refset files0

NOT as expected - need to add Lateralizable refset delta in as soon as receive from Yong

ModuleDependency files

0


0 records updated, as expected for January 2021 effectiveTimes

Readme file

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

Plus 3 new Concrete Domains files added:

> xsct2_RelationshipConcreteValues_Delta_INT_20210731.txt
> xsct2_RelationshipConcreteValues_Full_INT_20210731.txt
> xsct2_RelationshipConcreteValues_Snapshot_INT_20210731.txt

MRCM AttributeDomain files29

17 new records added, plus

12 records inactivated

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

MRCM AttributeRange files50

37 records added, plus

12 inactivated, plus

1 records updated

< c9fff1b3-a8e3-486a-8931-8c569c75cf54 20180131 1 900000000000012004 723562003 733723002 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733723002 |Has concentration strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005
---
> c9fff1b3-a8e3-486a-8931-8c569c75cf54 20210731 0 900000000000012004 723562003 733723002 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 733723002 |Has concentration strength denominator value| = < 260299005 |Number (qualifier value)| } 723597001 723596005


...as NOT confirmed by Maria/Yong to be as expected in email trail at 17:14 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 17:14 on 

Association Reference files10167

2 records updated, plus

1234 records inactivated, plus

8931 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/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0


...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Attribute Value files35468

311 records updated, plus

1327 records inactivated,

33830 records added

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on 

Language refset files37058

2381 records updated, plus

5306 records inactivated, plus

29371 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/1FnFCQUSE6iiJjbfFx2N6_D9ZEeX_rX3wRXEuUVulfoY/edit#gid=0

...as confirmed by Maria/Yong to be as expected in email trail at 17:14 on