Page tree

January 2019 Member (Version 1) to January 2019 PUBLIC PRODUCTION (Version 1) traceability

Differences found in package Comparison

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

ISRS-492

1 record updated with the new, active concept record (770802007), replacing the now inactive concept (72651009) as expected:

< ce557fc3-6f02-4818-84f1-deb19a351838 20190131 1 900000000000207008 733073007 276206000 SubClassOf(ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:246075003 :414561005) ObjectSomeValuesFrom(:363698007 :72651009) ObjectSomeValuesFrom(:370135005 :441862004)))) :276206000)
---
> ce557fc3-6f02-4818-84f1-deb19a351838 20190131 1 900000000000207008 733073007 276206000 SubClassOf(ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:246075003 :414561005) ObjectSomeValuesFrom(:363698007 :770802007) ObjectSomeValuesFrom(:370135005 :441862004)))) :276206000)

Inferred Relationship files11

ISRS-492

2 records inactivated plus 9 records reactivated as expected:

Expected by Yong:
THIS RECORD TO BE REMOVED: 10524475027,2019-01-31,1,900000000000207008,402134005,59258008,0,116680003,900000000000011006,900000000000451002
Expected by SCA Classification results:
REDUNDANT 11190159022 402134005 116680003 Is a (attribute) 59258008 900000000000011000 0
Actual:
< 10524475027 20190131 1 900000000000207008 402134005 59258008 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 402134005 116680003 Is a (attribute) 47382004 900000000000011000 0
Actual:
< 2706361027 20050731 0 900000000000207008 402134005 47382004 0 116680003 900000000000011006 900000000000451002
> 2706361027 20190131 1 900000000000207008 402134005 47382004 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED, PLUS OLD ACTIVE RECORD TO BE INACTIVATED
Expected by SCA Classification results:
REDUNDANT 11190128020 414941008 116680003 Is a (attribute) 312146001 900000000000011000 0
INFERRED 414941008 116680003 Is a (attribute) 276206000 900000000000011000 0
Actual:
< 2686759022 20050131 1 900000000000207008 414941008 312146001 0 116680003 900000000000011006 900000000000451002
> 2686759022 20190131 0 900000000000207008 414941008 312146001 0 116680003 900000000000011006 900000000000451002

> 11187378027 20190131 1 900000000000207008 414941008 276206000 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 23549005 116680003 Is a (attribute) 415723000 900000000000011000 0
Actual:
< 2689698024 20050731 0 900000000000207008 23549005 415723000 0 116680003 900000000000011006 900000000000451002
> 2689698024 20190131 1 900000000000207008 23549005 415723000 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403060001 116680003 Is a (attribute) 403072007 900000000000011000 0
Actual:
< 2249445023 20050731 0 900000000000207008 403060001 403072007 0 116680003 900000000000011006 900000000000451002
> 2249445023 20190131 1 900000000000207008 403060001 403072007 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403061002 116680003 Is a (attribute) 415723000 900000000000011000 0
Actual:
< 2706478024 20050731 0 900000000000207008 403061002 415723000 0 116680003 900000000000011006 900000000000451002
> 2706478024 20190131 1 900000000000207008 403061002 415723000 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403062009 116680003 Is a (attribute) 403083003 900000000000011000 0
Actual:
< 2249450028 20050731 0 900000000000207008 403062009 403083003 0 116680003 900000000000011006 900000000000451002
> 2249450028 20190131 1 900000000000207008 403062009 403083003 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403063004 116680003 Is a (attribute) 403084009 900000000000011000 0
Actual:
< 2249451029 20050731 0 900000000000207008 403063004 403084009 0 116680003 900000000000011006 900000000000451002
> 2249451029 20190131 1 900000000000207008 403063004 403084009 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403064005 116680003 Is a (attribute) 403086006 900000000000011000 0
Actual:
< 2249454021 20050731 0 900000000000207008 403064005 403086006 0 116680003 900000000000011006 900000000000451002
> 2249454021 20190131 1 900000000000207008 403064005 403086006 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 68543009 116680003 Is a (attribute) 403065006 900000000000011000 0
Actual:
< 2230481025 20050731 0 900000000000207008 68543009 403065006 0 116680003 900000000000011006 900000000000451002
> 2230481025 20190131 1 900000000000207008 68543009 403065006 0 116680003 900000000000011006 900000000000451002

MRCM AttributeRange files1

ISRS-488

1 new Record updated with new UUID as expected, due to being new record for this release cycle.
SimpleMap files11903

Records updated with new UUID's as expected, due to being new records for this release cycle.



January 2019 Beta (Version 4 - PUBLISHED) vs January 2019 Member (Version 1) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
MRCM AttributeRange files1

ISRS-488

1 new Record updated with new UUID as expected, due to being new record for this release cycle.
SimpleMap files23806

Records updated with new UUID's as expected, due to being new records for this release cycle.

Readme filen/a

Beta names updated to Member names (no x prefixes), plus Beta warnings removed, as expected

January 2019 Beta (Version 2) vs January 2019 Beta (Version 4 - PUBLISHED) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
MRCM AttributeRange files1

ISRS-488

1 record added as expected, to resolve the missing record issue in ISRS-488:

> aaf9cbdd-54d1-4929-aa4e-26d927c5cd7e 20190131 1 900000000000012004 723562003 411116001 << 105904009 |Type of drug preparation (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] 411116001 |Has manufactured dose form| = << 105904009 |Type of drug preparation (qualifier value)| 723597001 723596005

SimpleMap files23806

Records updated with new UUID's as expected, due to being new records for this release cycle.

January 2019 Beta (Version 1) vs January 2019 Beta (Version 2) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Readme filen/a

Beta names updated, as expected

MRCM AttributeRange files6ISRS-485

6 records had their refsetID corrected, as expected due to the fix in

< 11d8ff3a-80b1-40b5-a4a6-fd3268141085 20190131 1 900000000000012004 723561005 774081006 << 123037004 |Body structure (body structure)| << 123037004 |Body structure (body structure)|: [0..*] 774081006 |Proper part of| = << 123037004 |Body structure (body structure)| 723597001 723596005
---
> 11d8ff3a-80b1-40b5-a4a6-fd3268141085 20190131 1 900000000000012004 723562003 774081006 << 123037004 |Body structure (body structure)| << 123037004 |Body structure (body structure)|: [0..*] 774081006 |Proper part of| = << 123037004 |Body structure (body structure)| 723597001 723596005
17c17
< 2affaf44-9365-4d6d-84d3-31409206a77a 20190131 1 900000000000012004 723561005 774158006 << 774167006 | Product name (product name)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 774158006 |Has product name| = << 774167006 | Product name (product name)| 723597001 723596005
---
> 2affaf44-9365-4d6d-84d3-31409206a77a 20190131 1 900000000000012004 723562003 774158006 << 774167006 | Product name (product name)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 774158006 |Has product name| = << 774167006 | Product name (product name)| 723597001 723596005
22c22
< 355c9063-7238-4409-81a8-13f22b2a8bff 20190131 1 900000000000012004 723561005 774161007 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774161007 |Has pack size| = < 260299005 |Number (qualifier value)| } 723597001 723596005
---
> 355c9063-7238-4409-81a8-13f22b2a8bff 20190131 1 900000000000012004 723562003 774161007 < 260299005 |Number (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774161007 |Has pack size| = < 260299005 |Number (qualifier value)| } 723597001 723596005
45c45
< 608ab6f5-6830-4294-926a-5c3a20b62060 20190131 1 900000000000012004 723561005 774159003 << 774164004 | Supplier (supplier)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 774159003 |Has supplier| = << 774164004 | Supplier (supplier)| 723597001 723596005
---
> 608ab6f5-6830-4294-926a-5c3a20b62060 20190131 1 900000000000012004 723562003 774159003 << 774164004 | Supplier (supplier)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..1] 774159003 |Has supplier| = << 774164004 | Supplier (supplier)| 723597001 723596005
100c100
< e491647d-1793-4b20-b92d-c1180a96b00f 20190131 1 900000000000012004 723561005 774163005 << 767524001 |Unit of measure (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774163005 |Has pack size unit| = << 767524001 |Unit of measure (qualifier value)| } 723597001 723596005
---
> e491647d-1793-4b20-b92d-c1180a96b00f 20190131 1 900000000000012004 723562003 774163005 << 767524001 |Unit of measure (qualifier value)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774163005 |Has pack size unit| = << 767524001 |Unit of measure (qualifier value)| } 723597001 723596005
102c102
< e5945adf-c075-4fb7-8f1b-515a124326cf 20190131 1 900000000000012004 723561005 774160008 << 763158003 |Medicinal product (product)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774160008 |Contains clinical drug| = << 763158003 |Medicinal product (product)| } 723597001 723596005
---
> e5945adf-c075-4fb7-8f1b-515a124326cf 20190131 1 900000000000012004 723562003 774160008 << 763158003 |Medicinal product (product)| << 373873005 |Pharmaceutical / biologic product (product)|: [0..*] { [0..1] 774160008 |Contains clinical drug| = << 763158003 |Medicinal product (product)| } 723597001 723596005

SimpleMap files23806

Records updated with new UUID's as expected, due to being new records for this release cycle.

January 2019 Alpha (Version 2) (PUBLISHED) vs January 2019 Beta (Version 1) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Relationship files45ISRS-480

45 records added as expected, in order to replace the 45 missing records from the Alpha.

This was done as a data fix by Michael, but the long term fix needs to be to use the termServer exported classification results (which are now stable), instead of running another, now unnecessary classification in the SRS as well (which often doesn't match!)

January 2019 Alpha (Version 1) vs January 2019 Alpha (Version 2) traceability

Differences found in package Comparison

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

ISRS-471

2 records removed, plus one inactivated - to fix issues from pre-Alpha:

< 20190131 1 900000000000207008 734139008 220023008 372225004
< 20190131 1 900000000000207008 734139008 220023008 372225004

< 20170731 1 900000000000207008 734139008 72651009 120572007
> 20190131 0 900000000000207008 734139008 72651009 120572007

Relationship files1011

ISRS-480

84 records removed, plus

927 records added, ALMOST as expected as a result of the OWLExpression refset now correctly including the previous 17 records from July 2018

HOWEVER, WHEN WE CLASSIFIED THE SNAPSHOT FILE IT RETURNED 45 CHANGES, AND SO WE NEED TO FIX THIS IN TIME FOR THE BETA RELEASE!

OWLExpression files18

18 records from the July 2018 release (11 from the OWLAxiom refset history (though 1 is inactivated in this Jan 2019 release so doesn't show in diff report) + 7 from the OWLOntology refset history) as expected:

> 0a4047c5-0d6b-4e71-a786-21658377eecf 20180731 1 900000000000012004 733073007 424361007 SubObjectPropertyOf(ObjectPropertyChain(:424361007 :738774007) :424361007)
> 2992ad4c-c5f8-4235-8e6b-36be3cacca57 20180731 1 900000000000012004 762103008 734146004 Prefix(rdf:=<http://www.w3.org/1999/02/22-rdf-syntax-ns#>)
> 34a2b4fd-093f-41c0-81c9-c68f3dc76bec 20180731 1 900000000000012004 733073007 733928003 ReflexiveObjectProperty(:733928003)
> 37c61ae4-e371-4d90-b635-5934c0777890 20180731 1 900000000000012004 733073007 733928003 TransitiveObjectProperty(:733928003)
> 3b0c7f58-388d-4956-84d5-fbff44197018 20180731 1 900000000000012004 762103008 734146004 Prefix(rdfs:=<http://www.w3.org/2000/01/rdf-schema#>)
> 3c566f2c-b38f-40bb-a6cb-7ea114ce8cf9 20180731 1 900000000000012004 762103008 734146004 Prefix(xsd:=<http://www.w3.org/2001/XMLSchema#>)
> 709e618d-9434-4c3b-b437-200e9aa26d59 20180731 1 900000000000012004 762103008 734146004 Prefix(:=<http://snomed.info/id/>)
> 70c580eb-e0b2-4ac3-815f-8a9b1be45bb3 20180731 1 900000000000012004 733073007 127489000 SubObjectPropertyOf(ObjectPropertyChain(:127489000 :738774007) :127489000)
> b4b8c410-13af-46cc-b238-d132b7a79f1c 20180731 1 900000000000012004 733073007 738774007 ReflexiveObjectProperty(:738774007)
> b8074e53-7157-4f2c-826f-c9019afbff88 20180731 1 900000000000012004 733073007 246093002 SubObjectPropertyOf(ObjectPropertyChain(:246093002 :738774007) :246093002)
> ba81d0bf-1703-4edf-a641-4bf7ae336a7c 20180731 1 900000000000012004 762103008 734146004 Prefix(owl:=<http://www.w3.org/2002/07/owl#>)
> bcba6a63-15c7-4109-930d-bf561d98321d 20180731 1 900000000000012004 733073007 246075003 SubObjectPropertyOf(ObjectPropertyChain(:246075003 :738774007) :246075003)
> bcc83805-c402-4c02-ac6b-4ce8efd47773 20180731 1 900000000000012004 733073007 733930001 TransitiveObjectProperty(:733930001)
> beefaa9e-a868-4a36-9ca8-b301cd6ae17f 20180731 1 900000000000012004 762103008 734146004 Prefix(xml:=<http://www.w3.org/XML/1998/namespace>)
> c1200e3f-c808-4dc8-8904-fec1c7b26280 20180731 1 900000000000012004 733073007 363701004 SubObjectPropertyOf(ObjectPropertyChain(:363701004 :738774007) :363701004)
> f81c24fb-c40a-4b28-9adb-85f748f71395 20180731 1 900000000000012004 762103008 734147008 Ontology(<http://snomed.info/sct/900000000000207008>)
> fb90eade-26b7-4747-bf6a-c9c235c1802d 20180731 1 900000000000012004 733073007 738774007 TransitiveObjectProperty(:738774007)

July 2018 PRODUCTION (PUBLISHED) to January 2019 Alpha (Version 1) traceability

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Concept files16311

4408 records updated (including 3035 inactivated), plus

11903 records added, as expected as matches exactly with cut off QA report: https://dailybuild.ihtsdotools.org/qa-beta/ (plus confirmed by Maria to be as expected in her email at 13:41 on 19/11/2018)

Description files81937

38113 records updated, plus

43824 records added

(no data on this from qa.snomed.org) Content Team Lead confirmed that this is approximately the expected amount in her email at 13:41 on 19/11/2018)

Relationship files250018

130121 records updated, plus

119897 records added

(no data on this from qa.snomed.org) - Yong confirmed that this is approximately the expected amount in his email at 14:22 on 19/11/2018)

Stated Relationship files117940

38196 records updated, plus

79744 records added

(no data on this from qa.snomed.org) - Yong confirmed that this is approximately the expected amount in his email at 14:22 on 19/11/2018)

TextDefinition files758

51 records updated, plus

707 records added

(no data on this from qa.snomed.org) - Yong confirmed that this is approximately the expected amount in his email at 14:22 on 19/11/2018)


SimpleMap files11905

1 records updated, plus

11904 records added, as expected as:

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

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

ExtendedMap files3860

1416 records updated, plus

2444 records added, as expected from the ICD-10 map Delta file that WCI sent us from the mapping tool export

Simple Refset les172

56 records updated, plus

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

ModuleDependency files

3


3 records updated, as expected for Jan 2019 effectiveTimes

Readme file

Jan 2019 dates updated + OWL files combined from two to one, as expected

MRCM AttributeDomain files9

3 records inactivated, plus

6 new records added, as expected as per Linda's updated master sheet for the January 2019 cycle: 

https://docs.google.com/spreadsheets/d/1Ice4gsgjsoDWF8dTn-p2BzucspA3E9Isi1FkVnypRvM/edit#gid=360169347

(plus confirmed by Maria to be as expected in her email at 13:41 on 19/11/2018)

MRCM AttributeRange files9

2 records inactivated, plus 1 updated, plus

6 new records added, as expected as per Linda's updated master sheet for the January 2019 cycle: 

https://docs.google.com/spreadsheets/d/1Ice4gsgjsoDWF8dTn-p2BzucspA3E9Isi1FkVnypRvM/edit#gid=360169347

(plus confirmed by Maria to be as expected in her email at 13:41 on 19/11/2018)

MRCM Domain files5

5 records updated, as expected as per Linda's updated master sheet for the January 2019 cycle: 

https://docs.google.com/spreadsheets/d/1Ice4gsgjsoDWF8dTn-p2BzucspA3E9Isi1FkVnypRvM/edit#gid=360169347

(plus confirmed by Maria to be as expected in her email at 13:41 on 19/11/2018)

Association Reference files5712

2019 records updated, plus

3693 records added, as expected because:

  • 3270 new records (4461 total - 1191 replacements for those Association records inactivated), added as a result of the inactivations for this cycle - this is close to number of Concept inactivations (3035), and can be accounted for due to the possibility of a few of the records having multiple suggestions for replacements. Whilst the number of inactivations is significantly more than last cycle, the QA project will have had a significant impact on this number, and so we checked with the Content Leads to see if they are confident that this aligns with his rough approximation of the number of concept inactivations in the latest editing cycle - YONG confirmed his email at 17:15 on 19/11/2018 that he is happy that the number of inactivations in this cycle is valid and expected.
  • plus 91 records added/updated for the SEP refsets, as per Yong's confirmed changes.
  • ***** TWO ISSUES IDENTIFIED IN THE SEP REFSETS - YONG SENT NEW FILES WITH FIXES INCLUDED ON 19/11/2018 ****** :
    • The following two entries exist in the previous release. They are removed from the new delta file.

      ec57709c-6e05-4698-a1fd-d448db5acbed 20190131 1 900000000000207008 734139008 220023008 372225004 Plantar fascia structure (body structure) Part of plantar aponeurosis (body structure)
      9af2a728-72f2-48d7-8bfc-4943157a8f97 20190131 1 900000000000207008 734139008 220023008 372225004 Plantar fascia structure (body structure) Part of plantar aponeurosis (body structure)

    • A new row is added because both concepts are inactivated in Jan 2019 release. 

      a0b04182-657b-433c-ae67-36e1e1f3c520 20190131 0 900000000000207008 734139008 72651009 Nail structure (body structure) 120572007  Nail part (body structure)

Attribute Value files36509

797 records updated, plus

35712 records added

(no data on this from qa.snomed.org) - Yong confirmed that this is approximately the expected amount in his email at 14:22 on 19/11/2018)

Language refset files143110

54316 records updated, plus

88794 records added

(no data on this from qa.snomed.org) - Yong confirmed that this is approximately the expected amount in his email at 14:22 on 19/11/2018)


OWLExpression files206

206 new records included as expected, BUT

18 historical records from July 2018 release missing! Code fix needed...

  • No labels