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

Timestamp:

03/13/13 08:54:27 (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 columns.  Also contact Paul Smalley to double check that these columns mean what they appear to mean.