c_metadataxml

A nullable column within the ontology table used to store extra information about the concept in xml format. Currently used to describe value metadata associated with a lab finding.

A fuller explanation is given in the accompanying document; see MetadataXML Column Format.. This requires careful reading. The use of this column has expanded from v1.5 to v1.6 of i2b2.

Interestingly, here is an example of its use applied to integer values other than lab results...

From: Larry Errecart [larry.errecart@ucdmc.ucdavis.edu]
Sent: 03 March 2011 20:22
To: Holden, Nick
Subject: Re: Integer values in i2b2 data other than lab users

We 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:

<?xml version="1.0"?>
<ValueMetadata>
	<Version>3.02</Version>
	<CreationDateTime>12/15/2009 11:22:19</CreationDateTime>
	<TestID>SYSTOLIC</TestID>
	<TestName>SYSTOLIC</TestName>
	<DataType>PosInteger</DataType>
	<CodeType>GRP</CodeType>
	<Loinc>99999-9</Loinc>
	<Flagstouse>HL</Flagstouse>
	<Oktousevalues>Y</Oktousevalues>
	<MaxStringLength></MaxStringLength>
	<LowofLowValue>50</LowofLowValue>
	<HighofLowValue>90</HighofLowValue>
	<LowofHighValue>140</LowofHighValue>
	<HighofHighValue>230</HighofHighValue>
	<LowofToxicValue></LowofToxicValue>
	<HighofToxicValue></HighofToxicValue>
	<EnumValues></EnumValues>
	<CommentsDeterminingExclusion>
		<Com></Com>
	</CommentsDeterminingExclusion>
	<UnitValues>
		<NormalUnits>mm/Hg</NormalUnits>
		<EqualUnits> mm/Hg </EqualUnits>
		<ExcludingUnits></ExcludingUnits>
		<ConvertingUnits>
			<Units></Units>
			<MultiplyingFactor></MultiplyingFactor>
		</ConvertingUnits>
	</UnitValues>
	<Analysis>
		<Enums />
		<Counts />
		<New />
	</Analysis>
</ValueMetadata>

larry