This document delineates many of the broader technical aspects of REDCap, such as the infrastructure and third-party software required to host REDCap, details of its data storage model, user privileges, authentication We need this field because the normal REDCap survey timestamp is unfortunately not accessible in the reporting tool. FAX: (206) 616-9250. Currently possible tasks: automated data exports and imports from a specified REDCap project. 130 0 obj <> endobj �BZ{�!�vCP�c����Q���72Z���������b�{Z-f����yǝ����y�k[�A����Q��OG0��0L�9��ɏ'�h������#���F���ڌ�i�V/(��^ <> What type of storage do I need? endobj endobj First, you’ll need to switch the filter to the custom syntax mode instead of the drag and drop wizard. Follow these steps to set up reporting in your REDCap project. The survey participant will not see this field. REDCap Alerts & Notifications User Guide Alerts & Notifications The Alerts & Notifications feature allows you to construct alerts and send customized email notifications. You will need to customize this code by replacing the “[ts]” with the variable name that you’ve chosen for the time stamp variable in the first step. The Clinical and Translational Science Institute at Children's National (CTSI-CN) is supported through the National Institutes of Health (NIH) Clinical and Translational Science Award (CTSA) Program, grant UL1TR001876 and KL2TR001877.The CTSA program is led by the NIH's National Center for Advancing Translational Sciences (NCATS). endobj <>/F 4/A<>/StructParent 1>> endstream 2 0 obj ���� JFIF ` ` �� C Select the appropriate variables, give the report a name, and create a filter with an upper and lower bound date in the Filter section of the report builder. Research applications and services support basic, biomedical and clinical research missions; focusing on the technical aspects of the research lifecycle. Several authentication methods are available for use in REDCap: LDAP, Shibboleth, OpenID, Google OAuth2, an internal table-based authentication method, as well as a combination of LDAP and table- based together. Exporting Data from REDCap – How-To Guide This module allows you to easily view reports of your data, inspect plots and descriptive statistics of your data, as well as export your data to Microsoft Excel, SAS, Stata, R, or SPSS for analysis (if you have such privileges). 7 0 obj REDCap Authentication REDCap implements authentication to validate the identity of end-users that log in to the system. You can then add your custom logic. There are two ways of doing that: dynamically or static. REDCap is a secure web application for building and managing online surveys and databases. REDCap is a mature, secure web application for building and managing online surveys and databases. For example, if you only want to see Female subjects with a completed Demographics form (see below). 850 Republican St Assign view access and edit access to project users. Click the “Use advanced logic” link next to the “Switch format” tag to do so. Support and training are available for all services through knowledge base articles, presentations, in-person and remote sessions. See the example below. REDCap offers an external module for facilitating the creation of Adverse Event Reports by aggregating a REDCap project's data and formatting it using adverse event report templates from the IRB, CT.gov, and FDA. The Static Method Additional off-hours support will be provided on a best-effort basis. USA This project was supported by the National Center for Advancing Translational Sciences, National Institutes of Health, through Grant Number UL1 TR002319. Storage Solutions FAQ, Electronic Lab Notebook Vendor Demos and Discussions, LabArchives vs other Partners Enterprise Apps, Epic/Partners eCare Reporting Workbench for Research FAQ, Resources and Standard Operating Procedures, Enterprise Research Infrastructure & Services, Research IT Institutional Advisory Boards, New COVID-19 Research Tools for Researchers, Virtual Care- Next Generation Telehealth Devices, Non-Standard Windows Computer Management Pilot, RISC provides standard business-hours support (9AM to 5PM, Monday - Friday) for all supplied systems. q:O9H��d��"��r'g��{�K�X���T�C�y�U�A�����f�l��T{��$���N�����`̟R0t�8��-�}�Λj�,��[��E(�����U�&j�n6���:���N¬�ۍ�R�[-��P5�D�? Box 358051 endobj %PDF-1.5 Consumer Technology Management (CTM) was formed to create synergy between PC, Mac and Mobile teams to unify and operationalize the endpoint computing strategy. Started, HELP! Seattle, WA 98109 If you want to select a different dynamic range, change the “0” and the “-7” in the example to the desired range, (e.g. 4 0 obj Creating Customized Reports in REDCap – How-to Guide 3/22/2017 Step 2: Pick the fields you want to be displayed in the report. x����k�@�� ���������$mɠ���=�=�- }H��ia��tv�8KB�-s��?�Z���z���`4�*�н��>���iY�E��Dd!�)�I(�����(�� to������ϲ`��J ����ʢ;���� �||u���_�q���2�G△�vF��7#�&�Y�ـN����-FP8顈9�X��|s=��s���6�ܘ����B^�:g��,pȀ5jn@�םY� ��Rc�/b�O�Y�t]_zD�OD�Ȉ�y��+ܽ/�K}� 1. You can put in optional description for the report. 2. Institute of Translational Health Sciences This website was developed by the Institute of Translational Health Sciences. Click +Create New Report and enter a name for the report. The Dynamic Method %%EOF These notifications may be sent to one or more recipients and can be triggered or scheduled when a form/survey is saved and/or based on conditional logic whenever data is saved or %���� Now that we have a variable with a timestamp, we can incorporate it in a report. <> to look at the last month, the values would be “0” and “-30”). 5. An interface that allows external applications to connect to REDCap remotely in order to accomplish a task. h�b```��bq� ��ea�hpp`�����Nq��$ ��4�F�'�v(IK=�rN���#'�Iq�:����Ǝ �P4� �V>�ba�I�@�`�T�`�,R���[�=�/3�g:��0K�"��\�XB��)�iL�� }���4� %���f�0 ��(( ",#(7),01444'9=82. Quick Reference Guide SHORT DESCRIPTION REDCap offers an external module for facilitating the creation of Adverse Event Reports by aggregating a REDCap project's data and formatting it using adverse event report templates from the IRB, CT.gov, and FDA. For example, to pull all the survey results from the last seven days, add the following logic: ((datediff(“today”,[ts],”d”,”ymd”,true))<=0) and ((datediff(“today”,[ts],”d”,”ymd”,true))>=-7). $.' Step 3 (Optional): Use filters to only see certain subjects’ data or data at only one event (if longitudinal). h�bbd```b``�"f�H�2����~�HV[��l0�L^�d�����X� �dT��m�$cU��"�����Y�����e`$����T� � ��D Follow these steps to set up reporting in your REDCap project. REDCap Technical Overview Introduction REDCap is a web application for building and managing online surveys and databases. If you run a continuous survey, you may want to run a weekly or monthly report to get an overview of what was submitted. Research Information Services & Computing (RISC) and the Information Security and Privacy Office (ISPO) takes seriously the commitment to protect the confidentiality of information important to Partners' academic and research mission. The division of Research Information Science and Computing (RISC) is the cornerstone of the scientific utilization of Information Technology at Partners HealthCare. The Adverse Event external module must be requested from edc support by: Any further questions can be directed to edcsupport@partners.org, © 2010-2020 Partners HealthCare. endobj stream <>/XObject<>/Font<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 6 0 R] /MediaBox[ 0 0 612 792] /Contents 4 0 R/Group<>/Tabs/S/StructParents 0>> stream Programs talk to the REDCap API over HTTP, the same protocol that your browser uses to visit and interact with web pages. 5 0 obj This method is very similar to the static method, except you will need to write custom logic to make this report dependent on today’s date. %PDF-1.5 %���� endstream endobj startxref REDCap offers an external module for facilitating the creation of Adverse Event Reports by aggregating a REDCap project's data and formatting it using adverse event report templates from the IRB, CT.gov, and FDA. Step 1: Add a timestamp variable. First, add a text variable with the YMD validation and tag that field with the action tags @TODAY and @HIDDEN. Add optional filters to limit the report results. This will add a hidden field that will be automatically populated with today’s date. REDCap provides automated export procedures for seamless data downloads to Excel and common statistical packages (SPSS, SAS, Stata, R), as well as a built-in project calendar, a scheduling module, ad hoc reporting tools, and advanced features, such as branching logic, file uploading, and calculated fields.