Page tree

Versions Compared

Key

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

January 2023 PRODUCTION (PUBLISHED) to February 2023

Production

PRODUCTION (Version 1 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):  https://docs.google.com/spreadsheets/d/1lzgNDrnwBG0WbWIFwAwblsB-cevVz7v13t71CPqrFjM1NwEq7nLy1_s9aAo69dgz7di6XlhfKXwTPqCZPSCWb00/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 files
1210
1187
1050

908 records added/updated, plus

160

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:

0
  • 20 inactivations (734138000) +
0
  • 1 inactivations (734139008)
29
  • 40 new/updated records (734138000) +
7 inactivated
29
    • 40 new records +

7
    • 21 inactivations + 0 updates

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

153
  • 258 inactivations +
1021
  • 868 new/updated records

Makes a total of:

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

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

Attribute Value files
5731
2027
5727

1993 records added/updated, plus

4

34 inactivated

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

Language refset files
5165
9703
4926


8583 records added/updated,

plus239

plus  NOT THE SAME AS PRE-PROD OR THE SCS REPORT - BOTH SAY 8589 - COULD THIS BE 6 LESS THAN EXPECTED BECAUSE OF US FIXES IN MSSP-1750

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)("inactivated" count above matches against total of "Inactivated

"

+ "Changed Inactive"

columns in report)

ExtendedMap files
847
1964
517

1211 records added/updated, plus

330

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

10

13:

15

37 on

06 Jan

 :

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

47 records added/updated, plus

0

39 records inactivated

1nO9JgGuW2nl3FBoXnznZZ-_zorJeWqdIkBGlRcVinRs
0Report shows 17 changes - 17 new records + 0 inactivations +
updates
SimpleMap files
763
1146
763

1144 records added/updated, plus

0

2 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is
762
  • 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
1
  • 3 new +
0
  • 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
09
  • 13:
41
  • 05 on
06 Jan
    • "added/updated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (new) this
release 
      • release    
 
      •  
0
      •         +
      • Total New mapped entries this release   
                        1
      •  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   
                   0
      •  2
ModuleDependency files

3


3 records updated, as expected for January 2023 effectiveTimes

Readme file
January


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

Concept files
2129
1838
818

1565 records added/updated, plus

1311

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)

Description files
2616
4506
2494

3951 records added/updated, plus

122

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.

Relationship files
9736
19202
5348

11304 records added/updated, plus

4388

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)  

Relationship Concrete Values files
99
180
93

165 records added/updated, plus

6

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)  

OwlExpression (Axiom) files
3052
4053
1740

3778 records added/updated, plus

1312

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)

  • ("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 files
    94
    89
    91

    82 records added/updated, plus

    3

    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.

    MRCM AttributeDomain files0

    0 records added/updated as expected

    MRCM AttributeRange files
    0
    1
    0


    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 due to MRCM changes intentionally made by Yong this cycle...

    MRCM Domain files
    0
    1
    0


    1 records added/updated as expected

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

    MRCM ModuleScope files0

    0 records added/updated as expected


    January 2023 PRODUCTION (PUBLISHED) to February 2023 PRE-Production (Version 2 PRE VERSIONING) traceability

    SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING): https://docs.google.com/spreadsheets/d/1s6zjMn16XOvFjDhzCWonmEtmziNRkyPL-jnALjra6dw/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 files1187

    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:

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

    Attribute Value files2027

    1993 records added/updated, plus

    34 inactivated

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

    Language refset files9703


    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)

    ExtendedMap files1964

    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  :

    • "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
    Simple Refset files86

    47 records added/updated, plus

    39 records inactivated

    SimpleMap files1146

    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
      • "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
    ModuleDependency files

    3


    3 records updated, as expected for January 2023 effectiveTimes

    Readme file

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

    Concept files1838

    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)

    Description files4506

    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.

    Relationship files19202

    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)  

    Relationship Concrete Values files180

    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)  

    OwlExpression (Axiom) files4053

    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)

    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 files89

    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.

    MRCM AttributeDomain files0

    0 records added/updated as expected

    MRCM AttributeRange files1


    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 due to MRCM changes intentionally made by Yong this cycle...

    MRCM Domain files1


    1 records added/updated as expected

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

    MRCM ModuleScope files0

    0 records added/updated as expected