Create list of SNOMED grade concepts to destandardize

[kzollove]

See: https://athena.ohdsi.org/search-terms/terms/4160340 (Histologic grade of neoplasm) and https://athena.ohdsi.org/search-terms/terms/4297708 (finding of grade) and https://athena.ohdsi.org/search-terms/terms/4077696 (histologic grade)

select *
from prod.concept c
inner join prod.concept_ancestor ca 
on c.concept_id =ca.descendant_concept_id 
and (ca.ancestor_concept_id = 4077696
or ca.ancestor_concept_id = 4297708
or ca.ancestor_concept_id = 4160340)

[kzollove]

All concepts I've id'ed to be destandardized at this point:

concept_SNOMEDtoCM_grade.csv

[kzollove]

Missed a lot of standard SNOMED gleason grade score and gleason grade groups. Updated (and properly named) file:

grade_SNOMED.csv

[kzollove]

Reupload list with concept_codes quoted (to avoid truncation)

grade_SNOMED.csv