Changes between Version 7 and Version 8 of LEGACY - i2b2OntologyCRC-1

Timestamp:

02/21/11 14:39:23 (14 years ago)

Author:

jeff.lusted

Comment:

--

LEGACY - i2b2OntologyCRC-1

@@ -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]]
 
-The following point may be of some relevance...
-
 === Facts constrained by enumerated concepts ===
+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:
+ select * from observation_fact where concept_cd like 'DEM|AGE:50' ;