Page History

Here we outline the process for creating new participant records in LabKey. 

Note For managing participants in preclinical studies, please see the sub-page, Participants in Preclinical Studies.
Note Please remember that LabKey does not work with Internet Explorer. Please have Javascript enabled to access all features of Managing Participants.

Participants Tab Overview

The Participants tab is organized into two main parts:

...

Individual participant entry is done through the Enter Participant form.:

Image Added

1. Participant ID: this field is required. This field allows for alphanumeric entries. It is recommended that new CAMH studies on-boarded through LabKey follow the KCNI and NIP formats for proper integration with other NIP platforms. A full guide for Participant IDs (LabKey Participant IDs) can be found here.
   1. It is recommended users name their Participant Codes numerically (starting at 00000001 and incrementing as necessary).
   2. Any Participant ID that does not following the NIP naming convention will be assigned a new Study Participant ID that conforms to the NIP naming convention. The non-NIP ID entered will be listed as the Study Participant ID. See the Edit Participants section for further details on Study Participant IDs. Both IDs will be stored in LabKey for cross-referencing purposes.
2. Clinic: this field is required. Users will select the proper KCNI site code where the participants were recruited (for human participants) or collected (for animal participants) from a dropdown list. An external link to shows the full name and location of the three-letter site code for reference.
3. Sex: this field is recommended as it can be used for quality control purposes in genetic studies. However, study teams must ensure they have REB approval to collect and share this information with research personnel involved in the collection and analysis of the samples. Users will select the proper sex designation as outlined in the CAMH patient intake form from a dropdown list. For participants where sex was not entered or is irrelevant for the study’s purpose, it is recommended to mark the field as Unknown/Prefer not to answer.

...

There are two buttons at the bottom of the pageform:

1. Submit will insert the new Participant entry directly into the Participants dataset (assuming all required fields are entered, and optional fields are of the correct data type as indicated in the above table). The user will then be automatically redirected to the Specimen Entry form in the Specimens tab (see below).
2. The Cancel button will clear the form and return the user to the Overview tab.

...

Entering Participants

Participants can be entered individually or in bulk. The bulk option should only be used by external collaborators who have existing biosample-related data collected and stored elsewhere that are being shared with CAMH scientists for current analysis.

...

1. Enter a valid Participant ID (Recommended format: Neurinformatics Neuroinformatics Study Participant ID - Ex: TST01_CMH_00001000).
2. Indicate the Clinic (recruitment/collection location) from the dropdown menu.
   Image Added
3. Fill the remaining fields as necessary (see table from previous section).
4. Ensure that the entered information is correct and in the correct type (refer to the Data Type column in the table above), and press Submit. The window will redirect the user to the Specimen Entry
   1. Note that pressing the Cancel button will clear the form causing the window to redirect to the Overview tab.
      Image Added

NoteEntering The process for entering participants in bulk is as follows:

...

has been discontinued. If Participants need to be added in bulk, please contact the LabKey Administrator or Biobank staff.

Editing Participants

Note Editing participants by users has been discontinued. If edits need to be made, please contact the LabKey Administrator or Biobank with the following information:

1. Study with data to be edited
2. Participant ID/SP-ID of participant to be edited
3. Nature of edit (change in ID, sex, trio type, etc.)

The Administrator or Biobank staff will then add a comment explaining the change request.

Deleting Participants

Note Deleting participants by users has been discontinued. If deletions need to be made, please contact the LabKey Administrator or Biobank staff.

Anchor
Participants Across Multiple Studies Participants Across Multiple Studies

Participants Across Multiple Studies

In certain situations, participants consent to more than one study. In this case, the study team would enter a participant record for each study, noting the Participant ID of the other study to which the participant has consented in the Comments section. For example, the study team would create participant records in both studies ABC and XYZ using the participant’s study-specific participant ID.  The study team must also note in the Comments section of the participant record “Same as ABC01_CMH_00000001” in the XYZ record, and “Same as XYZ_CMH_00000001” in the ABC record.

Note that this procedure is similar for specimen entry as well. Please see "Samples Across Multiple Studies" for more details

...

1. Ensure that either method includes the proper header information.
2. Note that importing Participants in bulk will bypass the initial check that ensures data is in the correct format. This is especially important for fields linked to lookup tables (Sex, Clinic, Relationship, and Complete Trio). In order to ensure proper lookup entities are kept, select the ‘Import Lookups by Alternate Key’ box when uploading data.

...

1. Note that any errors will be displayed at the top of the page. These errors and may not be intuitive, as they may be generated by PostgrSQL rather than LabKey. For non-specific errors, please contact the LabKey administrator.

Image Removed

Editing Participants

In the Participants grid view, each Participant can be edited by selecting the pencil icon to the left of the Study Participant ID column. The user will then be taken to the Update Dataset Entry page with the corresponding Participant ID in the top row.

Image Removed

Each field can be edited by typing into empty text boxes or by replacing existing text. Note that each non-dropdown menu option has a superscript question mark (?) next to the field label. This indicates the expected and required data type that must be entered to update the desired participant information.
Image Removed

Note that the Participant ID and Study Participant ID are uneditable, as changing these values may affect linkages with Specimen and Instrument data. If the Participant is entered mistakenly, or if there are errors while entering the Participant ID, it is recommended to delete the participant record (assuming it is not already connected to any specimen records). If updating the Participant or SP-ID is necessary, please contact the LabKey Adminstrator.

Deleting Participants

In the Participants grid view, each participant can be deleted by selecting the checkbox in the left-most column, and navigating to the top of the grid to click on the DELETE button. An alert box will appear in the browser asking for confirmation to delete the selected rows (participants).

Image Removed

Note that deleting a participant record does not automatically remove the specimens and vials added for that participant; all specimens and vials records associated with the participant record being deleted also need to be deleted manually via the SpecimenDetail webpart.