| 50 | 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 records of interest. Also contact Paul Smalley to double check that these columns mean what they appear to mean.''''' I have checked the data and for all instances where the time portion of the WHO_COLLECTION_DATE_TIME is zero, it matches the time in the Coll_Time_Source column. Looks promising. However, I had a thought that the collection time may not mean the time that the sample was collected from the patient, but may mean the time that the sample was collected by the van. |
