OHDSI Home | Forums | Wiki | Github

Should ICD9CM 'V code' mapping to different domains go to different corresponding tables?

Vocabulary Users
#1

According to CDM wiki (https://github.com/OHDSI/CommonDataModel/wiki/Data-Model-Conventions)
“…For example, ICD-9-CM codes, which contain mostly diagnoses of human disease, also contain information about the status of patients having received a procedure: V25.5 “Encounter for insertion of implantable subdermal contraceptive” defines a procedure and is therefore stored in the PROCEDURE_OCCURRENCE table.”
My query to look up example v codes’ CDM Standard concept id:

select c1.concept_id as source_concept_id
, c1.domain_id as source_concept_domain
, c1.concept_code as source_concept_code
, c1.concept_name source_concept_name
, c2.concept_id as target_concept_id
, c2.domain_id as target_concept_domain
, c2.concept_code as target_concept_code
, c2.concept_name target_concept_name
from concept c1
join concept_relationship r on r.concept_id_1=c1.concept_id and r.invalid_reason is null and r.relationship_id=‘Maps to’
join concept c2 on c2.concept_id=r.concept_id_2
where c1.vocabulary_id = ‘ICD9CM’
and c1.concept_code in (‘V54.15’,‘V55.1’,‘V71.81’,‘V12.61’)
and c2.standard_concept =‘S’
order by c1.concept_code;

Does target concept’s domain play a role to decide which destination table that ICD9CM V codes go to? For example: the above example ICD9CM V codes are mapped to different target concept domains: Observation, Procedure, and Condition (which may or may not be the same as their source concept domain). Does it mean the V codes should be loaded to OBSERVATION, PROCEDURE_OCCURRENCE, and CONDITION_OCCURRENCE respectively?

#2

Yes, the target concept domain determines where the record should go. From
your example the V codes should be loaded in Observation,
Procedure_Occurrence and Condition_Occurrence.

#3

@yulingjiang:

You got it. That’s exactly how it works.

#4

@Christian_Reich @DTorok
A follow up question: when there multiple target domains returned from one source code, do we pick one destination table or load all?
Example:
V30.01 . (Single liveborn, born in hospital, delivered by cesarean section ) --> mapped to both Observation and Condition
V51.0 (Encounter for breast reconstruction following mastectomy) --> mapped to both Procedure and Observation

#5

@yulingjiang. You would map to both. Create a record for each domain with the corresponding standard code.

t