Data Repository (CRC) 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
Data Repository (CRC) 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
Data Repository (CRC) Cell
DATA PERMISSION
DEFINITION OF TERMS
I2B2 DATA MART
I2B2 DATA MART TABLES
CODE_LOOKUP Table
CONCEPT_DIMENSION Table
ENCOUNTER_MAPPING Table
General Information
Joining Columns
MODIFIER_DIMENSION Table
OBSERVATION_FACT Table
Example of Value Constraints Used in Queries
Value Columns
PATIENT_DIMENSION Table
PATIENT_MAPPING Table
PROVIDER_DIMENSION Table
VISIT_DIMENSION Table
INTRODUCTION
OBSERVATION FACT SCENARIOS
Use Case 1_ Replace old facts with new facts
Use Case 2_ Add new facts
PATIENT AND EVENT MAPPING SCENARIOS
Handling Existing Values
Use Case 1_ Hive id found but _patient_map_id_ is not mapped
Use Case 2_ Patient id, num and map_ids are not mapped
Use Case 3_ PATIENT_NUM in mapping table but with a different date
Use Case 4_ _patient_ without a HIVE number
Invalid XML
Use Case 1_ _pid_ without a PATIENT_ID)
New Mappings - Adding New Values
Use Case 1_ Create new entry if PID not found
Use Case 2_ Create new entry if patient does not exist
Use Case 3_ Create new entry if hive entry does not exist for a patient
Self-Mapping
PATIENT DATA OBJECT
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": 793, "requestCorrelationId": "2ad234a0969d5abf"}