Schema change · #SC-2412
Breaking migration on the General Ledger. Cert-aware review console — pin the SEC-suite panels you need to protect, then route through the dual- approval chain. Audit ledger streams as decisions land.
This change affects 3 CERTIFIED dashboards and 1 SEC-suite pipeline. Severity is breaking; dual-approval has been auto-routed (Mei-Ling C. → David O.). Pin the panels you need to protect at the current schema version before the migration window opens.
| Before | After | Kind |
|---|---|---|
entry_amt numeric(18,4) | entry_amount_usd numeric(18,4) | rename |
entry_dt date | — — | drop |
— — | posted_ts timestamptz | add |
fx_rate numeric(8,4) | fx_rate numeric(12,6) | type-change |
- Q3 10-Q workpapersSECdashboardSEC-suiteAFAhmed F.· ownercert by Robert C. · CDObreaking
References dropped column entry_dt across 6 panels. Hard break.
- GL ReconciliationSOXdashboardSEC-suiteAFAhmed F.· ownercert by Mei-Ling C. · Compliancerefactor needed
entry_amt → entry_amount_usd alias holds for 2 windows; refactor before forced upgrade.
- Vendor risk dashboardSOC 2dashboardDODavid O.· ownercert by Aisha P. · Security councilsafe via alias
Reads entry_amt via alias view. Will continue to work for 2 release windows.
- revenue-recognition-pipelineSECpipelineSEC-suiteMJMarcus J.· ownercert by Robert C. · CDOrefactor needed
Joins on entry_dt; needs to switch to posted_ts. ~3-4 hours of refactor work.
- Mei-Ling C.Compliance officer · SOX/SECactiveSign-off required because change is breaking + cert-affected.active now
- 2David O.Data platform stewardFinalizes the migration once compliance has signed off.pending