OHDSI Home | Forums | Wiki | Github

Do you map errors from the source database?

CDM Builders
,
#1

Hi all,

I am mapping conditions from my source database in ICD9/10 code to standard concept_ids (SNOMED). Some of the ICD codes are actually measurement/procedures/observations so they shouldn’t have been on the conditions table. For example, ‘790.1’ is the ICD9CM code for ‘Elevates Sedimentation Rate’, which is technically a Measurement but the clinician input it as a condition. Should I exclude or include these values? Could they affect future studies? I would deeply appreciate your assistance!

#2

Hi,
one of the ground rules of CDM tables population is to fill them based on a domain of a standard concept (snomed int this case), not on a source concept domain (ICD9/10). So 790.1 will go to OBSERVATION table (as it’s actually the result of a measurement). And there are mappings from ICD9/10 in concept_relationship table. Don’t you want to use them not to do the whole work again?

t