Versions Compared

Key

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

Description: This BO Template is used to add Custom Form data for Visits. The forms need to be created and attached at Visit level. Once a form is attached, user can access the template file by clicking on Collection Protocol→ Select the CP → Import→Select 'Visit' under record type→ download template file

User can add/update values for the fields of custom form attached to the 'Visit' level for all CPs or specific CPs in bulk through bulk operation, follow below steps to add/update values in bulk:

  1. Go to participants list page of the collection protocol whose visits custom form values has to be added/updated
  2. Click on 'More' button and select option 'Import'
    Image Added
  3. Select desired form, E.g. 'Base Haematology Pathology Annotation Form' from 'Select Record Type' visits's dropdown and click on 'Download Template File' to download the template file
    Image Added
  4. Enter all valid data in the template file as mentioned in the below table
  5. Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to add or 'Update' to update values of the custom forms
  6. Click on 'Validate and Import' button
  7. Refer 'Import status' to check the status of import job

Example: Base Haematology Pathology Annotation Form

Sample CSV File

   

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

DescriptionPermissible ValuesValidations
Record IDIntegerNoYesNeed not be specified while adding a new record  

Visit NameStringYes Depends

Visit should be existing within the system
Specimen ProcedureStringNoDependsValid value from the listPermissible Values File 
CommentStringNo  No


Other Specimen ProcedureStringNo No  


Biopsy Or Aspirate SiteStringNo No
Left posterior illiac crest/ Not applicable/ Not specified/ Other/ Right posterior illiac crest/ Sternum 
Adequacy Of SpecimenStringNo No
Limited/ Not Specified/ Satisfactory/ Unsatisfactory 
Cytogenetics StatusStringNo No
Not Specified/ Not performed/ Performed/ Performed - See separate report 
Cytogenetics ResultStringNo   No


Immuno Phenotyping StatusStringNo No
Not Specified/ Not performed/ Performed/ Performed - See separate report 
Immuno Phenotyping ResultStringNo   No


Immuno Phenotyping Method UsedStringNo   No


Other Biopsy Or Aspirate SiteStringNo No  


Pathologic Finding#1#Pathologic Finding DetailsStringNoNo

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

Pathologic Finding#2#Pathologic Finding Details

Pathologic Finding#2#Detail

Pathologic Finding#3#Pathologic Finding Details

Pathologic Finding#3#Detail


Permissible Values File 
Pathologic Finding#1#DetailStringNo No 

Histologic Type#1#TypeStringNoNo

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

Histologic Type#2#Type

Histologic Type#2#Details

Histologic Type#3#Type

Histologic Type#3#Details

Permissible Values File   
Histologic Type#1#DetailsStringNo No