Skip to content

Changes

Page history
Update NDA Upload Preparation authored by Mara Heneks's avatar Mara Heneks
Show whitespace changes
Inline Side-by-side
NDA-Upload-Preparation.md
View page @ d16eca54
# REDCap Export and NDA Upload Preparation
## Overview
![REDCap NDA overview](docs/redcap-and-nda-prep/NDA Upload Workflow.png)
![REDCap NDA overview](![NDA_Upload_Workflow__1_](uploads/00266393d1f3a5c3844a5bd4b1548628/NDA_Upload_Workflow__1_.png))
This chart shows the data flow for uploading data from REDCap and XNAT to the NDA (NIMH Data Archive). In each bounding box, we are showing relevant Dataorc commands. REDCap and XNAT are our primary data sources, and where data are permanently stored within our system. We use the REDCap export record API to export selected fields in CSV format. Next, we apply the transformation rules to split the single CSV into multiple relational database tables stored in the Dataorc SQLite database, as shown in the flowchart. The transformation rules define how to divide different fields (and potentially fields appearing under different contexts[^1]) into different database tables.
......