REDCap Introduction User Group Meeting

1. REDCap IntroductionUser Group Meeting By J KevanEssmyer Acknowledgements: Paul Harris

2. Need for Data Capture Software • Convenient uniform data entry method • Stateless web-based • Secure WUSM HIPAA compliant centralized data store. • Easy to use multi-purpose clinical database • Not Excel, Not Access, Not 3-4 composition notebooks somewhere on the top shelf • Mostly self service • Reduce data “cleaning” effort during analysis.

3. Public HTTPS Access Biostatistics Secure Domain Tiresias Server File Server https://redcapsurvey.wustl.edu... REDCap Survey MySQL Server Uploaded Files Authenticated Access Data Sync WEB Server WUCON Data Entry /Admin MySQL Slave Server Data Entry /Admin Installation Files Sidedoor Server Host Server

4. Development Server“Trying it Out” • http://www.biostat.wustl.edu/redcap • REDCap User Request forms (Fax or email) • Sponsoring PI • Username /password • Open access to the Development server • Off-campus Access • Sidedoor security certificate • Access from any “capable” Internet connection (world wide)

5. Case Report Forms PDFs Visual Status Data Validation NumerousField Types + Text (Free) (Number) (Phone) (Zip) (Date) +TextArea +Select +Radio +File HumanReadableLabels BranchingLogic Auto-Variable Coding

6. Field Types

7. Data Validation

8. Study Calendar – Participant Scheduling Participant Scheduling Module Optional Visit-Level View Shows Status + CRFs (Longitudinal Model)

9. REDCap Application (Classic Model) CRFs – Customized For Each Study REDCap Core Modules– Available For All Studies Project-Level Metadata Defined by Research Team

10. Audit Trails / Data Logging Full Audit Logs – Data Changes and Page Views

11. Reports

12. User Permission Rights Hierarchy REDCap Administrators -Grant Access to the System -Grant Creation Rights to PI and Project Admins PI and REDCap Administrators -Full Users Rights to Project -Responsible for setting Right of other users (PHI, Data Entry, Reporting) Regulars Users with restricted permissions

13. “?!!?” Branching Logic Data Validation User Rights API Data Dictionary Scheduling

14. REDCap Lifelines • Built-in tutorial videos • Built-in Frequently Asked Question (FAQ) guide • Demonstration Databases (Some Online, more to come) • WUSM BiostatREDCap Email Help Queue • [redcap@rt.biostat.wustl.edu] • Monitored by 4 to 5 Administrators

15. Top-Down and In-Line Video Training Resources

16. Built-in FAQ

17. REDCap Email Support redcap@rt.biostat.wustl.edu

18. Project Creation Flow Chart Move to Production Status on Production Server and start Data Collection Create Project –Project Name, Longitudinal or Cross-Sectional/ Survey Excel Spreadsheet Or Online Form Designer Test Forms Define Study Events (Longitudinal) add Schedule (optional) Data Entry Forms Add Users and Set User Rights

19. Production Server“Real Data” • http://www.biostat.wustl.edu/redcap • REDCap Project Request form (Fax or email) • Sponsoring PI • IRB Approval or Waiver • Only PI or Project Admin can create projects • Production “Status” • Data Dictionary • Changes saved • Review of submitted changes to avoid unintended data corruption • Delete all records function disallowed

20. Automated Data Export / Import (API) • Web based RESTFUL Service • Uses http(s) URL calls similar to the web browser • Programming Language neutral works for • (SAS, R, Python, Java) • Advantages • Automate access to data and metadata • On demand custom Reporting • Linking Multiple REDCap Projects (Advanced) • All Transactions logged

21. Biostatistics Secure Domain Accessible only from the secure Servers Routes User Program API Call Response REDCap WEB Server Authenticated Access WUCON Data Entry /Admin Data Entry /Admin Sidedoor Server

22. Automated Data Export / Import (API) • Export Methods • Required items • Token – obtained from REDCap administrator must be kept secure • Content – record • Format – Export data format CSV, JSON, XML(default) • Web based RESTFUL Service • Uses http(s) URL calls similar to the web browser • Programming Language neutral works for • (SAS, R, Python, Java) • Advantages • Automate access to data and metadata • On demand custom Reporting • Linking Multiple REDCap Projects (Advanced) • All Transactions logged

23. Simple SAS Example • filename ein "./etest_in.txt"; • filename eout "./etest_out.txt"; • filename ehdrout "./etest_hdrout.txt"; • data _null_; • file ein; input; put _infile_; datalines4; • token=8190DC542E1588AF52158EB181193DB9 • &content=record&format=xml&type=flat • &fields=id, first_name, last_name • ;;;; run; quit; • proc http • in=ein out=eoutheaderout=ehdrout • url="https://redcap.biostat.lan/redcap/srvrs/dev_v3_1_0_001/redcap/api/index.php" • method="post" • ct="application/x-www-form-urlencoded” ; run;

24. Built-in API Help

25. REDCap Goals • Easy to use • Metadata Driven • Adaptable Features • Data entry validation • Self service tool Questions?

27. Calculations • Simple • [weight]*10000/([height]*[height]) • Complex • Calculating the Mean of groups with null valid range includes zeroThe following equation will calculate the Mean of a list of variables • ((if(Math.abs([A])>0,[A],0)) +(if(Math.abs([B])>0,[B],0))+(if(Math.abs([C])>0,[C],0)))/((if(Math.abs([A])>0,1,if([A]=0,1,0))+if(Math.abs([B])>0,1,if([B]=0,1,0))+if(Math.abs([C])>0,1,if([C]=0,1,0)))