Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Informatics for Integrating Biology and the Bedside






i2b2 Design Document
Ontology Management (ONT) Cell







Document Version:

1.7.1

i2b2 Software Version:

1.7.00




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



  • No labels