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

Data standardization

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

Defining domains Grouping data by domain when exporting

The Data Standardization allow users to more easily manage the export files and conduct a more effective analysis of variables within the same category. The domain-based export 'regroups' variables by visit (including unscheduled visits and surveys) and domain. It is available for CSV and SAS exports.

Your browser does not support HTML5 video.

 

Defining domains

The data standardization page is available under the Study Design navigation item. On the Data standardization page, you can see the domains added to your study, and add, edit, and delete domains. 

 

To add a new domain:

  1. Navigate to the ‘Study design’ section. 
  2. Then to the ‘Data standardization’ subtab
  3. Select the ‘+Add’ button.

 

 

  1. In a new pop-up window enter the domain name and abbreviation
  2. Select the ‘Add’ button.


lick to Zoom
 
 
 

 

To delete or edit a domain select a relevant option from the three dots menu, next to the domain name.

 

 

When you edit a domain, you can assign fields to a domain (e.g., dem_height, and vis1_height).

 

Click to Zoom

 

After selecting fields, you can add domain-specific variable names for them (e.g., height for both fields) - in the first right-hand column. 

 

Domain-specific variable names have a maximum length of 32 characters, are lowercase, and can only contain alphanumeric characters and the character ‘_’.

 

 

An overview of the mappings between fields and domains can also be exported from the page. The file contains the domain abbreviation, domain name, domain variable name, parent type (visit/repeating data/survey), parent's name, and field information.

 

Click to Zoom

 

If there are assigned visit numbers to Visits on the Study Structure page, this visit number will be used in the ‘Visit number’ column in the exports that are grouped by domain.

Click to Zoom

 

 

Grouping data by domain when exporting

When you export Participant data, you have an option to group data by domain. This option is available for CSV and SAS file type. If the CSV or SAS file type is selected, an option is presented to ‘Do not group data’ (default) or ‘Group data by domain’.

Click to Zoom

When data is grouped by domain, the exported file format follows the following structure, with one line per Visit/Repeating Data instance/Survey instance:

  • Participant Id
  • Participant Status
  • Site Abbreviation
  • Randomization Id
  • Randomization Group
  • Randomized On
  • Participant Creation Date
  • Visit name
  • Visit number (as set on the Study Structure page)
  • Type (Visit, Repeating data, Survey)
  • Name (of the Visit, Repeating data, Survey)

 

Click to Zoom

 

  • All dates (field values & metadata) are exported in YYYY-MM-DD hh:mm (date and time), or YYYY-MM-DD (date) format.
  • Checkboxes are exported in the [domain variable name]_[option name] format, with a value of 1 representing a checked option, and 0 representing an unchecked option.
  • Number and date fields are exported in the [domain variable name]_number and [domain variable name]_date format.
  • Grid fields are exported in the [domain variable name]_[row name]_[column name] format.
  • Row and column names are cut off at 15 characters.
  • Data marked as missing is handled the same way as our other exports. 
  • Form blinding permissions are taken into account while exporting data. In case the user is blinded, the related cells are empty in the export.
  • View randomization permissions are taken into account while exporting data. Only randomization information from sites where a user has View randomization permissions for, are included in the export.
  • In case variable names are generated, they are limited to 64 characters.
  • A field variable list is added per domain ([domain abbreviation]_variablelist.[filetype]).
  • If the user does not have decrypt permissions for the site the participant is assigned to, the encrypted value will be exported as *encrypted*.
normalization standardization

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Adding a dependency on a grid field in EDC/CDMS
  • Enable encryption for your study in EDC/CDMS
  • Calculate the median of a set of values in EDC/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