M10: v_deprecated_utilities lifecycle view
cancelledSpec: TextureHQ/mono specs/relay/commongrid-nisc-matcher.md v1.5 task M10. SQL view exposing (eia_id, deprecated_at, successor_eia_id, reason) for utilities that merged, dissolved, or had their EIA id retired. Small, polled by internal consumers (CRM) to detect stale linkage keys on their side. Grant SELECT to internal_api_consumer. This is lifecycle signal, NOT data replication. Unblocks CRM side being able to mark stale CrmOrganization.eiaUtilityId values.
Event Timeline
created
status_change
queued → in_progress
failed
lease expired — re-queued for retry
in_progress → queued
progress
Pushed CI fixes: regen openapi spec, move neon() into beforeAll, expand smoke coverage. Local tests all green, build clean. Waiting on CI.
status_change
queued → in_progress
failed
lease expired — re-queued for retry
in_progress → queued
progress
Blocked pending covenant-unwind PR. Victor surfaced a fundamental framing error: CommonGrid is public OSS, so /api/internal/*, internal_api_consumer role, commongrid.* schema, and Texture-specific view names must all be removed. M10 will be reshipped as public GET /api/v1/utilities/deprecated. PR #232 closed.
status_change
queued → blocked
status_change
blocked → cancelled