FHIR Preprocessing
Overview
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.
| Column | Data Type | Description | Terminology |
|---|
coverage
Final mapping for Coverage FHIR resource. Claims data sources only.
| Column | Data Type | Description | Terminology |
|---|
explanation_of_benefit
Final mapping for Explanation of Benefit FHIR resource. Combines medical and pharmacy claims. Claims data sources only.
| Column | Data Type | Description | Terminology |
|---|
medication_dispense
Final mapping for Medication Dispense FHIR resource. Clinical data sources only.
| Column | Data Type | Description | Terminology |
|---|
observation
Final mapping for Observation FHIR resource. Combines observations and lab results. Clinical data sources only.
| Column | Data Type | Description | Terminology |
|---|
patient
Final mapping for Patient FHIR resource.
| Column | Data Type | Description | Terminology |
|---|
procedure
Final mapping for Procedure FHIR resource. Clinical data sources only.
| Column | Data Type | Description | Terminology |
|---|