Changes between Version 4 and Version 5 of BRICCS Study


Ignore:
Timestamp:
05/01/13 18:36:05 (11 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • BRICCS Study

    v4 v5  
    2020* 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
    2121
    22 After that first report, each month the report should be re-populated with a specific month's recruitment
     22After that first report, each month the report should be re-populated with a specific month's recruitment FROM BOTH THE LEICESTER AND NORTHAMPTON DATABASES
    2323
    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 > '2013-03-01 00:00:00' AND start_date < '2013-04-01 00: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, site_no, 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 > '2013-04-01 00:00:00' AND start_date < '2013-05-01 00:00:00' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_leicester_april.txt
     25
     26* mysql -h briccsdb -u auditor -p briccs_northampton -e "SELECT barcode, site_no, 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 > '2013-04-01 00:00:00' AND start_date < '2013-05-01 00:00:00' AND ptone.id = interview.participant_id order by start_date;" > briccs_enrollment_northampton_april.txt
    2527
    2628Reports are generated and sent to Angel Christian at angel.christian@uhl-tr.nhs.uk