Convention need for how/where to store > 1 race or ethnicity concept_id

OHDSI / Themis

Repository for OMOP CDM conventions as defined by THEMIS. These can be reference lists of concepts, pieces of standardized code for data generation or quality certification, and debates.

Apache License 2.0

27 stars 8 forks source link

Convention need for how/where to store > 1 race or ethnicity concept_id #71

Open MelaniePhilofsky opened 1 year ago

MelaniePhilofsky commented 1 year ago

From this forum post.

sarahmul commented 12 months ago

Has a solution for this been discussed/fixed?

MelaniePhilofsky commented 12 months ago

No, it needs a sponsor to take it through the Themis process found on the home page of this Git

aostropolets commented 4 months ago

Consensus recommendations from the Vocabulary WG that were collectively voted for (recording here):

Keep one race and ethnicity (if present) in race_concept_id and ethnicity_concept_id in PERSON table Keep all additional races and ethnicities and/or any longitudinal changes in OBSERVATION table. Provenance of the record can be captured through observation_type_concept_id. ETLers chose which race to put in OBSERVATION themselves and which date to used based on their knowledge of the data.
Vocabularies do not deduplicate races to allow greater flexibility given lack of consensus in terms. One can add other races and ethnicities to the OHDSI Vocabularies as long as they are not full duplicates of existing races.
No flavors of NULL are permitted, as usual. If race is unknown or not reported it is 0.

MelaniePhilofsky commented 3 months ago

Tagging @cgreich to finalize the details.

cgreich commented 3 months ago

Мakes sense to me. Let's build the vocabulary from the various national sources, and let's write up the Themis convention about the various scenarios (more than one race, mixed race, race changing over time).

clarkevans commented 2 months ago

For cases where there are >1 race or ethnicity, how do you pick which one is privileged and goes into the person table?

An alternative would be to not choose, and use 0.

aostropolets commented 2 months ago

The proposal gives the ETLer the authority to chose the race that goes to person/observation based on their unique expertise in local data.

MelaniePhilofsky commented 2 months ago

Hello @clarkevans,

Themis needs to finalize the details, document the conventions and publish them. Let me put this topic on the Themis WG agenda. I'll announce it on the OHDSI forums and MS Teams.