Ontology Management (ONT) Cell - Server (Cells) Design - i2b2 Community Wiki
assistive.skiplink.to.breadcrumbs
assistive.skiplink.to.header.menu
assistive.skiplink.to.action.menu
assistive.skiplink.to.quick.search
Server (Cells) Design
Space shortcuts
Space Tools
Overview
Content Tools
tachments (1)
Page History
Page Information
Resolved comments
View in Hierarchy
View Source
Export to PDF
Export to Word
Copy
Skip to end of banner
Jira links
Go to start of banner
Ontology Management (ONT) Cell
Server (Cells) Design
ServerSideDesign
Created by
user-47db1
, last modified on
Sep 04, 2018
Informatics for Integrating Biology and the Bedside
i2b2 Design Document
Ontology Management (ONT) Cell
INTRODUCTION-
RELATIONSHIP OF THE I2B2 ONTOLOGY STAR SCHEMA
Data Storage
Definition of Fields in the Ontology Table
C_BASECODE
C_COLUMNDATATYPE
C_COLUMNNAME
C_COMMENT
C_DIMCODE
C_FACTTABLECOLUMN
C_FULLNAME
C_HLEVEL
C_METADATAXML
C_NAME
C_OPERATOR
C_PATH
C_SYMBOL
C_SYNONYM_CD
C_TABLENAME
C_TOOLTIP
C_TOTALNUM
C_VISUALATTRIBUTES
DOWNLOAD_DATE
IMPORT_DATE
M_APPLIED_PATH
M_EXCLUSION_CD
SOURCESYSTEM_CD
UPDATE_DATE
VALUETYPE_CD
Ontology Table
SAMPLE ONTOLOGY QUERIES
Query Sample for Diagnoses
Query Sample for Labs
Query Sample for Problems
Document Version:
1.7.1
i2b2 Software Version:
1.7.00
No labels
Pages
Recently updated
Project Setup
updated Jan 10, 2023
view change
Value Columns
commented May 28, 2021
ENCOUNTER_MAPPING Table
commented Feb 12, 2021
OBSERVATION_FACT Table
updated Jul 15, 2020
view change
VISIT_DIMENSION Table
updated Jul 15, 2020
view change
Show More
Server (Cells) Design
ServerSideDesign
i2b2 tranSMART Foundation
Upcoming Events
News
Community Resources
Accrual to Clinical Trial (ACT)
i2b2 Working Groups
i2b2 Development
Release Management
i2b2 Repositories
Development Tracking System (JIRA)
Atlassian Confluence
7.19.19
and the
Enterprise Theme
by
bitvoodoo
{"serverDuration": 118, "requestCorrelationId": "9adac13682d66958"}