When data is collected by different sites and organizations, it can be difficult to keep visit naming standards consistent. The datasets generated might use many different ways of referring to the same visit. For example, the following list of values might all refer to the same visit:
  • "Month 1"
  • "M1"
  • "Day 30"
  • "First Month"
Instead of editing your datasets to force them to be consistent, you can define visit name aliases that are mapped to sequences numbers/VisitIDs in your study.

When you import a dataset containing the alias values, each alias is resolved to the appropriate sequence number via this mapping.

Multiple alias names can be mapped to a single sequence number, for example "Month 1", "M1", and "Day 30" can all be mapped to the sequence number "30".

Note: Alias/Sequence Number mapping is only available in visit-based studies, not date-based studies which use timepoints.

Create Alias/Sequence Number Mapping

  • Prepare your mappings as a tab separated list with two columns, like in the example below. You can map as many names as needed to a given sequence number.
    • Name
    • SequenceNum
NameSequenceNum
Two Week Checkup14
Three Week Checkup21
Seven Week Evaluation49
Seven Week Checkup49
  • From the Manage tab, click Manage Visits.
  • Click Visit Import Mapping
  • Click Import Custom Mapping
    • If an existing custom map is already defined you will click Replace Custom Mapping.
  • Copy and paste your tab separated list into the text area.
  • Click Submit.

Importing Data Using Alias Visit Names

Once the mapping is in place, you can import data using a name for the visit, instead of the sequence number value. Place the string values/alias in a column named "Visit". On import, the server will convert the string values in the Visit column to integers for internal storage. For example, the following table import physical exam data using string values in the Visit column:

ParticipantIDVisitTemperatureWeight
PT-101Two Week Checkup3780
PT-101Three Week Checkup3781
PT-101Seven Week Checkup3881

Related Topics

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand allcollapse all