Observation_period

Reading from Synthea table encounters.csv

| Destination Field | Source field | Logic | Comment field | | --- | --- | --- | --- | | observation_period_id | | Autogenerated | | | person_id | patient | Map by mapping person.person_source_value to patient. Find person.person_id by mapping encouters.patient to person.person_source_value. | | | observation_period_start_date | start | min(start) group by patient Take the earliest START per patient | | | observation_period_end_date | stop | max(stop) group by patient Take the latest STOP per patient | | | period_type_concept_id | | Set as concept 32882 (Standard algorithm from EHR) for all records | |



OHDSI/ETL-Synthea documentation built on Feb. 24, 2025, 3:48 a.m.