SNOMED International Release Management

Page tree

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

Compare with Current View Page History

« Previous Version 20 Next »

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

(plus confirmed by Maria/Yong to be as expected in email trail at XXXXXXXXXX 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


(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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..

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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

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

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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 12:18 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 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 (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)

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 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 12:18 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 12:18 on  

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

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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..

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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

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

(plus confirmed by Maria/Yong to be as expected in email trail at 12:18 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 12:18 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 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 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


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 files35468

311 records updated, plus

1327 records inactivated,

33830 records added

As confirmed by Maria/Yong to be as expected in email trail at 12:18 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 12:18 on  

  • No labels