REDCap is the standard data capture platform for clinical trials and health sciences research, trusted by thousands of institutions worldwide for its audit trail capabilities, HIPAA-compliant infrastructure, and structured data model. Getting a clinical trial questionnaire or case report form (CRF) into REDCap accurately is one of the most important and error-sensitive steps in study setup.
Why Accuracy Matters in Clinical REDCap Setup
In clinical research, the data dictionary defines the structure of every data point collected in the trial. A field type error — collecting a date as a text field instead of a validated date field — creates data quality problems that may only surface during analysis or audit. A variable name error means the wrong field is linked to a downstream calculation. These errors are costly to fix after data collection has begun.
Manual CRF entry into REDCap — field by field in the Online Designer — introduces transcription risk on every field. A 100-field instrument has 100 opportunities for a transcription error. Generating the REDCap Data Dictionary from the source document and uploading it reduces that risk significantly.
Clinical CRF Field Type Mapping
| CRF Field Type | REDCap Field Type | Validation to Apply |
|---|---|---|
| Date of visit | Text | Date (Y-M-D) validation |
| Patient age | Text | Integer validation with min/max |
| Yes/No | Radio or Yesno | No validation required |
| Severity scale (0-10) | Text or Slider | Integer or number range validation |
| Free text notes | Notes (paragraph) | No validation required |
| Laboratory value | Text | Number validation with appropriate range |
| Multi-select | Checkbox | No validation required |
| Single select | Radio or Dropdown | No validation required |
The Safe Import Process
Convert the CRF to a REDCap Data Dictionary
Upload the CRF document (Word, PDF, or Excel) to platform.piraiai.com and select REDCap. Pirai AI generates a Data Dictionary CSV with field variable names, field types, field labels, and choice options populated from the source document.
Review the Data Dictionary before uploading
Open the generated CSV in Excel or Google Sheets. Review every row against the source CRF. Confirm field types are correct, validation rules are appropriate for the data collected, and variable names follow your study's naming convention.
Create a new REDCap project
Create an empty REDCap project. If the study requires HIPAA-compliant data handling, confirm with your REDCap administrator that the project is hosted on appropriate infrastructure before proceeding.
Upload the Data Dictionary and validate
Go to Project Setup, then Data Dictionary. Upload the CSV. REDCap validates the file and shows a summary of fields to be created. Review the summary carefully for any warnings before clicking Commit Changes.
Add branching logic and validation
After the upload, add branching logic for any conditional fields, set field-level validation rules, and configure calculated fields. Use the Online Designer for this step rather than the Data Dictionary.
For the full guide to REDCap Data Dictionary imports, see How to Convert a Word Document to a REDCap Data Dictionary. For IRB requirements around clinical survey instruments, see the IRB Compliant Survey Design Guide.
Frequently Asked Questions
Convert the CRF document to a REDCap Data Dictionary CSV using Pirai AI, then upload it via Project Setup in REDCap. REDCap validates the file and shows a field summary before you commit the import. After import, add branching logic and validation rules in the Online Designer.
Use a Text field with Date validation applied. REDCap supports multiple date formats including Y-M-D, M-D-Y, and D-M-Y. Select the format that matches your study protocol and is consistent across all date fields in the instrument.
Modifying a Data Dictionary after data collection has begun is strongly discouraged and may require an IRB amendment. Changing field types or variable names after responses have been collected can corrupt existing data. If changes are necessary, consult your REDCap administrator and IRB before making any modifications.
REDCap hosted on an institutional server that has been configured and validated for HIPAA compliance is appropriate for clinical trial data. Compliance depends on the institutional infrastructure, not the REDCap software itself. Always confirm with your REDCap administrator and institution's compliance office before collecting clinical data.
Convert Your CRF to REDCap Data Dictionary
From document to platform-ready survey in minutes. No manual programming required.
Start Converting Free