Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 6

July 2023 PRODUCTION (PUBLISHED) to September 2023 PRODUCTION (Version 1 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):   https://docs.google.com/spreadsheets/d/18c8XfmIKmEa3VF4xUSqPPHnR3rbQDIjkbYXkAsjEArg/edit#gid=0  

SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING):  https://docs.google.com/spreadsheets/d/1lpP_YIT8_bjVklmrqyQW3odQhtqsf549EU5jIi-H9Lk1t2thATnI6JWDQnrM7gFjJunHS-sP00mgpY1qcMjsTM0/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 files254621

206 402 records added/updated, plus

48 219 records inactivated

...as expected as the totals ALMOST match exactly with Summary Component Stats report, but you also need to incorporate SEP changes:

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

  • 0 inactivations (734139008) + 0 inactivations (734139008)
  • 4 new/updated records (734138000) + 4 new records (734138000)
  • Confirmed as matches exactly with data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page) - see report above

    • Report shows 8 changes - 4 new records + 4 inactivations + 0 updates

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

  • 202 new/updated records +
  • 44 inactivations 

Makes a total of:

  • 206 new/updated records +
  • 48 inactivations 

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

Attribute Value files8303968

816 3929 records added/updated, plus

14 39 inactivated

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

Language refset files453615247


3884 10143 records added/updated, plus

652 5104 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 files521855

376 591 records added/updated, plus

45 264 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:06 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     375
    • Total Changed mapped entries (modified) 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     45
Simple Refset files6

2 records added/updated, plus

4 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) - see report above

SimpleMap files628

628 857 records added/updated, plus

0 records inactivated

Confirmed as matches with:

  • firstly the number of CTV3 records (900000000000497000) - which in this release is 625 (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 + 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 "Upload Successful", at 09:39 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     0
ModuleDependency files

3


3 records updated, as expected for July 2023 effectiveTimes

Readme file

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

Concept files822

723 records added/updated, plus

99 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 files2315

1969 records added/updated, plus

346 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 files7225

5151 records added/updated, plus

2074 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 files96

79 records added/updated, plus

17 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) files1217

1118 records added/updated, plus

99 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

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

TextDefinition files40

26 records added/updated, plus

14 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


September 2023 PRODUCTION (Version 2 PRE VERSIONING) to September 2023 PRODUCTION (Version 1 POST VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY DEVOPS POST-VERSIONING):  https://docs.google.com/spreadsheets/d/18c8XfmIKmEa3VF4xUSqPPHnR3rbQDIjkbYXkAsjEArg/edit#gid=0

SEP + LATERALIZABLE SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING):   https://docs.google.com/spreadsheets/d/1lpP_YIT8_bjVklmrqyQW3odQhtqsf549EU5jIi-H9Lk1t2thATnI6JWDQnrM7gFjJunHS-sP00mgpY1qcMjsTM0/edit#gid=0

625625

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

Readme file

Beta "x" prefixes removed + Prod naming conventions applied, as expected

SimpleMap files857

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


July 2023 PRODUCTION (PUBLISHED) to September 2023 PREPRODUCTION (Version 2 PRE VERSIONING) traceability

SUMMARY COMPONENT REPORT (RUN BY MARIA PRE-VERSIONING):  https://docs.google.com/spreadsheets/d/19AqljHDnHzgZYqNSngNoxDq15fZ4BbHYr1VjGmxb1NQ1kq8j74z3f2yfE5in6IF9DwC_GPGqyoQ3aCNu3MLnkek/edit#gid=0

SEP + LATERALIZABLE REFSET REPORT (RUN BY MARIA PRE-VERSIONING):  https://docs.google.com/spreadsheets/d/165jktWOipmWLYnBtgywa2u9_WVpm1t2thATnI6JWDQnrM7gFjJunHS-WHpB87QTZeyrugsP00mgpY1qcMjsTM0/edit#gid=20

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
254
621
206

402 records added/updated, plus

48

219 records inactivated

...as expected as the totals ALMOST match exactly with Summary Component Stats report, but you also need to incorporate SEP changes:

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

  • Refset:
  • 0 inactivations (734139008) + 0 inactivations (734139008)
    • 734138000
    • 1 new/updated records + 2 inactivated records
    • Refset: 734139008
    • 0
    4
    • new/updated records
    (734138000) + 4 new records (734138000)
    • + 0 inactivated records
    • Confirmed as matches exactly with data in Lateralizable Report sent to me by Maria (in Section 1 of Content Handover page) - see report above

      • Report shows

    8
      • 3 changes -

    4
      • 1 new records +

    4
      • 2 inactivations + 0 updates

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

    202
    • 401 new/updated records +
    44
    • 217 inactivations 

    Makes a total of:

    206
    • 402 new/updated records +
    48
    • 219 inactivations 

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

    Attribute Value files
    830
    3968
    816

    3929 records added/updated, plus

    14

    39 inactivated

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

    Language refset files
    4536
    15247
    3884


    10143 records added/updated, plus

    652

    5104 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 files
    521
    855
    376

    591 records added/updated, plus

    45

    264 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

    11:

    06

    18 on

    07 Jul

    :

    • "added/updated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (new) this release   
     1   
      •  176          +
      • Total New mapped entries this release   
     375
      •  380
      • Total Changed mapped entries (modified) this release   
    0
      • 35
    • "inactivated" counts from diff report matches to total of WCI report lines:
      • Total Changed mapped entries (retired) this release   
     0 
      •  126        +
      • Total Retired mapped entries this release   
     45
      •  138
    Simple Refset files6

    2 records added/updated, plus

    4 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) - see report above

    SimpleMap files
    628
    857
    628

    857 records added/updated, plus

    0 records inactivated

    Confirmed as matches with:

    • firstly the number of CTV3 records (900000000000497000) - which in this release is
    625
    • 857 (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
    • 0 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 "Upload Successful", at
    09
    • 10:
    39
    • 50 on
    07 Jul
      • "added/updated" counts from diff report matches to total of WCI report lines:
        • Total Changed mapped entries (new) this release   
     1 
        •  0            +
        • Total New mapped entries this release   
     2
        •  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
    ModuleDependency files

    3


    3 records updated, as expected for

    July

    September 2023 effectiveTimes(we're skipping August this time due to the move to 1st of the month releases)

    Readme file
    July


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

    Concept files
    822
    1387
    723

    1111 records added/updated, plus

    99

    276 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
    2315
    6552
    1969

    3900 records added/updated, plus

    346

    2652 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
    Identifier files
    7225

    5151 records added/updated, plus

    2074 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 files96

    79 records added/updated, plus

    17 records inactivated

    Confirmed as matches exactly with data in Summary Component Stats report - see Report linked above - ("added/updated"
    n/a

    Just the headers changed for this file, as per the planned change to the format of the file in FRI-658 + ISRS-1562 + ISRS-1563 + the new specs here: https://confluence.ihtsdotools.org/mag/snomed-international-proposal-to-change-the-rf2-identifier-file-specification

    < identifierSchemeId    alternateIdentifier    effectiveTime    active    moduleId    referencedComponentId
    ---
    > alternateIdentifier    effectiveTime    active    moduleId    identifierSchemeId    referencedComponentId

    Relationship files15610

    9519 records added/updated, plus

    6091 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)
    Relationship Concrete Values files
    1217
    405
    1118

    352 records added/updated, plus

    99

    53 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)
    Stated Relationship
    files
    0

    0 records updated, plus

    0 records inactivated

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

    TextDefinition files40
    2884

    2607

    26

    records added/updated, plus

    14

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

    "Changed DefnStatus" + "Reactivated" columns in report)

    Stated Relationship files0

    0 records updated, plus

    0 records inactivated

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

    TextDefinition files28

    28 records added/updated, plus

    0 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

    Just the one record changed, to allow the Range for concept 1142142004 to be updated from an Integer to a Decimal:

    < e96eade2-42ce-4c5c-8585-ad80b8dd7b41    20210731    1    900000000000012004    723562003    1142142004    int(>#0..)    << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 1142142004 |Has pack size| > #0 }    723597001    723596005
    ---
    > e96eade2-42ce-4c5c-8585-ad80b8dd7b41    20230901    1    900000000000012004    723562003    1142142004    dec(>#0..)    << 781405001 |Medicinal product package (product)|: [0..*] { [0..1] 1142142004 |Has pack size| > #0 }    723597001    723596005

    For details see Briefing Note attached to

    Jira
    serverIHTSDO JIRA
    serverIdb202d822-d767-33be-b234-fec5accd5d8c
    keyINFRA-11294
    (attached to the Content Handover Meeting minutes here: Content Handover Meeting minutes - September 2023 International Edition

    MRCM Domain files1


    1 records added/updated as expected

    See the same change applied in the Domain template here (for the same concept 1142142004):

    < 0867d3ba-1849-4de1-9812-dedcd18a561c    20210731    1    900000000000012004    723560006    781405001    << 781405001 |Medicinal product package (product)|    373873005 |Pharmaceutical / biologic product (product)|    << 781405001 |Medicinal product package (product)|        [[+id(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+int(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+id(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+id(<< 767524001 |Unit of measure (qualifier value)|)]] }    [[+scg(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+int(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+scg(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+scg(<< 767524001 |Unit of measure (qualifier value)|)]] }    http://snomed.org/dom781405001
    ---
    > 0867d3ba-1849-4de1-9812-dedcd18a561c    20230901    1    900000000000012004    723560006    781405001    << 781405001 |Medicinal product package (product)|    373873005 |Pharmaceutical / biologic product (product)|    << 781405001 |Medicinal product package (product)|        [[+id(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+dec(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+id(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+id(<< 767524001 |Unit of measure (qualifier value)|)]] }    [[+scg(<< 781405001 |Medicinal product package (product)|)]]: [[1..1]] 1142143009 |Count of clinical drug type| = [[+int(>#0..)]], [[1..*]] { [[0..1]] 1142142004 |Has pack size| = [[+dec(>#0..)]], [[1..1]] 774160008 |Contains clinical drug| = [[+scg(<< 763158003 |Medicinal product (product)|)]], [[0..1]] 774163005 |Has pack size unit| = [[+scg(<< 767524001 |Unit of measure (qualifier value)|)]] }    http://snomed.org/dom781405001

    MRCM AttributeDomain files0

    0 records added/updated as expected

    MRCM AttributeRange files0

    0 records added/updated as expected

    MRCM Domain files00 records added/updated as expected

    MRCM ModuleScope files0

    0 records added/updated as expected