Multiple visit schedules

LabKey Support Forum
Multiple visit schedules jdutra  2012-07-18 07:22
Status: Closed
 
We have a study and we're having trouble deciding how best to set it up. Basically, there are defined study "events" such as "Hospital Discharge" which don't take place at a specified time. We want to define visits (sequence #s) for these such that all participants have the same sequence # for the same event.

In addition, there are daily and weekly logs that include clinical and specimen data for participants, and it makes sense for the sequence numbers for these to be based on study day. It seems to make sense to separate these log files somehow. We looked at the ancillary studies, but I'm not sure that really works for this purpose.

Do you have any suggestions about what to do here? Is there any good way to separate the logs out without separating them so much that it's difficult to incorporate that data with the event data when needed?

Thanks,
Jen
 
 
marki responded:  2012-07-19 09:37
What other groups have done is create a specific sequenceNum for log datasets. Each row in that dataset has the same sequenceNum, but the dataset has an extra key defined (could be a Date) so that there is a unique key for each Participant/SequenceNum/Key combination.

We would like users to be able to flag datasets as log datasets and support them explicitly, but that work has not been a top priority yet.
 
jdutra responded:  2012-07-19 10:33
Thanks for your response. We were thinking of implementing something similar to what you've described, so it's good to know that other groups have set things up that way.