0 records added/updated as expected

908 records added/updated, plus

279 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) = 36 changes:

• 20 inactivations (734138000) +

• 1 inactivations (734139008)

• 40 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/1-u-8pAsQaI2fkER4XbK4ogtxjc65rPnM0NcYZZAAeYk/edit#gid=0

  • Report shows 36 changes -

• • 40 new records +

• • 21 inactivations + 0 updates

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

• 258 inactivations +

• 868 new/updated records

Makes a total of:

• 279 inactivations +
• 908 new

• /updated records  

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

1993 records added/updated, plus

34 inactivated

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

8589 records added/updated,

plus  

1114 records inactivated

*NOTE -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

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)

1211 records added/updated, plus

753 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

13:

37 on

10 Feb 2023 :

• "added/updated" counts from diff report matches to total of WCI report lines:
  • Total Changed mapped entries (new) this release   

• •  571            +
  • Total New mapped entries this

• • release   

• •  640
    
• "inactivated" counts from diff report matches to total of WCI report lines:
  • Total Changed mapped entries (retired) this release   

• •  571        +
  • Total Retired mapped entries this release   

• •  182

47 records added/updated, plus

39 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/

• • 1h-zR_L0g6J2ApuW6-aNUw-Qp4tquPPI_kXp6BCPJxwM/edit#gid=0

1144 records added/updated, plus

2 records inactivated

Confirmed as matches with:

• firstly the number of CTV3 records (900000000000497000) - which in this release is

• 1141 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see "Concepts" tab in the Summary Component Stats report above) PLUS
• the manual counts of ICD-0 records (446608001) - here

• 3 new +

• 2 inactivations, in the SimpleMap diff file, which also 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:

• 05 on

• 10 Feb 2023
  • "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   

• • •  2
      
  • "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   

• • •  2

1565 records added/updated, plus

273 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 -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

3951 records added/updated, plus

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

*NOTE -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

11304 records

added/updated, plus

7898 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 -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

165 records added/updated, plus

15

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)  

3778 records added/updated, plus

275 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 -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

0 records updated, plus

0 records inactivated, plus

9000000000004970000 records added

As expected due to full migration to OWLExpression file in the July 2019 International Edition

82 records added/updated, plus

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

0 records added/updated as expected

1 records added/updated as expected

< e25ae83a-4da4-4c87-b254-f5399dd9b088    20180131    1    900000000000012004    723562003    719722006    << 719982003 |Process (qualifier value)|    (<< 363787002 |Observable entity (observable entity)| OR << 404684003 |Clinical finding (finding)|): [0..*] { [0..1] 719722006 |Has realization| = << 719982003 |Process (qualifier value)| }    723597001    723596005
---
> e25ae83a-4da4-4c87-b254-f5399dd9b088    20230228    1    900000000000012004    723562003    719722006    << 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)| OR << 719982003 |Process (qualifier value)|    (<< 363787002 |Observable entity (observable entity)| OR << 404684003 |Clinical finding (finding)|): [0..*] { [0..1] 719722006 |Has realization| = (<< 272379006 |Event (event)| OR << 404684003 |Clinical finding (finding)| OR << 71388002 |Procedure (procedure)| OR << 719982003 |Process (qualifier value)|) }    723597001    723596005

As confirmed by Maria + Yong due to MRCM changes intentionally made by Yong this cycle...

*NOTE -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

1 records added/updated as expected

As confirmed by Maria + Yong due to MRCM changes intentionally made by Yong this cycle...

*NOTE -  NEED TO SEARCH THE LANG REFSET FILES FOR BOTH the following modules in order to get the full totals:

• 20230228\t1\t900000000000207008
• 20230228\t1\t900000000000012004

0 records added/updated as expected

0 records added/updated as expected

908 records added/updated, plus

279 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) = 36 changes:

• 20 inactivations (734138000) +

• 1 inactivations (734139008)

• 40 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/1-u-8pAsQaI2fkER4XbK4ogtxjc65rPnM0NcYZZAAeYk/edit#gid=0

  • Report shows 36 changes -

• • 40 new records +

• • 21 inactivations + 0 updates

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

• 258 inactivations +

• 869 new/updated records

Makes a total of:

• 279 inactivations +

• 909 new/updated records  

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

1993 records added/updated, plus

34 inactivated

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

8589 records added/updated, plus

1114 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)

1211 records added/updated, plus

753 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

13:

37 on

10 Feb 2023 :

• "added/updated" counts from diff report matches to total of WCI report lines:
  • Total Changed mapped entries (new) this release   

• •  571            +
  • Total New mapped entries this

• • release   

• •  640
    
• "inactivated" counts from diff report matches to total of WCI report lines:
  • Total Changed mapped entries (retired) this release   

• •  571        +
  • Total Retired mapped entries this release   

• •  182

47 records added/updated, plus

39 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/

• • 1h-zR_L0g6J2ApuW6-aNUw-Qp4tquPPI_kXp6BCPJxwM/edit#gid=0

1144 records added/updated, plus

2 records inactivated

Confirmed as matches with:

• firstly the number of CTV3 records (900000000000497000) - which in this release is

• 1141 (as per the number of 900000000000497000 records in the SimpleMap diff files, + it's exactly the same number as new concepts this cycle - see "Concepts" tab in the Summary Component Stats report above) PLUS
• the manual counts of ICD-0 records (446608001) - here

• 3 new +

• 2 inactivations, in the SimpleMap diff file, which also 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:

• 05 on

• 10 Feb 2023
  • "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   

• • •  2
      
  • "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   

• • •  2

1565 records added/updated, plus

273 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)

3951 records added/updated, plus

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

11304 records added/updated, plus

7898 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)  

165 records added/updated, plus

15 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)  

3778 records added/updated, plus

275 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

9000000000004970000 records added

As expected due to full migration to OWLExpression file in the July 2019 International Edition

82 records added/updated, plus

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