Specimen Comments jdutra  2013-03-26 09:21
Status: Closed
 
When I look at the specimen views (by individual vial, by vial group, and history), all 3 of them have a comment column. The specimen archive instructions say that a 200C comment can be included, and that it's an attribute of the draw. However, when I include comments, they show up in history view, and are apparently considered to be an attribute of the event. The comment columns for the individual vial and vial group are empty. What are these comments? Is there a way to import data into them in the archive?

Thanks,
Jen
 
 
Dave Bradlee responded:  2013-04-02 13:47
Hi,

It's incorrect for our documentation to say that Comments is a Draw field. It should be an Event field. In the actual DB, the Comments field is only on the SpecimenEvent table. The Comments field on the LabKey SpecimenDetail table is a combination/choice of comments from various specimen and participant tables. However, the field LatestComments on SpecimenDetail (which corresponds to the actual DB Vial table) will be the Comments field from the latest chronological event for that specimen found in the archive.

Dave