Configuring Export Mapping

Export mapping is available for ePRO and eClinRO surveys to allow you to provide custom values for survey questions and answers that will be displayed in the data export.

Using export mappings can help with the following goals:

  • SDTM Compliance: Map survey configuration so that it aligns more closely to SDTM expectations.
  • Consistent Exports: Eliminate end-user formatting that can complicate data analysis.
  • Improved Data Quality: Ensure clean and standardized data for downstream processes.

Understanding Export Mapping

Mappable Elements

You can map the following elements for exports:

  • Block Headings: The descriptive text for a survey block
  • Block Names: The internal name of the survey block
  • Answer Names: The internal name of the answer choice.
  • Answer Value: The label of text that is displayed for an answer choice.

Mapping Suggestions

To help align your data with SDTM requirements, the system automatically analyzes your survey design and provides mapping suggestions. These suggestions are identified based on potential issues that could lead to noncompliant data.

The system looks for the following issues in its analysis:

  • Block Headings:
    • Contain non-ASCII characters.
    • Exceed 40 characters.
    • Include HTML formatting.
  • Block Names:
    • Exceed 8 characters.
  • Answer Names and Values:
    • Contain non-ASCII characters.
    • Exceed 200 characters.
    • Include HTML formatting.

If an issue is identified, the mapping suggestions will indicate that we recommend mapping it to an accepted value.

Importing and Exporting Existing Mappings

You can choose to export an existing survey mapping to use for a survey. The following information applies to imported mapping:

  • The survey name in the exported survey must exactly match the survey name of the survey you are importing it to.
  • The blocks and answers in the exported survey must have been used in at least one version of the survey you are importing to.
  • The mapped values in the file must all be strings.
  • You can update partial mappings for only a subset of your survey elements. To do this, ensure that only the values you want to import are included in the .JSON file you upload.
  • Any mappings added to a library survey are automatically included when that survey is used in a study.
  • If you download a mapping from a previous collection version, the name will match the previous version, but the current mappings will be downloaded.

Understanding Domains

We categorize surveys by instrument type in domains. This guarantees correct and consistent column headings when exporting and grouping the data.

The following SDTM domains are available for survey mapping:

  • QS (Questionnaires). This domain is selected by default.
  • FT (Functional Tests)
  • RS (Clinical Classifications and Disease Response)

Each domain is exported in a separate file for Survey Data reports.

Mapping Exports

  1. In Studio, open the ePRO or eClinRO survey you want to map.
  2. Select the SDTM Domain that the survey will be exported to.
  3. Decide whether you want to download the current survey to map or import mapping from a different survey to work from.
    • New Mapping
      1. Select Manage Mapping.
      2. Review suggestions, and define the custom export values.
    • Imported Mapping
      1. In Studio, open the ePRO or eClinRO survey you want to export mappings for.
      2. Ensure that the latest version of the survey is saved, and select Export Current Mapping. The .JSON file is saved to your device.
      3. Open the downloaded .JSON file in the editor of your choice.
      4. For each mapped parameter, enter the string that you want to be used in exports.
        1. Changing the source parameter does not affect mapped values. The source is only for guidance while you are looking at the mapped values.
      5. Open the ePRO or eClinRO survey you want to import mappings for.
      6. Select Manage Mapping.
      7. Add the .JSON file you downloaded above to the Import New Mapping File box.
      8. Review suggestions, and make necessary updates.

The mappings are applied to exports and are kept even if you update the survey to change an element’s name.

Additional Resources