Changes between Version 11 and Version 12 of BRICCS Study


Ignore:
Timestamp:
12/18/14 11:34:47 (10 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • BRICCS Study

    v11 v12  
    4343=== Recruitment reporting ===
    4444
     45As from December 2014, recruitment is monitored in REDCap for all sites (excluding Northampton, which is still using Onyx). To collect recruitment monitoring data from REDCap, the REDCap logging table can be used.
     46
     47
     48November 2014 example - Leicester:
     49
     50* mysql -h briccsdb -u auditor -p redcap -e "SELECT pk,project_id,ts from redcap_log_event where event = 'INSERT' and object_type = 'redcap_data' and project_id = '24' and ts > '20141101000000' and ts < '20141201000000' order by ts;" > briccs_enrolment_leicester_2014_11.txt
     51
     52November 2014 example - external sites:
     53
     54Note: Project ID 12 is the DEMO project. Watch that when other externally facing projects are set up, they don't mess with the reporting...
     55
     56* mysql -h briccsdb -u auditor -p redcap_briccsext -e "SELECT pk,project_id,ts from redcap_log_event where event = 'INSERT' and object_type = 'redcap_data' and project_id <> '12' and ts > '20141101000000' and ts < '20141201000000' order by ts;" > briccs_enrolment_external_sites_2014_11.txt
     57
     58
     59SUPERCEDED
    4560As of February 2013, the BRICCS project was included in the Leicestershire, Northamptonshire and Rutland CLRN Portfolio. Monthly reporting is therefore required for the CLRN, starting with an initial report of recruitment from the start until the end of January:
    4661