Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • CDMS
  • Castor CDMS Manual
  • Export data
  • Participant Data

Export data formats in CDMS

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • CDMS
    Castor CDMS Manual Castor CDMS Calculations Manual Frequently Asked Questions Articles for Data Managers Castor CDMS Compliance Release Documents
  • eConsent
    Castor eConsent Manual Castor eConsent Compliance Release Documents
  • SMS
    Castor SMS Manual Castor SMS Compliance Release Documents
  • Castor Connect
    Castor Connect Compliance Release Documents Castor Connect Manual Castor Connect - Participant Quick Start Guide
  • Helpdesk
    News Other Resources Castor products knowledge resources
  • Status page
  • Completing a Study
+ More

Table of Contents

Study data Repeating Data export Surveys data Queries data Comments data Variables list Custom verifications data

Your export is either Excel or a ZIP file which contains multiple files in the format of your choice. Along with the study, repeating data, and survey data, you will find additional files with comments, custom verifications, field options, queries, source data verifications for Forms, and variable lists.

 

This article outlines how your data will be exported into CSV and Excel formats. 

 

Since semicolons are used as a delimiter in CSV export files, the semicolons (;) in the text fields will be replaced with a hyphen (-) when exported.

 

Study data

Study data is exported into a wide format. All data for one participant (subject/sample) will be presented in one row. The study data export file contains the following columns:

  • Participant Id
  • Participant Status
  • Site Abbreviation
  • Randomization Id (in case randomization is used)
  • Randomization Group (in case randomization is used)
  • Randomized On (in case randomization is used)
  • Participant Creation date

These columns followed by the study variables with rows containing the actual study data. Here is an example:

Repeating Data export

Repeating Datas data is exported into a long format. Each repeating data and survey per each participant will be exported on a separate row. Please note that each repeating data is exported as a separate file in CSV and SPSS and as a separate tab in Excel.

Repeating Data export file contains the following columns:

  • Participant Id
  • Participant Status
  • Report creation date
  • Report Name Custom
  • Report Parent

These columns are followed by the repeating data variables with rows containing the actual repeating data. Here is an example:

Surveys data

Surveys data is exported into a long format. Each survey per each participant will be exported on a separate row. Please note that each survey is exported as a separate file in CSV and SPSS and as a separate tab in Excel.

Survey export file contains the following columns:

  • Survey Instance Id
  • Castor Participant Id
  • Participant Status
  • Survey creation date
  • Survey sent date
  • Survey Progress
  • Survey Completed On
  • Survey Parent
  • Survey Package Name
  • Survey Package Id

These columns are followed by the survey variables with rows containing the actual survey data. Here is an example:

Queries data

Each query per each participant will be exported on a separate row. Please note that the queries data is exported as a separate file in CSV and SPSS and as a separate tab in Excel.

Queries export file contains the following columns:

  • Participant Id
  • Site
  • Field Id
  • Field Variable name / Field label
  • Location
  • Query creating date
  • User
  • Last status
  • Remark/ comment
  • Site Id
  • First remark/comment
  • Query age
  • Time to resolve

These columns are followed by the query variables with rows containing the actual query data. Here is an example:

Comments data

Each comment per each participant will be exported on a separate row. Please note that the comments data is exported as a separate file in CSV and SPSS and as a separate tab in Excel.

Comments export file contains the following columns:

  • Participant Id
  • Study / Repeating Data
  • Repeating Data name
  • Field Id
  • Field Variable name / Field label
  • Date
  • User
  • Last status
  • Comment
  • Current value

These columns are followed by the comment variables with rows containing the actual comments data. Here is an example:

Variables list

The variable list is exported as a separate file for repeating datas, study and survey’s variable list in CSV and SPSS and as a separate tab in Excel.  The variables are exported as they are entered in the Form Builder. The (study|reports|surveys)_variablelist.csv files contain information on variables that are requested/included in the export. 
 

When no variable name is configured:

  • We use the field label to generate a variable name.
  • The generation of variable names is the same across all export types.
  • We add the form and field number in front of this generated name.

Variables list export file contains the following columns:

  • Visit name
  • Form name
  • Form number
  • Field number
  • Field type
  • Variable name
  • Field label
  • Option group name
  • Field required
  • Field min
  • Field max
  • Field units
  • Field info
  • Calculation/summary template
  • Field hidden
  • Dependency parent name
  • Field dependency operator
  • Field dependency value

These columns are followed by the comment variables with rows containing the actual comments data. 

Custom verifications data

The custom verifications export file contains added and dropped or removed custom verifications data and includes the following columns:

  • Participant Id
  • Visit name
  • Form name
  • Repeating Data instance name
  • Repeating Data form name
  • Verification user
  • Verification type
  • Action
  • Dropped / removed date
  • Dropped / removed by user
  • Dropped for field Id
  • Dropped for field variable name / label

These columns are followed by the rows containing the actual custom verifications data. Here is an example:

cdms data edc formats

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Export data from CSV into SAS in CDMS
  • Export and merge data in R in CDMS
  • Export data into SPSS in EDC/CDMS
  • Export uploaded files in CDMS
ISO 27001
FDA - 21 CFR part 11
ICH GCP compliant
HIPAA compliant
CDISC
ISO 9001
gdpr compliant

Products & Industries

  • Electronic Data Capture (EDC)
  • ePRO
  • eConsent
  • Decentralized Clinical Trials (DCT)
  • Clinical Data Management
  • Medical Device & Diagnostics
  • Biotech & Pharma
  • CROs
  • Academic Research

Resources

  • Thought Leadership
  • Blog
  • Castor Academy
  • Knowledge Base

 

Company

  • About Us
  • Careers
  • News
  • Contact Support
  • Contact Us

Legal & Compliance

  • Terms of Use
  • Privacy & Cookie Statement
  • Responsible Disclosure Policy
  • Good Clinical Practice (GCP)
  • ISO Compliance Certificates
  • GDPR & HIPAA Compliance
  • Security Statement

© 2022, Castor. All Rights Reserved.

Follow us on social media


Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand