Changes between Version 9 and Version 10 of i2b2 Data Import Pathology Procedure v1

Timestamp:

03/13/13 08:55:11 (12 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import Pathology Procedure v1

@@ -48 +48 @@
 '''''SOLUTION: Since we are reloading all the data every load.  Could we just add a second on for every preceeding duplicate?'''''
 
-'''''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.
+'''''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 records of interest.  Also contact Paul Smalley to double check that these columns mean what they appear to mean.