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