Page tree

Versions Compared

Key

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

July 2022 PRODUCTION (PUBLISHED) to August 2022 Production (Version 2 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT:  https://docs.google.com/spreadsheets/d/1j_cizcP5-uqvhpuUFL79I3PpYzY-6T-_NOUB4l2XgYs/edit#gid=0

Differences found in package Comparison

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

0 records added/updated as expected

Concept files710

590 records added/updated, plus

120 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

Description files1649

1529 records added/updated, plus

120 records inactivated (ALMOST matches - 1255 in the report - https://jira.ihtsdotools.org/browse/INFRA-9336 raised....

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) 

NOTE:  Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256.  This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms.  So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

Relationship files10240

6662 records added/updated, plus

3578 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)  

Relationship Concrete Values files211

205 records added/updated, plus

6 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)  

OwlExpression files2014

1867 records added/updated, plus

147 records inactivated

XXXXXXX 145 in initial Summary Stats report....same in the new final Summary report...

Peter confirmed in INFRA-9492 that the issue here is with the content team updating already-inactive components.  This shouldn't be allowed (as agreed with the content team) and so the report doesn't account for this kind of ill-advised (but not technically illegal) change.  However, we've raised RP-617 to keep an eye on how many of these type of changes occur each cycle, and make a call from there as to whether or not we need the AP to completely block these changes, or if they're actually useful valid changes?

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

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 files18

17 records added/updated, plus

1 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) 

NOTE:  Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256.  This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms.  So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

SimpleMap files468

468 records added/updated, plus

0 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 468 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see Summary Component Stats report above) PLUS
  • the manual counts of ICD-0 records (446608001) - here 0 new + 0 inactivation, which match with those in the SimpleMap diff report sent by Rick via email on 15/07/22 at 00:54

Which matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 13:48 on  

  • "added/updated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (new) this release     0            +
    • Total New mapped entries this release     0
  • "inactivated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (retired) this release     0        +
    • Total Retired mapped entries this release     0
ExtendedMap files353

321 records added/updated, plus

32 records inactivated

Which matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 14:17 on  :

  • "added/updated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (new) this release     1            +
    • Total New mapped entries this release     320
  • "inactivated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (retired) this release     1        +
    • Total Retired mapped entries this release     31
Simple Refset files52

51 records added/updated, plus

1 records inactivated

ModuleDependency files

3


3 records updated, as expected for August 2022 effectiveTimes

Readme file

August 2022 dates updated + Beta "x" prefixes removed, as expected

MRCM AttributeDomain files0

0 records added/updated as expected

MRCM AttributeRange files0

0 records added/updated as expected

MRCM Domain files0

0 records added/updated as expected

Association Reference files333

261 records added/updated, plus

72 records inactivated

...as expected as the totals ALMOST match exactly with Summary Component Stats report, but this report was run BEFORE we manually added in the 15 new records as part of the fixes in ISRS-1271 (spot checked these manually and they are present in new Association Snapshot + Full files as planned), so this brings us much closer to the figures in Comparison Diff files.


In order to get an accurate comparison, we have to ALSO INCLUDE the SEP refset (734138000 + 734139008) totals from the RF2 files (manually tallied from the new Association Snapshot files) and add them to the "Hist Assoc" tab in the Summary Component Report:

SEP (from RF2 diff files) = 48 changes:

This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats:

  • 71 inactivations +
  • 234 new/updated records

Makes a total of:

  • 72 inactivations +
  • 261 new/updated records  

Which matches exactly with the counts I got above from the RF2 files!!  

Attribute Value files635

634 records added/updated, plus 

XXXXXXX 633 in initial Summary Stats report....same in the new final Summary report...

MANUAL validation in the DIFF files confirms:

  • 567 records added brand new +
  • 68 records updated/inactivated:
    • 1 inactivated
    • 67 updated:
      • 44 updated existing active records
      • 23 re-activated from previous inactive records

Peter confirmed that this is a reporting issue only - fixed in https://jira.ihtsdotools.org/browse/RP-628 - so if you check out the new report here you'll see it now matches 624 added/updated + 1 inactivated: https://docs.google.com/spreadsheets/d/1ifgQwZh0rnFAq9ky8d2V65R5j41r1aOtZ1ZjFchFdoY/edit#gid=13

1 records inactivated

...as expected as the totals ALMOST match exactly with Summary Component Stats report

Language refset files3288

3053 records added/updated, plus

235 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)


July 2022 PRODUCTION (PUBLISHED) to August 2022 PRE-Production (Version 1 PRE VERSIONING) traceability

SUMMARY COMPONENT REPORT: https://docs.google.com/spreadsheets/d/1K5f_uaDKn2Cq0tuun4HRFreOOSVUQ2251leySO3mszo/edit#gid=0

Differences found in package Comparison

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

0 records added/updated as expected

Concept files841

685 records added/updated, plus

156 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

Description files
2352
2360

1831 records added/updated, plus

521

529 records inactivated

(ALMOST matches - 1255 in the report - https://jira.ihtsdotools.org/browse/INFRA-9336 raised....

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) 

NOTE:  Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256.  This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms.  So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

Relationship files11741

7427 records added/updated, plus

4314 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)  

Relationship Concrete Values files89

78 records added/updated, plus

11 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)  

OwlExpression files1982

1826 records added/updated, plus

156 records inactivated

XXXXXXX 145 in initial Summary Stats report....same in the new final Summary report...

Peter confirmed in INFRA-9492 that the issue here is with the content team updating already-inactive components.  This shouldn't be allowed (as agreed with the content team) and so the report doesn't account for this kind of ill-advised (but not technically illegal) change.  However, we've raised RP-617 to keep an eye on how many of these type of changes occur each cycle, and make a call from there as to whether or not we need the AP to completely block these changes, or if they're actually useful valid changes?

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)

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 files90

88 records added/updated, plus

2 records inactivated

Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) 

NOTE:  Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256.  This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms.  So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

SimpleMap files463

463

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 files9088

records added/updated, plus

2

0 records inactivated

Confirmed as matches

exactly with data in

with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 468 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see Summary Component Stats report
- see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report) 

NOTE:  Updated total DOES NOT ALWAYS MATCH EXACTLY (like the others) - the report states 1255 inactivations instead of 1256.  This is explained by the inclusion of the "<" character (which I use to search the Diff files to separate out the different change types) in many actual Terms.  So searching for "< " instead (including the tab after <) finds instead 334 records updated, which is much closer.

SimpleMap files463

463 records added/updated, plus

0 records inactivated

  • above) PLUS
  • the manual counts of ICD-0 records (446608001) - here 0 new + 0 inactivation, which match with those in the SimpleMap diff report sent by Rick via email on 15/07/22 at 00:54

Which matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 13:48 on  

  • "added/updated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (new) this release     0            +
    • Total New mapped entries this release     0
  • "inactivated" counts from diff report matches to total of WCI report lines:
    • Total Changed mapped entries (retired) this release     0        +
    • Total Retired mapped entries this release     0
ExtendedMap files442

333 records added/updated, plus

109 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 468 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see Summary Component Stats report above) PLUS
  • the manual counts of ICD-0 records (446608001) - here 0 new + 0 inactivation, which match with those in the SimpleMap diff report sent by Rick via email on 15/07/22 at 00:54

    Which matches exactly with the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at

    13

    14:

    48

    17 on  :

    • "added/updated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (new) this
    release
      • release   
      0 
      •  1            +
      • Total New mapped entries this
    release 
      • release    
     0
      • 320
    • "inactivated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (retired) this
    release
      • release   
      0 
      •  1        +
      • Total Retired mapped entries this release    
    0
      • 31
    ExtendedMap
    Simple Refset files
    442
    5
    333

    3 records added/updated, plus

    109

    2 records inactivated

    Which
    • Confirmed as matches exactly with

    the new detailed Map Reports WCI sent off the back of Maria's Map tasks, sent in an email from noreply@snomed.org entitled "Upload Successful", at 14:17 on  :
    • "added/updated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (new) this release     1            +
      • Total New mapped entries this release     320
    • "inactivated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (retired) this release     1        +
      • Total Retired mapped entries this release     31
    Simple Refset files5

    3 records added/updated, plus

    2 records inactivated

    ModuleDependency files

    3

    3 records updated, as expected for September 2022 effectiveTimes

    Readme file

    September 2022 dates updated + Beta "x" prefixes added, as expected

    MRCM AttributeDomain files0

    0 records added/updated as expected

    MRCM AttributeRange files1

    1 records updated as expected:

    < e8ec5f5c-a9e0-4241-912d-8ea9331cce91    20200731    1    900000000000012004    723562003    370135005    << 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)|    << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 370135005 |Pathological process| = (<< 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)|) }    723597001    723596005
    ---
    > e8ec5f5c-
    ModuleDependency files

    3


    3 records updated, as expected for September 2022 effectiveTimes

    Readme file

    September 2022 dates updated + Beta "x" prefixes added, as expected

    MRCM AttributeDomain files0

    0 records added/updated as expected

    MRCM AttributeRange files1

    1 records updated as expected:

    < e8ec5f5c-a9e0-4241-912d-8ea9331cce91  

     20220930

     20200731    1    900000000000012004    723562003    370135005    <<

    1495041000004108 |Proliferation of neoplasm (qualifier value)| OR <<

    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)|    << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 370135005 |Pathological process| =

    (<< 1495041000004108 |Proliferation of neoplasm

    (

    qualifier value)| OR

    << 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)|) }    723597001    723596005

    MRCM Domain files1

    1 records updated as expected

    21c21
    < f1136b12-f2bd-46db-b9fb-be484129e40c    20220731

    ---
    > e8ec5f5c-a9e0-4241-912d-8ea9331cce91    20220930    1    900000000000012004  

     723560006

     723562003  

     404684003

     370135005    <<

    404684003 |Clinical finding (finding)|        << 404684003 |Clinical finding (finding)|        [[+id(<< 404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..1]] 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

    1495041000004108 |Proliferation of neoplasm (qualifier value)| OR << 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)|    << 404684003 |Clinical finding (finding)|: [0..*] { [0..1] 370135005 |Pathological process| = (<< 1495041000004108 |Proliferation of neoplasm (qualifier value)| OR << 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)|) }    723597001    723596005

    MRCM Domain files1

    1 records updated as expected

    21c21
    < f1136b12-f2bd-46db-b9fb-be484129e40c    20220731    1    900000000000012004    723560006    404684003    << 404684003 |Clinical finding (finding)|        << 404684003 |Clinical finding (finding)|        [[+id(<< 404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..1]] 116676008 |Associated morphology| = [[+id(<<

    272379006

    49755003 |

    Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure

    Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]]

    263502005

    246075003 |

    Clinical course

    Causative agent| = [[+id(<<

    288524001 |Courses (qualifier value

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

    288556008

    246112005 |

    Before

    Severity| = [[+id(<<

    71388002

    272141005 |

    Procedure

    Severities (

    procedure

    qualifier value)|)]], [[0..1]]

    363698007

    246454002 |

    Finding site

    Occurrence| = [[+id(<<

    442083009 |Anatomical or acquired body structure (body structure

    282032007 |Periods of life (qualifier value)|)]], [[0..1]]

    363713009

    246456000 |

    Has interpretation

    Episodicity| = [[+id(<<

    260245000

    288526004 |

    Finding value

    Episodicities (qualifier value)|

    OR << 263714004 |Colors (qualifier value

    )

    | OR << 308916002 |Environment or geographical location (environment / location)|)

    ]], [[0..1]]

    363714003

    255234002 |

    Interprets

    After| = [[+id(<<

    108252007

    272379006 |

    Laboratory procedure

    Event (

    procedure

    event)| OR <<

    363787002

    404684003 |

    Observable entity (observable entity

    Clinical finding (finding)| OR <<

    386053000

    71388002 |

    Evaluation procedure

    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

    ]] 263502005 |Clinical course| = [[+id(<< 288524001 |Courses (qualifier value)|)]], [[0..1]]

    371881003

    288556008 |

    During

    Before| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..1]]

    418775008

    363698007 |Finding

    method

    site| = [[+id(<<

    71388002 |Procedure (procedure

    442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]]

    419066007

    363713009 |

    Finding informer

    Has interpretation| = [[+id(<<

    419358007 |Subject of record or other provider of history (person

    260245000 |Finding value (qualifier value)| OR <<

    420158005

    263714004 |

    Performer of method (person

    Colors (qualifier value)| OR <<

    444018008 |Person with characteristic related to subject of record (person

    308916002 |Environment or geographical location (environment / location)|)]], [[0..1]]

    42752001

    363714003 |

    Due to

    Interprets| = [[+id(<<

    272379006

    108252007 |

    Event

    Laboratory procedure (

    event

    procedure)| OR <<

    404684003

    363787002 |

    Clinical finding (finding

    Observable entity (observable entity)| OR <<

    71388002

    386053000 |

    Procedure

    Evaluation procedure (procedure)|)]], [[0..

    *

    1]]

    47429007

    370135005 |

    Associated with

    Pathological process| = [[+id(<<

    105590001

    308490002 |

    Substance (substance

    Pathological developmental process (qualifier value)| OR <<

    260787004

    441862004 |

    Physical object (physical object

    Infectious process (qualifier value)| OR <<

    272379006

    472963003 |

    Event

    Hypersensitivity process (

    event

    qualifier value)| OR <<

    404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR

    769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+id(<< 71388002 |Procedure (procedure)|

    OR << 78621006 |Physical force (physical force

    )

    |)

    ]], [[0..1]]

    719722006

    418775008 |

    Has realization

    Finding method| = [[+id(<<

    719982003

    71388002 |

    Process

    Procedure (

    qualifier value

    procedure)|)]], [[0..

    *

    1]]

    726633004 |Temporally related to

    419066007 |Finding informer| = [[+id(<<

    404684003 |Clinical finding (finding

    419358007 |Subject of record or other provider of history (person)| OR <<

    71388002

    420158005 |

    Procedure

    Performer of method (

    procedure

    person)|

    )]] }    [[+scg(<< 404684003 |Clinical finding (finding

    OR << 444018008 |Person with characteristic related to subject of record (person)|)]]

    :

    , [[0..

    *]] { [[0..

    1]]

    116676008

    42752001 |

    Associated morphology

    Due to| = [[+

    scg(<< 49755003 |Morphologically abnormal structure (morphologic abnormality

    id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..

    1

    *]]

    246075003

    47429007 |

    Causative agent

    Associated with| = [[+

    scg

    id(<< 105590001 |Substance (substance)| OR

    138875005 |SNOMED CT Concept (SNOMED RT+CTV3

    << 260787004 |Physical object (physical object)| OR <<

    260787004

    272379006 |

    Physical object

    Event (

    physical object

    event)| OR <<

    373873005 |Pharmaceutical / biologic product (product

    404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR << 71388002 |Procedure (procedure)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]]

    246112005

    719722006 |

    Severity

    Has realization| = [[+

    scg

    id(<<

    272141005

    719982003 |

    Severities

    Process (qualifier value)|)]], [[0..

    1

    *]]

    246454002

    726633004 |

    Occurrence

    Temporally related to| = [[+id(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] }    [[+scg(<<

    282032007 |Periods of life (qualifier value)|)]],

    404684003 |Clinical finding (finding)|)]]: [[0..*]] { [[0..1]]

    246456000

    116676008 |

    Episodicity

    Associated morphology| = [[+scg(<<

    288526004

    49755003 |

    Episodicities (qualifier value

    Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]]

    255234002

    246075003 |

    After

    Causative agent| = [[+scg(<<

    272379006 |Event (event

    105590001 |Substance (substance)| OR 138875005 |SNOMED CT Concept (SNOMED RT+CTV3)| OR <<

    404684003

    260787004 |

    Clinical finding (finding

    Physical object (physical object)| OR <<

    71388002 |Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+scg(<< 288524001 |Courses (qualifier value

    373873005 |Pharmaceutical / biologic product (product)| OR << 410607006 |Organism (organism)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]]

    288556008

    246112005 |

    Before

    Severity| = [[+scg(<<

    71388002

    272141005 |

    Procedure

    Severities (

    procedure

    qualifier value)|)]], [[0..1]]

    363698007

    246454002 |

    Finding site

    Occurrence| = [[+scg(<<

    442083009 |Anatomical or acquired body structure (body structure

    282032007 |Periods of life (qualifier value)|)]], [[0..1]]

    363713009

    246456000 |

    Has interpretation

    Episodicity| = [[+scg(<<

    260245000 |Finding value (qualifier value)| OR << 263714004 |Colors

    288526004 |Episodicities (qualifier value

    )| OR << 308916002 |Environment or geographical location (environment / location

    )|)]], [[0..1]]

    363714003

    255234002 |

    Interprets

    After| = [[+scg(<<

    108252007

    272379006 |

    Laboratory procedure

    Event (

    procedure

    event)| OR <<

    363787002

    404684003 |

    Observable entity (observable entity

    Clinical finding (finding)| OR <<

    386053000

    71388002 |

    Evaluation procedure

    Procedure (procedure)|)]], [[0..1]]

    370135005

    263502005 |

    Pathological process

    Clinical course| = [[+scg(<<

    308490002

    288524001 |

    Pathological developmental process

    Courses (qualifier value)|

    OR << 441862004 |Infectious process (qualifier value)| OR << 472963003 |Hypersensitivity process (qualifier value

    )

    | OR << 769247005 |Abnormal immune process (qualifier value)|)

    ]], [[0..1]]

    371881003

    288556008 |

    During

    Before| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..1]]

    418775008

    363698007 |Finding

    method

    site| = [[+scg(<<

    71388002 |Procedure (procedure

    442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]]

    419066007

    363713009 |

    Finding informer

    Has interpretation| = [[+scg(<<

    419358007 |Subject of record or other provider of history (person

    260245000 |Finding value (qualifier value)| OR <<

    420158005

    263714004 |

    Performer of method (person

    Colors (qualifier value)| OR <<

    444018008 |Person with characteristic related to subject of record (person

    308916002 |Environment or geographical location (environment / location)|)]], [[0..1]]

    42752001

    363714003 |

    Due to

    Interprets| = [[+scg(<<

    272379006

    108252007 |

    Event

    Laboratory procedure (

    event

    procedure)| OR <<

    404684003

    363787002 |

    Clinical finding (finding

    Observable entity (observable entity)| OR <<

    71388002

    386053000 |

    Procedure

    Evaluation procedure (procedure)|)]], [[0..

    *

    1]]

    47429007

    370135005 |

    Associated with

    Pathological process| = [[+scg

    (<< 105590001 |Substance (substance)| OR 138875005 |SNOMED CT Concept

    (

    SNOMED RT+CTV3)| OR << 260787004 |Physical object (physical object

    << 308490002 |Pathological developmental process (qualifier value)| OR <<

    272379006

    441862004 |

    Event

    Infectious process (

    event

    qualifier value)| OR <<

    373873005 |Pharmaceutical / biologic product (product

    472963003 |Hypersensitivity process (qualifier value)| OR <<

    404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR

    769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+scg(<< 71388002 |Procedure (procedure

    )| OR << 78621006 |Physical force (physical force

    )|)]], [[0..1]]

    719722006

    418775008 |

    Has realization

    Finding method| = [[+scg(<<

    719982003

    71388002 |

    Process

    Procedure (

    qualifier value

    procedure)|)]], [[0..

    *

    1]]

    726633004 |Temporally related to

    419066007 |Finding informer| = [[+scg(<<

    404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] }    http://snomed.org/dom404684003
    ---
    > f1136b12-f2bd-46db-b9fb-be484129e40c    20220930    1    900000000000012004    723560006    404684003    << 404684003 |Clinical finding (finding)|        << 404684003 |Clinical finding (finding)|        [[+id(<< 404684003 |Clinical finding (finding

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

    *]] { [[0..

    1]]

    116676008

    42752001 |

    Associated morphology

    Due to| = [[+

    id(<< 49755003 |Morphologically abnormal structure (morphologic abnormality

    scg(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..

    1

    *]]

    246075003

    47429007 |

    Causative agent

    Associated with| = [[+

    id

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

    246112005 |Severity

    719722006 |Has realization| = [[+scg(<< 719982003 |Process (qualifier value)|)]], [[0..*]] 726633004 |Temporally related to| = [[+

    id(<< 272141005 |Severities (qualifier value

    scg(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]]

    , [[0..1]] 246454002 |Occurrence| =

    }    http://snomed.org/dom404684003
    ---
    > f1136b12-f2bd-46db-b9fb-be484129e40c    20220930    1    900000000000012004    723560006    404684003    << 404684003 |Clinical finding (finding)|        << 404684003 |Clinical finding (finding)|        [[+id(<<

    282032007 |Periods of life (qualifier value

    404684003 |Clinical finding (finding)|)]]: [[0..*]]

    ,

    { [[0..1]]

    246456000

    116676008 |

    Episodicity

    Associated morphology| = [[+id(<<

    288526004

    49755003 |

    Episodicities (qualifier value

    Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]]

    255234002

    246075003 |

    After

    Causative agent| = [[+id(<<

    272379006

    105590001 |

    Event

    Substance (

    event

    substance)| OR <<

    404684003

    260787004 |

    Clinical finding (finding

    Physical object (physical object)| OR <<

    71388002 |Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+id(<< 288524001 |Courses (qualifier value)|)]], [[0..1]] 288556008 |Before| = [[+id(<< 71388002 |Procedure (procedure

    373873005 |Pharmaceutical / biologic product (product)| OR << 410607006 |Organism (organism)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]]

    363698007

    246112005 |

    Finding site

    Severity| = [[+id(<<

    442083009 |Anatomical or acquired body structure (body structure

    272141005 |Severities (qualifier value)|)]], [[0..1]]

    363713009

    246454002 |

    Has interpretation

    Occurrence| = [[+id(<<

    260245000 |Finding value (qualifier value)| OR << 263714004 |Colors (qualifier value)| OR << 308916002 |Environment or geographical location (environment / location

    282032007 |Periods of life (qualifier value)|)]], [[0..1]]

    363714003

    246456000 |

    Interprets

    Episodicity| = [[+id(<<

    108252007

    288526004 |

    Laboratory procedure

    Episodicities (

    procedure

    qualifier value)|

    OR << 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|

    )]], [[0..1]]

    370135005

    255234002 |

    Pathological process

    After| = [[+id(<<

    1495041000004108

    272379006 |

    Proliferation of neoplasm (qualifier value

    Event (event)| OR <<

    308490002 |Pathological developmental process (qualifier value

    404684003 |Clinical finding (finding)| OR <<

    441862004

    71388002 |

    Infectious process (qualifier value)| OR << 472963003 |Hypersensitivity process (qualifier value)| OR << 769247005 |Abnormal immune process

    Procedure (procedure)|)]], [[0..1]] 263502005 |Clinical course| = [[+id(<< 288524001 |Courses (qualifier value)|)]], [[0..1]]

    371881003

    288556008 |

    During

    Before| = [[+id(<< 71388002 |Procedure (procedure)|)]], [[0..1]]

    418775008

    363698007 |Finding

    method

    site| = [[+id(<<

    71388002 |Procedure (procedure

    442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]]

    419066007

    363713009 |

    Finding informer

    Has interpretation| = [[+id(<<

    419358007 |Subject of record or other provider of history (person

    260245000 |Finding value (qualifier value)| OR <<

    420158005

    263714004 |

    Performer of method (person

    Colors (qualifier value)| OR <<

    444018008 |Person with characteristic related to subject of record (person

    308916002 |Environment or geographical location (environment / location)|)]], [[0..1]]

    42752001

    363714003 |

    Due to

    Interprets| = [[+id(<<

    272379006

    108252007 |

    Event

    Laboratory procedure (

    event

    procedure)| OR <<

    404684003

    363787002 |

    Clinical finding (finding

    Observable entity (observable entity)| OR <<

    71388002

    386053000 |

    Procedure

    Evaluation procedure (procedure)|)]], [[0..

    *

    1]]

    47429007

    370135005 |

    Associated with

    Pathological process| = [[+id(<< 1495041000004108 |Proliferation of neoplasm (qualifier value)| OR <<

    105590001

    308490002 |

    Substance (substance

    Pathological developmental process (qualifier value)| OR <<

    260787004

    441862004 |

    Physical object (physical object

    Infectious process (qualifier value)| OR <<

    272379006

    472963003 |

    Event

    Hypersensitivity process (

    event

    qualifier value)| OR <<

    404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR

    769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]] 371881003 |During| = [[+id(<< 71388002 |Procedure (procedure)|

    OR << 78621006 |Physical force (physical force

    )

    |)

    ]], [[0..1]]

    719722006

    418775008 |

    Has realization

    Finding method| = [[+id(<<

    719982003

    71388002 |

    Process

    Procedure (

    qualifier value

    procedure)|)]], [[0..

    *

    1]]

    726633004 |Temporally related to

    419066007 |Finding informer| = [[+id(<<

    404684003 |Clinical finding (finding

    419358007 |Subject of record or other provider of history (person)| OR <<

    71388002

    420158005 |

    Procedure

    Performer of method (

    procedure

    person)|

    )]] }    [[+scg(<< 404684003 |Clinical finding (finding

    OR << 444018008 |Person with characteristic related to subject of record (person)|)]]

    :

    , [[0..

    *]] { [[0..

    1]]

    116676008

    42752001 |

    Associated morphology

    Due to| = [[+

    scg(<< 49755003 |Morphologically abnormal structure (morphologic abnormality

    id(<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..

    1

    *]]

    246075003

    47429007 |

    Causative agent

    Associated with| = [[+

    scg

    id(<< 105590001 |Substance (substance)| OR

    138875005 |SNOMED CT Concept (SNOMED RT+CTV3

    << 260787004 |Physical object (physical object)| OR <<

    260787004

    272379006 |

    Physical object

    Event (

    physical object

    event)| OR <<

    373873005 |Pharmaceutical / biologic product (product

    404684003 |Clinical finding (finding)| OR << 410607006 |Organism (organism)| OR << 71388002 |Procedure (procedure)| OR << 78621006 |Physical force (physical force)|)]], [[0..1]]

    246112005 |Severity| =

    719722006 |Has realization| = [[+id(<< 719982003 |Process (qualifier value)|)]], [[0..*]] 726633004 |Temporally related to| = [[+id(<< 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] }    [[+scg(<<

    272141005

    404684003 |

    Severities

    Clinical finding (

    qualifier value

    finding)|)]]

    ,

    : [[0..*]] { [[0..1]]

    246454002

    116676008 |

    Occurrence

    Associated morphology| = [[+scg(<<

    282032007 |Periods of life (qualifier value

    49755003 |Morphologically abnormal structure (morphologic abnormality)|)]], [[0..1]]

    246456000

    246075003 |

    Episodicity

    Causative agent| = [[+scg(<<

    288526004

    105590001 |

    Episodicities

    Substance (

    qualifier value

    substance)|

    )]], [[0..1]] 255234002 |After| = [[+scg(<< 272379006 |Event (event

    OR 138875005 |SNOMED CT Concept (SNOMED RT+CTV3)| OR << 260787004 |Physical object (physical object)| OR << 373873005 |Pharmaceutical / biologic product (product)| OR <<

    404684003

    410607006 |

    Clinical finding

    Organism (

    finding

    organism)| OR <<

    71388002

    78621006 |

    Procedure

    Physical force (

    procedure

    physical force)|)]], [[0..1]]

    263502005

    246112005 |

    Clinical course

    Severity| = [[+scg(<<

    288524001

    272141005 |

    Courses

    Severities (qualifier value)|)]], [[0..1]]

    288556008

    246454002 |

    Before

    Occurrence| = [[+scg(<<

    71388002

    282032007 |

    Procedure (procedure

    Periods of life (qualifier value)|)]], [[0..1]]

    363698007

    246456000 |

    Finding site

    Episodicity| = [[+scg(<<

    442083009 |Anatomical or acquired body structure (body structure

    288526004 |Episodicities (qualifier value)|)]], [[0..1]]

    363713009

    255234002 |

    Has interpretation

    After| = [[+scg(<<

    260245000

    272379006 |

    Finding value

    Event (

    qualifier value

    event)| OR <<

    263714004

    404684003 |

    Colors

    Clinical finding (

    qualifier value

    finding)| OR <<

    308916002 |Environment or geographical location (environment / location

    71388002 |Procedure (procedure)|)]], [[0..1]]

    363714003

    263502005 |

    Interprets

    Clinical course| = [[+scg(<<

    108252007

    288524001 |

    Laboratory procedure

    Courses (

    procedure)| OR << 363787002 |Observable entity (observable entity)| OR << 386053000 |Evaluation procedure

    qualifier value)|)]], [[0..1]] 288556008 |Before| = [[+scg(<< 71388002 |Procedure (procedure)|)]], [[0..1]]

    370135005

    363698007 |

    Pathological process

    Finding site| = [[+scg(<<

    1495041000004108 |Proliferation of neoplasm (qualifier value)| OR << 308490002 |Pathological developmental process (qualifier value)| OR << 441862004 |Infectious process

    442083009 |Anatomical or acquired body structure (body structure)|)]], [[0..1]] 363713009 |Has interpretation| = [[+scg(<< 260245000 |Finding value (qualifier value)| OR <<

    472963003

    263714004 |

    Hypersensitivity process

    Colors (qualifier value)| OR <<

    769247005 |Abnormal immune process (qualifier value

    308916002 |Environment or geographical location (environment / location)|)]], [[0..1]]

    371881003

    363714003 |

    During

    Interprets| = [[+scg(<<

    71388002

    108252007 |

    Procedure

    Laboratory procedure (procedure)| OR << 363787002 |

    )]], [[0..1]] 418775008 |Finding method| = [[+scg(<< 71388002 |Procedure

    Observable entity (observable entity)| OR << 386053000 |Evaluation procedure (procedure)|)]], [[0..1]]

    419066007

    370135005 |

    Finding informer

    Pathological process| = [[+scg(<<

    419358007

    1495041000004108 |

    Subject of record or other provider of history (person

    Proliferation of neoplasm (qualifier value)| OR << 308490002 |Pathological developmental process (qualifier value)| OR << 441862004 |Infectious process (qualifier value)| OR <<

    420158005 |Performer of method (person

    472963003 |Hypersensitivity process (qualifier value)| OR <<

    444018008 |Person with characteristic related to subject of record (person

    769247005 |Abnormal immune process (qualifier value)|)]], [[0..1]]

    42752001

    371881003 |

    Due to

    During| = [[+scg

    (<< 272379006 |Event (event)| OR << 404684003 |Clinical finding

    (

    finding)| OR

    << 71388002 |Procedure (procedure)|)]], [[0..

    *

    1]]

    47429007

    418775008 |

    Associated with

    Finding method| = [[+scg(<<

    105590001

    71388002 |

    Substance

    Procedure (

    substance

    procedure)|

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

    719722006

    42752001 |

    Has realization

    Due to| = [[+scg(<<

    719982003 |Process (qualifier value

    272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]], [[0..*]]

    726633004 |Temporally related to

    47429007 |Associated with| = [[+scg(<<

    404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)|)]] }    http://snomed.org/dom404684003MRCM ModuleScope files0

    0 records added/updated as expected

    Association Reference files869

    527 records added/updated, plus

    342 records inactivated

    ...as expected as the totals ALMOST match exactly with Summary Component Stats report, but this report was run BEFORE we manually added in the 15 new records as part of the fixes in ISRS-1271 (spot checked these manually and they are present in new Association Snapshot + Full files as planned), so this brings us much closer to the figures in Comparison Diff files.

    In order to get an accurate comparison, we have to ALSO INCLUDE the SEP refset (734138000 + 734139008) totals from the RF2 files (manually tallied from the new Association Snapshot files) and add them to the "Hist Assoc" tab in the Summary Component Report:

    SEP (from RF2 diff files) = 48 changes:

    This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats:

    • 71 inactivations +
    • 234 new/updated records

    Makes a total of:

    • 72 inactivations +
    • 261 new/updated records  

    Which matches exactly with the counts I got above from the RF2 files!!  

    Attribute Value files1455

    1448 records added/updated, plus 

    7 inactivated

    XXXXXXX 633 in initial Summary Stats report....same in the new final Summary report...

    MANUAL validation in the DIFF files confirms:

    • 567 records added brand new +
    • 68 records updated/inactivated:
      • 1 inactivated
      • 67 updated:
        • 44 updated existing active records
        • 23 re-activated from previous inactive records

    Peter confirmed that this is a reporting issue only - fixed in https://jira.ihtsdotools.org/browse/RP-628 - so if you check out the new report here you'll see it now matches 624 added/updated + 1 inactivated: https://docs.google.com/spreadsheets/d/1ifgQwZh0rnFAq9ky8d2V65R5j41r1aOtZ1ZjFchFdoY/edit#gid=13

    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

    MRCM ModuleScope files0

    0 records added/updated as expected

    Association Reference files869

    527 records added/updated, plus

    342 records inactivated

    ...as expected as the totals ALMOST match exactly with Summary Component Stats report, but this report was run BEFORE we manually added in the 15 new records as part of the fixes in ISRS-1271 (spot checked these manually and they are present in new Association Snapshot + Full files as planned), so this brings us much closer to the figures in Comparison Diff files.


    In order to get an accurate comparison, we have to ALSO INCLUDE the SEP refset (734138000 + 734139008) totals from the RF2 files (manually tallied from the new Association Snapshot files) and add them to the "Hist Assoc" tab in the Summary Component Report:

    SEP (from RF2 diff files) = 48 changes:

    This then, adds to the "Association" totals in the final refsets tab, in the Summary report stats:

    • 341 inactivations +
    • 525 new/updated records

    Makes a total of:

    • 342 inactivations +
    • 527 new/updated records  

    Which matches exactly with the counts I got above from the RF2 files!!  

    Attribute Value files1455

    1448 records added/updated, plus 

    7

    1 records

    inactivated

    ...as expected as the totals

     ALMOST match

     match exactly with Summary Component Stats report

    Language refset files4757

    3695 records added/updated, plus

    1062 records inactivated

    Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated" counts above match against total of "New" + "Changed DefnStatus" + "Reactivated" columns in report)