SNOMED International Release Management

Page tree

Versions Compared

Old Version 3

changes.mady.by.user Andrew Atkinson

Saved on

compared with

New Version Current

changes.mady.by.user Andrew Atkinson

Saved on

Key

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

September 2022 Pre-Production (

Version 2

Version7) vs September 2022

Pre-

Production (

Version 4

Version1) traceability

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

Summary Component Stats report (INT 20220131 - 20220630):https://docs.google.com/spreadsheets/d/19VsiSfqZGc9DSO8qINiqtBSYAdCsL6I_AfyUT0JoiRo/edit#gid=0

Differences found in package Comparison

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

INTERNATIONAL EFFECTIVETIME 20220630:

0 records inactivated, plus

0 records added/updated

US EDITION EFFECTIVETIME 20220901:

6413 records inactivated, plus

14181 records added/updated

AS EXPECTED?????

AttributeValue files2

ISRS-1287

1 AttributeValue record removed from the US Edition release package:

    1. < 83423945-4ca4-48c7-833c-f6fb06e59aa3    20220901    1    731000124108    900000000000490003    4652417010    900000000000495008

As expected due to fixes in ISRS-1287 - Darryn to confirm exact changes expected....

ModuleDependency files22 records had their UUID's refreshed as expected??
March 2022 (PUBLISHED
ALL

ISRS-1215

UUID's only refreshed for 2 new records, as expected

Readme files

x prefixes removed and Production naming conventions applied as expected


September 2022 Pre-Production (Version6) vs September 2022 Pre-Production (Version7) traceability

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

Summary Component Stats report (INT 20220131 - 20220630):https://docs.google.com/spreadsheets/d/19VsiSfqZGc9DSO8qINiqtBSYAdCsL6I_AfyUT0JoiRo/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
ModuleDependency filesALL

ISRS-1215

UUID's only refreshed for 2 new records, as expected

All files0
ZERO changes as expected (as simply verifying that John's final fixes were promoted up to USREL branch correctly.


September 2022 Pre-Production (Version4) vs September 2022 Pre-Production (

Version4

Version6) traceability

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

Summary Component Stats report (INT 20220131 - 20220630):https://docs.google.com/spreadsheets/d/19VsiSfqZGc9DSO8qINiqtBSYAdCsL6I_AfyUT0JoiRo/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
OWL Axiom files1MSSP-1616

1 record updated to update an attribute for concept 11778001000119103, as per John's comments in MSSP-1616 on 9/8/22:

  • < 7880dec4-bbc4-4b3f-8a8d-bfe101cb0d3a    20220901    1    731000124108    733073007    11778001000119103    EquivalentClasses(:11778001000119103 ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:116676008 :35933005) ObjectSomeValuesFrom(:363698007 :1197046007) ObjectSomeValuesFrom(:42752001 :773760007)))))
  • > 7880dec4-bbc4-4b3f-8a8d-bfe101cb0d3a    20220901    1    731000124108    733073007    11778001000119103    EquivalentClasses(:11778001000119103 ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:116676008 :35933005) ObjectSomeValuesFrom(:363698007 :1197046007))) ObjectSomeValuesFrom(:609096000 ObjectSomeValuesFrom(:42752001 :773760007))))

Just need to verify with John that these changes are expected due to his intended fixes...John confirmed exactly as expected on 10/8/22 in MSSP-1616

Inferred Relationship files2

MSSP-1616

1 record removed:

  • < 2636131000124128    20220901    1    731000124108    11778001000119103    773760007    1    42752001    900000000000011006    900000000000451002

Plus 1 record updated, re-activating the record from 2020:

  • < 1813401000124121    20220901    0    731000124108    11778001000119103    773760007    2    42752001    900000000000011006    900000000000451002
  • > 1813401000124121    20200901    1    731000124108    11778001000119103    773760007    2    42752001    900000000000011006    900000000000451002

Just need to verify with John that these changes are expected due to his intended fixes...John confirmed exactly as expected on 10/8/22 in MSSP-1616

ModuleDependency filesALL

ISRS-1215


UUID's only refreshed for 2 new records, as expected



September 2022 Pre-Production (Version4) vs September 2022 Pre-Production (Version5) traceability

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

Summary Component Stats report (INT 20220131 - 20220630):https://docs.google.com/spreadsheets/d/19VsiSfqZGc9DSO8qINiqtBSYAdCsL6I_AfyUT0JoiRo/edit#gid=0

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
OWL Axiom files1MSSP-1616

1 record updated to update an attribute for concept 11778001000119103, as per John's comments in MSSP-1616 on 9/8/22:

  • < 7880dec4-bbc4-4b3f-8a8d-bfe101cb0d3a    20220901    1    731000124108    733073007    11778001000119103    EquivalentClasses(:11778001000119103 ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:116676008 :35933005) ObjectSomeValuesFrom(:363698007 :1197046007) ObjectSomeValuesFrom(:42752001 :773760007)))))
  • > 7880dec4-bbc4-4b3f-8a8d-bfe101cb0d3a    20220901    1    731000124108    733073007    11778001000119103    EquivalentClasses(:11778001000119103 ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:116676008 :35933005) ObjectSomeValuesFrom(:363698007 :1197046007))) ObjectSomeValuesFrom(:609096000 ObjectSomeValuesFrom(:42752001 :773760007))))

Just need to verify with John that these changes are expected due to his intended fixes...John confirmed exactly as expected on 10/8/22 in MSSP-1616

Inferred Relationship files2

MSSP-1616

1 record removed:

  • < 2636131000124128    20220901    1    731000124108    11778001000119103    773760007    1    42752001    900000000000011006    900000000000451002

Plus 1 record updated, re-activating the record from 2020:

  • < 1813401000124121    20220901    0    731000124108    11778001000119103    773760007    2    42752001    900000000000011006    900000000000451002
  • > 1813401000124121    20200901    1    731000124108    11778001000119103    773760007    2    42752001    900000000000011006    900000000000451002

Just need to verify with John that these changes are expected due to his intended fixes...John confirmed exactly as expected on 10/8/22 in MSSP-1616

ModuleDependency filesALL

ISRS-1215


20220901 records reverted back to 20220301 records - probably just because we're running from a fix branch, so just need to double check this once John has promoted his fix to MAIN...



March 2022 (PUBLISHED) vs September 2022 Pre-Production (Version4) traceability

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

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)RationaleSimple refset files488

INTERNATIONAL EFFECTIVETIME 20220131:

123 records inactivated, plus

365 records added

US EDITION EFFECTIVETIME 20220301:

0 records changed

This is as expected from the Lateralizable Refset changes that Yong made in this cycle for the International Edition, with no additional US changes found

See here for confirmation:  International Edition Traceability matrix (January 2022)

Therefore this is the expected result, as we never expect to have US specific changes in this file

BUT THERE ARE 344 RECORDS THAT THE NEW AUTOMATED LATERALIZABLE REFSET CODE HAS PUT INTO THE WRONG MODULE! 

ExtendedMap files29796

INTERNATIONAL EFFECTIVETIME 20220131:

533 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

2141 records added (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

0 records added

0 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

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

NO US CONTENT YET!!!

ModuleDependency filesALL

n/a

NO US CONTENT YET!!!

6 records updated with latest effectiveTimes, as expected:

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

Association files4051

INTERNATIONAL EFFECTIVETIME 20220131:

0 records updated, plus

863 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

3097 records added (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

81 records added plus

10 inactivated

????????????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 
As expected when compared to the Summary Component Stats Report:  

Summary Component Stats report (INT 20220131 - 20220630):

https://docs.google.com/spreadsheets/d/

1Ft-fUmtP2upfNhc9rKOGU3RXpjnsaUv8A7y

19VsiSfqZGc9DSO8qINiqtBSYAdCsL6I_

UX3Pq7I

AfyUT0JoiRo/edit#gid=0

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

INTERNATIONAL EFFECTIVETIME 20220131:

1171 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

5552 records added/updated (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

188 records added plus

plus 91 updated plus

68 inactivated

As confirmed by the Summary Component Stats Report:  https://docs.google.com/spreadsheets/d/1Ft-fUmtP2upfNhc9rKOGU3RXpjnsaUv8A7y_UX3Pq7I/edit#gid=0Description 38237 20220131:

8963 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

27524 records added/updated (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

1639 records added/updated plus

111 inactivated

80751

US EDITION EFFECTIVETIME 20220301:

0 records updated

INTERNATIONAL EFFECTIVETIME 20220131:

1 new records added,   January 2022)

> 7e29d963-b054-4454-9121-8de1cffceadd 20211031 1 900000000000012004 723561005 1003735000 363787002 1 0..* 0..1 723597001 723596005

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

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

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

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

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

Differences found in package Comparison

Number of RF2 records impactedRelated JIRA ticket(s)Rationale
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

ISRS-1215


2 extra records than normal added by Automated process!  Calling out dependencies of ICD-10CM module on 2x core modules - this is because "Dependencies are not transitive and this means that dependencies cannot be inferred from a chain of dependencies. If module-A depends on module-B and module-B depends on module-C, the dependency of module-A on module-C must still be stated explicitly." - therefore these records have always been missing from the US Edition.  The TRAG has recently been discussing the possibility of changing the spec to make them transitive, but so far the business case for doing so is not strong enough (ISRS-1215 + point 31 here: 2022-09-26 - TRAG Meeting Agenda/Minutes)

##### SO WE JUST NEED TO LET THE US NRC KNOW THAT THESE EXPLICIT RECORDS ARE BEING ADDED IN THIS CYCLE #####

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

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


PLUS 3 US Module records updated with latest effectiveTimes, as expected:

< 53773521-fd81-5dde-9a2d-8b87e8803251    20220301    1    5991000124107    900000000000534007    731000124108    20220301    20220301
< 70edb2ac-8a7a-5a94-b385-f8ad80db3858    20220301    1    731000124108    900000000000534007    900000000000012004    20220301    20220131
< 71ae8ceb-7984-550c-b1f5-9a69681b383a    20220301    1    731000124108    900000000000534007    900000000000207008    20220301    20220131
---
> 53773521-fd81-5dde-9a2d-8b87e8803251    20220901    1    5991000124107    900000000000534007    731000124108    20220901    20220901
> 70edb2ac-8a7a-5a94-b385-f8ad80db3858    20220901    1    731000124108    900000000000534007    900000000000012004    20220901    20220630
> 71ae8ceb-7984-550c-b1f5-9a69681b383a    20220901    1    731000124108    900000000000534007    900000000000207008    20220901    20220630

PLUS 3 INT Module records updated with latest effectiveTimes, as expected as match 20220630 INT Edition exactly:

< 1244116f-fdb5-5645-afcc-5281288409da    20220131    1    900000000000207008    900000000000534007    900000000000012004    20220131    20220131
< 686fe392-d2f7-586d-98aa-078aba426832    20220131    1    449080006    900000000000534007    900000000000207008    20220131    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
> 686fe392-d2f7-586d-98aa-078aba426832    20220630    1    449080006    900000000000534007    900000000000207008    20220630    20220630
> f6431457-161b-5b46-9217-573c20c00070    20220630    1    449080006    900000000000534007    900000000000012004    20220630    20220630



Only way to validate this is by manually going back through the past 6 months' worth of dependent INT Edition Traceability matrices, and checking the changes match!

***** THESE RECORDS DO NOT APPEAR TO BE VALID, AS THERE WERE ZERO MODULEDEPENDENCY RECORD CHANGES BETWEEN 20220228 - 20220630 releases (inclusive)!


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

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

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:

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

188 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  (for ANY of interim Monthly releases between their dependent releases from 20220131 - 20220630!):

1 new records added

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

Only way to validate this is by manually going back through the past 6 months' worth of dependent INT Edition Traceability matrices, and checking the changes match!

***** THESE RECORDS MATCH THE PRODUCTION INTERNATIONAL EDITION CHANGES FOR THE MONTHLY RELEASES BETWEEN THE DEPENDENT INT EDITION RELEASES (20220228 - 20220630) - the changes above are  identical to those INT changes made in the 20220228 INT Edition release, as requested by Linda (see International Edition Traceability matrix (February 2022)).  NOTE - whilst the inactivation records are identical, the UUID of the new replacement record is different from the first INT Edition build (PreProd version 9), but thankfully this UUID was refreshed in the final Feb 2022 Prod release (version 1), and matched the one above.   There were no other refsetDescriptor changes between 20220228 - 20220630, so the above changes are valid and expected.

Readme file
n/a

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

SimpleMap files4432

INTERNATIONAL EFFECTIVETIME 20220630 (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:

0 records changed

This matches the International Edition changes, as looking at the INT Stats report (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above) there were 4412 BRAND NEW Concepts added in this US dependent cycle, and therefore there should have been 4412 records added for CTV3.

+ a handful of new/updated records for ICD-0 as expected, gets us to the 4432 number of changes.

Therefore this is the expected result, as we never expect to have US specific changes in this file.

Simple refset files444

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

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

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

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

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


US EDITION EFFECTIVETIME 20220901:

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


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

Concept files7894

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

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 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), plus

5706 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 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 records added/updated plus

46 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 (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 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), plus

17341 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 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 records added/updated plus

31 inactivated

  • EXACTLY AS EXPECTED by the Summary Component Stats Report above  
  • This reports 1040 added/updated + 31 inactivated...


OwlExpression files14673

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

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 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), plus

11894 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 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 records added/updated plus

48 inactivated

  • As confirmed 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 files

80490



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

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

27688 records inactivated (as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above), 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 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!!)

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

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

2165 records updated, plus as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above

386 records inactivated  as confirmed in new INT only Component Stats Report run by devops from INT 20220131 - 20220630 - see above

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

US EDITION EFFECTIVETIME 20220901:

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
TextDefinition files700n/a

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

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:

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

19 records added/updated plus

0 inactivated

  • As confirmed by the Summary Component Stats Report above
Attribute Value files37675

INTERNATIONAL EFFECTIVETIME 20220131:

3186 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

34091 records added/updated (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

341 records added plus

183 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 

Roughly the expected figure then, when compared to previous cycles, plus confirmed by the Summary Component Stats Report:  https://docs.google.com/spreadsheets/d/1Ft-fUmtP2upfNhc9rKOGU3RXpjnsaUv8A7y_UX3Pq7I/edit#gid=0

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

RefsetDescriptor files9

US EDITION EFFECTIVETIME 20220301:

0 records changed

INTERNATIONAL EFFECTIVETIME 20220131:

9 new records added, as expected due to new expression refset records introduced in Jan 2022 International Edition - see here for full details: International Edition Traceability matrix (January 2022)

  • > 3bfaee84-647e-4469-a673-aaed52de0314 20220131 1 900000000000012004 900000000000456007 705109006 900000000000500006 900000000000465000 1
  • > 3bff8547-fe17-48c3-8f77-cecb12f59c34 20220131 1 900000000000012004 900000000000456007 705111002 900000000000505001 900000000000461009 0
  • > 4b1ae18f-c2c1-49d9-8a52-3e5f6f694e86 20220131 1 900000000000012004 900000000000456007 1193543008 1193546000 900000000000461009 2
  • > 55d49025-cb4a-43b0-8d20-d6515bbb21d3 20220131 1 900000000000012004 900000000000456007 1187636009 900000000000505001 900000000000461009 0
  • > 56f1edbd-b700-4a9d-af7e-50a219bcc1fb 20220131 1 900000000000012004 900000000000456007 1193542003 1193546000 900000000000461009 2
  • > 5aaea794-b8a3-4d57-912c-28222d40171c 20220131 1 900000000000012004 900000000000456007 1193542003 900000000000505001 900000000000465000 1
  • > 7b5ae70c-7d06-4aa6-9c5b-4550e7ac6f41 20220131 1 900000000000012004 900000000000456007 1193544002 1193546000 900000000000461009 2
  • > 8ff477e9-da58-4731-8a4c-9dab28763fa9 20220131 1 900000000000012004 900000000000456007 1193543008 900000000000500006 900000000000465000 1
  • > 9052b31b-bce5-4487-ab96-9a13b4010f5e 20220131 1 900000000000012004 900000000000456007 1193544002 900000000000505001 900000000000465000 1
  • > 97758694-c0b3-4c75-8b7c-8699b3643a1d 20220131 1 900000000000012004 900000000000456007 705109006 1193546000 900000000000461009 4
  • > b6388756-32fc-44cc-a81d-7f90b3ca20ec 20220131 1 900000000000012004 900000000000456007 1193542003 900000000000500006 900000000000461009 0
  • > c8792e0e-2d08-4473-9dec-7119b091bc58 20220131 1 900000000000012004 900000000000456007 1187636009 900000000000500006 900000000000465000 1
  • > dd6a92b3-a9fd-4faf-9bbe-02494c59a703 20220131 1 900000000000012004 900000000000456007 705111002 900000000000500006 900000000000465000 1
  • > e6efc563-025f-4050-abc2-0606e5f5b030 20220131 1 900000000000012004 900000000000456007 900000000000496009 900000000000505001 900000000000465000 1
  • > f66f05d5-44db-4872-b09a-57412405a493 20220131 1 900000000000012004 900000000000456007 1193543008 900000000000505001 900000000000461009 0
  • > 0e0ff97c-4a91-4d62-8601-8106e7f8cbcc 20220131 1 900000000000012004 900000000000456007 1193544002 900000000000500006 900000000000461009 0
  • > 1b0f3059-fe0b-4174-8d84-af015389d7b2 20220131 1 900000000000012004 900000000000456007 705111002 1193546000 900000000000461009 3

Plus 6 inactivations:

  • < 11a85439-228c-4f29-987f-46ac1c732e22 20180131 1 900000000000012004 900000000000456007 705111002 449608002 900000000000461009 0
    > 11a85439-228c-4f29-987f-46ac1c732e22 20220131 0 900000000000012004 900000000000456007 705111002 449608002 900000000000461009 0
  • < eb0accdb-0751-488f-bf71-5ba2acd4e50c 20180131 1 900000000000012004 900000000000456007 705111002 447247004 900000000000461009 3
    > eb0accdb-0751-488f-bf71-5ba2acd4e50c 20220131 0 900000000000012004 900000000000456007 705111002 447247004 900000000000461009 3
  • < 2ce1f83d-a0ab-4c52-a2e9-cf2daa017dac 20180131 1 900000000000012004 900000000000456007 705109006 900000000000505001 900000000000465000 1
    > 2ce1f83d-a0ab-4c52-a2e9-cf2daa017dac 20220131 0 900000000000012004 900000000000456007 705109006 900000000000505001 900000000000465000 1
  • < 7c97da90-d565-40a2-ac06-0c86275202e6 20180131 1 900000000000012004 900000000000456007 705111002 900000000000505001 900000000000465000 1
    > 7c97da90-d565-40a2-ac06-0c86275202e6 20220131 0 900000000000012004 900000000000456007 705111002 900000000000505001 900000000000465000 1
  • < 885e163a-5c99-423d-9879-dc9e10599fb5 20170731 1 900000000000207008 900000000000456007 900000000000496009 900000000000499002 900000000000465000 1
    > 885e163a-5c99-423d-9879-dc9e10599fb5 20220131 0 900000000000207008 900000000000456007 900000000000496009 900000000000499002 900000000000465000 1
  • < 91871acf-7344-4209-9b37-249486dd2ca8 20180131 1 900000000000012004 900000000000456007 705109006 447247004 900000000000461009 4
    > 91871acf-7344-4209-9b37-249486dd2ca8 20220131 0 900000000000012004 900000000000456007 705109006 447247004 900000000000461009 4

Plus 1 updated (change of module):

  • < a7b29cee-d563-4e14-9a01-a491a6aab300 20170731 1 900000000000207008 900000000000456007 900000000000496009 900000000000500006 900000000000461009 0
    > a7b29cee-d563-4e14-9a01-a491a6aab300 20220131 1 900000000000012004 900000000000456007 900000000000496009 900000000000500006 900000000000461009 0

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

Readme filen/a

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

PLUS ALL DELTA FILES REMOVED, AS PLANNED!

SimpleMap files4592

INTERNATIONAL EFFECTIVETIME 20220131:

65 records inactivated, plus

4527 records added

US EDITION EFFECTIVETIME 20220301:

0 records changed

This matches the International Edition changes exactly, as 3559 added for CTV3 (as part of the normal authoring cycle updates, exported from the termServer - this is the exact expected amount as it matches exactly the number of new concepts created in the latest authoring cycle)

+ 2 new/updated records for ICD-0 as expected, matching the 2 records in the Delta from mapping tool.

See here for confirmation:  International Edition Traceability matrix (January 2022)

Therefore this is the expected result, as we never expect to have US specific changes in this file

Concept files9592

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

Language files42846

INTERNATIONAL EFFECTIVETIME

OwlExpression files17100

INTERNATIONAL EFFECTIVETIME 20220131:

1164 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

15255 records added/updated (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

612 records added plus

69 inactivated

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 files

INTERNATIONAL EFFECTIVETIME 20220131:

28147 records inactivated (roughly same as International Edition - see final Production International Delta file for confirmation), plus

48736 records added/updated (roughly same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

1872 records added plus

1996 inactivated

HOWEVER WE STILL NEED TO CLASSIFY THIS SEPARATELY ON THE COMMAND LINE TO DOUBLE CHECK NO RESULTS...

Relationship Concrete Values files2150

INTERNATIONAL EFFECTIVETIME 20220131:

1053 records updated, plus

1097 records inactivated

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

US EDITION EFFECTIVETIME 20220301:

0 records changed

Therefore there are no US specific changes this cycle 

TextDefinition files733n/a

INTERNATIONAL EFFECTIVETIME 20220131:

45 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

674 records added/updated (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

4 records added plus

0 inactivated

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

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

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

36493 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 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 records added/updated plus

44 inactivated

  • As confirmed by the Summary Component Stats Report above

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

MRCMAttributeDomain files0

US EDITION EFFECTIVETIME 20220901:

0 records updated

INTERNATIONAL EFFECTIVETIME 20220630 (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 files0n/a

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

0records updated, plus

0 records inactivated, plus

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

US EDITION EFFECTIVETIME 20220901:

0 records changed

Therefore there are no US specific changes tis cycle

MRCMDomain files0n/a 

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

0 new records added, BUT THERE SHOULD HAVE BEEN IN ORDER TO MATCH

Language files74534

INTERNATIONAL EFFECTIVETIME 20220131:

17765 records inactivated (same as International Edition - see final Production International Delta file for confirmation), plus

55771 records added/updated (same as International Edition - see final Production International Delta file for confirmation)

US EDITION EFFECTIVETIME 20220301:

839 records added/updated plus

159 inactivated

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

MRCMAttributeDomain files1

exactly the same as with the International editing cycle.  See here for confirmation:

 International Edition Traceability matrix (

MRCMAttributeRange files1n/a

INTERNATIONAL EFFECTIVETIME 20220131:

0records updated, plus

0 records inactivated, plus

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

US EDITION EFFECTIVETIME 20220301:

0 records changed

Therefore there are no US specific changes tis cycle

MRCMDomain files1n/a 

INTERNATIONAL EFFECTIVETIME 20220131:

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

US EDITION EFFECTIVETIME 20220301:

0 records changed

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

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

US EDITION EFFECTIVETIME 20220901:

0 records changed

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

Transitive Closure file0

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

Transitive Closure file0

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

tls_Icd10cmHumanReadableMap_

US1000124_20170901.tsv

0

doc_Icd10cmMapTechnicalSpecifications_Current-en-US_US1000124_20170901.pdf

0

doc_Icd10cmMapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx

0

doc_Icd10cmMapReleaseNotes_Current-en-US_US1000124_20170901.pdf

0

doc_Icd10MapTechnicalGuideExemplars_Current-en-US_US1000124_20170901.xlsx

0








September 2022 Pre-Production (Version 2) vs September 2022 Pre-Production (Version 4) traceability

Differences found in package Comparison

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

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

0 records inactivated, plus

0 records added/updated

US EDITION EFFECTIVETIME 20220901:

6413 records inactivated, plus

14181 records added/updated

AS EXPECTED????? - SEND TO JULIA and KIN WAH TO VERIFY ONCE HAVE FINAL VERSION

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

AttributeValue files2

ISRS-1287

1 AttributeValue record removed from the US Edition release package:

    1. < 83423945-4ca4-48c7-833c-f6fb06e59aa3    20220901    1    731000124108    900000000000490003    4652417010    900000000000495008

As expected due to fixes in ISRS-1287 - Darryn confirmed exact changes expected....

ModuleDependency files2ISRS-12152 records had their UUID's refreshed as expected, due to the 2x new records being added this cycle due to ISRS-1215