Dashboard Queue Workflow Hub

Main

Dashboard Queue Workflow Hub

Core Records

Customers Properties Plans Inspections Claims Invoices Payments

Workflow Tools

Search Open Items Recent Activity Aging Exceptions Financial Exposure Reconciliation Integrity Export Filters

Rollout

Rollout Room Command Center Readiness Status Review Summary

Workflow Aging

Aging buckets across plans, inspections, claims, invoices, and payments. This page uses defensive table and column detection so it can still render even if your schema varies across modules.

Open Work Recent Activity Workflow Index
Aged records found
4
Open records with usable aging dates across active workflow modules.
Tracked amount
$185.00
Best-effort total from detected amount or balance columns.
31+ day items
1
Longest-aging records that likely need review first.
Live modules
5
Modules where at least one supported table was detected.

Aging by module

Bucket view for 0–7, 8–30, and 31+ day open records across Plans, Inspections, Claims, Invoices, and Payments.

Grand total: 4 items

Plans

Using plans · aging by created_at · filtered by status
0–7 days
0
$0.00
8–30 days
0
$0.00
31+ days
1
$0.00
Total: 1 items
Amount: $0.00
Oldest 31+ date: 2026-03-24 10:06 PM

Inspections

Using fourps_inspections · aging by created_at · filtered by status
0–7 days
0
$0.00
8–30 days
2
$0.00
31+ days
0
$0.00
Total: 2 items
Amount: $0.00
Oldest 31+ date: —

Claims

Using claims · aging by claim_date · filtered by claim_status
0–7 days
0
$0.00
8–30 days
1
$185.00
31+ days
0
$0.00
Total: 1 items
Amount: $185.00
Oldest 31+ date: —

Invoices

Using invoices · aging by due_date · filtered by status
0–7 days
0
$0.00
8–30 days
0
$0.00
31+ days
0
$0.00
Total: 0 items
Amount: $0.00
Oldest 31+ date: —

Payments

Using payments · aging by payment_date · filtered by status
0–7 days
0
$0.00
8–30 days
0
$0.00
31+ days
0
$0.00
Total: 0 items
Amount: $0.00
Oldest 31+ date: —
Bucket Count Tracked Amount Focus
0–7 days 0 $0.00 Fresh open work that is still inside the first week.
8–30 days 3 $185.00 Items that should be actively worked and monitored.
31+ days 1 $0.00 High-priority stalled work and likely exception candidates.

31+ day attention queue

Oldest aging records pulled into one review list.

No 31+ day open records were found from the detected modules, or the needed date columns were not available.

How this page works

Best-effort logic based on whatever schema exists now.

This page looks for supported table name variants first, then picks the first matching date, amount, status, title, and number columns it finds for each module. Closed, completed, paid, cancelled, void, released, and resolved statuses are excluded when a status column is available. That keeps the page from hard crashing when table or column names vary while still giving you a usable aging overview.