July 2025 Production (PUBLISHED) vs August 2025 Production (Version 1) traceability

MSSP TICKET:  MSSP-4101

CONCLUSION: 

• 2x new refsets added

  • LWO 20250728: Verify 4x refset descriptors have been deleted after INFRA-15454
    • Since these refset members were not exported to RF2, these deletions will only be verifiable in Snowstorm and not via PCR.
    • LWO 20250821: Confirmed, the query below returns 0 results
      • https://authoring.ihtsdotools.org/snowstorm/snomed-ct/MAIN%2FSNOMEDCT-AU%2F2025-08-31/members?referenceSet=900000000000456007&referencedComponentId=703870008&referencedComponentId=1119410008&referencedComponentId=450994008&active=true&offset=0&limit=50

  • id    effectivetime    active    moduleid    refsetid    referencedcomponentid    attributedescription    attributetype    attributeorder

    9e7e01ae-15c5-4c6c-833f-ee442ca80857    2025-08-31    1    32506021000036107    900000000000456007    933536871000036102    449608002    900000000000461009    0

    474e95e6-2b38-4f8e-a3b0-e2ddc36d4b4c    2025-08-31    1    32506021000036107    900000000000456007    933536911000036100    449608002    900000000000461009    0

• SimpleMap files
  • 221 new + 2 inactivated records
• SimpleRefset files
  • 3278 active (new + reactivated), 595 inactivated records
• MDRS records:
  • 8x records updated, as per usual
• Concept records match PCR report 
  • 13x promoted concepts

    • id    term

      1100901000168102    Succinate dehydrogenase complex iron sulfur subunit B gene mutation detected (finding)

      1100911000168104    Succinate dehydrogenase complex flavoprotein subunit A gene mutation detected (finding)

      1100921000168106    Succinate dehydrogenase complex subunit C gene mutation detected (finding)

      1100931000168109    Maternally inherited succinate dehydrogenase complex subunit D gene mutation detected (finding)

      1100941000168100    Paternally inherited succinate dehydrogenase complex subunit D gene mutation detected (finding)

      1244551000168105    Bereavement counseling service (qualifier value)

      1244591000168100    Problem gambling counseling service (qualifier value)

      1244601000168107    Trauma counseling service (qualifier value)

      1248691000168108    Women's health service (qualifier value)

      1248711000168106    Youth health service (qualifier value)

      1255981000168108    Victims of crime counseling service (qualifier value)

      1277221000168106    Health counseling service (qualifier value)

      1586751000168107    Eating disorder service (qualifier value)

  • 1x moved module/demoted concept

    • id    effectiveTime    active    moduleId    definitionStatusId

      350594000    20250831    1    32506021000036107    900000000000073002

    • Triggered a false positive in the assertion "All inactive members within the concept and description inactivation indicator reference set have valid modifications to their inactivation indicator reasons."
      • Logged and resolved in ISRS-7390
• Description records match PCR report 
• LanguageRefset records match PCR report 
• Association records match PCR report 
• AttributeValue records match PCR report 
• Relationship records match PCR report 
  • 6x "new inactive" records
  • Spot checked - appear to be valid changes - replacement of INT parent with a more specific Extension concept or modifying INT relationships within the Extension modules

  • id    effectivetime    active    moduleid    sourceid    destinationid    relationshipgroup    typeid    characteristictypeid    modifierid

    3185136022    2025-08-31    0    32506021000036107    11608005    85813009    0    116680003    900000000000011006    900000000000451002

    16352683022    2025-08-31    0    32506021000036107    1366096009    283165009    0    116680003    900000000000011006    900000000000451002

    16352684027    2025-08-31    0    32506021000036107    1366096009    302129007    0    116680003    900000000000011006    900000000000451002

    16352685026    2025-08-31    0    32506021000036107    1366096009    429377005    0    116680003    900000000000011006    900000000000451002

    16363772027    2025-08-31    0    32506021000036107    1278003    85813009    0    116680003    900000000000011006    900000000000451002

    16364862028    2025-08-31    0    32506021000036107    438371007    302130002    0    116680003    900000000000011006    900000000000451002

• RelationshipConcreteValues records match PCR report 
• OWL records match PCR report
  • Larger number of changed axioms (1366x) relative to new axioms (700x)
  • Spot checked - appears to be due to new concrete domain values "Count of clinical drug type (attribute)" being added to drug concepts
    • This CD property already exists in 109k concepts in their July 2025 release
• MRCM records match PCR report
  • No changes as expected
• TextDefinition records match PCR report
  • 2x new records (for 2x new refsets)
  • However, not all GB/US language preferences have corresponding AU language preferences defined : https://docs.google.com/spreadsheets/d/1QOJx5o-ZrSDw2c2RPYlD1PWZppx17QEZ4b8CrbuZCC8/edit?gid=448743139#gid=448743139
    
  • Potentially 4k concepts with missing AU language preferences for TextDefinitions, logged as ISRS-7379
  • Pending comprehensive review by AU NRC, no major changes in this release