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 Financial Exposure

Best-effort money and risk review across plans, inspections, claims, invoices, and payments. This page looks for supported money, balance, due, and total columns first, then groups what it finds into one risk view without assuming a fixed schema.

Next: Reconciliation Exceptions Workflow Index
Tracked total
$260.00
Best-effort total from detected amount, total, due, balance, premium, claim, and payment columns.
Open exposure
$185.00
Rows treated as open when a status column exists and is not closed, completed, paid, cancelled, void, released, or resolved.
Open money rows
9
Count of active financial records still carrying a non-closed status where a supported amount column exists.
Largest open item
$185.00
Highest single open amount found across the detected workflow modules.

Exposure by module

Balances, due amounts, claim amounts, and other tracked financial totals rolled up by Plans, Inspections, Claims, Invoices, and Payments.

Live modules: 5

Plans

Table: plans
Tracked total
$0.00
All rows in this module using the first supported money column found.
Open exposure
$0.00
Best-effort total for non-closed rows when status is available.
Closed / cleared
$0.00
Rows counted as finished, paid, closed, released, or resolved.
Largest open item
$0.00
Highest individual open amount found in this module.
Total rows: 1
Open rows: 1
Latest date: 2026-03-24 10:06 PM

Inspections

Table: inspections
Tracked total
$0.00
All rows in this module using the first supported money column found.
Open exposure
$0.00
Best-effort total for non-closed rows when status is available.
Closed / cleared
$0.00
Rows counted as finished, paid, closed, released, or resolved.
Largest open item
$0.00
Highest individual open amount found in this module.
Total rows: 8
Open rows: 7
Latest date: 2026-04-10 12:00 AM

Claims

Table: claims · Amount column: approved_amount
Tracked total
$185.00
All rows in this module using the first supported money column found.
Open exposure
$185.00
Best-effort total for non-closed rows when status is available.
Closed / cleared
$0.00
Rows counted as finished, paid, closed, released, or resolved.
Largest open item
$185.00
Highest individual open amount found in this module.
Total rows: 1
Open rows: 1
Latest date: 2026-04-15 12:00 AM

Invoices

Table: invoices · Amount column: balance_due
Tracked total
$0.00
All rows in this module using the first supported money column found.
Open exposure
$0.00
Best-effort total for non-closed rows when status is available.
Closed / cleared
$0.00
Rows counted as finished, paid, closed, released, or resolved.
Largest open item
$0.00
Highest individual open amount found in this module.
Total rows: 1
Open rows: 0
Latest date: 2026-04-15 12:00 AM

Payments

Table: payments · Amount column: amount
Tracked total
$75.00
All rows in this module using the first supported money column found.
Open exposure
$0.00
Best-effort total for non-closed rows when status is available.
Closed / cleared
$75.00
Rows counted as finished, paid, closed, released, or resolved.
Largest open item
$0.00
Highest individual open amount found in this module.
Total rows: 1
Open rows: 0
Latest date: 2026-04-15 12:00 AM

Highest open exposure

Largest active rows detected across all modules.

No open financial exposure rows were found from the detected modules, or usable amount columns were not available yet.

How this page works

Best-effort financial logic based on your live schema.

This page does not assume one exact financial schema. It first detects whichever supported table name exists for each module, then picks the first usable amount, status, date, title, and number columns it finds. That means the totals here are meant to be operationally useful and defensive, not accounting-perfect. The next page in your handoff order is workflow-reconciliation.php, which should be used for mismatch review between claims, invoices, and payments. fileciteturn8file2L34-L47