Changes between Version 4 and Version 5 of LEGACY - i2b2OntologyCRC-1


Ignore:
Timestamp:
02/21/11 13:04:01 (13 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - i2b2OntologyCRC-1

    v4 v5  
    1515
    1616=== In an Ontology table, what does c_columndatatype really mean? ===
    17 The docs state: "either ‘T’ for text or ‘N’ for numeric and describes the datatype of the concept". Yet the lentgh of the column is varchar 50.[[br]]
     17The docs state: "either ‘T’ for text or ‘N’ for numeric and describes the datatype of the concept". Yet the length of the column is varchar 50.[[br]]
    1818
    1919Within the demo project:
    … …  
    2121   * select count(*) from i2b2 where c_columndatatype like '%T%' ===> returns 134762
    2222   * select count(*) from i2b2 ===> returns 134762
     23
     24Yet within the query tool (from the Workbench) I can select terms from a Labtest and constrain by value. This is undoubtedly possible because of the optional metadataxml column. But even so, what '''''does''''' c_columndatatype really mean?