i2b2 Developer's Forum
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

c_fullname

c_name

c_basecode

Diagnoses| Diagnoses

 

Diagnoses\Respiratory disorders|\

Respiratory disorders

 

Diagnoses\Respiratory disorders\asthma|\

Asthma

ICD9:493

Diagnoses\Respiratory disorders\COPD|\

Emphysema

ICD9:492


Now, to add the modifiers, mild, moderate and severe, we add the new column, m_applied_path to the ontology table, and three new rows, one for each modifier: 

m_applied_path

c_fullname

c_name

c_basecode

@

Diagnoses|\

Diagnoses

 

@

Diagnoses\Respiratory disorders|\

Respiratory disorders

 

@

Diagnoses\Respiratory disorders\asthma|\

Asthma

ICD9:493

@

Diagnoses\Respiratory disorders\COPD|\

Emphysema

ICD9:492

Diagnoses\Respiratory disorders%

\severe|\

Severe

MOD:SEVER

Diagnoses\Respiratory disorders%

\moderate|\

Moderate

MOD:MODER

Diagnoses\Respiratory disorders%

\mild|\

Mild

MOD:MILD


The field m_applied_path indicates which paths the associated modifier refers to.  The '%' wild card is used to indicate that the modifier refers to all extensions to the path 'Diagnoses\Respiratory disorders\'
© Shawn Murphy 2011