Consents CSV
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

Consents CSV

Using 'Consents' BO template, you can:

  • Create new responses for the list of participants

  • Update existing responses

  • Upload signed consent forms 

This template is used to save or update consents. This will update consents if it's already present else will add them.

Steps to import CSV

  1. Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data'. OR

  2. Go to participants list page of the CP whose participants' consent responses has to be added/updated, click on the 'More' button, and select option 'Biospecimen Data.'

  3. Select 'Consents' from 'Select Record Type' dropdown and click on 'Download Template File' to download the template file.

  4. Enter all valid data in the template file as mentioned in the 'Data Dictionary' table.

  5. Upload the filled template file in the 'Input Records File' field.

  6. Click on 'Validate and Import' button.

  7. Refer 'Import status' to check the status of the import job.

Sample CSV

Download

Data Dictionary

Column Name

Datatype

Mandatory?

Description

Permissible Values

Validations

Column Name

Datatype

Mandatory?

Description

Permissible Values

Validations

CP Short Title

String

Yes

 

 

 

PPID

String

Yes

The participant for whom this consent is being added/updated

 

 

Consent Date

Date

Yes

 

 

Select the correct date format from UI based on the data in the file

 

Consent Comments

String

No

 

 

 

Consent Statement

String

No

Consent Tier Statement defined in CP

 

Should be an existing consent statement as set up in the corresponding collection protocol. If this statement has a response for the participant, it will update with the new response.

Consent Statement Code

String

Yes

Consent Code used while creating the consent statement

 

Should be an existing consent code as set up in the corresponding collection protocol.

Consent Response

String

No

Patient response to be saved

  • Yes

  • No

  • Not Specified

  • Withdrawn

  • None

 

Signed Consent Form

String

No

Name of the consent document to be uploaded

 

This is used to upload the consent document. The document file name is specified in this column and the actual file is uploaded along with the CSV in a zip file. For more details refer to 'File Upload via BO'

Consent Witness#Email Address

String

No

The email address of the witness

 

 

 

For multiple consents in single CPR add multiple rows with the same CP Short Title and PPID with other Consent Statement.

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com