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

16632 401 SimpleMap

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!

900000000000207008

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

First need to search diff file for US active - "1 731000124108 active US 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 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)| of monthly releases! ######

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

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

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 inactive 0 inactive 900000000000012004

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

Differences found in package Comparison

Number of RF2 records impacted

Related JIRA ticket(s)

Rationale

ExtendedMap files

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

Info

title	Getting 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!!)

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

title	Getting 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!):

Info

title	Getting 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

title	Getting 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

title	Getting 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

title	Getting 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

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

Language files

Simple refset files

Info

title	Getting accurate manual counts:

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

Info

title	Getting 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!!)

Info

title	Getting accurate manual counts:

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

title	Getting 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'

Concept files

Info

title	Getting accurate manual counts:

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

title	Getting 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

title	Getting 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 !!)

163 records added/updated plus

66 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

title	Getting 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!!)

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

2565 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

title	Getting 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 163 records added/updated plus

127 66 inactivated

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

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

Description

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

title	Getting 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!!)

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

28929 2565 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

title	Getting 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!!)

1416 451 records added/updated plus

3991 127 inactivated

EXACTLY AS EXPECTED by the Summary Component Stats Report aboveabove

Stated Relationship Concrete Values files

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

Relationship files

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

Info

title	Getting accurate manual counts:

First

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

Info

title	Getting accurate manual counts:

Info

title	Getting 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 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!!)

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:

in your count!!)

First need to search diff file for US INT active - "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 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!!)

Next need to search diff file for INT inactive - "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

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

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

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

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

Info

title	Getting 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!!)!!)

1416 records added plus

3991 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

title	Getting accurate manual counts:

First Next 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!!)

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

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

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

US EDITION EFFECTIVETIME 20230901:

Info

title	Getting 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!!)

273 records added/updated plus

0 records changed

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

As confirmed by the Summary Component Stats Report above

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

Language OwlExpression files

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

Info

title	Getting 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 12717 records added/updated (as confirmed in new INT only Component Stats Report run by devops from INT 20221231 - 20230630 - see above)

5128 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

title	Getting 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!!)

532 273 records added/updated plus

128 68 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

title	Getting 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!!)

617 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

title	Getting 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!!)

8 records added/updated plus

1 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 impacted	Related JIRA ticket(s)	Rationale
Association files	10	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 files	35		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 files	2		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 files	10		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 File	0		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 files	45		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 files	14		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 files	2		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 impacted

Related JIRA ticket(s)

Rationale

ExtendedMap files

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

Info

title	Getting accurate manual counts: