Changes between Version 15 and Version 16 of Onyx to PDO


Ignore:
Timestamp:
05/09/15 13:37:17 (9 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Onyx to PDO

    v15 v16  
    22This is a discussion document and work in progress.
    33
    4 Detailed below are the assumptions underlying importing facts from the BRICCS questionnaire into i2b2. The primary focus here is on participant data. All assumptions are open for discussion.
     4Detailed below are the assumptions underlying importing facts from the [[BRICCS Study]] questionnaire into i2b2. The primary focus here is on participant data. All assumptions are open for discussion.
    55
    66=== The Target : i2b2 CRC Cell ===
     
    2323The '''__patient mapping__''' maps external identifiers (eg: s-number or bpt-number) to an internal i2b2 patient identifier. The favoured way of populating this is via the web service that invokes the CRC loader facility. The alternative is to use a manually supplied number. Either way, the contents of this is relatively uncontroversial.
    2424
    25 The '''__event mapping__''' (or visit mapping or encounter mapping) maps external identifiers of a visit to an internal i2b2 event identifier. The latter internal event identifier is similarly uncontroversial to the patient mapping (see above). But the external identifier is a somewhat hazy idea. What constitutes a unique identifier for an event in the BRICCS questionnaire (or for that matter a pathology test)?
     25The '''__event mapping__''' (or visit mapping or encounter mapping) maps external identifiers of a visit to an internal i2b2 event identifier. The latter internal event identifier is similarly uncontroversial to the patient mapping (see above). But the external identifier is a somewhat hazy idea. What constitutes a unique identifier for an event in the [[BRICCS Study]] questionnaire (or for that matter a pathology test)?
    2626
    2727That leaves just three tables to consider, and these are the main ones:
    2828
    29 The '''__visit dimension__'''  holds one row for every visit/encounter/event that a patient is involved in. What is an event with respect to the BRICCS questionnaire? Currently, the process creates just one event for each participant in the questionnaire.
     29The '''__visit dimension__'''  holds one row for every visit/encounter/event that a patient is involved in. What is an event with respect to the [[BRICCS Study]] questionnaire? Currently, the process creates just one event for each participant in the questionnaire.
    3030
    3131The '''__patient dimension__'''  holds one row for every patient (ie: for every participant interviewed in the questionnaire).