Versions Compared

Key

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

...

Expand
  1. After adding the project, you can move to the ‘Fields and Events Mapping’ page by clicking the Next button.

  2. Map REDCap variables (on the left) obtained from the 'data dictionary' to OpenSpecimen (on the right) as shown below.

Image Removed
  1. Image Added

List of Participant Fields and Variables

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

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
  1. Like 'Participant Level Mapping', map visits fields for the REDCap project as shown below.

  2. Additionally, you can map events for the REDCap project, as shown below.

  3. Those events from REDCap which are not mapped can create unwanted, unplanned events in OpenSpecimen. To avoid this, click on the 'Ignore Unmapped Events’ checkbox as shown above in the red box.

List of Visit Fields and Variables

Fields Name

Variable Name

Visit Name

name

Event Label

eventLabel

Visit Date

visitDate

Clinical Diagnosis

clinicalDiagnoses

Visit Site

site

Clinical Status

clinicalStatus

Path. Report Number

surgicalPathologyNumber

Cohort

cohort

Comments

comments

Collection Visit Status

status

Custom Field

extensionDetail.attrsMap.<custom_field_name>

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

...