PERSON - AmericanManufacturingCohort/HR-CDM-Data-Transformation GitHub Wiki
The table below presents the data mappings for the PERSON table where the source variables refer to the column names in the base data set.
| PERSON Variable | Source Variable | Note |
|---|---|---|
| person_id | N/A | (Auto-generated by a computer program) |
| gender_concept_id | sex | Map the value to the gender concept vocabulary |
| year_of_birth | dobdt | Extract the year |
| month_of_birth | dobdt | Extract the month |
| day_of_birth | dobdt | Extract the day |
| birth_datetime | dobdt | |
| race_concept_id | -- | |
| ethnicity_concept_id | ethnicde | Map the value to the ethnicity concept vocabulary |
| location_id | N/A | Foreign key to the LOCATION table |
| provider_id | N/A | Foreign key to the PROVIDER table |
| care_site_id | N/A | Foreign key to the CARE_SITE table |
| person_source_value | eessno | |
| gender_source_value | sex | Map the value "F" to "Female", "M" to "Male", or otherwise "NA" |
| gender_source_concept_id | sex | |
| race_source_value | -- | |
| race_source_concept_id | -- | |
| ethnicity_source_value | ethnicde | |
| ethnicity_source_concept_id | -- |