Changes between Version 48 and Version 49 of LEGACY - i2b2OntologyCRC-1


Ignore:
Timestamp:
02/24/11 10:03:02 (14 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • LEGACY - i2b2OntologyCRC-1

    v48 v49  
    122122I was having difficulty making sense of some entries in an ontology table within the Ontology cell and their relationship with the patient_dimension table within the CRC cell. And discovered this. [[br]]
    123123
    124 Take the religion "Jewish". In the ontology display this looks like a bottom leaf. It isn't. The following three rows (some columns excluded) are relevant.
     124Take the religion "Jewish". In the ontology display this looks like a bottom leaf. It isn't. The following three rows from the ontology table i2b2 (some columns excluded) are relevant:
    125125
    126126||= C_HLEVEL =||= C_FULLNAME =||= C_NAME =||= C_SYNONYM_CD =||= C_VISUALATTRIBUTES =||= C_TOTALNUM =||= C_BASECODE =||= C_METADATAXML =||= C_FACTTABLECOLUMN =||= C_TABLENAME =||= C_COLUMNNAME =||
     
    130130
    131131The 'LH' setting flags that there are hidden leaves. The 'MA' setting flags that this is not a bottom leaf and has hidden leaves below it. The upshot is that there are two codes relevant to being "Jewish": "DEM|RELIGION:jewish" and "DEM|RELIGION:jh". What you see in the Ontology tree is the 'MA' entry.
     132
     133=== The code_lookup, patient_dimension and observation_fact tables within the CRC cell ===
     134This is partly related to the previous point, so also concerns ontology entries! And I'm finding this quite confusing.[[br]]
     135
     136There are 16 people in the demo system who are Jewish. I won't display all rows... [[br]]
     137
     138