×
Maintenance Notice: labkey.org will be offline at 10:00 AM Pacific Time on Sunday, July 14th 2024 for maintenance. The estimated downtime should be no more than one hour. Please save your work before this time. We apologize for any inconvenience.

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