Changes between Version 6 and Version 7 of Onyx to PDO

Timestamp:

01/10/12 21:50:09 (12 years ago)

Author:

jeff.lusted

Comment:

--

Onyx to PDO

@@ -23 +23 @@
 The '''__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.
 
+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)? 
 
+That leaves just three tables to consider, and these are the main ones:
+
+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.