Changes between Version 10 and Version 11 of LEGACY - i2b2OntologyCRC-1


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

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - i2b2OntologyCRC-1

    v10 v11  
    2828 select * from observation_fact where concept_cd like 'DEM|AGE:50' ;[[br]]
    2929
    30 This retrieved 3 rows from the fact table:
     30This retrieved 3 rows of patients aged 50 from the fact table:
    3131||= 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 =||
    3232|| 2005000014 ||  1000000014 || DEM|AGE:50 || @ || 22-MAY-06 || @ || @ || -  || -  || -  || -  || -  || @ || 25-APR-07 || @ || -  || -  || 25-APR-07 || 25-APR-07 || 25-APR-07 || DEMOGRAPH|DEMO || - ||
    3333|| 2005000082 || 1000000082 || DEM|AGE:50 || @ || 25-MAY-06 || @ || @ || -  || -  || -  || -  || -  || @ || 25-APR-07 || @ || -  || -  || 25-APR-07 || 25-APR-07 || 25-APR-07 || DEMOGRAPH|DEMO || - ||
    3434|| 2005000095 || 1000000095 || DEM|AGE:50 || @ || 05-MAY-07 || @ || @ || -  || -  || -  || -  || -  || @ || 25-APR-07 || @ || -  || -  || 25-APR-07 || 25-APR-07 || 25-APR-07 || DEMOGRAPH|DEMO || - ||
     35