Changes between Version 11 and Version 12 of Onyx to PDO
- Timestamp:
- 01/11/12 08:11:48 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Onyx to PDO
v11 v12 2 2 This is a discussion document and work in progress. 3 3 4 Detailed below are the assumptions underlying importing facts from the BRICCS questionnaire into i2b2. All assumptions are open for discussion.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. 5 5 6 6 === The Target : i2b2 CRC Cell === … … 32 32 33 33 The '''__observation facts__''' holds one row for every fact (deemed sensible to include) that has been gleaned about a participant from the questionnaire. 34 35 Each 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 34 42 35 43 === Building Observation Facts ===