We have stored our patient visit data into “visit_occurrence” table. A patient might have multiple visits (records) in Visit_occurrence table. I mean when a patient moves from one facility to another facility, it is recorded as two records in visit_occurrence table. Is it okay to follow this approach? I read the discussion around this topic in forum but I followed the CDM doc. Shown below. An inpatient/oupatient may be transferred to different health care facilities for multiple tests etc, so I inferred that it can be recorded as multiple records for the same person (multiple Visit_occurrence_Ids but same person_id). Is my interpretation correct?
We didn’t use Visit_detail table as we didn’t find any use of it. Are we doing it the wrong way? Are there any issues if we avoid Visit_detail table and store all records in Visit_occurrence table?