Changes between Version 4 and Version 5 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 09:24:52 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -14 +14 @@
 ||Start_Date||The source table observation date field (see below)||
 ||Modifier_Cd||"@"||
-||ValType_Cd||"T"||
+||ValType_Cd||"T" (text)||
 ||Units_Cd||"@"||
 ||Location_Cd||"@"||
@@ -38 +38 @@
 
 == Numeric Fields
+
+Numeric 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||"PTS:{TABLE_NAME}_{COLUMN_ID}"||
+||Provider_Id||"@"||
+||Start_Date||The source table observation date field (see above)||
+||Modifier_Cd||"@"||
+||ValType_Cd||"N" (numeric)||
+||TVal_Char||"E" (see below)||
+||Units_Cd||||
+||Location_Cd||"@"||
+||Update_Date||The current date using the GETDATE() Function||
+||SourceSystem_Cd||"BRICCS"||
+||Upload_Id||"1"||
+
+'''''SOMETIME (RB): Convert Update_Date to use a date parameter.  It's just a little quicker.'''''
+
+'''''SOMETIME (RB): Should the SourceSystem_Cd not be "PATS"?'''''
+
+'''''SOMETIME (RB): The Upload_Id is presumably always one because everything is reloaded each time.  Might be nice to change this to something more meaningful.'''''
+
+=== TVal_Char
+
+The ''TVal_Char'' describes the meaning of the value contained in the ''NVal_Num'' field.
+
+For all values currently the value of ''TVal_Char'' is set to "E", which means equals.  That is, the value in the ''NVal_Num'' field is the result of the test.  All possible values of ''TVal_Char'' are:
+
+||Value||Meaning||
+||E||Equals||
+||NE||Not Equal||
+||L||Less Than||
+||LE||Less Than or Equals||
+||G||Greater Than||
+||GE||Greater Than or Equals||
+
+From a casual look at the data, I think that a value of less than X, or greater than Y is sometimes used for Pathology data.