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


Ignore:
Timestamp:
02/21/11 12:53:16 (14 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - i2b2OntologyCRC-1

    v3 v4  
    1313
    1414The totals are 93844 as opposed to 73590. Why is there a difference and what does it mean?
     15
     16=== In an Ontology table, what does c_columndatatype really mean? ===
     17The 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]]
     18
     19Within the demo project:
     20   * select count(*) from i2b2 where c_columndatatype like '%N%' ===> returns 0
     21   * select count(*) from i2b2 where c_columndatatype like '%T%' ===> returns 134762
     22   * select count(*) from i2b2 ===> returns 134762