Synthetic demonstration only. Fictional Demo Rivers Health (DRH) warehouse outputs. Not Dorset HealthCare (RDY) public data. Not official reporting. Human sign-off required.
Question
How does the mock warehouse support investigation of urgent-care activity movements in early 2026 — distinguishing genuine operational pressure from extract or attribution artefacts?
Key findings explained
Jan–Feb 2026 — multi-source escalation
IUCS contacts and operational cases elevated
| Field |
Reading |
| Figure | IUCS contacts: 1,592 (Jan), 1,477 (Feb). Operational cases opened: 274 (Jan), 402 (Feb). Agency spend on urgent-care cost centre: ~£51k (Jan), ~£61k (Feb). |
|---|
| Comparator | Sep–Nov 2025 IUCS baseline average ~1,263. Feb urgent-care bank shifts: 219 vs ~190 in prior months. |
|---|
| Trend | Elevated vs baseline — Jan peak then slight easing into Feb; cases and contacts both up with source links retained. |
|---|
| Judgement | Likely genuine — needs review — coordinated signals across CareCall, RosterFlow and LedgerWise. |
|---|
| Evidence | volume_trends.csv; demo_provider_month_measures.csv; DQ007, DQ008; localops_validation_notes.xlsx references bank-holiday pressure. |
|---|
| Human confirmation | Urgent care and performance lead to confirm operational narrative before board or service reporting. |
|---|
March 2026 — CareCase spike without IUCS corroboration
Cases up, activity down — extract change aligns
| Field |
Reading |
| Figure | Cases opened (all): 542 (+3% MoM). Operational cases (demo filter): 197. IUCS contacts: 1,272 (−14% MoM). Cases without SourceContactId: 322 of 542. |
|---|
| Comparator | Feb 2026: 525 cases, 402 operational, 1,477 IUCS, 123 without source contact. |
|---|
| Trend | Diverging — case opens and IUCS moving in opposite directions; missing-source cases sharply up. |
|---|
| Judgement | Likely artefactual — needs review — extract change log records CareCase inclusion rule change effective March run (2026-02-28). |
|---|
| Evidence | volume_trends.csv; DQ002; source_profiling_report.md §5; localops_extract_change_log.xlsx (CareCase, NightlyCaseExtract). |
|---|
| Human confirmation | CareCase data owner to confirm inclusion rule change and whether March rows should count as operational demand. |
|---|
December 2025 — date-boundary mismatch
Contact date before created date on 46 IUCS contacts
| Field |
Reading |
| Figure | 46 IUCS contacts in Dec 2025 have ContactDate one calendar day earlier than CreatedDateTime date (DQ001). |
|---|
| Comparator | Prior months: negligible DQ001 count. Dec IUCS volume 1,301 (+4.6% MoM) — modest headline movement. |
|---|
| Trend | Localised — pattern tied to Dec 2025 export window, not sustained across Q1 2026. |
|---|
| Judgement | Likely artefactual — needs review — CareCall export schedule moved to 02:00 UTC on 2025-12-04 per extract change log. |
|---|
| Evidence | dq_register.csv DQ001; source_profiling_report.md §3; localops_extract_change_log.xlsx (CareCall, 2025-12-04). |
|---|
| Human confirmation | Information lead to confirm export schedule change before re-attributing contacts across month boundaries. |
|---|
Provider-month summary (Jan–Mar 2026)
| Month |
IUCS contacts |
Cases opened (all) |
Operational cases |
Agency spend (£) |
| 2026-01 | 1,592 | 461 | 274 | 51,179 |
| 2026-02 | 1,477 | 525 | 402 | 61,356 |
| 2026-03 | 1,272 | 542 | 197 | 44,758 |
Operational cases exclude ExtractInclusionFlag=1 and missing source contact (demo filter). Source: mart CSV and volume trends.
Bottom line
Early 2026 shows mixed signals. Jan–Feb uplift is corroborated across multiple synthetic sources and may reflect genuine operational pressure. March case increase is not supported by IUCS contacts and aligns with a CareCase extract rule change — treat as extract-driven until confirmed. December date-boundary flags need export-schedule review before month attribution. Do not blend these DRH warehouse findings with public RDY briefs.
Human review required before any use outside this demonstration site.
Audit trail (source paths)
site/warehouse-demo/marts/demo_provider_month_measures.csvsite/warehouse-demo/profile-output/volume_trends.csvsite/warehouse-demo/profile-output/dq_register.csvsite/warehouse-demo/profile-output/source_profiling_report.mdsite/warehouse-demo/source-data/localops_extract_change_log.xlsx
Conclusions derived from profiler and mart outputs only — not from human reviewer answer key.
← Back to warehouse demonstration