Changes between Version 42 and Version 43 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 16:20:27 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -76 +76 @@
 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.'''''
+'''''~~ACTION (RB): Work out what this function actually does.~~''''' The function just selects the units column from the Data_Dictionary table in the DWBRICCS database.  If the result is an empty string, it returns 'units' instead.  Don't know why it would do that.
+
+'''''ACTION (RB): Rewrite numeric data extract to do the same, but with a join.  Or it could be moved into the query that copies all the numeric fields into the recordset for looping with the for each.  Either really.'''''
 
 == Tables