Changes between Version 2 and Version 3 of BRICCS Study


Ignore:
Timestamp:
02/25/13 16:11:24 (12 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • BRICCS Study

    v2 v3  
    1818As 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:
    1919
    20 * mysql -h briccsdb -u auditor -p briccs -e "SELECT barcode, start_date, status
    21 FROM participant ptone, interview WHERE NOT EXISTS (SELECT 1 FROM participant pttwo WHERE pttwo.enrollment_id = ptone.enrollment_id LIMIT 1, 1 ) AND barcode is not null AND status <> 'CANCELLED' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_to_date.txt
     20* mysql -h briccsdb -u auditor -p briccs -e "SELECT barcode, start_date, status FROM participant ptone, interview WHERE NOT EXISTS (SELECT 1 FROM participant pttwo WHERE pttwo.enrollment_id = ptone.enrollment_id LIMIT 1, 1 ) AND barcode is not null AND status <> 'CANCELLED' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_to_date.txt
    2221
    2322After that first report, each month the report should be re-populated with a specific month's recruitment
    2423
    25 * mysql -h briccsdb -u auditor -p briccs -e "SELECT barcode, start_date, status
    26 FROM participant ptone, interview WHERE NOT EXISTS (SELECT 1 FROM participant pttwo WHERE pttwo.enrollment_id = ptone.enrollment_id LIMIT 1, 1 ) AND barcode is not null AND status <> 'CANCELLED' AND start_date > '01/02/2013 00:00' AND start_date < '01/03/2013 00:00' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_this_month.txt
     24* mysql -h briccsdb -u auditor -p briccs -e "SELECT barcode, start_date, status FROM participant ptone, interview WHERE NOT EXISTS (SELECT 1 FROM participant pttwo WHERE pttwo.enrollment_id = ptone.enrollment_id LIMIT 1, 1 ) AND barcode is not null AND status <> 'CANCELLED' AND start_date > '01/02/2013 00:00' AND start_date < '01/03/2013 00:00' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_this_month.txt
    2725
    2826Reports are generated and sent to Angel Christian at angel.christian@uhl-tr.nhs.uk