1 / 27

REDCap Introduction User Group Meeting

REDCap Introduction User Group Meeting. By J Kevan Essmyer Acknowledgements: Paul Harris. 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

metea
Download Presentation

REDCap Introduction User Group Meeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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?

  26. 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)))

More Related