OHDSI / OncologyWG

Oncology Working Group Repository
https://ohdsi.github.io/OncologyWG
Apache License 2.0
53 stars 24 forks source link

cancer modifier 'variable concept id' causing grade values not to get ETLed #642

Open tfalcs opened 2 months ago

tfalcs commented 2 months ago

There seems to be two values for 'variable concept id' (referenced in link below) - one for the NAACCR vocabulary and a second for the Cancer Modifier vocabulary. When the value of the NAACCR vocabulary is used, Grade values get imported into MEASUREMENT. However, when the value of the Cancer Modifier vocab gets used for the mapping, any grade values associated with that mapping do not get imported into MEASUREMENT.

https://github.com/OHDSI/OncologyWG/blob/06b9da6cde36dbac626148323ad4ee181e032167/etl/naaccr_etl_sqlserver.sql#L1173