i2b2 Developer's Forum
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

In the Observation_fact table of the Clinical Research Chart of i2b2, the following columns are used to describe values associated with concepts:

     ValueType     ValType_CD (Varchar(50))

     NVal_num (number)

...

Values are defined according to the ValueTypeValType_CD column, which can be construed as an identifier for the type of value object that fills out the rest of the above columns.   There are two identifiers that are used for medication modifiers:

...

MaxStringLength will contain a postitive integer or 0, representing the longest acceptable string length, if the datatype is "string".

LowofLowReference LowofLowValue specifies the lowest of the low range values for PosInteger, Integer, Float, and PosFloat datatypes.

HighofLowReference HighofLowValue specifies the highest of the low range values for PosInteger, Integer, Float, and PosFloat datatypes.

LowofHighReference LowofHighValue specifies the lowest of the high range values for PosInteger, Integer, Float, and PosFloat datatypes.

HighofHighReference HighofHighValue specifies the highest of the high range values for PosInteger, Integer, Float, and PosFloat datatypes.

LowofToxicReference LowofToxicValue specifies the lowest of the toxic range values for PosInteger, Integer, Float, and PosFloat datatypes.

HighofToxicReference HighofToxicValue specifies the highest of the toxic range values for PosInteger, Integer, Float, and PosFloat datatypes (rarely used).

...

               <Units>mg/15ml</Units>

               <MultiplyingFactor>15<               <MultiplyingFactor>0.066</MultiplyingFactor>

          </ConvertingUnits>

...

               <Units>mg/5ml</Units>

               <MultiplyingFactor>5<               <MultiplyingFactor>0.2</MultiplyingFactor>

          </ConvertingUnits>

...