Versions Compared

Key

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

Summary

This article is intended to provide details related to mapping of CRF data in XPT, CSV, and Excel transfer style exports - addressing variable setup in ClinSpark and reporting of those variables. In this article, “Base Fields” refer to variables that are fully or partially intrinsic to the ClinSpark application and not fully modifiable by site users.  “Custom Fields” refer to variables that are based on study design and therefore entirely modifiable by site users.

...

DTC variables capture the Collection Time for data fields contained within the same Form.  This is intended to represent the date/time at which a data collector performs an activity.  For more information on how Collection Time is captured, refer to the Collection Time Knowledge Base Article. CORRECT LINK

Clinical Data XPT

Collection Time maps within every dataset under a “[domain]DTC” variable when reported via a Clinical Data XPT Transfer report.

...

Repeating Item Groups Knowledge Base Article CORRECT LINK

Default Item Groupings Knowledge Base Article CORRECT LINK

...

Clinical Data XPT

Item Group repeat numbers map within every dataset under a “[domain]REPEAT” variable when reported via a Clinical Data XPT Transfer report.

...

An example XPT file including all available data types can be found here:1081704460

View file
nameTransfer Report Mapping Output.xpt

Variable naming is as follows:

...

An example CSV file including all available data types can be found here:1081606167

View file
nameClinical Data CSV.csv

An example Excel file including all available data types can be found here:1081606172

View file
nameClinical Data Excel.xlsx

Variable naming is as follows:

...

An example XPT file including example laboratory results can be found here:LAB_DATA

View file
nameLab Data XPT.xpt

Clinical Data CSV and Excel

An example CSV file including example laboratory results can be found here:LAB_DATA

View file
nameLab Data CSV.csv

An example Excel file including example laboratory results can be found here:LAB_DATA

View file
nameLab Data Excel.xlsx

LAB_DATA Variables

The following table describes variables found in the LAB_DATA dataset:

...