463 new records had their UUID's refreshed, as expected

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

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

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

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 463 (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 14:05 on 09 Sep 2022 

• "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:35 on 09 Sep 2022 :

• "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     332
    
• "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     108

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

  • Report shows 5 changes - 3 new records + 2 inactivations + 0 updates

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

Messaged Yong in ATF-1673 to confirm that he's happy with the exact RF2 changes... he confirmed they are exactly as expected on 12/9/2022 in the ticket

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

Messaged Yong in ATF-1673 to confirm that he's happy with the exact RF2 changes... he confirmed they are exactly as expected on 12/9/2022 in the ticket

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)
• 2 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:

• 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!!  

1448 records added/updated, plus 

7 inactivated

...as expected as the totals 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)