Versions Compared

Version Old Version 38 New Version Current
Changes made by

Saurav Singh

Ankita Chavan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Introduction

...

Note

When you are adding a mapping for participant or visit fields, make sure there is no space between OS and RC field. If you introduce a space, the mapping will not be saved.

For example:

Correct mapping: rcRecordId=ppid

Incorrect mapping: rcRecordId = ppid

Participant Level Mapping

...

Expand

Field Name

Variable Name

PPID

ppid

Registration Date

registrationDate

External Subject ID

externalSubjectId

Registration Site

site

First Name

participant.firstName

Last Name

participant.lastName

Middle Name

participant.middleName

Birth Date

participant.birthDate

Death Date

participant.deathDate

Gender

participant.gender

Races

participant.races

Vital Status

participant.vitalStatus

Ethnicity

participant.ethnicities

eMPI

participant.empi

National ID / SSN

participant.uid

MRN Site

participant.pmis.siteName

MRN

participant.pmis.mrn

Email Address (v10.3)

participant.emailAddress

Custom field

participant.extensionDetail.attrsMap.<custom_field_name>

For example: if the field name is 'redcap_age' in the custom form the use: participant.extensionDetail.attrsMap.redcap_age

...

Expand
titleSteps for mapping one PV from REDCap to one PV on OpenSpecimen

Let's say you want to map the gender value "M" received from the REDCap project to the corresponding OpenSpecimen PV "Male". To do so, you can follow the given steps:

  1. Go to Extras from the homepage and select Dropdown Manager.

  2. Click on the "Gender" attribute and click on 'Male' PV.

  3. Click on 'Edit', and under properties, enter the name of the PV Mapping Key and its corresponding value for your REDCap study.

Mapping Specific CP

The property name is the same as the "PV Mapping Key" displayed on the OS-RC configuration page.

Name: RC_<CP_ID>_<RC_Project_ID>

Value: To which the value should be mapped.

Mapping for all CPs under a single site

The property name is RC_<site_id>. The site ID can be obtained from the sites list view in the following steps:

  1. Go to the 'site' page from the homepage and select the sites you are interested in.

  2. Click on the 'Export' button to download the .csv file.

  3. Open the file, and you can see the 'site id' as 'identifier'.

Mapping all REDCap projects irrespective of sites or CP

The property name is RC, as illustrated in the below image.

...