Changes between Version 2 and Version 3 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 09:05:50 (12 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -5 +5 @@
 == Text Fields
 
+Text fields are mapped to the i2b2 Observation Fact table like this
+
+||i2b2 Field||Source||
+||Encounter_Num||i2b2 Patient ID||
+||Patient_Num||i2b2 PatientID||
+||Concept_Cd||Enum lookup value (see below)||
+||Provider_Id||"@"||
+||Start_Date||The source table observation date field (see below)||
+
+=== Enum Lookup Value
+
+The Concept Code to use is found in the table DATA_DICTIONARY_ENUM_VALUES in the DWBRICCS database on UHLDWH server.  This table contains records for concept code keyed on source table name, column name and column value.  NULL column values may be mapped to the field '(empty)'.
+
+'''''ACTION (RB): Check if all possible values of column value contain a mapping in the ''DATA_DICTIONARY_ENUM_VALUES'' table.'''''
+
+=== Source Table Observation Date Field
+
+For each source table in the there is a single field that is used as the start date for all columns from that field.  The observation date field to use for each table is stored in the ''pats_tables'' table in the DWBRICS on the UHLDWH server.
+
 == Numeric Fields