Cerner HealthFacts to OMOP CDM ETL

Implementers
1

Has anyone developed an Extract, Transform and Load (ETL) procedure to map the Cerner HealthFacts database to the OMOP common data model (CDM)?

If so, would you be willing to share your learnings, approach, and/or code?

Many thanks,
Christophe

Christophe Lambert, PhD
Associate Professor
University of New Mexico
Center for Global Health
Division of Translational Informatics
Department of Internal Medicine

2

any progress on this? discussing this today with @shawndolley

3

This group in Texas in 2016 probably developed an ETL. I recently talked with folks who could use it a lot.

link:https://www.ohdsi.org/web/wiki/lib/exe/fetch.php?media=symposium_2016:ohdsi_2016_cerner_etl_v1.pdf

image
image655×590 71.6 KB

4

Yes we did ETL for Healthfact at UTHealth. There is a published ETL protocol for Healthfact by another group: https://github.com/OHDSI/ETL-CDMBuilder/blob/master/man/CERNER/Cerner_ETL_v6.docx