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

Timestamp:

02/21/11 14:41:34 (14 years ago)

Author:

jeff.lusted

Comment:

--

LEGACY - i2b2OntologyCRC-1

@@ -26 +26 @@
 === 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' ;
+ select * from observation_fact where concept_cd like 'DEM|AGE:50' ;[[br]]
+
+This retrieved 3 rows from the fact table: 
+ENCOUNTER_NUM   PATIENT_NUM     CONCEPT_CD      PROVIDER_ID     START_DATE      MODIFIER_CD     VALTYPE_CD      TVAL_CHAR       NVAL_NUM        VALUEFLAG_CD    QUANTITY_NUM    INSTANCE_NUM    UNITS_CD        END_DATE        LOCATION_CD     CONFIDENCE_NUM  OBSERVATION_BLOB        UPDATE_DATE     DOWNLOAD_DATE   IMPORT_DATE     SOURCESYSTEM_CD UPLOAD_ID
+2005000014      1000000014      DEM|AGE:50      @       22-MAY-06       @       @       -       -       -       -       -       @       25-APR-07       @       -       -       25-APR-07       25-APR-07       25-APR-07       DEMOGRAPH|DEMO  -
+2005000082      1000000082      DEM|AGE:50      @       25-MAY-06       @       @       -       -       -       -       -       @       25-APR-07       @       -       -       25-APR-07       25-APR-07       25-APR-07       DEMOGRAPH|DEMO  -
+2005000095      1000000095      DEM|AGE:50      @       05-MAY-07       @       @       -       -       -       -       -       @       25-APR-07       @       -       -       25-APR-07       25-APR-07       25-APR-07       DEMOGRAPH|DEMO  -