Changes between Version 7 and Version 8 of i2b2 Data Import Pathology Procedure v1


Ignore:
Timestamp:
03/13/13 08:53:19 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import Pathology Procedure v1

    v7 v8  
    4747
    4848'''''SOLUTION: Since we are reloading all the data every load.  Could we just add a second on for every preceeding duplicate?'''''
     49
     50'''''SOLUTION: I have just checked the HAEM_RESULTS_FILE for records where the time of WHO_COLLECTION_DATE_TIME is zero.  The table also contains varchar columns called Coll_Date_Source and Coll_Time_Source.  On the ones that I have checked, the Coll_Date_Source is the same as the date portion of  the WHO_COLLECTION_DATE_TIME column.  However, the Coll_Time_Source column does contain a valid time.  I Will need to check that the dates match and the time is filled in for all columns.  Also contact Paul Smalley to double check that these columns mean what they appear to mean.