Expected 2x MDRS records to be "Changed" after data fix in INFRA-15212

• While PCR shows 0x changes, MDRS is still correct:

  • id effectiveTime active moduleId refsetId referencedComponentId sourceEffectiveTime targetEffectiveTime a4fbf40a-73ae-4e51-80da-cddc448d3a32 20250607 1 2011000195101 900000000000534007 900000000000012004 20250607 20250501 36ddb438-742a-4c97-9dca-b95489b6a08a 20250607 1 2011000195101 900000000000534007 900000000000207008 20250607 20250501

AttributeValue records

• 2x invalid records deleted after data fix in INFRA-15170

Refsets: n/a (none in externally-maintained repo or from RT2)

MDRS records:

• 2x records updated, as per usual

• 11000241103 |SNOMED CT Common French translation module (core metadata concept)| is defined in SRS config

Concept records match PCR report

Description records match PCR report

• 5 times increase in new descriptions (~55k French terms) compared to the previous release.

• Random samples appear to be structurally sound

LanguageRefset records match PCR report

Association records match PCR report

AttributeValue records

• 2x "new inactive" records in PCR but not in SCS

  • In Snowstorm: inactive in CH module since 20190731, but CH module concept did not exist then

  • Raised investigation ticket INFRA-15170

  • id    effectivetime    active    moduleid    refsetid    referencedcomponentid    valueid

    d7bad26c-96fd-4c84-a9c2-9fc2b29f3ef5    2025-06-07    0    2011000195101    900000000000490003    283677016    723277005

    10f423fa-7d44-4738-9fb9-5a68ea45a8e4    2025-06-07    0    2011000195101    900000000000490003    283676013    723277005

  • Interim finding: Verified by Devs as an unpublished content change, hence appeared in the Delta in this cycle.

  • Update: Resolved in PreProd Version 2 package

• 4x "new" records in PCR but not in SCS (1317 vs 1313)

  • Manual SQL query shows 1317 records, no shortfall

  • Somewhat similar to PCR discrepancy reported in MSSP-3484

  • Records match when running the latest PCR code locally: https://docs.google.com/spreadsheets/d/1RFNaNUJI2hsuYzjfmpfCaZhLa2eeHMEvW3fxSlnu-Xw/edit?gid=16#gid=16

  • Records match (new 1317 + changed 9 = 1326) according to Snowstorm API: https://authoring.ihtsdotools.org/snowstorm/snomed-ct/MAIN%2FSNOMEDCT-CH%2FCHREL/members?referenceSet=900000000000490003&module=2011000195101&active=true&isNullEffectiveTime=true&offset=0&limit=50

  • Records match (new 1317 + changed 9 + inactivated 47 = 1373) according to Delta export: https://authoring.ihtsdotools.org/snowstorm/snomed-ct/exports/5e119078-ecd8-48b6-b47d-e441128a2418

  • Conclusion: Likely to be a reporting issue instead of content issue, possibly fixed by RP-1018

Relationship records match PCR report 

OWL records match PCR report 

RefsetDescriptor records match PCR report