Business logic
The words behind the numbers
4 metrics and 5 glossary terms drawn from Caldera Logistics's own language. The semantics — not the SQL — are where the board dispute lives: 3 of 4 metrics are contested (defined more than one way and never reconciled), and 1 is undefined — a name the team uses that no query has ever computed.
contested On-Time Delivery is defined more than one way and never reconciled.
contested Revenue is defined more than one way and never reconciled.
contested Active customer is defined more than one way and never reconciled.
undefined OTIF (On-Time In-Full) is named but never defined or computed here — a gap, not a number.
Metrics & KPIs
4 metrics · 3 contested · 1 undefinedOn-Time Delivery
Defined by OTD · not canonical
Revenue
Reports two ways: gross billed ($22.04M) vs net of credits ($21.71M). Same credit_amount field that forks OTD forks revenue. No ratified definition of which the board sees.
Defined by Revenue · not canonical
Active customer
53 by CRM status vs 60 by 'billed in the last 90 days'. Two populations, both called 'active'.
Defined by Active customer · not canonical
OTIF (On-Time In-Full)
An industry-standard 3PL service metric the team references but has never defined or computed here. A named gap, not a number.
Defined by OTIF · not canonical
Acronyms & terms
5 terms · the shared vocabularyOTD
Defined twice in the client's own data dictionary and never reconciled — the root of the 6.4-point board dispute.
OTIF
Standard 3PL metric: delivered on time AND complete. Referenced, never defined here.
SCAC
The carrier identifier code; lives on the carriers table.
Revenue
Active customer