Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Listed below is the general description for all the fields in the specimen disposal template with their permissible value for all the events.

Table of Contents

Steps to import CSV

Expand
  • Go to the collection protocols list page, click on the 'Import' button, and select the option 'Biospecimen Data' 

Image Added


  • Go to the participants' list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data'

Image Added

  • Select 'Specimen Disposal' to create disposal event or "Disposal Event" to update existing disposal event from 'Select Record Type' specimen's dropdown and click on 'Download Template File' to download the template file

Image Added

  • Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
  • Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update specimens molecular review event
  • Click on the 'Validate and Import' button
  • Refer 'Import status' to check the status of import job

Sample CSV

  1. Specimen Disposal (Create template)
  2. Disposal Event (Update template)

Data Dictionary

  1. Create Disposal Event:

Column Name

Datatype
Mandatory?
(Create)
Description
Permissible Values
Validations
CP Short TitleStringYesCollection protocol code/short title.

Specimen LabelStringYesSpecimen label of the specimen for which the disposal event is to be added.
The specimen should exist within the system
BarcodeStringNo

Should be unique within the system
Activity StatusStringYes

Activity status of the specimen.

  • Closed
  • Disabled

Disposal dateDate and TimeNo

Select the correct format for the date, similar to the one in UI.
Disposal reasonStringNoSpecify the reason for the disposal of the specimen
The minimum character added to the field should atleast at least be 10.
User email StringNoThe email address of the user

2. Update disposal event:

Column nameDatatype

Mandatory?

(Update)

DescriptionPermissible ValuesValidations
Event IDStringYesUnique ID of the event.-Select the correct event ID.
Date and TimeDate and TimeNo
-Select the correct format for the date, similar to the one in UI.
ReasonStringNo
-The minimum character added to the field should at least be 10.
CommentsStringNo
-
User#Email AddressStringNoThe email address of the user-