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

Visit_detail

Reading from Synthea table encounters.csv

• Use logic found here (depending on cdm version - CDM v5.4 provided as example):: https://github.com/OHDSI/ETL-Synthea/blob/main/inst/sql/sql_server/cdm_version/v540/AllVisitTable.sql and https://github.com/OHDSI/ETL-Synthea/blob/main/inst/sql/sql_server/cdm_version/v540/final_visit_ids.sql

| Destination Field | Source field | Logic | Comment field | | --- | --- | --- | --- | | visit_detailid | all_visits.visit_occurrence_id | all_visits.visit_occurrence_id + 1000000 | | | 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. | | | visit_detailconcept_id | encounterclass | When encounterclass is 'emergency' or 'urgentcare' then set to 9203. When encounterclass is 'ambulatory', 'wellness', or 'outpatient' then set to 9202. When encounterclass is 'inpatient' then set to 9201. Otherwise set to 0. | | | visit_detailstart_date | start | | | | visit_detailstart_datetime | start | | | | visi_detail_t_end_date | stop | | | | visit_detailend_datetime | stop | | | | visitdetail_type_concept_id | | Set all records as concept_id 32827 (EHR encounter record). | | | provider_id | encounters.provider | | | | care_site_id | | Set to null for all records | | | admitted_from_source_concept_id | | Set to 0 for all records | | | admitted_from_source_value | | Set to null for all record | | | discharged_to_concept_id | | Set to 0 for all records | | | discharged_to_source_value | | Set to null for all record | | | preceding_visit_detail__id | | lag(all_visits.visit_occurrence_id) over(partition by person.person_id order by all_visits.visit_start_date) + 1000000 | | | visit_detail_source_value | all_visits.encounter_id | | | | visit_detail_source_concept_id | | Set to 0 for all record | |

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