cladteam / CCDA_OMOP_by_Python

2 stars 3 forks source link

compare old and new vocabulary mappings #142

Open chrisroederucdenver opened 2 weeks ago

chrisroederucdenver commented 2 weeks ago

I compared the older map we had been using with the maps from Tanner. Have a look and get with @tannerzhang to reconcile. This could be bad mapping on my part. It could be unused mappings, though I recall building this map as concepts were needed. The last two, the ones that map to 9202 are clearly where Tanner has a better mapping.

NUCC code

These don't seem to be in the codemap_xwalk, and not ccda_value_set_mapping_table_dataset either.

2.16.840.1.113883.6.101, 163W00000X --> 38003716 Provider NOT FOUND codemap code mapped:"0" domain:"Observation" *** failure was found but not mapped the same by the CODEM table 163W00000X

2.16.840.1.113883.6.101, 207QA0505X --> 38003854 Provider NOT FOUND codemap code mapped:"0" domain:"Observation" *** failure was found but not mapped the same by the CODEM table 207QA0505X

2.16.840.1.113883.6.101, 207R00000X --> 38003860 Provider NOT FOUND codemap code mapped:"0" domain:"Observation" *** failure was found but not mapped the same by the CODEM table 207R00000X

2.16.840.1.113883.6.101, 207RC0000X --> 38003865 Provider NOT FOUND codemap code mapped:"0" domain:"Observation" *** failure was found but not mapped the same by the CODEM table 207RC0000X

2.16.840.1.113883.6.101, 208D00000X --> 38004022 Provider NOT FOUND codemap code mapped:"0" domain:"Observation" *** failure was found but not mapped the same by the CODEM table 208D00000X

2.16.840.1.113883.6.101, 261QP2300X --> 38004247 Visit NOT FOUND codemap code mapped:"0" domain:"Observation"

CDCREC See #147 2.16.840.1.113883.6.238

These are in the ccda_value_set_mapping_table_dataset, but with a different OID 2.16.840.1.113883.5.104

2.16.840.1.113883.6.238, 2076-8 --> 8557 Race NOT FOUND codemap code mapped:"0" domain:"Observation"

2.16.840.1.113883.6.238, 2106-3 --> 8527 Race NOT FOUND codemap code mapped:"0" domain:"Observation" *** failure was found but not mapped the same by the CODEM table 2106-3

2.16.840.1.113883.6.238, 2186-5 --> 38003564 Ethnicity NOT FOUND codemap code mapped:"0" domain:"Observation"

SNOMED codes describing a section: NOT NEEDED

2.16.840.1.113883.6.96, 409586006 --> 4260179 Observation NOT FOUND codemap code mapped:"37158809" domain:"Observation"

2.16.840.1.113883.6.96, 46680005 --> 4263222 Measurement NOT FOUND codemap code mapped:"4181663" domain:"Observation"

POOR CHOICE of code for test data see #153 (not on Vocab Team)

2.16.840.1.113883.6.96, 95971004 --> 3299517 Observation NOT FOUND codemap code mapped:"0" domain:"Observation"

PHIN VADS CDC vocabulary see #149 and #72

2.16.840.1.113883.6.12, 99212 --> 2414396 Observation NOT FOUND codemap code mapped:"9202" domain:"Visit"

2.16.840.1.113883.6.12, 99213 --> 2414397 Observation NOT FOUND codemap code mapped:"9202" domain:"Visit" source:124, valueset:2/2, codemap:108/122

chrisroederucdenver commented 2 weeks ago

messages above from running the prototype_2.test.compare_maps unit test. The script bin/test.sh runs a handful of them. This one is last.