Listed below are 2 sample event templates with descriptions for all the fields:

Create/Edit Event

Click here to expand...

Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR
Go to the participants list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data.'
Select 'Frozen Event' from the 'Select Record Type' specimen's dropdown and click on 'Download Template File' to download the template file.
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 specimen frozen event, or 'Update Else Create' to either create or update record. For the 'Update Else create' feature, please refer to Create & Update in Single Bulk Operation.
Click on the 'Validate and Import' button
Refer'Import status'to check the status of the import job.

A general description of the other fields is listed below. File for permissible values for all the events

Column Name	Datatype	Mandatory? (Create)	Mandatory? (Update)	Description	Permissible Values	Validations
Record ID	Integer	No	Yes	System generated the unique identifier for each event. Used to update an existing event record in the system		Required only when updating.
CP Short Title	String	Yes	Yes	It is required when a unique label per CP setting is enabled.
Specimen Label	String	Yes	Yes	Specimen label of the specimen for which the frozen event is to be added		The specimen should exist within the system.
Activity Status	String	No	No	Activity status of the record. To remove the existing records for the form, add 'Disabled.'	Active/Disabled	Default: Active 'Disabled' status cannot be used when creating specimen event.
User	String	Yes	No	Email address of the user
Date and Time	Date and Time	Yes	No			The format should be the same as that selected on UI during import.

Note

From version v5.2 onwards, when a user downloads any specimen event template to update the events, the user will see the specific event name with the ID field instead of 'Record ID' since it was very confusing to the user while updating the specimen events.

Example:

'Fixed Event ID' for 'Fixed Event'
'Frozen Event ID' for 'Frozen Event

OpenSpecimen

Specimen Events CSV

Create/Edit Event