-
Inputs: de-identified patient episode identifiers (
pat_eid) -
Uses: 10 core USCDI v1 data elements in a sample clinical data shape
-
Source: Azure Cosmos DB with FHIR-shaped clinical extracts
-
Metric: % of patients with controlled A1C (an operational + payer quality target)
-
Output: quick visualization clinicians recognize immediately
-
Key Risk Value: In the Epic EHI Export schema the lab value for HbA1c (Hemoglobin A1c)
-
Preoperative HbA1c optimization tiers for surgical risk review
-
FHIR-ready CDS resources for Epic integration review
- David Balkcom, MPH, Principal Data Engineer, Quality Measurement Group, IT Vendor Services, United States. Contact: castle.palaces8l@icloud.com. Acknowledgments: Andrea Pitkus, PhD (testing methods alignment).
A serum HbA1c test method does not exist. HbA1c measures the glucose attached to hemoglobin, which is a protein found strictly inside red blood cells. Serum is the liquid portion of the blood after the red blood cells and clotting factors have been removed, meaning it contains no hemoglobin to test. For HbA1c testing, a whole blood sample (which includes red blood cells) is always required. Laboratories process this using methods like HPLC (High-Performance Liquid Chromatography) or immunoassays.
| Capability | Where |
|---|---|
| Patient-level USCDI fields | Cosmos JSON query |
| Cohort selection by EID | ARRAY_CONTAINS(@eids…) |
| Clinically meaningful metric | Controlled diabetes |
| Payer-relevant QI metric | HEDIS-aligned glycemic control |
| Visualization | Matplotlib bar chart |
The flow below summarizes how external HbA1c values move from EHI or another clinical source into the preoperative CDS workflow.
flowchart TD
A["EHI or External Clinical Source"] --> B["FHIR Observation<br/>HbA1c LOINC 4548-4"]
B --> C["Azure Cosmos DB<br/>Clinical data layer"]
C --> D["Observation.valueQuantity %<br/>Observation.effectiveDateTime"]
D --> E["Pre-op HbA1c CDS Pipeline"]
E --> F["Risk Tiering<br/>info / warning / critical"]
F --> G["FHIR-ready CDS Resources<br/>CommunicationRequest / Task"]
G --> H["Epic workflow integration review"]
Use preop_hba1c_cds_workflow.ipynb to run the demo workflow end to end.
- Default mode is
DATA_SOURCE=samplefor a credential-free walkthrough. - Sample mode reads sample-hba1c-cohort.json, a 64-patient synthetic cohort keyed by
pat_eid. - Base runtime dependencies are
python-dotenv pandas numpy requests matplotlib azure-cosmos. - Set values from
.env.exampleand useDATA_SOURCE=cosmosto run against Azure Cosmos DB. - FHIR delivery is review-only by default; the notebook generates
CommunicationRequestandTaskresources without sending them. - The notebook records thresholds, execution date, package versions, cohort size, and FHIR preview count for replication.
- The Society for Imaging Informatics in Medicine (SIIM) created SWIM as a standards-focused initiative to improve interopereable clinical workflows for medical imaging, AI model integration, and edge-to-enterprise orchestration.
- It originally began as a blueprint tool showing how data moves through
- Inside regulated workflows, the SIIM Workflow Initiative in Medicine (SWIM) is the best practical model currently available, but i
In computing, the "data-infrastructure" provides the storage, compute, pipelines, exchange method, and procedural logging. s data stores, schemas, provenance lineage, and semantics that downstream analyses depend on:
- In this layer, we focus on "producers" that generate content to be consumed by components further downstream in the workflow.
- Analogy: Acquiring ingredients, and preparing/cooking the food for a fine-dining meal in the kitchen.
DATA-ANALYTIC LAYER
In computing, the "analytics service layer" (ASL) delivers computed insights and the end-user experience (UX):
- The ASL leverages applied data science techniques such as forecasting, predictive analyses, causal analysis icluding causal inference (CI), forecasting, and machine learning (ML).
- This proccess derives insights and generates visualizations for decision makers in healthcare.
- Analogy: Plating and serving the meal with final touches in the dining room.
- What is a risk model? A risk model is an analytic artifact that uses features engineering within the data model.
- For example, it relies on a statistical or ML construct that predicts the answer to a scientific question of interest.
- For this project, the risk model is the foundation of the Clinical Decision Support (CDS) layer nested within the ASL.
- The risk model itself is a consumer of the data architecture, not part of it.
| Model | Low-Risk Threshold | Medium-Risk Threshold | High-Risk Threshold | Usage |
|---|---|---|---|---|
| Simplified Diabetes Surgical Risk Model | < 7.5% | 7.5–8.5% | > 8.5% | NSQIP Risk |
| Cardiometabolic Surgical Optimization Model | < 7% | 7–8% | > 8% | Bariatric / high-risk cardiovascular |