Table of Contents |
---|
Video:
Widget Connector | ||
---|---|---|
|
...
Expand | ||
---|---|---|
| ||
|
...
Column Name | PHI Field? | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
---|---|---|---|---|---|---|---|
CPR#1#CP Short Title | No | String | Yes | Depends | Collection Protocol to which the participant is to be registered | Should be an existing CP within OS. | |
CPR#1#PPID | No | String | Depends | Yes | Unique ID generated for the participant per protocol. This can be auto-generated by the system or manually assigned by the user. | Should be unique within a CP. It should be left blank if auto-generation is ON. | |
CPR#1#Registration Date | No | Date | Yes | No | Select the correct date format from UI based on the data in the file | ||
CPR#1#Registration Site | No | String | No | No | The site where the participant enrolled in the study/protocol. | ||
CPR#1#External Subject ID | No | String | No | No | Unique study or system ID assigned to participants by external systems like OpenClinica, REDCap, etc. | ||
CPR#1#Activity Status | String | No | Activity status of the participant to be registered under CP-1. Used to reactivate or delete participants in bulk. |
| The value should be 'Active' during creation or kept blank in which case it will take the default value as 'Active.' While deleting participants, change this value to 'Disabled' and import the CSV having columns CP Short Title, PPID, and Activity Status in 'Update' mode. | ||
First Name | Yes | String | No | No | |||
Last Name | Yes | String | No | No | |||
Middle Name | Yes | String | No | No | |||
Date Of Birth | Yes | Date | No | No | Select the correct date format from UI based on the data in the file | ||
Death Date | Yes | Date | No | No | Select the correct date format from UI based on the data in the file | ||
Gender | No | String | No | No |
| ||
Race#1 | No | String | No | No | Add an extra column for the participant with multiple races. E.g. Race#1, Race#2, etc. |
| |
Vital Status | No | String | No | No |
| ||
Ethnicity | No | String | No | No |
| ||
SSN/NIN | Yes | Integer | No | No | Social Security Number for US locale National Identification Number for other countries | Should be unique within OS | |
eMPI | Yes | String | No | No | Enterprise Master Patient Index | Should be unique within OS | |
Activity Status | String | No | No |
| The value should be 'Active' during creation or kept blank in which case it will take the default value as 'Active.' | ||
PMI#1#MRN | Yes | String | No | No | Medical Record Number (unique identification given by the site) | Should be unique within a site | |
PMI#1#Site Name | No | String | No | No | The site which issued the MRN | Should be an existing site within OS |
Note |
---|
|
Update MRNs for existing participants
...