OHDSI Home | Forums | Wiki | Github

Patient address at admission time

We are capturing a patient’s location changes in the location_history table as per OMOP model. The encounter table has only the patient_id foreign key and we would like to know what is the best way to resolve a patient’s address at admission time

Thank you


visit table not encounter.

I believe the way to do this would be to calculate the address at admission time based on visit_start_date and location_start and end_date in location_history.