Data Source Register
Illustrative, for a fictional community health nonprofit called Cedar Line Community Health. One programme, 23 chain elements, one indicator each. Status is scored against the fields the organisation holds today, not against what it intends to collect.
| ID | Indicator | Status | Field or absence behind it |
|---|---|---|---|
| A-1 | Sessions delivered per cohort | live | Session attendance record |
| O-1 | Distinct individuals with a first session | live | Attendance record |
| O-2 | Individuals present at all six sessions | live | Attendance record |
| A-5 | Follow-up calls attempted and reached | buildable | Nothing. Staff record these in notes |
| O-3 | Monitors issued to enrolled participants | buildable | Paper supply log, not joined to enrolment |
| S-1 | Score change on the course's knowledge check | partial | Pre and post check on paper, entered for some cohorts |
| S-2 | Self-reported monitoring at session six | partial | Session six form, added last quarter |
| S-3 | Individuals with a named primary care clinician | live | Encounter record |
| O-5 | Referrals with a confirmed first appointment | none | The counselling provider does not report back |
| S-4 | Validated anxiety measure at intake and exit | none | Nothing |
| M-1 | Change in the clinical measure at six months | none | No six-month follow-up field, and the lab result is only here when the test was ordered here |
| M-3 | Emergency visits per participant per year | none | Hospital data is not shared with us |
| L-1 | Population complication rate against a comparison | none | Needs registry or claims data plus a comparison group |
| L-2 | Self-management measure at 24 months | none | No contact route past six months |
| Column | Elements | live | partial | buildable | none | Measurable today |
|---|---|---|---|---|---|---|
| Input | 4 | 2 | 2 | 0 | 0 | 50% |
| Activity | 5 | 3 | 0 | 2 | 0 | 60% |
| Output | 5 | 3 | 0 | 1 | 1 | 60% |
| Short-term outcome | 4 | 1 | 2 | 0 | 1 | 25% |
| Medium-term outcome | 3 | 0 | 1 | 0 | 2 | 0% |
| Long-term outcome | 2 | 0 | 0 | 0 | 2 | 0% |
| All | 23 | 9 | 5 | 3 | 6 | 39% |
The collapse is the finding, and it is structural rather than sloppy. Activities and outputs happen inside systems the organisation runs, so they get recorded. Outcomes happen to people after they leave, and the further right you go the further outside the organisation's reach the data sits. A long-term population outcome needs a comparison group by definition, which makes it a study rather than a field. Inputs through outputs score 8 of 14 live, 57%. Outcomes score 1 of 9, 11%. Nearly every programme has this shape and almost no submitted logic model says so.