Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
March 2022 (PUBLISHED

September 2023 Pre-Production (Version 7) vs September

2022 Pre-

2023 Production (

Version4

Version 1) traceability

Summary Component Stats report (US 20220301 20230301 - 2022090120230901):  https://docs.google.com/spreadsheets/d/1TXItDv1emQPKZmR0XGZUwEhbPeH3f9tFDQO4vI_PxRI1NEzzhHaOTjq1b97AeZvGjeIz07czLCXWB2f4z39YBuw/edit#gid=0

Summary Component Stats report (INT 20220131 20221231 - 2022063020230630):https://docs.google.com/spreadsheets/d/19VsiSfqZGc9DSO8qINiqtBSYAdCsL6I1QfyE9Dys2tAnQXi7CDz9zvNGXXo_AfyUT0JoiRod5zIlivcCUpHDug/edit#gid=03

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Readme file
n/a

Updated to remove x prefixes + add in Production naming conventions, as expected


September 2023 Pre-Production (Version 6) vs September 2023 Pre-Production (Version 7) traceability

Summary Component Stats report (US 20230301 - 20230901):  https://docs.google.com/spreadsheets/d/1NEzzhHaOTjq1b97AeZvGjeIz07czLCXWB2f4z39YBuw/edit#gid=0

Summary Component Stats report (INT 20221231 - 20230630): https://docs.google.com/spreadsheets/d/1QfyE9Dys2tAnQXi7CDz9zvNGXXo_d5zIlivcCUpHDug/edit#gid=3

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Extended Map files7

ISRS-1600

2 records removed completely, matching exactly the issues identified in ISRS-1600:

  • < 01ccdb76-0117-5858-9516-24947a0b2b4f    20230901    1    5991000124107    6011000124106    434321000124107    1    1    TRUE    ALWAYS G37.89    G37.89    447561005    447637006
  • < fd667d3f-116d-51e8-82c1-0f70026059f0    20230901    1    5991000124107    6011000124106    445967004    1    3    IFA 434321000124107 | Clinically isolated syndrome of brainstem |    IF CLINICALLY ISOLATED SYNDROME OF BRAINSTEM CHOOSE G37.89 | MAP OF SOURCE CONCEPT IS CONTEXT DEPENDENT    G37.89    447561005    447639009

Plus 5 records updated:

  • < 5f4bbe5d-34ae-5356-b5e8-0f2964b9581c    20230901    1    5991000124107    6011000124106    11800811000119100    1    1    TRUE    ALWAYS S35.90X? | CONSIDER ADDITIONAL CODE TO IDENTIFY SPECIFIC CONDITION OR DISEASE | DESCENDANTS NOT EXHAUSTIVELY MAPPED | EPISODE OF CARE INFORMATION NEEDED | POSSIBLE REQUIREMENT FOR AN EXTERNAL CAUSE CODE    S35.90X?    447561005    447637006
    > 5f4bbe5d-34ae-5356-b5e8-0f2964b9581c    20230301    0    5991000124107    6011000124106    11800811000119100    1    1    TRUE    ALWAYS S35.90X? | CONSIDER ADDITIONAL CODE TO IDENTIFY SPECIFIC CONDITION OR DISEASE | EPISODE OF CARE INFORMATION NEEDED | POSSIBLE REQUIREMENT FOR AN EXTERNAL CAUSE CODE    S35.90X?    447561005    447637006
  • < 8482f654-8611-5797-8bc0-aa27a4808ddd    20220901    1    5991000124107    6011000124106    620961000124106    1    1    TRUE    ALWAYS Z60.5    Z60.5    447561005    447637006
    > 8482f654-8611-5797-8bc0-aa27a4808ddd    20230901    0    5991000124107    6011000124106    620961000124106    1    1    TRUE    ALWAYS Z60.5    Z60.5    447561005    447637006
  • < d7048399-3fdd-5867-8281-c660aee69685    20230901    1    5991000124107    6011000124106    445967004    1    4    IFA 703621006 | Multifocal clinically isolated syndrome |    IF MULTIFOCAL CLINICALLY ISOLATED SYNDROME CHOOSE G37.89 | MAP OF SOURCE CONCEPT IS CONTEXT DEPENDENT    G37.89    447561005    447639009
    > d7048399-3fdd-5867-8281-c660aee69685    20230901    1    5991000124107    6011000124106    445967004    1    3    IFA 703621006 | Multifocal clinically isolated syndrome |    IF MULTIFOCAL CLINICALLY ISOLATED SYNDROME CHOOSE G37.89 | MAP OF SOURCE CONCEPT IS CONTEXT DEPENDENT    G37.89    447561005    447639009
  • < e30f57bc-cbff-5636-bdba-67a096f43295    20230901    1    5991000124107    6011000124106    445967004    1    5    IFA 703622004 | Monofocal clinically isolated syndrome |    IF MONOFOCAL CLINICALLY ISOLATED SYNDROME CHOOSE G37.89 | MAP OF SOURCE CONCEPT IS CONTEXT DEPENDENT    G37.89    447561005    447639009
    > e30f57bc-cbff-5636-bdba-67a096f43295    20230901    1    5991000124107    6011000124106    445967004    1    4    IFA 703622004 | Monofocal clinically isolated syndrome |    IF MONOFOCAL CLINICALLY ISOLATED SYNDROME CHOOSE G37.89 | MAP OF SOURCE CONCEPT IS CONTEXT DEPENDENT    G37.89    447561005    447639009
  • < f852a1f0-0948-5b4b-b63a-135039362942    20230901    1    5991000124107    6011000124106    445967004    1    6    OTHERWISE TRUE    ALWAYS G37.9    G37.9    447561005    447637006
    > f852a1f0-0948-5b4b-b63a-135039362942    20230901    1    5991000124107    6011000124106    445967004    1    5    OTHERWISE TRUE    ALWAYS G37.9    G37.9    447561005    447637006

The first 2x updated records correspond to additional similar errors that Rick found when investigating the original problems, and Slack messaged me about to confirm he'd changed them as well:

  • 11800811000119100
  • 620961000124106

The remaining 3x updated records also appear to be linked to the second concept that was originally identified as a problem in ISRS-1600 - 445967004.

I'm therefore asking Rick to confirm that the updates were also intentional as well as the removal of the first record....he confirmed my analysis was correct and everything is now good, via slack on  


September 2023 Pre-Production (Version 4) vs September 2023 Pre-Production (Version 6) traceability

Summary Component Stats report (US 20230301 - 20230901):  https://docs.google.com/spreadsheets/d/1NEzzhHaOTjq1b97AeZvGjeIz07czLCXWB2f4z39YBuw/edit#gid=0

Summary Component Stats report (INT 20221231 - 20230630): https://docs.google.com/spreadsheets/d/1QfyE9Dys2tAnQXi7CDz9zvNGXXo_d5zIlivcCUpHDug/edit#gid=3

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Description files25


25 records removed, as per fixes in MSSP-2203 (the diff file in the RF2 packages matches the Description Delta created by Peter as part of the fixes - see MSSP-2203-part2.zip attached to the ticket.

Language files83

83 records removed, as per fixes in MSSP-2203 (the diff file in the RF2 packages matches the Language Delta created by Peter as part of the fixes - see MSSP-2203.zip attached to the ticket.


March 2023 (PUBLISHED) vs September 2023 Pre-Production (Version 4) traceability

Summary Component Stats report (US 20230301 - 20230901):  https://docs.google.com/spreadsheets/d/1NEzzhHaOTjq1b97AeZvGjeIz07czLCXWB2f4z39YBuw/edit#gid=0

Summary Component Stats report (INT 20221231 - 20230630): https://docs.google.com/spreadsheets/d/1QfyE9Dys2tAnQXi7CDz9zvNGXXo_d5zIlivcCUpHDug/edit#gid=3

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
ExtendedMap files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for ICD-10 (INT) - "1    449080006", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active ICD-10CM records that were REMOVED this release in your count!!)

Next need to search diff file for ICD-10 (INT) - "0    449080006", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive ICD-10CM records that were REMOVED this release in your count!!)

3759 records added/updated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

2061 records inactivated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

##########################################################################################################

DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the MAP files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!!

##########################################################################################################


US EDITION EFFECTIVETIME 20230901 - for ICD-10-CM (5991000124107) map:

Info
titleGetting accurate manual counts:

First need to search diff file for ICD-10CM (US) - "1    5991000124107", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active ICD-10CM records that were REMOVED this release in your count!!)

Next need to search diff file for ICD-10CM (US) - "0    5991000124107", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive ICD-10CM records that were REMOVED this release in your count!!)

42,464 records added/updated

10,159 records inactivated

????Need to verify this with WCI + Kin Wah.... Kin Wah confirmed they don't keep logs!

  • Sept18 - Mar19 Diff = 36,100
  • Mar19 - Sept19 Diff = 20157
  • Sept19 - Mar20 Diff = 20158
  • Mar20 - Sept20 Diff = 24598
  • Sept20 - Mar21 Diff = 29796
  • Mar21 - Sept21 Diff = 22582
  • Sept21 - Mar22 Diff = 25561 
  • Mar22 - Sept22 Diff = 20619 US changes 
  • Sept22 - Mar23 Diff = 40733 US changes 
  • Mar23 - Sept23 Diff = 52623 US changes 

So roughly the right amount given the previous number of changes

HOWEVER, PRETTY CLOSE TO WHAT WAS EXPECTED BY WCI - as per the report they sent with the Map files ("Icd10cmstats.txt"):

  • TOTAL ADDED/UPDATED = Total Changed mapped entries (modified) this release + Total Changed mapped entries (new) this release + Total New mapped entries this release 
                  • = 13938 + 22204 + 6144
                  • = 42,286
  • TOTAL INACTIVATED         = Total Changed mapped entries (retired) this release + Total Retired mapped entries this release
                  • = 7766 + 2377
                  • = 10,143

SEND TO JULIA and KIN WAH TO VERIFY ONCE HAVE FINAL VERSION

Just need confirmation from the US in Pre-Prod validation stage...

ModuleDependency files

n/a

ALL 8 records updated with latest effectiveTimes, as expected.

Association files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

5336 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

1750 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus


US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

96 records added/updated plus

2 inactivated

  • As confirmed by the Summary Component Stats Report above

US Edition specific changes are related to ...

  • Sept18 - Mar19 Diff = 63 US changes
  • Mar19 - Sept19 Diff = 11 US changes
  • Sept19 - Mar20 Diff = 21 US changes
  • Mar20 - Sept20 Diff = 22 US changes
  • Sept20 - Mar21 Diff = 66 US changes
  • Mar21 - Sept21 Diff = 83 + 0 = 83 US changes
  • Sept21 - Mar22 Diff = 91 US changes 
  • Mar22 - Sept22 Diff = 51 + 1 = 83 US changes

Just need confirmation from the US in Pre-Prod validation stage...

Attribute Value files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

16634 records added/updated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

318 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

434 records added/updated plus

1 inactivated

This is only ???????? changes more than the International Edition - therefore the US specific changes are....

  • Sept18 - Mar19 Diff = 214 US changes
  • Mar19 - Sept19 Diff = 64 US changes
  • Sept19 - Mar20 Diff = 84 US changes
  • Mar20 - Sept20 Diff = 28 US changes
  • Sept20 - Mar21 Diff = 398 US changes
  • Mar21 - Sept21 Diff = 380 + 2 = 382 US changes
  • Sept21 - Mar22 Diff = 524 US changes 
  • Mar22 - Sept22 Diff = 188 + 1 = 382 US changes
  • Mar23 - Sept23 Diff = 399 + 1 = 400 US changes

Roughly the expected figure then, when compared to previous cycles, plus confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage... 

RefsetDescriptor files


US EDITION EFFECTIVETIME 20230901:

0 records changed

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

0 new records added, as expected???????

Language files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

38652 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

5128 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

533 records added/updated plus

129 inactivated

  • As confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage...

Readme file
n/a

Updated to reflect new EffectiveTime as expected + x prefixes added for Pre-Production

SimpleMap files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

???? records inactivated, plus

???? records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!

US EDITION EFFECTIVETIME 20230901:

0 records changed

###### no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! ######

Therefore IS this the expected result???  As we never expect to have US specific changes in this file!

Simple refset files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

???? records inactivated, plus

???? records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

0 records added +

144 records inactivated - as planned for the deprecation of the ROA refset:

      • 442311000124105 |Route of administration reference set (foundation metadata concept)|


  • ###### no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! ######

    Therefore IS this the expected result???  As we never expect to have US specific changes in this file!

Concept files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

6530 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

2869 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

163 records added/updated plus

76 inactivated

  • As confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage...

Description files



INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

18601 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

2566 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

451 records added/updated plus

127 inactivated

  • EXACTLY AS EXPECTED by the Summary Component Stats Report above  


Identifier File0

New format incorporated (after latest SCT Code release on 2/8/2023) as expected - see ISRS-1563:

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

2x Archive Structural RVF tests that were previously failing are now also passing, as expected from version 4 of PreProd onwards:

"testCategory": "xsct2_Identifier_Snapshot_AT1000234_20230815.txt","testType": "ARCHIVE_STRUCTURAL","assertionText": "RF2 Structural test failed",

"testCategory": "xsct2_Identifier_Full_AT1000234_20230815.txt","testType": "ARCHIVE_STRUCTURAL","assertionText": "RF2 Structural test failed",

Stated Relationship files

0 changes as expected! (same as International Edition as well)

Relationship files




INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

44093 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

29391 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

1421 records added plus

4020 inactivated

  • EXACTLY AS EXPECTED by the Summary Component Stats Report above


Relationship Concrete Values files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

657 records updated, plus as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above

56 records inactivated  as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above

...exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (January 2022)

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

0 records changed

Therefore there are no US specific changes this cycle, as confirmed in the Summary Component Stats report above

  • As confirmed by the Summary Component Stats Report above
OwlExpression files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

12721 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

2875 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

277 records added/updated plus

78 inactivated

  • As confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage...

TextDefinition files
n/a

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

623 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

149 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

9 records added/updated plus

2 inactivated

  • As confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage...

MRCMAttributeDomain files

US EDITION EFFECTIVETIME 20230901:

0 records updated

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

0 new records added, BUT THERE SHOULD HAVE BEEN IN ORDER TO MATCH exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (July 2022)

Confirmed this US Edition is based on the JUNE 2022 INT Edition and NOT the July 2022 INT Edition, and therefore there were no MRCM changes between Feb + June 2022 monthly releases, so zero MRCM changes in this Sept 2022 US Edition is as expected


MRCMAttributeRange files
n/a

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

7 records updated, plus

0 records inactivated, plus

0 new records added,

AS EXPECTED exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (June 2023) + International Edition Traceability matrix (February 2023)

Confirmed this US Edition is based on the JUNE 2022 INT Edition and NOT the July 2022 INT Edition, and therefore there were no MRCM changes between Feb + June 2022 monthly releases, so zero MRCM changes in this Sept 2022 US Edition is as expected

US EDITION EFFECTIVETIME 20230901:

0 records changed

Therefore there are no US specific changes tis cycle

MRCMDomain files
n/a 

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

4 records updated, plus

0 records inactivated, plus

0 new records added, 

AS EXPECTED exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (June 2023) + International Edition Traceability matrix (February 2023)

Confirmed this US Edition is based on the JUNE 2022 INT Edition and NOT the July 2022 INT Edition, and therefore there were no MRCM changes between Feb + June 2022 monthly releases, so zero MRCM changes in this Sept 2022 US Edition is as expected

US EDITION EFFECTIVETIME 20230901:

0 records changed

Therefore there are no US specific changes this cycle ??????????

Transitive Closure file

MOVED TO ITS OWN TRANSITIVE CLOSURE PACKAGE - WILL RUN COMPARISONS ON PAGE:


tls_Icd10cmHumanReadableMap_

US1000124_20170901.tsv



MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10cmMapTechnicalSpecifications_Current-en-US_US1000124_20170901.pdf



MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10cmMapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx



MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10cmMapReleaseNotes_Current-en-US_US1000124_20170901.pdf



MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


doc_Icd10MapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx



MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:



March 2023 (PUBLISHED) vs September 2023 Pre-Production (Version 3) traceability

Summary Component Stats report (US 20230301 - 20230901):  https://docs.google.com/spreadsheets/d/1NEzzhHaOTjq1b97AeZvGjeIz07czLCXWB2f4z39YBuw/edit#gid=0

Summary Component Stats report (INT 20221231 - 20230630): https://docs.google.com/spreadsheets/d/1QfyE9Dys2tAnQXi7CDz9zvNGXXo_d5zIlivcCUpHDug/edit#gid=3

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
Association files10

ISRS-1601

US EDITION EFFECTIVETIME 20230901:

10 new records added (with SAME AS linked to the replacement INT Concept as Maria recommended in the ticket ISRS-1601), for the 10 Concepts John inactivated to fix ISRS-1601:

> 01110e39-4680-4caa-a54c-799280bd00b5    20230901    1    731000124108    900000000000527005    457711000124107    40861000146101
> 0d255bf7-4f83-4a80-ba7e-68ea04df53da    20230901    1    731000124108    900000000000527005    434321000124107    1259630004
> 37286c86-74e0-4d39-98c9-3fae1019e904    20230901    1    731000124108    900000000000527005    541391000124101    841000181104
> 56eed7e5-dd4c-4d75-a080-bb172b31278c    20230901    1    731000124108    900000000000527005    11800811000119100    1269058008
> a08800ec-c077-4b2c-b3b2-6d3739fa2717    20230901    1    731000124108    900000000000527005    541381000124104    1263678007
> ad77ae63-025a-44a4-b85f-5e9634ebeaf2    20230901    1    731000124108    900000000000527005    620961000124106    135331000146104
> b1fc55dc-54a9-4f89-af32-8f3ca4961f14    20230901    1    731000124108    900000000000527005    447751000124105    146921000146105
> d19775b6-bb6e-4ff2-9aa5-a41a644bea83    20230901    1    731000124108    900000000000527005    611631000124108    68191000052106
> e1dcf0bb-aa3e-480b-82c1-5f9f5a016564    20230901    1    731000124108    900000000000527005    449321000124109    1284801004
> f8db3923-9b29-45f5-a0d8-dec72a49dedf    20230901    1    731000124108    900000000000527005    443971000124108    1284968009

Attribute Value files35


US EDITION EFFECTIVETIME 20230901:

35 new records added + 2 removed

10 of them were for the Concepts that were inactivated in the ticket ISRS-1601 

The remaining 25 were for ...

The 2 removed were for the fixes in ISRS-1604


Language files2


US EDITION EFFECTIVETIME 20230901:

1 new records added + 1 inactivated:

  • > 1a35732a-c154-4997-accf-b2726e891b9a    20230901    1    731000124108    900000000000509007    1422581000124112    900000000000548007
  • < b2b227a3-8b0d-4cf8-91fb-1b92301574cc    20220901    1    731000124108    900000000000509007    1138161000124114    900000000000548007
    > b2b227a3-8b0d-4cf8-91fb-1b92301574cc    20230901    0    731000124108    900000000000509007    1138161000124114    900000000000548007
ExtendedMap files

ISRS-1609

US EDITION EFFECTIVETIME 20230901:

173,468 records removed, but THEN OUT OF THAT

31,300 records inactivated, +

94,590 records added/updated, LEAVING

47,578 removed completely

as a result of the up-propagation fixes in ISRS-1609

WILL THEREFORE NEED TO COMPARE TO ORIGINAL MARCH 2023 MAP FILES TO ENSURE THIS NOW LOOKS GOOD, AS TOO MUCH OF A MESS WHEN COMPARED TO COMPLETELY BROKEN MAP FILES FROM VERSION 3 of the SEPT 2023 PREPROD RELEASE!!

Concept files10


US EDITION EFFECTIVETIME 20230901:

10 CONCEPTS inactivated, as a result of the fixes in ISRS-1601:

  • < 11800811000119100    20180901    1    731000124108    900000000000073002
    > 11800811000119100    20230901    0    731000124108    900000000000074008
  • < 434321000124107    20130301    1    731000124108    900000000000074008
    > 434321000124107    20230901    0    731000124108    900000000000074008
  • < 443971000124108    20140901    1    731000124108    900000000000074008
    > 443971000124108    20230901    0    731000124108    900000000000074008
  • < 447751000124105    20150901    1    731000124108    900000000000074008
    > 447751000124105    20230901    0    731000124108    900000000000074008
  • < 449321000124109    20150901    1    731000124108    900000000000074008
    > 449321000124109    20230901    0    731000124108    900000000000074008
  • < 457711000124107    20180901    1    731000124108    900000000000074008
    > 457711000124107    20230901    0    731000124108    900000000000074008
  • < 541381000124104    20220301    1    731000124108    900000000000074008
    > 541381000124104    20230901    0    731000124108    900000000000074008
  • < 541391000124101    20220301    1    731000124108    900000000000074008
    > 541391000124101    20230901    0    731000124108    900000000000074008
  • < 611631000124108    20220901    1    731000124108    900000000000074008
    > 611631000124108    20230901    0    731000124108    900000000000074008
  • < 620961000124106    20220901    1    731000124108    900000000000074008
    > 620961000124106    20230901    0    731000124108    900000000000074008

Identifier File0

New format incorporated (after latest SCT Code release on 2/8/2023) as expected - see ISRS-1563:

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

2x Archive Structural RVF tests that were previously failing are now also passing, as expected from version 4 of PreProd onwards:

"testCategory": "xsct2_Identifier_Snapshot_AT1000234_20230815.txt","testType": "ARCHIVE_STRUCTURAL","assertionText": "RF2 Structural test failed",

"testCategory": "xsct2_Identifier_Full_AT1000234_20230815.txt","testType": "ARCHIVE_STRUCTURAL","assertionText": "RF2 Structural test failed",

Inferred Relationship files45


US EDITION EFFECTIVETIME 20230901:

30 records inactivated, +

12 records added/updated, AND

3 records removed COMPLETELY

The Inactivated records were for the Concepts that were inactivated in the ticket ISRS-1601 

The new/updated records were for....

OWL Axiom files14


US EDITION EFFECTIVETIME 20230901:

10 records inactivated, +

4 records added/updated, AND

The Inactivated records were for the Concepts that were inactivated in the ticket ISRS-1601 

The new/updated records were for....

TextDefinition files2


US EDITION EFFECTIVETIME 20230901:

1 records inactivated, +

1 records added/updated, AND

The Inactivated record was for the Concepts that were inactivated in the ticket ISRS-1601 

The new record was for....



March 2023 (PUBLISHED) vs September 2023 Pre-Production (Version 3) traceability

Summary Component Stats report (US 20230301 - 20230901):  https://docs.google.com/spreadsheets/d/1NEzzhHaOTjq1b97AeZvGjeIz07czLCXWB2f4z39YBuw/edit#gid=0

Summary Component Stats report (INT 20221231 - 20230630): https://docs.google.com/spreadsheets/d/1QfyE9Dys2tAnQXi7CDz9zvNGXXo_d5zIlivcCUpHDug/edit#gid=3

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
ExtendedMap files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for ICD-10 (INT) - "1    449080006", then copy/paste

ExtendedMap files23692

INTERNATIONAL EFFECTIVETIME 20220630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for ICD-10 (INT) - "1    449080006", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active ICD-10CM records that were REMOVED this release in your count!!)

Next need to search diff file for ICD-10 (INT) - "0    449080006", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive ICD-10CM records that were REMOVED this release in your count!!)

2177 records added/updated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

830 records inactivated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

#################################################################################################################

SO MAYBE DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the MAP files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!!

#################################################################################################################

US EDITION EFFECTIVETIME 20220901 - for ICD-10-CM (5991000124107) map:

Info
titleGetting accurate manual counts:

First need to search diff file for ICD-10CM (US) - "1    5991000124107", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active ICD-10CM records that were REMOVED this release in your count!!)

Next need to search diff file for ICD-10CM (US) - "0    5991000124107", then copy/paste

results into a separate txt file, THEN search that new file for "> " to get

final number of added/updated (as otherwise you include the inactive ICD-10CM records that were REMOVED this release in your count!!)

14197 records added/updated

6422 records inactivated

????Need to verify this with WCI + Kin Wah.... Kin Wah confirmed they don't keep logs!

  • Sept18 - Mar19 Diff = 36,100
  • Mar19 - Sept19 Diff = 20157
  • Sept19 - Mar20 Diff = 20158
  • Mar20 - Sept20 Diff = 24598
  • Sept20 - Mar21 Diff = 29796
  • Mar21 - Sept21 Diff = 22582
  • Sept21 - Mar22 Diff = 25561 
  • Mar22 - Sept22 Diff = 20619 US changes 

So roughly the right amount given the previous number of changes

SEND TO JULIA and KIN WAH TO VERIFY ONCE HAVE FINAL VERSION

Just need confirmation from the US in Pre-Prod validation stage...

ModuleDependency filesALL

n/a

2 extra records than normal added by Automated process!  Calling out dependencies of ICD-10CM module on 2x core modules?????????

> e37cecd9-329a-4bf2-96eb-befefd9c45c3    20220901    1    5991000124107    900000000000534007    900000000000207008    20220901    20220630

> 5b163b38-a5e6-4430-aaaa-82663c4bca4a    20220901    1    5991000124107    900000000000534007    900000000000012004    20220901    20220630

NO US CONTENT YET!!!

6 records updated with latest effectiveTimes, as expected:

< 1244116f-fdb5-5645-afcc-5281288409da    20220131    1    900000000000207008    900000000000534007    900000000000012004    20220131    20220131
< 53773521-fd81-5dde-9a2d-8b87e8803251    20220301    1    5991000124107    900000000000534007    731000124108    20220301    20220301
< 686fe392-d2f7-586d-98aa-078aba426832    20220131    1    449080006    900000000000534007    900000000000207008    20220131    20220131
< 70edb2ac-8a7a-5a94-b385-f8ad80db3858    20220301    1    731000124108    900000000000534007    900000000000012004    20220301    20220131
< 71ae8ceb-7984-550c-b1f5-9a69681b383a    20220301    1    731000124108    900000000000534007    900000000000207008    20220301    20220131
< f6431457-161b-5b46-9217-573c20c00070    20220131    1    449080006    900000000000534007    900000000000012004    20220131    20220131
---
> 1244116f-fdb5-5645-afcc-5281288409da    20220630    1    900000000000207008    900000000000534007    900000000000012004    20220630    20220630
> 53773521-fd81-5dde-9a2d-8b87e8803251    20220901    1    5991000124107    900000000000534007    731000124108    20220901    20220901
> 686fe392-d2f7-586d-98aa-078aba426832    20220630    1    449080006    900000000000534007    900000000000207008    20220630    20220630
> 70edb2ac-8a7a-5a94-b385-f8ad80db3858    20220901    1    731000124108    900000000000534007    900000000000012004    20220901    20220630
> 71ae8ceb-7984-550c-b1f5-9a69681b383a    20220901    1    731000124108    900000000000534007    900000000000207008    20220901    20220630
> f6431457-161b-5b46-9217-573c20c00070    20220630    1    449080006    900000000000534007    900000000000012004    20220630    20220630

final number of added/updated (as otherwise you include the active ICD-10CM records that were REMOVED this release in your count!!)

Next need to search diff file for ICD-10 (INT) - "0    449080006", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive ICD-10CM records that were REMOVED this release in your count!!)

3829 records added/updated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

2061 records inactivated  (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

##########################################################################################################

DON'T BOTHER TOTALLING UP THE INT EDITION COUNTS for the MAP files AS NOTHING TO COMPARE AGAINST, SO JUST WASTED TIME?!!!!

##########################################################################################################


US EDITION EFFECTIVETIME 20230901 - for ICD-10-CM (5991000124107) map:

Info
titleGetting accurate manual counts:

First need to search diff file for ICD-10CM (US) - "1    5991000124107", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active ICD-10CM records that were REMOVED this release in your count!!)

Next need to search diff file for ICD-10CM (US) - "0    5991000124107", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive ICD-10CM records that were REMOVED this release in your count!!)

110,459 records added/updated

84,353 records inactivated

????Need to verify this with WCI + Kin Wah.... Kin Wah confirmed they don't keep logs!

  • Sept18 - Mar19 Diff = 36,100
  • Mar19 - Sept19 Diff = 20157
  • Sept19 - Mar20 Diff = 20158
  • Mar20 - Sept20 Diff = 24598
  • Sept20 - Mar21 Diff = 29796
  • Mar21 - Sept21 Diff = 22582
  • Sept21 - Mar22 Diff = 25561 
  • Mar22 - Sept22 Diff = 20619 US changes 
  • Sept22 - Mar23 Diff = 40733 US changes 
  • Mar23 - Sept23 Diff = 194812 US changes 

So NOT roughly the right amount given the previous number of changes

HOWEVER, PRETTY CLOSE TO WHAT WAS EXPECTED BY WCI - as per the report they sent with the Map files ("Icd10cmstats.txt"):

  • = Total Changed mapped entries (modified) this release + Total Changed mapped entries (new) this release + Total Changed mapped entries (retired) this release + Total New mapped entries this release + Total Retired mapped entries this release
  • = 7849 + 96365 + 81927 + 6144 + 2377
  • = 194662

SEND TO JULIA and KIN WAH TO VERIFY ONCE HAVE FINAL VERSION

Just need confirmation from the US in Pre-Prod validation stage...

ModuleDependency files

n/a

ALL 8 records updated with latest effectiveTimes, as expected.

Association files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!)

Association files4794

INTERNATIONAL EFFECTIVETIME 20220630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

1377 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), plus

3365 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above)

US EDITION EFFECTIVETIME 20220901

:

Info
titleGetting accurate manual counts:

First need to search diff file for

US

INT active - "1  

 731000124108

 900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active

US

INT records that were REMOVED this release in your count!!)

Next need to search diff file for

US

INT inactive - "0  

 731000124108

 900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive

US

INT records that were REMOVED this release in your

count!!)

51 records added/updated plus

1 inactivated

  • As confirmed by the Summary Component Stats Report above

US Edition specific changes are related to ...

  • Sept18 - Mar19 Diff = 63 US changes
  • Mar19 - Sept19 Diff = 11 US changes
  • Sept19 - Mar20 Diff = 21 US changes
  • Mar20 - Sept20 Diff = 22 US changes
  • Sept20 - Mar21 Diff = 66 US changes
  • Mar21 - Sept21 Diff = 83 + 0 = 83 US changes
  • Sept21 - Mar22 Diff = 91 US changes 
  • Mar22 - Sept22 Diff = 51 + 1 = 83 US changes

Just need confirmation from the US in Pre-Prod validation stage...

count!!)

5336 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

1750 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus


US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108

Attribute Value files10932

INTERNATIONAL EFFECTIVETIME 20220630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:
First need to search diff file for INT active - "1    900000000000207008

", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of

added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

907 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), plus

9836 records added/updated (no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

US EDITION EFFECTIVETIME 20220901

added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

96 records added/updated plus

2 inactivated

  • As confirmed by the Summary Component Stats Report above

US Edition specific changes are related to ...

  • Sept18 - Mar19 Diff = 63 US changes
  • Mar19 - Sept19 Diff = 11 US changes
  • Sept19 - Mar20 Diff = 21 US changes
  • Mar20 - Sept20 Diff = 22 US changes
  • Sept20 - Mar21 Diff = 66 US changes
  • Mar21 - Sept21 Diff = 83 + 0 = 83 US changes
  • Sept21 - Mar22 Diff = 91 US changes 
  • Mar22 - Sept22 Diff = 51 + 1 = 83 US changes

Just need confirmation from the US in Pre-Prod validation stage...

Attribute Value files

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for

US

INT active - "1  

 731000124108

 900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active

US

INT records that were REMOVED this release in your count!!)

Next need to search diff file for

US

INT inactive - "0  

 731000124108

 900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive

US

INT records that were REMOVED this release in your count!!)

188

16632 records added/updated

plus

1 inactivated

This is only ???????? changes more than the International Edition - therefore the US specific changes are....

  • Sept18 - Mar19 Diff = 214 US changes
  • Mar19 - Sept19 Diff = 64 US changes
  • Sept19 - Mar20 Diff = 84 US changes
  • Mar20 - Sept20 Diff = 28 US changes
  • Sept20 - Mar21 Diff = 398 US changes
  • Mar21 - Sept21 Diff = 380 + 2 = 382 US changes
  • Sept21 - Mar22 Diff = 524 US changes 
  • Mar22 - Sept22 Diff = 188 + 1 = 382 US changes

Roughly the expected figure then, when compared to previous cycles, plus confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage... 

RefsetDescriptor files2

US EDITION EFFECTIVETIME 20220901:

0 records changed

INTERNATIONAL EFFECTIVETIME 20220630 (or any of interim Monthly releases!):

1 new records added, as expected due to new ???????

  • > a3e46ae7-0da5-461e-8e33-913cd6ae4d20    20220228    1    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000461009    1

Plus 1 inactivations:

  • < 48a3c317-795d-4d45-8cab-0cf385849422    20220131    1    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000465000    1
    > 48a3c317-795d-4d45-8cab-0cf385849422    20220228    0    900000000000012004    900000000000456007    1193544002    900000000000505001    900000000000465000    1

***** ????????FYI THESE RECORD MATCH THE FINAL PRODUCTION INTERNATIONAL EDITION RELEASE DELTA FILE - THE UUID'S AND EVERYTHING MATCH EXACTLY AS EXPECTED - THIS MEANS THAT SUBSEQUENT US EDITION RELEASE PACKAGES WOULD ***NOT*** BE EXPECTED TO HAVE THE UUID'S REFRESHED ANY MORE DURING THIS CYCLE!

(no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!)

318 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

US EDITION EFFECTIVETIME 20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

401 records added/updated plus

1 inactivated

This is only ???????? changes more than the International Edition - therefore the US specific changes are....

  • Sept18 - Mar19 Diff = 214 US changes
  • Mar19 - Sept19 Diff = 64 US changes
  • Sept19 - Mar20 Diff = 84 US changes
  • Mar20 - Sept20 Diff = 28 US changes
  • Sept20 - Mar21 Diff = 398 US changes
  • Mar21 - Sept21 Diff = 380 + 2 = 382 US changes
  • Sept21 - Mar22 Diff = 524 US changes 
  • Mar22 - Sept22 Diff = 188 + 1 = 382 US changes

Roughly the expected figure then, when compared to previous cycles, plus confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage... 

RefsetDescriptor files


US EDITION EFFECTIVETIME 20230901:

0 records changed

INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!):

0 new records added, as expected???????

Readme file
n/a

Updated to reflect new EffectiveTime as expected + x prefixes added for Pre-Production

SimpleMap files
4432


INTERNATIONAL EFFECTIVETIME

20220630

20230630 (or any of interim Monthly releases!):

0

???? records inactivated, plus

4432

???? records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!

US EDITION EFFECTIVETIME

20220901

20230901:

0 records changed

###### no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! ######

Therefore IS this the expected result???  As we never expect to have US specific changes in this file!

Simple refset files
444


INTERNATIONAL EFFECTIVETIME

20220630

20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

23

???? records inactivated, plus

421

???? records added no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases!

US EDITION EFFECTIVETIME

20220901

20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records

that were REMOVED this release in your count!!)

0 records changed

that were REMOVED this release in your count!!)

0 records added +

144 records inactivated - as planned for the deprecation of the ROA refset:

      • 442311000124105 |Route of administration reference set (foundation metadata concept)|


  • ###### no longer able to validate this against the International Edition as would need to manually total up 6 months' of monthly releases! ######

    Therefore IS this the expected result???  As we never expect to have US specific changes in this file!

Concept files
7894


INTERNATIONAL EFFECTIVETIME

20220630

20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

1480

6530 records

inactivated

added/updated (as confirmed in new INT only Component Stats Report run by devops from INT

20220131

20221231 -

20220630

20230630 - see above)

, plus

5706

2869 records

added/updated

inactivated (as confirmed in new INT only Component Stats Report run by devops from INT

20220131

20221231 -

20220630

20230630 - see above), plus

US EDITION EFFECTIVETIME

20220901

20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

662

163 records added/updated plus

46

66 inactivated

  • As confirmed by the Summary Component Stats Report above

Just need confirmation from the US in Pre-Prod validation stage...

Description files
21030



INTERNATIONAL EFFECTIVETIME

20220630

20230630 (or any of interim Monthly releases!):

Info
titleGetting accurate manual counts:

First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

2614

18600 records

inactivated

added/updated (as confirmed in new INT only Component Stats Report run by devops from INT

20220131

20221231 -

20220630

20230630 - see above)

, plus

17341

2565 records

added/updated

inactivated (as confirmed in new INT only Component Stats Report run by devops from INT

20220131

20221231 -

20220630

20230630 - see above), plus

US EDITION EFFECTIVETIME

20220901

20230901:

Info
titleGetting accurate manual counts:

First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

1040

451 records added/updated plus

31

127 inactivated

  • EXACTLY AS EXPECTED by the Summary
Component Stats Report above  
  • Component Stats Report above  


Stated Relationship files

0 changes as expected! (same as International Edition as well)

Relationship files




INTERNATIONAL EFFECTIVETIME 20230630

  • This reports 1040 added/updated + 31 inactivated...
  • OwlExpression files14673INTERNATIONAL EFFECTIVETIME 20220630

    (or any of interim Monthly releases!):

    Info
    titleGetting accurate manual counts:

    First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

    First need to search diff file for INT active - "1    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

    Next need to search diff file for INT inactive - "0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

    Next need to search diff file for INT inactive - "0    900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

    1487

    43909 records

    inactivated

    added/updated (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131

    20221231 -

    20220630

    20230630 - see above)

    , plus

    11894

    28929 records

    added/updated

    inactivated (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131

    20221231 -

    20220630

    20230630 - see above), plus

    US EDITION EFFECTIVETIME

    20220901

    20230901:

    Info
    titleGetting accurate manual counts:

    First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

    Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

    1244

    1416 records added

    /updated

    plus

    48

    3991 inactivated

    As confirmed
    • EXACTLY AS EXPECTED by the Summary Component Stats Report above

    Just need confirmation from the US in Pre-Prod validation stage...

    Stated Relationship files0

    0 changes as expected! (same as International Edition as well)

    Relationship files80490


    Relationship Concrete Values files

    INTERNATIONAL EFFECTIVETIME

    20220630

    20230630 (or any of interim Monthly releases!):

    Info
    titleGetting accurate manual counts:

    First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

    First

    Next need to search diff file for INT

    active

    inactive - "

    1

    0  

     900000000000012004

     900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number

    of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)Next

    of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

    657 records updated, plus as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above

    56 records inactivated  as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above

    ...exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (January 2022)

    US EDITION EFFECTIVETIME 20230901:

    Info
    titleGetting accurate manual counts:

    First need to search diff file for

    INT inactive

    US active - "

    0

    1  

     900000000000207008

     731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    inactive INT

    active US records that were REMOVED this release in your count!!)

    Next need to search diff file for

    INT

    US inactive - "0  

     900000000000012004

     731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive

    INT

    US records that were REMOVED this release in your count!!)

    27688 records inactivated (

    0 records changed

    Therefore there are no US specific changes this cycle, as confirmed in

    new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above

    the Summary Component Stats report above

    • As confirmed by the Summary Component Stats Report above
    OwlExpression files

    INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!)

    ), plus

    45182 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above)

    US EDITION EFFECTIVETIME 20220901

    :

    Info
    titleGetting accurate manual counts:

    First need to search diff file for

    US

    INT active - "1  

     731000124108

     900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active

    US

    INT records that were REMOVED this release in your count!!)

    Next

    First need to search diff file for

    US inactive

    INT active - "

    0

    1  

     731000124108

     900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    inactive US

    active INT records that were REMOVED this release in your count!!)

    3894 records added plus

    3726 inactivated

    • EXACTLY AS EXPECTED by the Summary Component Stats Report above
    Relationship Concrete Values files2551

    INTERNATIONAL EFFECTIVETIME 20220630 (or any of interim Monthly releases!):

    Next

    Info
    titleGetting accurate manual counts:
    First

    need to search diff file for INT

    active

    inactive - "

    1

    0    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    active

    inactive INT records that were REMOVED this release in your count!!)

    Next need to search diff file for INT inactive - "0  

     900000000000207008

     900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

    2165

    12717 records added/updated

    , plus

    (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131

    20221231 -

    20220630

    20230630 - see above)

    386

    2875 records inactivated

     

    (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131

    20221231 -

    20220630

    20230630 - see above

    ...exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (January 2022)

    ), plus

    US EDITION EFFECTIVETIME

    20220901

    20230901:

    Info
    titleGetting accurate manual counts:

    First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

    Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

    0 records changed

    Therefore there are no US specific changes this cycle, as confirmed in

    273 records added/updated plus

    68 inactivated

    • As confirmed by the Summary Component Stats
    report
    • Report above
    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the US in Pre-Prod validation stage...

    Language files

    INTERNATIONAL EFFECTIVETIME 20230630

    TextDefinition files700n/aINTERNATIONAL EFFECTIVETIME 20220630

    (or any of interim Monthly releases!):

    Info
    titleGetting accurate manual counts:

    First need to search diff file for INT active - "1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active INT records that were REMOVED this release in your count!!)

    Next

    First need to search diff file for INT

    inactive

    active - "

    0

    1  

     900000000000207008

     900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    inactive Info
    titleGetting accurate manual counts:
    First

    active INT records that were REMOVED this release in your count!!)

    35 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), plus

    646 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above)

    US EDITION EFFECTIVETIME 20220901:

    Next need to search diff file for

    US active

    INT inactive - "

    1

    0  

     731000124108

     900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    active US

    inactive INT records that were REMOVED this release in your count!!)

    Next need to search diff file for

    US

    INT inactive - "0  

     731000124108

     900000000000012004", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive

    US

    INT records that were REMOVED this release in your count!!)

    19

    38652 records added/updated

    plus

    (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

    5128 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above), plus

    US EDITION EFFECTIVETIME 20230901

    0 inactivated

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the US in Pre-Prod validation stage...

    Language files42846INTERNATIONAL EFFECTIVETIME 20220630 (or any of interim Monthly releases!)

    :

    Info
    titleGetting accurate manual counts:

    First need to search diff file for

    INT

    US active - "1  

     900000000000207008

     731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active

    INT

    US records that were REMOVED this release in your count!!)

    First

    Next need to search diff file for

    INT active

    US inactive - "

    1

    0  

     900000000000012004

     731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    active INT

    inactive US records that were REMOVED this release in your count!!)

    532 records added/updated plus

    128 inactivated

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the US in Pre-Prod validation stage...

    TextDefinition files
    n/a

    INTERNATIONAL EFFECTIVETIME 20230630 (or any of interim Monthly releases!)

    Next

    :

    Info
    titleGetting accurate manual counts:

    First need to search diff file for INT

    inactive

    active - "

    0

    1    900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the

    inactive

    active INT records that were REMOVED this release in your count!!)

    Next need to search diff file for INT inactive - "0  

     900000000000012004

     900000000000207008", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive INT records that were REMOVED this release in your count!!)

    5159

    617 records

    inactivated

    added/updated (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131

    20221231 -

    20220630

    20230630 - see above)

    , plus

    36493

    149 records

    added/updated

    inactivated (as confirmed in new INT only Component Stats Report run by devops from INT

    20220131

    20221231 -

    20220630

    20230630 - see above), plus

    US EDITION EFFECTIVETIME

    20220901

    20230901:

    Info
    titleGetting accurate manual counts:

    First need to search diff file for US active - "1    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the active US records that were REMOVED this release in your count!!)

    Next need to search diff file for US inactive - "0    731000124108", then copy/paste results into a separate txt file, THEN search that new file for "> " to get final number of added/updated (as otherwise you include the inactive US records that were REMOVED this release in your count!!)

    1150

    8 records added/updated plus

    44

    1 inactivated

    • As confirmed by the Summary Component Stats Report above

    Just need confirmation from the US in Pre-Prod validation stage...

    MRCMAttributeDomain files
    0


    US EDITION EFFECTIVETIME

    20220901

    20230901:

    0 records updated

    INTERNATIONAL EFFECTIVETIME

    20220630

    20230630 (or any of interim Monthly releases!):

    0 new records added, BUT THERE SHOULD HAVE BEEN IN ORDER TO MATCH exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (July 2022)

    Confirmed this US Edition is based on the JUNE 2022 INT Edition and NOT the July 2022 INT Edition, and therefore there were no MRCM changes between Feb + June 2022 monthly releases, so zero MRCM changes in this Sept 2022 US Edition is as expected


    MRCMAttributeRange files
    0

    n/a

    INTERNATIONAL EFFECTIVETIME

    20220630

    20230630 (or any of interim Monthly releases!):

    0records

    7 records updated, plus

    0 records inactivated, plus

    0 new records added,

    BUT THERE SHOULD HAVE BEEN IN ORDER TO MATCH

    AS EXPECTED exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (June 2023) + International Edition Traceability matrix (

    July 2022

    February 2023)

    Confirmed this US Edition is based on the JUNE 2022 INT Edition and NOT the July 2022 INT Edition, and therefore there were no MRCM changes between Feb + June 2022 monthly releases, so zero MRCM changes in this Sept 2022 US Edition is as expected

    US EDITION EFFECTIVETIME

    20220901

    20230901:

    0 records changed

    Therefore there are no US specific changes tis cycle

    MRCMDomain files
    0

    n/a 

    INTERNATIONAL EFFECTIVETIME

    20220630

    20230630 (or any of interim Monthly releases!):

    4 records updated, plus

    0 records inactivated, plus

    0 new records added,

    BUT THERE SHOULD HAVE BEEN IN ORDER TO MATCH

     

    AS EXPECTED exactly the same as with the International editing cycle.  See here for confirmation:  International Edition Traceability matrix (

    July 2022

    June 2023) + International Edition Traceability matrix (February 2023)

    Confirmed this US Edition is based on the JUNE 2022 INT Edition and NOT the July 2022 INT Edition, and therefore there were no MRCM changes between Feb + June 2022 monthly releases, so zero MRCM changes in this Sept 2022 US Edition is as expected

    US EDITION EFFECTIVETIME

    20220901

    20230901:

    0 records changed

    Therefore there are no US specific changes this cycle ??????????

    Transitive Closure file
    0


    MOVED TO ITS OWN TRANSITIVE CLOSURE PACKAGE - WILL RUN COMPARISONS ON PAGE:


    tls_Icd10cmHumanReadableMap_

    US1000124_20170901.tsv

    0


    MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


    doc_Icd10cmMapTechnicalSpecifications_Current-en-US_US1000124_20170901.pdf

    0


    MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


    doc_Icd10cmMapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx

    0


    MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


    doc_Icd10cmMapReleaseNotes_Current-en-US_US1000124_20170901.pdf

    0



    MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE:


    doc_Icd10MapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx

    0



    MOVED TO ITS OWN ICD-10-CM RESOURCES PACKAGE - WILL RUN COMPARISONS ON PAGE: