Changes between Version 1 and Version 2 of BRICCS Study

Timestamp:

02/25/13 16:11:17 (12 years ago)

Author:

Nick Holden

Comment:

--

BRICCS Study

@@ -13 +13 @@
 
 See [[Northampton Recruitment into BRICCS]] for details of the parallel recruitment project, whereby patients are being recruited into the BRICCS population from non-UHL hospitals, initially Northampton General Hospital.
+
+=== Recruitment reporting ===
+
+As 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:
+
+* 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
+
+After that first report, each month the report should be re-populated with a specific month's recruitment
+
+* 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
+
+Reports are generated and sent to Angel Christian at angel.christian@uhl-tr.nhs.uk