Hello All - (@schillil, @dorrd, @yguilarte, @Jes_Rhodes, @jon_duke, @DTorok, @roger.carlson)
We have joined the OHDSI community as a function of our involvement in the All of Us Research Program, but we also hope to use OMOP for additional Research efforts.
Spectrum Health is a health system in West Michigan and we are currently all Epic (since Nov 2017), but have a mix of Epic and Cerner in our legacy data.
- Cerner: Inpatient: 2001-2017
-- Ambulatory: ~2007-Present
-- Inpatient: 2017-Present (Much of the Inpt Cerner data is in Epic Clarity for Epic Ambulatory pts.)
As part of our OMOP mapping fo the Epic data, we have been using Epic UserWeb forums to document, update and share our extract ETL and assumptions (also told we couldn't post Epic details on public forums...). The posts we (@roger.carlson and I) have published are designed to present what we've done and gather additional feedback from the community. The central post within the Research Forum serves as an aggregator for table-specific additional threads it is at:
Please review and contribute to those posts. You will need access to Epic UseWeb, but that offered to all Epic customers (go to https://userweb.epic.com/ )
As to the suggestion to use the Report Repository, we considered it but were concerned our ETL code was still under development and had the impression the Report Repository was for more finalized output. We have asked Epic for best approach and will advise if anything changes.
Also as an FYI, below is the general overview I've designed for obtaining the full EHR record (legacy and current Epic) for our participants. There are a few items specific to All of Us or internal work, but most is OHDSI/OMOP focused. I welcome additional feedback on this - will be at the 2018 OHDSI Symposium (Bethesda)
Merged OMOP ETL Workflow
Early 2018 Summary Stats