Single source of truth for what is agreed, moving, open or superseded. Updated when emails are filed. Last updated: 21 October 2026.
Workstreams
| Workstream | Status | Where it stands |
|---|---|---|
| ILR interface (provider file + WYCA extract) |
Agreed | WYCA's collection process (Michael Webster, Ellen Coleman) will work to our reissued specs (15 Oct). Ellen confirmed on 21 Oct she had been working from the older 12 Oct draft and will adopt the newer spec, squaring it with Michael. Only residual action: amend our spec wording from incremental to full refresh. |
| Learning Aim Lookup (LARS) |
Ours · done | Built. Learning Aim Lookup.xlsx (138,666 aims): Learning Aim Reference → SSA Tier 2 and Notional NVQ Level (code + description) from LARS V12. Not duplicated by anyone else. |
| Aim Category | Open | Custom to the pilot (ESOL / English / Maths / Digital / Construction, with level). Not in LARS, no agreed definition. Likely owned by IBP/survey. Our guessed rules were removed. Awaiting a definition from WYCA/IBP. |
| Snap surveys & API | Moving | Fraser supplied dummy API details (3 dummy surveys). Survey Lookup structure agreed: Survey ID, Name, GUID, Provider Name, Wave, Route, Is Dummy. Provider comes from the API (one survey per provider & route live). Outcome route = email (WhatsApp/SMS possibly to come). ULN carried as hidden match key. Live APIs to follow. |
| Data platform / Warehouse | Not started | Build pending. Agreed approach for Fraser's one-row-per-learner export: a Gold pivot view + paginated report emailed as Excel. Deferred until the warehouse is built. |
| QR codes / provider rollout | Moving (WYCA) | WYCA distributing per-provider baseline QR codes to providers now. Provider list still growing (Kirklees College added). |
Open questions & decisions
- Aim Category definition — who owns it and how an aim maps to category + level. With WYCA/IBP.
- Full refresh vs incremental — WYCA confirmed the monthly extract is a full refresh; our spec wording still says incremental and needs amending.
- Dummy must mirror live — the dummy is WYCA-wide; live will be per-provider. Flagged so the dummy actually tests the live shape.
- SharePoint access — access to the AEBDelivery pilot folder via personal share links is unreliable; may need WYCA to grant
matthew@disseminate.co.ukdirectly.
Current artefacts
All in _output\Interface Specifications\.
| File | Status |
|---|---|
| Learning Aim Lookup.xlsx | Current · ours |
| WYCA Survey API Details.xlsx (+ Survey Lookup sheet) | Working |
| Interface for ILR - WYCA.xlsx | Current · WYCA adopting |
| Interface for ILR - Provider.xlsx | Current · WYCA adopting |
Who owns what
- Matthew Denison (Disseminate) — data platform & Power BI in WYCA Fabric; lookups; survey pull.
- Chris Maunder (Thrive) — project co-ordination.
- Fraser Gilfillan (IBP) — Snap surveys, API, dummy data.
- Eddy Graham (IBP) — options / sampling analysis.
- Jamie Tasker (WYCA) — Data & Analytics / Fabric, Bronze load.
- Michael Webster (WYCA) — Performance & Data Lead; now the route for data queries.
- Ellen Coleman (WYCA) — Lead Programme Performance Coordinator; collection/handover process.
- Philippa (Pippa) Syers (WYCA) — Policy & Partnerships Lead, Adult Skills.
- Stefan Sykes (WYCA) — DPA / data.
- Amy Kinghorn (WYCA) — meetings co-ordination.
Recent change log
- 21 Oct — WYCA (Michael/Ellen) had built their collection process off the 12 Oct version. Matthew flagged the crossover and pointed to Friday's reissue. Ellen confirmed she was on the older spec and will work to the reissued specs, checking in with Michael. Crossover resolved.
- 20 Oct — Fraser confirmed provider comes from the API, and the outcome route is email (WhatsApp/SMS possibly to come).
- 15 Oct — Matthew reissued the three split specs and uploaded to SharePoint. Fraser sent dummy Snap API details.
- 9 Oct — Jamie meeting: two sources into Bronze (ILR + Snap); each survey = Provider × Wave × Route; survey lookup to come from IBP; ULN carried as the hidden key.