From: George Harenberg Sent: Thursday, March 12, 2026 11:57 AM To: Raghu Arunachalam Cc: Sai Nageswara Rao Vagicharla; Sai Surendra kollipara; Michael Dombaugh; Jeff Mitchell; Shivani Shrivastava Subject: FW: Must read if you create or write SPARQL queries for ICD10CM or ICD10PCS Follow Up Flag: Follow up Flag Status: Flagged FYI George Harenberg, Software Developer Oracle Health, Clinical - Multum From: Paul Zielinski <paul.zielinski@oracle.com> Date: Thursday, March 12, 2026 at 9:48?AM To: skg_consumers_grp <skg_consumers_grp@oracle.com>, skg_contributors_us_grp <skg_contributors_us_grp@oracle.com> Subject: Must read if you create or write SPARQL queries for ICD10CM or ICD10PCS Confidential - Oracle Restricted \Including External Recipients Because some terminologies have time-sensitive definitions (ICD10CM and ICD10PCS), the ECF team will soon begin distributing multiple versions of these terminologies into the Common Graph. What is changing � Each terminology version will be loaded into a versioned named graph IRI, for example: <http://skg.health.oraclecloud.com/icdcm10-vxxx> � Subject IRIs remain unversioned (same as today), for example: <http://skg.health.oraclecloud.com/icdcm10> Each versioned graph includes three additional triples that capture the vendor-declared effective dates for that version: * skg:startDate � version start date * skg:stopDate � version stop date * skg:allowMultipleVersions � must be set to true to allow packaging into the Common Graph Query impact If you write SPARQL queries against these terminologies, you will need to qualify which versioned graph you want to use. With multiple versions present, queries that do not select a specific versioned graph may return duplicate results (one per version). To avoid duplicates, add logic to select the appropriate version: � Use today�s date to select the current version, or � Use a use-case-specific �asOfDate� date (e.g., encounter date, activity date) to select the version active at that time. Example: select the current version SELECT g, startDate, endDate, title FROM TABLE( SEM_MATCH( q'[ PREFIX xsd: http://www.w3.org/2001/XMLSchema# PREFIX dc: http://purl.org/dc/elements/1.1/ SELECT ?g ?startDate ?endDate ?title WHERE { BIND("2026-01-15"^^xsd:date AS ?asOfDate) GRAPH ?g { http://skg.health.oraclecloud.com/icd10cm dc:title ?title ; http://skg.health.oraclecloud.com/ns#startDate ?startDate ; http://skg.health.oraclecloud.com/ns#stopDate ?endDate . } FILTER(?startDate <= ?asOfDate && ?endDate >= ?asOfDate) } ]', SEM_Models('VM1'), NULL, NULL, NULL, NULL, ' PLUS_RDFT=VC ', NULL, NULL, 'PDZ_RDFSERVER', 'RDF_NETWORK' ) ); For additional details, please see: Guide - Versioned Terminologies - Health AI - ALM Confluence Confidential - Oracle Restricted \Including External Recipients