Person

Reading from Synthea table patients.csv

Destination Field Source field Logic Comment field
person_id Autogenerated
gender_concept_id gender When gender = ‘M’ then set gender_concept_id to 8507, when gender = ‘F’ then set to 8532 Drop any rows with missing/unknown gender.
year_of_birth birthdate Take year from birthdate
month_of_birth birthdate Take month from birthdate
day_of_birth birthdate Take day from birthdate
birth_datetime birthdate With midnight as time 00:00:00
death_datetime deathdate With midnight as time 00:00:00
race_concept_id race When race = ‘WHITE’ then set as 8527, when race = ‘BLACK’ then set as 8516, when race = ‘ASIAN’ then set as 8515, otherwise set as 0
ethnicity_concept_id race ethnicity When race = ‘HISPANIC’ then set as 38003563, otherwise set as 0 When race = ‘HISPANIC’ then set as 38003563, otherwise set as 0
location_id Set as null for all records
provider_id Set as null for all records
care_site_id Set as null for all records
person_source_value id
gender_source_value gender
gender_source_concept_id Set as 0 for all records
race_source_value race
race_source_concept_id Set as 0 for all records
ethnicity_source_value ethnicity
ethnicity_source_concept_id Set as 0 for all records