search

databrickslabs / dbignite

Other
22 stars 10 forks source link

OMOP Remaining table creation #46

Open SomanathSankaran opened 1 month ago

SomanathSankaran commented 1 month ago

https://ohdsi.github.io/CommonDataModel/cdm60.html

As per this document I could see lot of table Common Data Model of OMOP. But DBIgnite provides only conversion for 4 entities as per readme.md Is there any way to add or extend for other tables. Is there any roadmap to extract the data for other tables

zavoraad commented 1 week ago

Hi @SomanathSankaran,

The OMOP mappings are patient centric resources and assuming that the FHIR bundles are C-CDA CCD. We'd welcome external contributors to this roadmap, but do not plan to extend it at this time due to the many permutations of FHIR messages including prior auths, claims, various FHIR API calls out of an EHR etc.

Depending on the use case, the easiest path would be to write out FHIR resources as tables and then write SQL to map into the relevant OMOP tables. I believe there are several public FHIR to OMOP mapping documents that can be referenced as generally acceptable.