Versions Compared

Version Old Version 34 New Version Current
Changes made by

Shraddha Ranpise (Deactivated)

Ashish Vishwakarma

Saved on

Key

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

...

...

...

...

...

Table of Contents

Video on Visit CSV:

Widget Connector
overlayyoutube
_templatecom/atlassian/confluence/extra/widgetconnector/templates/youtube.vm
width400px
urlhttps://www.youtube.com/watch?v=NSQ74ZFgTzc
height300px

Steps to import CSV

Expand
titleExpand...

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

...

  • Biospecimen Data' OR

...

Image Added

  • Go to

...

  • the Participant's list page of the CP

...

  • under which the visit has to be created/updated, click on the 'More' button, and select

...

  • the option 'Biospecimen Data'.

Image Added

  • Select 'Visits' from the 'Select Record Type' 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 'Data Dictionary' table below

...

  • .

  • Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update visits or 'Update Else Create' to either create or update record. For the 'Update Else create' feature please refer to Update Else Create Operation.

  • Click on the 'Validate and Import' button.

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

...

Note

...

On updating the activity status of the visits to 'Disabled', the dependent data - specimens collected under this will be deleted. This is the force delete feature

...

available on the UI as well.

Sample CSV

...

Download

Data Dictionary

Note

  1. The "Name" (Visit Name) is required when updating visits to identify which records you are updating.

  2. To change the "Visit Name," include the visit identifier column.

You can build queries to fetch the Vist Names or Identifiers and export.

Column Name

Data type

Mandatory?

(Create)

Mandatory?

(Update)

Description

Permissible Values

Validations

Identifier

Number

No

Depends

No

System auto-generated unique number for every visit.

Mandatory while updating Visit Name.

CP Short Title

String

Yes

No

Collection Protocol of the visit to be added.

Should be an existing

and unique within OS

CP

PPID

String

Yes

No

The

participant for

Participant for whom this visit is being created.

Existing PPID.

Event Label

String

No

No

Event Point Label from the protocol for which this event corresponds. E.g., baseline, surgery, etc.

In v3.4, if

If left blank, the system will add a visit with the event label as 'Unplanned Visit.'

Name

String

Depends

Yes

Name of the visit. 

Should be unique within the system.

Mandatory if the auto label generation is set to OFF

Should be unique within OS

.

Visit Date

Date

No

No

Select the correct date format from UI based on the data in the file. In v3.4, if

If left blank, the system will add the current date by default

Visit Site

String

No

No

Valid site name

In v3.4, if

If left blank, the system will add a recent visit site

Visit Status

String

No

No

  • Complete

,

  • Pending

,

  • Missed Collection

In v3.4, if left blank, system will add 'Complete' status

Default Value: Complete

Clinical Diagnosis

String

No

No

Permissible Values File - SNOMED

Permissible Values File - ICD 10

In v3.4, if left blank, system will display '

Default Value: Not Specified

'

Clinical Status

String

No

No

'

  • No Diagnosis / Control

' /

  • New Diagnosis

/

  • Pre-Therapy

/

  • Post-Therapy

/

  • Pre-Operative

/

  • Operative

/

  • Post-Operative

/

  • Remission

/

  • Relapse, Primary Site

/

  • Relapse, Distant Site

/

  • Relapse, Not Specified

/

  • Not Specified

In v3.4, if left blank, system will display '

Default Value: Not Specified

'

Cohort

String

No

No

The group to which the visit belongs

By default, this field is not visible.

In order to display this field,

The system administrator needs to add values in the database table 'catissue_permissible_value' to display this field, or the user can add values through 'Dropdown Manager'. The dropdown is only visible

in

on the visit page

only

if

it has

PVs are added.

Path. Number (PHI Field)

String

No

No

Surgical Pathology Number

In v3.4, if left blank, system will display '

Default Value: Not Specified

'

Pathology Report Name

String

No

No

File name

The filename of the surgical pathology report

This is used to upload pathology reports. 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 the 'File Upload via BO'.

Missed Reason

String

No

No

Reason for the missed visit

Beyond processing time/ Insufficient sample collected / available/ Laboratory error/ Patient declined collection/ Poor sample quality/ Sample damaged/ Sample not collected by clinic / Clinic error/ Visit cancelled

In v3.4, if left blank, system will display '

Default Value: Not Specified

'

Comments

String

No

No

Activity Status

String

No

No

  • Active

Value

  • Disabled

'Disabled' status cannot be used when creating visits.
The value should be 'Active' during creation or kept blank, in which case it will take the default value as 'Active.'

To delete the visit, keep the value as 'Disabled' and run the 'Update' operation. 'Name' or 'Identifier' column is mandatory for this operation.

Missed By#Email Address

String

No

No

Email address of the user who missed the visit

Should

It should be an existing user

in OpenSpecimen

.