Location

Reading from Synthea table patients.csv

| Destination Field | Source field | Logic | Comment field | | --- | --- | --- | --- | | location_id | | Autogenerated | | | address_1 | | cast(null as varchar) | | | address_2 | | cast(null as varchar) | | | city | city | | | | state | state | Map state to "states_map" table to crosswalk the full state text to the abbreviation | | | county | | cast(null as varchar) | | | zip | zip | | | | location_source_value | zip | | |



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