Changes between Version 48 and Version 49 of LEGACY - i2b2OntologyCRC-1
- Timestamp:
- 02/24/11 10:03:02 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
LEGACY - i2b2OntologyCRC-1
v48 v49 122 122 I 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]] 123 123 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.124 Take 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: 125 125 126 126 ||= C_HLEVEL =||= C_FULLNAME =||= C_NAME =||= C_SYNONYM_CD =||= C_VISUALATTRIBUTES =||= C_TOTALNUM =||= C_BASECODE =||= C_METADATAXML =||= C_FACTTABLECOLUMN =||= C_TABLENAME =||= C_COLUMNNAME =|| … … 130 130 131 131 The '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 === 134 This is partly related to the previous point, so also concerns ontology entries! And I'm finding this quite confusing.[[br]] 135 136 There are 16 people in the demo system who are Jewish. I won't display all rows... [[br]] 137 138