Version 2 (modified by 12 years ago) ( diff ) | ,
---|
BRICCS
BRICCS, the Biomedical Informatics Centre for Cardiovascular Science, is the founding project behind the BRICCS platform, now the LCBRU IT Platform. BRICCS is a cohort discovery project to accelerate recruitment into translational medicine studies, recruiting patients with cardiovascular conditions (ACS, Aortic Stenosis, CHD, heart failure, etc) into a population from which cohorts can be isolated for common phenotypes.
BRICCS uses - and provided the initial impetus for development of - most of the tools in the LCBRU IT Platform.
Onyx: For recruitment management and electronic data capture / questionnaire.
CaTissue: For specimen collection management and inventory.
i2b2: For cohort discovery and clinical data integration.
Remote sites
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@…