Intelligence Dashboard
Provider database intelligence, POS table visibility and connection health.
Provider: Provider #1
Provider intelligence health
Confirms the provider database mapping, cross-database visibility and core POS table counts. This screen is for system intelligence only. It does not send messages or change provider data.
Provider: Provider #1
Provider ID: 1
DB: dcmecom_provider_001
Connection OK
NO LIVE CUSTOMER MESSAGES
Controls
Dockets
17,341
Provider POS tickets
Docket Items
26,167
Item rows available
Payments
17,536
Payment records
Invoices
111
Invoice records
Core table visibility
| Table | Status | Total Rows |
|---|---|---|
| tblDockets | Visible | 17,341 |
| tblDocketItems | Visible | 26,167 |
| tblPayments | Visible | 17,536 |
| tblInvoices | Visible | 111 |
Connection details
| Field | Value |
|---|---|
| Mode | master_cross_database_query |
| Host | localhost |
| Database | dcmecom_provider_001 |
| Recorded User | dcmecom_engine |
| Core Readiness | Ready |
| Total Records Checked | 61,155 |
System response
{
"ok": true,
"build": "intelligence-dashboard-saas-2026-standardised",
"provider_id": 1,
"from": "2026-05-01",
"to": "2026-05-06",
"connection": {
"mode": "master_cross_database_query",
"db_host": "localhost",
"db_name": "dcmecom_provider_001",
"db_user_recorded": "dcmecom_engine",
"notes": [
"Used master DB connection with cross-database queries.",
"No second provider PDO login attempted."
]
},
"sample_tables": {
"tblDockets": true,
"tblDocketItems": true,
"tblPayments": true,
"tblInvoices": true
},
"sample_totals": {
"total_dockets": 17341,
"total_docket_items": 26167,
"total_payments": 17536,
"total_invoices": 111
},
"error": ""
}