| person_id |
|
|
|
| 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’, or when ethnicity in (‘CENTRAL_AMERICAN’, ‘DOMINICAN’, ‘MEXICAN’, ‘PUERTO_RICAN’, ‘SOUTH_AMERICAN’ ) then set as 38003563, otherwise set as 0 When race = ‘HISPANIC’, or when ethnicity in (‘CENTRAL_AMERICAN’, ‘DOMINICAN’, ‘MEXICAN’, ‘PUERTO_RICAN’, ‘SOUTH_AMERICAN’ ) then set as 38003563, otherwise set as 0 |
|
| location_id |
|
|
|
| provider_id |
|
|
|
| care_site_id |
|
|
|
| person_source_value |
id |
|
|
| gender_source_value |
gender |
|
|
| gender_source_concept_id |
|
|
|
| race_source_value |
race |
|
|
| race_source_concept_id |
|
|
|
| ethnicity_source_value |
ethnicity |
|
|
| ethnicity_source_concept_id |
|
|
|