Changes between Version 11 and Version 12 of Onyx to PDO


Ignore:
Timestamp:
01/11/12 08:11:48 (13 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Onyx to PDO

    v11 v12  
    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. All assumptions are open for discussion.
     4Detailed 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.
    55
    66=== The Target : i2b2 CRC Cell ===
     
    3232
    3333The '''__observation facts__''' holds one row for every fact (deemed sensible to include) that has been gleaned about a participant from the questionnaire.
     34
     35Each observation fact points to a patient and a visit: these are part of the observation fact's primary key. All three main tables have dates:
     36
     37||= observation fact =|| start date || end date ||
     38||= visit dimension =|| start date || end date ||
     39||= patient dimension =|| birthdate || death date ||
     40
     41
    3442
    3543=== Building Observation Facts ===