| 14 | | [raw-attachment:MetadataXML-documentation.txt MetadataXML Column Format.] |
| 15 | | The Ontology table within the Ontology cell contains an optional column c_metadataxml. The design document for the Ontology Cell states in sum total: |
| 16 | | {{{ |
| 17 | | c_metadataxml is an optional field to store extra information about the concept in xml |
| 18 | | format. It is currently used to describe value metadata associated with a lab finding. |
| 19 | | }}} |
| 20 | | The attached document is a valuable addition. To my mind (Jeff), the use of this column extends beyond lab findings to any column which can contain a variable amount. |
| 21 | | |
| 22 | | {{{ |
| 23 | | From: Larry Errecart [larry.errecart@ucdmc.ucdavis.edu] |
| 24 | | Sent: 03 March 2011 20:22 |
| 25 | | To: Holden, Nick |
| 26 | | Subject: Re: Integer values in i2b2 data other than lab users |
| 27 | | |
| 28 | | 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: |
| 29 | | |
| 30 | | <?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> |
| 31 | | |
| 32 | | larry |
| 33 | | }}} |
| | 14 | Contents removed. Now see [[c_metadataxml]] |
