OMOP CDM view of mimic III data

[vojtechhuser]

I would like to contribute to concept folder a view of the data that emulates some of the tables in the OMOP CDM.

Do all concept folder contribution get build automatically?

Is the syntax for any contributed view Postgres SQL flavor?

Do I just submit PR to the repo with concept/OMOP/person.sql code?
(if I want to start with person table?)

per readme file

A Makefile build system has been created to facilitate the building of the MIMIC database, and >optionally contributed views from the community. Please refer to the Makefile guide for more details.

related link : http://forums.ohdsi.org/t/mimic2-and-possibly-mimic3-data-in-ohdsi-cdm-format/860

[alistairewj]

Yes - the makefile is quite simple though. It calls a single SQL script: make-concepts.sql. This script creates all the subsequent tables by calling all the various SQL files.

PostgreSQL (or "standard" SQL if you prefer) is the desired syntax. I think creating an individual folder like you suggest (OMOP) would work well.

[alistairewj]

We have another colleague looking into OMOP and its suitability for MIMIC-III. @parisni any comment?

[vojtechhuser]

Thanks for the comment. It would be great to have more people in the mimic-omop team. awaiting @parisni reply.....

[parisni]

Hi @vojtechhuser I plan to work on that topic too. I would be glad to collaborate. My goal is to have something working before 2018