Transcription
Howtodesignadatabaseforelectronicdatacapturein1
Outline REDCapbackground REDCapfeatures- ‐Systemfeatures- ‐Databasedesignfeatures- ‐DataEntry(DE)&managementfeatures Real- ‐BmeCRFcreaBon CRFcreaBonusingatemplate DEoverview REDCapmodulesoverview2
ResearchElectronicDataCapture(REDCap)Background– secureweb- ‐basedapplicaBon– anderbiltUniversity(VU)(www.project- ‐redcap.org)– availableatnocosttoREDCapconsorBumpartners– Currently228consorBumpartners3
DatafromREDCapConsor8um4
FeaturesofREDCapSystemFeatures Secureandweb- ‐based- ‐Inputdataorbuilddatabasefromanywhere- - orinternetaccess. 21CFRpart11Capable- ‐servercanbeconfiguredtoensurecompliance5
Fullycustomizable- ‐ totalcontroltoshapedatabaseandfeatures- ‐ wriReninphp–sourcecodeavailabletopartners- ‐ recommended. WellSupportedbypartners- ‐Onlinemailinglists/forum- ‐Weeklyweb- ‐seminar/conferences- ‐Onlinetutorials6
DatabaseDesignFeatures Stream- ‐linedprocessforrapidlybuildingadatabase- ‐Point/Click&dragforreal- ‐BmeCRFCreaBon- ‐Oruploadfromcsvfile. Databasechangeseasilyimplemented- isinprogress.7
DataEntry&ManagementFeatures SupportsfollowingAdvancedfeatures:- ‐Auto- ‐validaBon(Range/datachecks)- ‐Branching/skiplogic- eforBodyMassIndex(BMI))- pdatabasewithlinkexpiringopBon- ‐Cansetdatabasetoallowdoubledataentry8
MulI- ‐siteaccess- sssamedatabase. ExportdatatocommonstaIsIcalpackages- PSS.9
rReal- pScreensOp8onalLongitudinalCRFMapping10
NewDatabasename11
ClickToStarteCRFDesign12
eCRFname13
FieldtypeoneCRFFieldtypeindatabaseifTextBox14
databasefieldnameQuesBononeCRF15
�eldnotetoaidclarityduringDE16
definingcodedresponseforradiobuRons17
definingcodedresponsefordrop- ‐downlist18
creaBngcheckresponses19
creaBngauto- ‐calculaBons20
ns21
condiBonistrue)22
creaBngfieldthatallowstouploadfiles23
sedonquerye.g.pulllistofmedicaBonsfromSPINE24
DefineSecBonheadingoneCRF25
csvdatadicBonaryfileopenedinExcel26
csvdatadicBonaryuploadmodule27
DataEntryOvervieweCRFs28
orDE29
pop- ‐UpCalendar30
radiobuRonsdrop- ‐downlistcheckBoxes31
fileuploaddialogue32
datacheckpop- ‐upmessageduringDE(valuenowithrange)33
datacheckpop- ��ed)34
completedeCRFbuRonforviewingdatafieldhistory35
givingreasonforchange36
datafieldhistory/log37
Onlysendsdownloadlinkforspecifiedfile38
REDCapmodulesoverview- ‐Dynamicprojectstatus- ‐ParBcipantscheduling- ‐DataExportandImport- ‐DataComparisonToolREDCapModules39
- ‐Userrights&acBvityLogging- ‐FileRepository- ‐DatavisualizaBon/CleaningandReports- ‐Recordlocking&e- ‐Signatures- ‐API&SharedLibrary- ‐OnlineTutorials&CiBngREDCapinpublicaBons40
hichs/hehasRead/Editrights41
DynamicdatabasestaBsBcs42
43
SelecBngfieldforExport44
DataExport De- ‐IDToolsEmbeddedDe- ‐Iden8fica8onTools
46
47
48
rApplica8onsREDCapModuleAccesseCRFaccessrights
DatabaseexpiraBondate50
51
LoginaccountReason(s)fordatafieldchanges52
ProjectFileRepositoryProject- ‐SpecificFilesUploadedHereProject- to- ‐Saved
54
55
- ‐- ‐RequiresR- ‐ApacheServerConnec8on56
57
58
REDCapAPI- .php,.Net,Python.59
Bons60
OnlineVideoresourceaccessedthroughInternet61
62
Acknowledgements- ‐PaulHarris,VanderbiltUniversity(www.project- ‐redcap.org)- ‐REDCapproject(www.project- ‐redcap.org)Thankyou63
How to design a database for electronic data capture in REDCap Database, REDCap Survey and Data Management Tool, data collection Created Date:
