Page tree

Versions Compared

Key

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

December 2022 PRODUCTION (PUBLISHED) to January 2023

PRE-

Production (Version 1

PRE

POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY MARIA PREDEVOPS POST-VERSIONING): : https://docs.google.com/spreadsheets/d/1lzgNDrnwBG0WbWIFwAwblsB-cevVz7v13t71CPqrFjM/edit#gid=0

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

RefsetDescriptor files0

0 records added/updated as expected

Association Reference files1210

1050 records added/updated, plus

160 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) =

54

36 changes:

4
  • 0 inactivations (734138000) + 0 inactivations (734139008)
38
  • 29 new/updated records (734138000) +
0 new
42
    • 36 changes -

38
    • 29 new records +

4
    • 7 inactivations + 0 updates

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

156
  • 153 inactivations +
554
  • 1021 new/updated records

Makes a total of:

  • 153 + 0 + 7 = 160 inactivations +
592 new
  • 1021 + 0 + 29 = 1050 new/updated records  

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

Attribute Value files5731

5727 records added/updated, plus

4 inactivated

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

Language refset files5165


4926 records added/updated, plus

239 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)
  • ("inactivated" count above matches against total of "Inactivated" + "Changed Inactive" columns in report)
ExtendedMap files847

517 records added/updated, plus

330 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 10:15 on  :

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

17

NOT MATCHING - REPORT STATES:

5204

records added/updated, plus

613

0 records inactivated

  • Confirmed

to be a Reporting issue - Peter fixed in ISRS-1392 and ran locally against the new code to confirm correct figures:
1fpH5tqCaBNfEMbkBE4GvjVRYalCHlS0R2_nfDEE2C-o
ExtendedMap
SimpleMap files
847
763
517

763 records added/updated, plus

330

0 records inactivated

Which

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 762 (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 1 new + 0 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
  •  entitled "Upload Successful", at 09:
49 on  :
  • 41 on
    • "added/updated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (new) this release     
 39 
      •    0       +
      • Total New mapped entries this
release
      • release                           
551
      • 1
    • "inactivated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (retired) this
release 
      • release     0 
 33 
      •      +
      • Total Retired mapped entries this release 
   150

RICK Investigated and confirmed it's an issue with the Stats report, whereby the mutable field changes are not counted in the stats report (only those immutable changes which require inactivation and recreation of the records).  He will fix the report, but in the meantime Donna has confirmed the figures we have are about right, so we can continue as planned for now... Rick then confirmed in the Final Handover meeting that this is a reporting issue only, and all Map records are correct.

      •                      0
ModuleDependency files

3


3 records updated, as expected for January 2023 effectiveTimes

Readme file

January 2023 dates updated, as expected

Concept files2129

818 records added/updated, plus

1311 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 files2616

2494 records added/updated, plus

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

Relationship files9736

5348 records added/updated, plus

4388 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 files99

93 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 (Axiom) files3052

1740 records added/updated, plus

1312 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)
  • ("inactivated" count above matches against total of "Inactivated" + "Changed Inactive" columns in report)
Stated Relationship files0

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

TextDefinition files94

91 records added/updated, plus

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

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

MRCM ModuleScope files0

0 records added/updated as expected


January 2023 PRE-Production (Version 1 PRE VERSIONING) to January 2023 Production (Version 1 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): 

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

Readme filen/a
x prefixes removed, and package naming convention updated to Production as planned
SimpleMap files762

762 new records had their UUID's refreshed as expected


December 2022 PRODUCTION (PUBLISHED) to January 2023 PRE-Production (Version 1 PRE VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): 

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

RefsetDescriptor files0

0 records added/updated as expected

Association Reference files1210

1050 records added/updated, plus

160 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:

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

  • 153 inactivations +
  • 1021 new/updated records

Makes a total of:

  • 7 inactivations +
  • 29 new/updated records  

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

Attribute Value files5731

5727 records added/updated, plus

4 inactivated

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

Language refset files5165


4926 records added/updated, plus

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

ExtendedMap files847

517 records added/updated, plus

330 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 10:15 on  :

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

17 records added/updated, plus

0 records inactivated

1-u-8pAsQaI2fkER4XbK4ogtxjc65rPnM0NcYZZAAeYk
33
    • 17 changes -
31
    • 17 new records +
2
    • 0 inactivations + 0 updates
SimpleMap files763

763 records added/updated, plus

0 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is
829
  • 762 (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
2
  • 1 new +
11
  • 0 inactivations,
which match with those
  • in the SimpleMap diff
report sent by Rick via email on 15/07/22 at 00:54:
  • > bd997c9a-d70f-5d04-9190-fe70a4d80dc0    20221031    1    900000000000207008    446608001    1255722004    8620/1
  • > ce3df39b-ea26-550f-a577-a1a6ea764f2e    20221031    0    900000000000207008    446608001    84427001    8950/3
  • > f1e1ff7e-d2ce-5a0c-8a57-97c6b8b1cb2e    20221031    0    900000000000207008    446608001    734274003    8620/1
Which
  • 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
  •  entitled "Upload Successful", at 09:
23 on  
  • 41 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   
 2
      •  1
    • "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   
 11
      •  0
ModuleDependency files

3


3 records updated, as expected for January 2023 effectiveTimes

Readme file

January 2023 dates updated + Beta "x" prefixes added, as expected

Concept files2129

818 records added/updated, plus

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

NOT MATCHING - REPORT STATES:

1032 records added/updated, plus

70 records inactivated

Confirmed to be a Reporting issue - Peter fixed in ISRS-1392 and ran locally against the new code to confirm correct figures:

https://docs.google.com/spreadsheets/d/1fpH5tqCaBNfEMbkBE4GvjVRYalCHlS0R2_nfDEE2C-o/edit#gid=0

Description files2616

2494 records added/updated, plus

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

Relationship files9736

5348 records added/updated, plus

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

NOT MATCHING - REPORT STATES:

11257 records added/updated, plus

6281 records inactivated

Confirmed to be a Reporting issue - Peter fixed in ISRS-1392 and ran locally against the new code to confirm correct figures:

https://docs.google.com/spreadsheets/d/1fpH5tqCaBNfEMbkBE4GvjVRYalCHlS0R2_nfDEE2C-o/edit#gid=0

Relationship Concrete Values files99

93 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 (Axiom) files3052

1740 records added/updated, plus

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

NOT MATCHING - REPORT STATES:

11257 records added/updated, plus

71 records inactivated

Confirmed to be a Reporting issue - Peter fixed in ISRS-1392 and ran locally against the new code to confirm correct figures:

https://docs.google.com/spreadsheets/d/1fpH5tqCaBNfEMbkBE4GvjVRYalCHlS0R2_nfDEE2C-o/edit#gid=0

Stated Relationship files0

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

TextDefinition files94

91 records added/updated, plus

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

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

MRCM ModuleScope files0

0 records added/updated as expected