Changes between Version 13 and Version 14 of i2b2 Data Import Pathology Procedure v1


Ignore:
Timestamp:
03/20/13 14:54:19 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • i2b2 Data Import Pathology Procedure v1

    v13 v14  
    4949
    5050'''''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.
     51
     52'''''ACTION (RB): Ask Nick why the Pathology data is only loaded for tests received after 04 July 2010.'''''