Versions Compared

Key

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

Table of Contents

...

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Upload)

DescriptionPermissible ValuesValidations
Smoking history IDIntegerNoNoThis is required only during the update. Please leave it blank during add.

The record for this custom form should exist within the system.

Record ID is system generated ID for every form record. To retrieve record ID, create a query to retrieve form records and include the form ID for the corresponding form in the query results' columns.

For multiple records, update the record id required.

Collection ProtocolStringYesYes

Short title of the collection protocol which should be existing within the system.
PPIDStringYesYes

Participant Protocol ID of the participant which should be existing within the system.
Activity StatusStringNoNo
  • Active
  • Disabled
This is required only during an update to delete the form records.

To remove the existing records for the form, add 'Disabled'
AgentStringNoNoForm field-1

Years Agent FreeDoubleNoNoForm field-2

Other AgentStringNoNoForm field-3

Packs Per DayDoubleNoNoForm field-4

Duration#1#Duration In DaysDoubleNoNoForm field-5

In the case of subforms, 
multiple values can be specified by adding additional columns in the csv as:

Duration#2#Duration In Days

Duration#2#End Date

Duration#2#Start Date

Duration#3#Duration In Days

Duration#3#End Date

Duration#3#Start Date



Duration#1#End DateDateNoNoForm field-6

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


Duration#1#Start DateDateNoNoForm field-7

...