One row per client×contract engagement (grain (client_id, contract_id)), sourced from int_whse__contract_sla joined to fulfillment actuals. Carries each SLA target next to its achieved actual (otif_target_pct/otif_actual_pct, pick_accuracy_target_pct/ pick_accuracy_actual_pct, dock_to_stock_target_hrs), the derived otif_gap_pct (negative = breach), order_volume, billing_model (∈ {open_book, fixed_fee, cost_plus, activity_based}), and client segment/tier. client_name is a company, not PII. Client-scoped via the client_account_manager row policy on client_id — the canonical isolation-demo surface: two managers open this and see disjoint scorecards.
- highComparing actual to target without the gap sign
A breach is otif_actual_pct < otif_target_pct (i.e. otif_gap_pct < 0) — read the sign, don't assume higher-is-worse.
- highAssuming a manager sees every client
The row policy scopes to the caller's client_id. This mart is the isolation showpiece — disjoint rows per manager are the expected, enforced behavior.
- lowReading client_name as PII
A client is a company; the natural-person PII (primary_contact_name/email) is not projected here.
- “Which of my contracts are breaching OTIF?”
- “Show strategic-tier clients under an activity-based billing model.”
- “List active contracts by achieved OTIF.”