...
Column Name | Data type | Mandatory? | Description | Permissible Values | Validations | |
|---|---|---|---|---|---|---|
| Identifier | Number | System auto generated unique number for every visit | ||||
| CP Short Title | String | Yes | Collection Protocol of the visit to be added | Should be existing and unique within OS | ||
| PPID | String | Yes | The participant for whom this visit is being created. | Existing PPID. | ||
| Event Label | String | No | Event Point Label from the protocol for which this event corresponds. E.g. baseline, surgery, etc. | In v3.4, if left blank, system will add visit with event label as 'Unplanned Visit' | ||
| Name | String | Depends | Name of the visit. Mandatory if the auto label generation set to OFF | Should be unique within OS | ||
| Visit Date | Date | No | US format: MM-DD-YYYY Rest: DD-MM-YYYY In v3.4, if left blank, system will add current date by default | |||
| Visit Site | String | No | Valid site name | In v3.4, if left blank, system will add recent visit site | ||
| Visit Status | String | No | Complete, Pending | In v3.4, if left blank, system will add Complete status | ||
| Clinical Diagnosis | String | No | In v3.4, if left blank, system will display Not specified | |||
| Clinical Status | String | 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 Not specified | ||
| Path. Number | String | No | Surgical Pathology Number | In v3.4, if left blank, system will display Not specified | ||
| Pathology Report Name | String | No | Medical document written by pathologist | |||
| Missed Reason | String | No | Reason for 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 Not specified | |
| Comments | String | No | ||||
| Activity Status | String | No | Active | Should be 'Active' when adding a visit | ||
| Missed By#Email Address | String | No |
...