docs/Observation_period.md

In chrisroederucdenver/ETL-Synthea: A Builder for Converting the Synthea Data to the OMOP CDM

layout: default title: Observation_period nav_order: 3 description: "Observation_period mapping from encounters.csv"

Observation_period

Reading from Synthea table encounters.csv

| Destination Field | Source field | Logic | Comment field | | --- | --- | --- | --- | | observation_period_id | | | | | 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 44814724 for all records |

chrisroederucdenver/ETL-Synthea documentation built on Aug. 1, 2020, 4:21 p.m.