wiki:BRICCS Study

Version 3 (modified by Nick Holden, 11 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@…

Note: See TracWiki for help on using the wiki.