Changes between Version 1 and Version 2 of i2b2 Ontology c_metadataxml Column


Ignore:
Timestamp:
07/14/11 08:32:28 (13 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Ontology c_metadataxml Column

    v1 v2  
    22A nullable column within the ontology table used to store extra information about the concept in xml
    33format. Currently used to describe value metadata associated with a lab finding.
     4
     5A fuller explanation is given in the accompanying document; see [raw-attachment:MetadataXML-documentation.txt MetadataXML Column Format.]. This requires careful reading. The use of this column has expanded from v1.5 to v1.6 of i2b2.
     6
     7Interestingly, here is an example of its use applied to integer values other than lab results...
     8
     9{{{
     10From: Larry Errecart [larry.errecart@ucdmc.ucdavis.edu]
     11Sent: 03 March 2011 20:22
     12To: Holden, Nick
     13Subject: Re: Integer values in i2b2 data other than lab users
     14
     15We have blood pressure and BMI loaded and had to emulate the xml in the lab records to  enable the "set value" function.  Here's our c_metadataxml entry for systolic:
     16
     17<?xml version="1.0"?>
     18<ValueMetadata>
     19        <Version>3.02</Version>
     20        <CreationDateTime>12/15/2009 11:22:19</CreationDateTime>
     21        <TestID>SYSTOLIC</TestID>
     22        <TestName>SYSTOLIC</TestName>
     23        <DataType>PosInteger</DataType>
     24        <CodeType>GRP</CodeType>
     25        <Loinc>99999-9</Loinc>
     26        <Flagstouse>HL</Flagstouse>
     27        <Oktousevalues>Y</Oktousevalues>
     28        <MaxStringLength></MaxStringLength>
     29        <LowofLowValue>50</LowofLowValue>
     30        <HighofLowValue>90</HighofLowValue>
     31        <LowofHighValue>140</LowofHighValue>
     32        <HighofHighValue>230</HighofHighValue>
     33        <LowofToxicValue></LowofToxicValue>
     34        <HighofToxicValue></HighofToxicValue>
     35        <EnumValues></EnumValues>
     36        <CommentsDeterminingExclusion>
     37                <Com></Com>
     38        </CommentsDeterminingExclusion>
     39        <UnitValues>
     40                <NormalUnits>mm/Hg</NormalUnits>
     41                <EqualUnits> mm/Hg </EqualUnits>
     42                <ExcludingUnits></ExcludingUnits>
     43                <ConvertingUnits>
     44                        <Units></Units>
     45                        <MultiplyingFactor></MultiplyingFactor>
     46                </ConvertingUnits>
     47        </UnitValues>
     48        <Analysis>
     49                <Enums />
     50                <Counts />
     51                <New />
     52        </Analysis>
     53</ValueMetadata>
     54
     55larry
     56}}}
     57