Skip to content
All projects
Research programmeData Systems Lead

TB Reach Wave 11 — Health Camps & Facility Screening

BCHPR · Stop TB Partnership · Apr 2025 – present

Largest and most operationally complex BCHPR data system — 19,673 lines integrating 5 REDCap projects across community health camps, primary health facility screening, and prison screening in 7 regions of Cameroon. Target: 494,400 screenings and 105,646 diagnostic results.

Highlights

  • 5 integrated REDCap projects (Health Camps · Location · Primary Health Screening · Primary Health Results · Daily Attendance).
  • Dual QR-code schemes — screening QR for participant ID and testing QR for specimen ID — enable flexible post-collection linkage.
  • Spirometry PDF extractor (1,743 lines) using pdfplumber with French / English / hybrid detection, SHA-256 deduplication, and SQLite file-hash index.
  • Windows COM Outlook email processor that auto-ingests monthly site reports from regional coordinators with MMM-YYYY regex.
  • Multi-language spirometry parameter mapping (French CVF → FVC, VEMS → FEV1, DEF25-75 → FEF25-75).
  • Three-stage Airflow orchestration: Pipeline (hourly 6am–6pm) · User Activity (30 min incremental) · Reports (3-hourly).
  • Cross-project linkage with Global Outcome treatment tracking and FujiLAM II eligibility via FC IDs.