Synthetic demonstration: Illustrative only. Mar 2026 shows dashboard vs agreed referral divergence — see reconciliation.
MHSDS-like (illustrative)
View in source-to-report map · Full Mar 2026 submission pack · Legacy snapshot CSV · fact_mh_referral_episode.csv
- Source requirement
- Referral episodes from Legendary Care and/or PathwayOne access actions
- Business definition
- Referrals received — agreed OPT-C hybrid (134 Mar 2026), not dashboard logic (154)
- Transformation
- fact_mh_referral_episode with OPT-C derivation_rule and inclusion flags
- Validation
- Monthly reconciliation; VAL-06 failed Mar 2026 — dashboard figure submitted in error
- Sign-off
- Mandatory reporting owner + performance lead before submission
- Risk if wrong
- False assurance to NHSE; local Board narrative diverges from mandatory return
| Measure | Value | Notes |
|---|---|---|
| Referrals (dashboard logic) | 154 | Not agreed definition |
| Referrals (agreed OPT-C) | 134 | Post-reconciliation |
| Contacts | 420 | Cross-check with CSDS-like |
CSDS-like (illustrative)
- Source requirement
- CARE_ONGOING and CARE_FIRST_CONTACT actions from PathwayOne
- Business definition
- Clinical contacts only — KPI-05; exclude admin and duplicate ActionId
- Transformation
- fact_activity with action-type filter and DQ exclusions
- Validation
- CSDS-like cross-check; admin inflation vignette DRH-PAT-003201
- Sign-off
- CSDS owner before mandatory submission
- Risk if wrong
- Over-reported activity inflates workforce productivity narrative
| Activity type | Count |
|---|---|
| Assessment | 890 |
| Clinical Intervention | 1,120 |
Urgent Care ADC-like (illustrative)
ADC_E07_ANALOGUE: 2,840 contacts — separate urgent-care strand; see warehouse demo for IUCS context.
MHSDS-like Mar 2026 submission · Legacy snapshot CSV · fact_mh_referral_episode.csv