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

Timestamp:

03/14/13 09:29:18 (12 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -50 +50 @@
 ||ValType_Cd||"N" (numeric)||
 ||TVal_Char||"E" (see below)||
-||Units_Cd||||
+||Units_Cd||Value calculated by ufn_get_units function (see below)||
 ||Location_Cd||"@"||
 ||Update_Date||The current date using the GETDATE() Function||
@@ -77 +77 @@
 
 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.
+
+=== ufn_get_units Function
+
+The function ufn_get_units in the DWBRICCS database is called with parameters of ''table_name'' and ''field_name'' to determine the units.
+
+'''''ACTION (RB): Work out what this function actually does and then move the logic into a join if possible.  This should be clearer and also quicker.'''''