Outcome data unified from paper forms, spreadsheets, and a legacy database — with the missing-data and cohort-tracking discipline the original process couldn't enforce.
| Source | Records | Format | Status |
|---|---|---|---|
| Intake forms (scanned)› | 1,940 | OCR + manual review | Reconciled |
| 1,940 forms run through OCR — 2.1% flagged low-confidence and routed to manual review before entering the pipeline. | |||
| Follow-up tracker› | 2,105 | Spreadsheet | Reconciled |
| Owned by the clinical coordinator, updated daily — ingested and validated against patient IDs on every sync, not just at import. | |||
| Legacy database | 767 | FileMaker export | 23 conflicts flagged |
The 23 flagged conflicts are patient records where the legacy database and the follow-up tracker disagreed — surfaced for review instead of silently picking one. That's the actual value: not just merging three sources, but never letting a disagreement between them pass as settled fact.