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 impacted | Related JIRA ticket(s) | Rationale |
|---|---|---|---|
| RefsetDescriptor files | 0 | 0 records added/updated as expected | |
| Concept files | 710 | 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 files | 1649 | 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 files | 10240 | 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 files | 211 | 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 files | 2014 | 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 files | 0 | 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 files | 18 | 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 files | 468 | 468 records added/updated, plus 0 records inactivated Confirmed as matches with:
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
| |
| ExtendedMap files | 353 | 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 :
| |
| Simple Refset files | 52 | 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 files | 0 | 0 records added/updated as expected | |
| MRCM AttributeRange files | 0 | 0 records added/updated as expected | |
| MRCM Domain files | 0 | 0 records added/updated as expected | |
| Association Reference files | 333 | 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:
Makes a total of:
Which matches exactly with the counts I got above from the RF2 files!! | |
| Attribute Value files | 635 | 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:
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 files | 3288 | 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
...
0 records added/updated as expected
...
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)
...
1831 records added/updated, plus
521 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.
...
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)
...
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)
...
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)
...
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
...
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.
...
463 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
...
333 records added/updated, plus
109 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
...
3 records added/updated, plus
2 records inactivated
Confirmed as matches exactly with Lateralizable refset (723264001) data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page)
https://docs.google.com/spreadsheets/d/1LCuPBRfRn0vg5EeoUB-uYYz9T35qN7JB3xLxKexwMc8/edit#gid=0
- Report shows 52 changes - 51 new records + 1 inactivations + 0 updates
...
3
...
3 records updated, as expected for September 2022 effectiveTimes
...
September 2022 dates updated + Beta "x" prefixes added, as expected
...
0 records added/updated as expected
...
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-a9e0-4241-912d-8ea9331cce91 20220930 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
...
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(<< 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..1]] 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..1]] 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..1]] 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
---
> f1136b12-f2bd-46db-b9fb-be484129e40c 20220930 1 900000000000012004 723560006 404684003 << 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| = [[+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..1]] 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(<< 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)|)]], [[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..1]] 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..1]] 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(<< 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)|)]], [[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
...
0 records added/updated as expected
...
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:
- 1 inactivations (734138000) + 0 inactivations (734139008)
- 27 new/updated records (734138000) + 0 new records (734139008)
Confirmed as matches exactly with data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page)
https://docs.google.com/spreadsheets/d/1opikf-o_Dpe80sr7ddtStIWGdg4gqffL2o_5nXxTeVU/edit#gid=2
Report shows 35 changes - 22 new records + 12 inactivations + 1 updates
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!!
...
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
1 records inactivated
...as expected as the totals ALMOST match exactly with Summary Component Stats report
...
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)