Skip to content

Pending Aging

Per-sheet walkthrough — L1 Reconciliation Dashboard.

What the sheet shows

Transactions stuck in status='Pending' past their rail's max_pending_age cap. The cap is per-rail in the L2 instance; the underlying view inlines it at schema-emit time as a CASE branch keyed on rail_name. Rails without an aging watch (no max_pending_age set) are excluded by construction — they emit a NULL cap and the outer WHERE filters it out.

Screenshot

Pending Aging

When to use it

When the operations team asks "what's stuck waiting to settle?" Or during the morning routine, to surface things that should have transitioned overnight and didn't.

Visuals

  • Stuck Pending (KPI) — count of transactions whose live age has exceeded their rail's max_pending_age cap. Healthy = ZERO.
  • Stuck Pending by Age Bucket (BarChart, horizontal) — distribution across 5 number-prefixed buckets: 0-6h, 6-24h, 1-3d, 3-7d, >7d. The bucket is a CASE expression in the dataset SQL keyed on age_seconds — a plain column, not a QS CalcField (App2's column-only fetcher renders the same column). Bars stack by rail_name, so XOR-grouped multi-mode templates show which variant is dragging. Right-skew (>3d, >7d) ⇒ slow drift; spike at 0-6h ⇒ a recent batch failed to post.
  • Stuck Pending Detail (Table) — every stuck-Pending leg with rail, amount, posting and live age. max_pending_age_seconds is the rail's cap (inlined from L2 at view-emit time).

Drills

  • Right-click any row → "View Transactions for this transfer" — opens Transactions narrowed to the clicked transfer_id so the analyst can see every leg of the multi-leg transfer. The drill also widens the destination's date window, so a stuck row older than the default 7-day picker still surfaces.

Filters

  • Date From / Date To — universal date-range pickers (scoped on posting, the original transaction posting timestamp).
  • Account — multi-select dropdown over the account display (name (id)).
  • Transfer Type — multi-select dropdown that pushes down to rail_name.
  • Rail — multi-select dropdown over rail_name (the same column Transfer Type narrows).

See it live