Skip to main content

FHIR Preprocessing

Last updated: 05-29-2025

Overview

Code on Github

In the Tuva Project, we have built a FHIR preprocessing mart designed to streamline the transformation of healthcare data into a FHIR-ready format. This mart transforms data from the Tuva Core Data Model into standardized tables aligned with FHIR resources, ready to be exported as CSVs, making it easier to generate valid FHIR patient bundles.

To support this pipeline, we will be releasing a companion open-source Python library that helps convert the exported CSVs into fully structured FHIR patient bundles.

Together, these tools are built for flexibility, enabling seamless integration into ETL workflows for anyone adopting FHIR for healthcare data exchange and interoperability.

Stay tuned for more updates on the open-source initiative and an announcement regarding our soon-to-be-released turnkey solution for NCQA-certified HEDIS measures.

How to run the mart

This data mart is disabled by default. To run the data mart, simply add the variable fhir_preprocessing_enabled to your dbt_project.yml file or use the --vars dbt command.

dbt_project.yml:

vars:
fhir_preprocessing_enabled: true

dbt command:

dbt build --select tag:fhir_preprocessing --vars '{fhir_preprocessing_enabled: true}'

Data Dictionary

The FHIR Preprocessing mart outputs a table per FHIR resource.

condition

Final mapping for Condition FHIR resource. Clinical data sources only.

ColumnData TypeDescriptionTerminology

coverage

Final mapping for Coverage FHIR resource. Claims data sources only.

ColumnData TypeDescriptionTerminology

explanation_of_benefit

Final mapping for Explanation of Benefit FHIR resource. Combines medical and pharmacy claims. Claims data sources only.

ColumnData TypeDescriptionTerminology

medication_dispense

Final mapping for Medication Dispense FHIR resource. Clinical data sources only.

ColumnData TypeDescriptionTerminology

observation

Final mapping for Observation FHIR resource. Combines observations and lab results. Clinical data sources only.

ColumnData TypeDescriptionTerminology

patient

Final mapping for Patient FHIR resource.

ColumnData TypeDescriptionTerminology

procedure

Final mapping for Procedure FHIR resource. Clinical data sources only.

ColumnData TypeDescriptionTerminology