OHDSI Home | Forums | Wiki | Github

Patient address at admission time

Implementers
#1

Hi,
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

Faramarz

#2

Correction:
visit table not encounter.

#3

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.

t