epic: SIS → PDP → AR → Dashboard sandbox

[William-Hill]

Summary

Build a self-contained sandbox simulating the full institutional data pipeline (SIS → PDP submission → AR file → Dashboard) using synthetic data. Substrate for demoing data lineage (#107), validation reports (#110), submission runbooks (#111), and the realistic-mockup explainer (#115). Becomes the standard demo asset for AASCU member onboarding.

Spec: docs/superpowers/specs/2026-05-02-sis-pdp-ar-sandbox-design.md

Why

From the AASCU intermediary feedback session, the strongest unaddressed gaps are around data trust and provenance. A sandbox we control end-to-end lets us demo and develop those features without touching real institutional data.

Scope

Seven phases tracked as child issues — #117 #118 #119 #120 #121 #122 #123:

1. Schema + seed (sandbox_sis + upload_events)
2. SIS → PDP transform + validation
3. AR file generation
4. UI: SIS console (Banner-style with revealed density)
5. UI: PDP submission console (preflight → submit → receipt)
6. UI: AR manifest + lineage drawer
7. Pipeline rail + polish

Total estimate: 17–23 engineering days.

Out of scope

• Real SIS connections (feat: SIS deep-link from student detail view (FERPA-compliant identity resolution) #78 covers that).
• Multi-institution / multi-tenant.
• Streaming. Batch only.

Acceptance

• make sandbox-reset && make sandbox-run reproduces full flow on a clean checkout
• Every dashboard number reachable from a sandbox run links to its source SIS row in ≤ 3 clicks
• Non-technical user can submit, read validation report, download AR file without engineer help
• Sandbox data namespaced and never appears in non-sandbox views

Related

• feat: data lineage view — "where did this number come from" #107 data lineage view
• feat: upload validation report — row-level errors, coercions, and diff vs. last upload #110 upload validation report
• feat: submission runbook generator — capture and reproduce institutional upload steps #111 submission runbook
• feat: Remotion explainer video — proposed data flow (abstract, ~42s) #114 / feat: Remotion explainer video — realistic UI mockups (~60–90s) #115 Remotion explainers