Example: SELECT el/name/defining_code as someElement FROM EHR e CONTAINS COMPOSITION c CONTAINS OBSERVATION o CONTAINS ELEMENT el WHERE el/name/value/mappings/target = 'SNOMED-CT::12345'
could we do ELEMENT-level querying on e.g. OBS-based Entries
ex: get PEWS total score value via code in defining_code or in mappings
Erik Sundvall - definitely exists where need to query on code system A but data are recorded in internal codes, or other code system (hence looking in mappings).
Assumption: the codes we want to query on are in the data
Requirements:
PRIMARY NEED: get back (e.g) OBS on the basis of term codes used to tag them, without knowing archetype or at-code etc
possible subsumption inferencing needed (actual codes in data are children of query code)
possible lookup of mappings that are not in the data, but may be in archetypes
make the AQL query simpler / more intuitive,
dirty import data scenario: need to use the codes that came in the data
handle terminology-tagged OBSERVATIONs (presumably other ENTRYs also)
Seref Arikan can get a (probably unwanted) permutations effect - question on DISTINCT semantics etc
ACTION: find out from vendors if ELEMENT-level querying allowed / works / …
Ian McNicoll AQL ELEMENT/term matching question - precise use case please
Outstanding topics:
Action items
ALL IMPLEMENTERS: please check your OPT14s against ITS XSDs on spec site. E.g. at least report diffs please. NB namepace v1/v2 question & importing (all versions have to be the same in XSD).
Thomas Beale : create conformance discussion online
Diego Bosca at some future point, propose some initial OMOP-related mapping resource