One row per warehouse site (grain site_id). Carries utilization_pct (occupied/capacity), throughput_units, order_count, avg_units_per_labor_hr, and the certification flags (cert_gdp / cert_iso27001 / cert_hazmat). A site is shared infrastructure across many tenants, so this mart is intentionally not client-scoped — all personas see all sites. Measures are only tenant-safe for multi_user sites; a dedicated/in_house site's throughput is effectively one client's figure. Feeds the inventory_turnover metric's utilization_pct dimension context; read rows to answer "which sites are hot / cold / certified".
- mediumReading utilization_pct as a client figure
Utilization is site-wide across all tenants stored there — it is not attributable to one client (and dedicated-site measures are effectively one client's).
- lowTreating NULL utilization as 0%
NULL means capacity or occupancy is unmapped, not empty.
- “Which sites are over 90% utilization?”
- “List GDP-certified sites in the EU.”
- “Which sites have the best labor productivity?”