Skip to content

ICD10fi cancer metastasis codes C7[789] mapped to nonstandard targets #26

@ahammais

Description

@ahammais

In FinOMOP release v2.1.0, the Finnish ICD10fi codes C7[789] are mapped to nonstandard targets. These non-standard SNOMED codes are mapped to Cancer Modifier concepts in Athena, so automatic remapping should have been possible but did not happen for some reason.

The source concepts in question are found by the following query:

select c.concept_id as source_concept_id, c.vocabulary_id as source_vocabulary_id, c.concept_code as source_code,
c2.concept_id as target_concept_id, c2.vocabulary_id as target_vocabulary_id,
c2.standard_concept as target_is_standard_concept
from concept as c
inner join concept_relationship as cr on c.concept_id = cr.concept_id_1 and cr.relationship_id = 'Maps to'
inner join concept as c2 on cr.concept_id_2 = c2.concept_id
where c.vocabulary_id in( 'ICD10fi')
and c.concept_code ~* 'C7[789]'
order by c.concept_code;

Result:

Image

Metadata

Metadata

Assignees

Labels

bugSomething isn't workinggood first issueGood for newcomers

Type

No type

Projects

Status

🔍 In Review

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions