Changes between Version 13 and Version 14 of i2b2 Data Import Pathology Mapping v2


Ignore:
Timestamp:
04/17/13 11:28:59 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import Pathology Mapping v2

    v13 v14  
    5656I think this information is stored in the table MICRO_ANTIBIOTICS, which is linked to the MICRO_ORGANISMS table using the column Micro_organisms, which in turn is linked to the MICRO_TESTS table using the Micro_Tests column.  I THINK!
    5757
     58In the MICRO_ANTIBIOTICS table there are 73 values for the Antibiotic_Code.  There are also 4 values for the Interpreted_Sensitivity_Result column, whose meaning I can guess at:
     59
     60||= Interpreted_Sensitivity_Result =||= Guessed Meaning =||= Actual Meaning =||
     61|| NULL || Not recorded || ||
     62|| I || Indeterminate? || ||
     63|| R || Resistant? || ||
     64|| S || Susceptible || ||
     65
     66
     67
    5868=== Histology
    5969