Hello Everyone,
I would like to know the importance of visit ids.
- For example, we have survey data where patients were interviewed.
We are trying to convert this to OMOP CDM form. But it’s natural that we don’t have visit data/table for these patients (who come under survey data). What we have is interview date which I feel it syncs with “observation_date” column of “observation” table.
I understand that we can key in Zero for missing visit_ids but when the domain itself is missing, will that result in any problem if I leave the visit_table empty (which I am not able to foresee due to limited knowledge). I know some constraints might fail but how do we handle a scenario like this?
So, do I just key in zero in domain tables (wherever there is visit_occurrence id column)?