Informatics for Integrating Biology and the Bedside






i2b2 Design Document
Ontology Management (ONT) Cell

Table of Contents
Document Management
1. Introduction
2. Relationship of the i2b2 Ontology star Schema
2.1. Data Storage
2.2. Ontology Table
2.3. Definition of Fields in the Ontology Table
2.3.1. _C_HLEVEL_
2.3.2. _C_FULLNAME_
2.3.3. _C_NAME_
2.3.4. _C_SYNONYM_CD_
2.3.5. _C_VISUALATTRIBUTES_
2.3.6. _C_TOTALNUM_
2.3.7. _C_BASECODE_
2.3.8. _C_METADATAXML_
2.3.9. _C_FACTTABLECOLUMN_
2.3.10. _C_TABLENAME_
2.3.11. _C_COLUMNNAME_
2.3.12. _C_COLUMNDATATYPE_
2.3.13. _C_OPERATOR_
2.3.14. _C_DIMCODE_
2.3.15. _C_COMMENT_
2.3.16. _C_TOOLTIP_
2.3.17. UPDATE_DATE
2.3.18. DOWNLOAD_DATE
2.3.19. IMPORT_DATE
2.3.20. SOURCESYSTEM_CD
2.3.21. VALUETYPE_CD
2.3.22. _M_APPLIED_PATH_
2.3.23. _M_EXCLUSION_CD_
2.3.24. _C_PATH_
2.3.25. _C_SYMBOL_
3. Sample Ontology Queries
3.1. Query Sample for Diagnoses
3.2. Query Sample for Problems
3.3. Query Sample for Labs