Changes between Version 12 and Version 13 of LEGACY - i2b2OntologyCRC-1
- Timestamp:
- 02/21/11 15:27:09 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
LEGACY - i2b2OntologyCRC-1
v12 v13 24 24 Yet 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?[[br]] 25 25 26 By comparison with the observation_fact table in the CRC cell: 27 * select count(*) from observation_fact where valtype_cd like '%T%' ===> returns 5055 28 * select count(*) from observation_fact where valtype_cd like '%N%' ===> returns 23731 29 26 30 === Facts constrained by enumerated concepts === 27 31 Facts can be constrained by simply pointing at a concept row within the concept_dimension table with very little else alongside it. For example, a numeric value like AGE can be divided into an enumeration of concepts, say one for each age from 0 to 114, as is the demo system. Here is a selection based upon this:
