How to handle missing dates in all CDM tables?

[MPhilofsky (Melanie Philofsky)]

Hello @SELVA_MUTHU_KUMARAN,

@SELVA_MUTHU_KUMARAN

Are all lab/condition/drug records always have an associated visit?

@SELVA_MUTHU_KUMARAN

Have you encountered in your experience where records outside/not related to visit_ids in the visit table are present in other domain tables like lab, drugs, conditions etc.?

No, sometimes a lab Measurement, Drug dispense, or other clinical event happens outside of the Person-Provider Visit. And that’s ok.

@SELVA_MUTHU_KUMARAN

If yes, how do you handle such scenarios? Can you share some suggestions on how to address this?

I am not aware of a use case that would require all clinical events to be linked to a Visit. So, we don’t worry about the lack of a visit_occurrence_id in a clinical event table. Do your researchers have a use case for this?