Five missing composite indexes added

Decision

Add the five composite Firestore indexes identified by actual query patterns: Expense Review's ay + entry_class, family-invite + dissolution processor's family_id + status, admin KPI recompute's status + approved_at on CA applications, hourly notification TTL sweep's archived_at + created_at, and admin grievance KPI's kind + status.

Why

Phase 7e exit criterion called out 5 missing composites; audit identified them from actual query patterns: Expense Review's ay + entry_class ledger query, family-invite + dissolution processor's family_id + status query, admin KPI recompute's status + approved_at on CA applications, hourly notification TTL sweep's archived_at + created_at, and admin grievance KPI's kind + status.

Impact

• firebase/firestore.indexes.json grows from 38 to 43 indexes.
• Run firebase deploy --only firestore:indexes to materialise on prod.
• Affects pillar-expense, pillar-admin, and tier-pro-family (family invite processor).

Status

Active.

Sources

• .context/wiki/decisions/* § "2026-06-10 — Five missing composite indexes added"