| Version 5 (modified by , 13 years ago) ( diff ) |
|---|
Onyx to PDO
This is a discussion document and work in progress.
Detailed below are the assumptions underlying importing facts from the BRICCS questionnaire into i2b2. All assumptions are open for discussion.
The Target : i2b2 CRC Cell
The data from an Onyx export will eventually end up in the main i2b2 data warehouse, otherwise known as the CRC cell. The CRC cell has eight tables in which to store data:
- Observation facts
- Patient dimension
- Visit dimension
- Patient mapping
- Event mapping
- Concept dimension
- Provider dimension
- Code lookup
The concept dimension can be considered immaterial to importing onyx data into i2b2 on a routine basis. The assumption here is that the concept dimension should be in synch with the ontology cell where the main ontology data is held. Currently, this assumption is safeguarded by previous steps in the process which updates both the ontology cell and the ontology dimension before we import any participant data.
The code lookup is a lookup table. Basically a code to description mapping (eg, LCBRU : Leicester Cardiovascular Biomedical Research Unit). Currently no attempt is made to populate the lookup table: it is empty. The code lookup table is considered here to be a minor issue.
