Mapping NOTE entries back to NOTEEVENTS?

[stevenbedrick]

Hello! Apologies if this has been asked already or is documented somewhere, but I am working with an OMOP-ified version of MIMIC-III and need to link a specific note back to its original MIMIC-III note ID, i.e. with its corresponding entry in the NOTEEVENTS table. Actually what I really need is to go in the opposite direction - I have a dataset of annotations that were produced for NOTEEVENTS and are keyed by the relevant note's ROW_ID, and I want to use them with my OMOP-ified MIMIC. So at least I am 100% sure that there is a corresponding entry in NOTE.

Anyway, from my read of the code, the NOTE.note_id column is populated part of the ETL script's big "create all of the OMOP ID columns" step, and I don't see anywhere that the original NOTEEVENTS entry's ID would have been moved over, but thought it was worth asking just in case. :-) Any help/thoughts/advice would be most appreciated!