Log- or ongoing-style data

General Server Forum (Inactive)
Log- or ongoing-style data sadams7703  2019-02-28 16:45
Status: Closed
 

Hi,
I am trying to build out a study the has been going on for some time. So I am uploading data.
The study has a Participant ID - Visit Number structure for most data.
However, some data were collected without a Visit Number but only have a Participant ID and a date. In addition, there are multiple entries for each Participant ID (and also Participant ID-date).

An example is a "concomitant medication log" in which the Paticipant ID, Start Date, Stop Date, and Med Name are recorded in each row (a "log-book") regardless of study visits.
Another example is a "vital status follow up log" in which each phone call or contact with a participant is recorded for years after the last formal study visits. So each row is Participant ID, Date of Call, Vital Status.
Is there a way I can integrate these data into a study with a Participant ID-Visit Number structure?
I have been trying with a General Assay but having no success, as it is demanding a Visit Number when I copy over the data from the assay to the study. Is there a way around this?
Or do I need to assign dummy Visit Numbers or use some other work around?
Thanks,
Scott

 
 
Jon (LabKey DevOps) responded:  2019-03-01 12:15
Hi Scott,

Unfortunately, you would need visitId values if you are running on a Visit-Based study. There is no way to get those records into the system without it since the combination of the ParticipantId and the VisitId are used together to identify a specific row and act as a combined primary key.

Regards,

Jon
 
sadams7703 responded:  2019-03-02 07:41
Status: Active
OK, how would you recommend managing these types of data in LabKey?
Thanks,
Scott
 
Jon (LabKey DevOps) responded:  2019-03-18 22:20
Status: Closed
Hi Scott,

Since this data is comprised of multiple rows of the same participantIds and participantIds+Dates, your options are going to be limited.

The datasets are out of the questions since you've indicated you're working with a visit-based study, so you would have to have some kind of visitId field to apply to these records to satisfy the study's restrictions.

It is possible to use a list to upload these to, provided that you allow the list to generate its own auto-incrementing integer for the primary key since there would be no other identifier differentiate between one row to another.

https://www.labkey.org/Documentation/wiki-page.view?name=listDefineFields

Regards,

Jon
 
Jon (LabKey DevOps) responded:  2019-03-22 10:59
Hi Scott,

Another possible option, although would require some work, you could setup a dummy visit ID value within your data and have another field acting as a 3rd key as well for the dataset to mitigate participant/visit duplicates.

https://www.labkey.org/Documentation/wiki-page.view?name=editDatasetProperties

Regards,

Jon