Skip to main content
. Author manuscript; available in PMC: 2023 Oct 1.
Published in final edited form as: J Biomed Inform. 2022 Sep 9;134:104201. doi: 10.1016/j.jbi.2022.104201

Table 1.

Demonstration Queries.

OMOP Table(s) FHIR Resource(s) Query*
person, visit_occurrence, concept Patient, Encounter Q1: Identify male patients with inpatient admissions lasting greater than 5 days.
condition_occurrence, concept Condition Q2: Identify patients diagnosed with Alzheimer’s Disease.
procedure_occurrence, concept Procedure Q3: Identify patients who delivered a baby.
drug_exposure, concept Medication Statement Q4: Identify patients prescribed trazadone.
measurement, concept Observation Q5: Identify patients with an HbA1c result >= 10 %.
*

SQL and SPARQL code versions of these queries can be reviewed at https://github.com/fhircat/FHIROntopOMOP/blob/main/evaluation/jbi-2022-queries.md.