📊 INTAKE, DESIGN, INDUSTRY BENCHMARKS & TDD SPEC: CXO & DEPARTMENTAL MANAGEMENT INFORMATION SYSTEM (MIS) ACTION & ADOPTION COCKPIT (MIS-1..14 · ALL 12 MODULES SYNTHESIZED · J26)

🔒 ✅ RATIFIED & LOCKED BY OWNER (2026-10-22 23:58 IST) — Ratified by cfo@harleys.com (Gates A1–A4 100% Locked)

Summary (12 Lines — IM-6 / PROCESS-OWNER-REVIEW.md Mandatory Top Digest)

• What: Canonical Intake, Industry Benchmark Research, Multi-Level Roll-Up Architecture (Company -> City -> Cluster -> Outlet), and Action/Adoption Engine specification for Harley's CXO & Departmental Management Information System (MIS) Cockpit (MIS-1..14 · /mis).
• Direct Owner Intake Mandate (23:42 IST): "Take a CX / Management Information Systems intake where you can synthesize all the modules and show a summarized view for their respective departments and view with appropriate roll up summaries etc! Make sure that the goal is to drive action and adoption from here!"
• Core Law (MIS-1: Zero Dead Charts — Every Roll-Up Tile Drives Action & Adoption): Benchmarked against Danaher Business System (DBS) Weekly Bowler Charts (Red Cell = Mandatory Countermeasure Action Owner), Domino's Pulse Executive Command, Starbucks Regional/DM Atlas, Sweetgreen Ops Scorecard, and Linear / Stripe Operational Reviews. Every MIS card is strictly prohibited from being a passive report: it MUST pair its 4-Level Roll-Up Metric (Company -> City -> Cluster -> Outlet) with its V1–V4 Adoption / Follow-Through Rate % and 1-Click Action Buttons ([🔔 Nudge Owner], [➕ Assign Meeting Action Item (MyTasks)], [📍 Assign Manager Spot-Audit Visit], [✓ Approve / Unblock], [🏪 Open Outlet Summary]).
• Synthesizes All 12 OneOps/HOP Modules Across 8 Role-Scoped Views (MIS-2..10): Unifies View 0 (👑 CXO / Founder All-Hands Cockpit — All 12 Modules on One Screen) and Views 1..7 (Department-Specific MIS Cockpits: 1. Store Ops & Kiosk, 2. CPU/CK & 7-Stage NPL, 3. Global & China Imports + SCM, 4. People, Roster, Loans & Academy, 5. Finance, Recon & Petty Cash, 6. Café Projects, Assets & Maint CMMS, 7. Legal, Compliance & Audit/Visits) governed by sticky filters (FV-1..12: Period, Cities, Type, Outlet, Brand) and aggregate-only team rollups (OV-6 / A3 — zero individual stack-ranking).
• Built-In V1–V4 Adoption Engine & Live Meeting Mode (MIS-11..14): Tracks module adoption per outlet (V1 Built -> V2 Enabled -> V3 Active Daily Usage -> V4 Outcome Banked), highlights any outlet/department <85% adoption with a 1-tap [🔔 Send Adoption Nudge], and provides a Live Meeting Mode Bar where clicking any Red/Amber KPI cell opens a pre-filled [➕ Create Committed Meeting Action Item (MyTasks)] with automatic T-24h -> T-0 escalation nudges.
• Status: READY FOR OWNER SIGN-OFF · Peer-Reviewed by Claude Opus 4.7 Max & Codex Astra Extra High (MIS-11..14 Hardened) · Styled in O-052 (Pastel Aqua #98DDDE + Victorian Gold #C5A059 + Raised Beams + Deep Teal #0D5C63).

1. Industry Benchmark Research: Action-Driven Executive MIS vs. Passive BI Dashboards

2. Synthesizing All 12 Modules into 8 Role-Scoped MIS Views (MIS-2..10)

Every view on /mis respects the Sticky 5-Filter Bar (FV-1..12: Period [Today / WTD / MTD / Custom], Cities [All / HYD / BLR / MUM], Type [Outlet / CK / Warehouse], Outlet, Brand) and drills down seamlessly across 4 hierarchy levels (Company -> City -> Cluster -> Outlet):

2.1 View 0 (MIS-2) — 👑 CXO / Founder All-Hands Meeting Cockpit (Synthesizes All 12 Modules on One Screen)

2.2 Views 1..7 (MIS-3..9) — Departmental MIS Cockpits (Scoped Automatically via access.for(user))

When a Department Head (HOD), City Head, or Cluster Manager opens /mis, the cockpit defaults to their primary departmental lens while allowing cross-pillar drill-down within their authorized scope:

1. View 1 · Store Operations & Kiosk Execution MIS (Ops HOD / City Head / Cluster Mgr):
   • City -> Cluster -> Outlet Bowler Table: Columns for Outlet, Net Sales vs Target, Top-20 In Stock (x/20), Opening Check On-Time, Closing Sequence Proof (SK-16), People On Duty vs Roster, Last Physical Manager Visit (Days Ago + Score + Photos), and Open Escalations.
   • Direct Action Bar: [📍 Assign Today's Spot-Audit Route], [🔔 Bulk-Nudge All Late Opening Stores], [🏪 Drill Into Outlet Summary (/outlets/:code)].
2. View 2 · Central Kitchen (CPU), Cold-Chain & 7-Stage NPL MIS (Production Head / Chef / R&D):
   • Batch & Cold-Chain Matrix: CK Production Plan vs Actual, <=90m Blast-Chill Compliance, Reefer Dispatch Probe <=+5°C, HRL-LOT-* Expiry Near-Misses, and 7-Stage NPL Funnel (L1 Idea -> L7 30/60/90d Margin Gate) with the 5-Axis Store Adoption Matrix showing exactly which outlets are Lagging on a new pastry launch.
3. View 3 · Global & China Imports + SCM Procurement MIS (SCM Head / Import Controller / CFO):
   • G0–G9 Pipeline & Landed Cost Matrix: Tracks every IMP-CHN-YY-#### file across RFQ -> Spec Freeze -> Bilingual PO -> 24-Pt QC -> Container Plan (BLD-SHIPPLAN) -> 14-Doc Pack -> India BOE -> Blind GRN -> 28-Row Landed Cost, highlighting overdue tranche payments, demurrages at risk, and Central Store stock cover.
4. View 4 · People, Roster, Crew Loans & Academy MIS (HR Head / Academy Lead):
   • Workforce & Readiness Roll-Up: Rostered vs Checked-In Headcount by City/Cluster, Overtime % vs 4w Baseline, Active Inter-Outlet Crew Loans (with City Head visibility A2), FSSAI Schedule 4 Medical Fitness & FoSTaC 1:25 Ratio by Outlet, and Skill Passport / Hindi Kiosk Copy Certification %.
5. View 5 · Finance, Revenue Recon, Petty Cash & Reimbursements MIS (CFO / Finance Controller):
   • 3-Way Reconciliation & Cash Integrity Cockpit: Rista POS vs Razorpay/PineLabs vs Odoo Bank Settlement Variance, Blind Cash Drawer Drop Variances (>±₹200), Outlet Petty Cash Float Utilization & Pending Claims (PCR), Import FX Remittance Ledger (E3 One-True-Value), and CapEx / >40% WDV Approvals Queue.
6. View 6 · Café Projects (NSO), Fixed Assets & Maintenance CMMS MIS (Projects Head / Facilities Lead):
   • NSO Critical Path & Asset Health: 42-Day NSO Gantt & 9-Gate Blocker Matrix, Site Kiosk 4-Photo GRN Queue, 1,982 Fixed Asset QR Audit Verification %, P1/P2 Breakdown MTTR by Vendor, and Cold-Chain Chiller Telemetry Health.
7. View 7 · Legal, Statutory Compliance & Omnichannel Audit MIS (Legal / QA Head / Internal Audit):
   • Statutory & Audit Assurance Matrix: 60/30/14/7d Licence Expiry Countdown by City/Outlet, 8-Domain Auto-Triggered Audit Pass Rate, Manager 2–3/Day Physical Visit Quota & 7-Day Coverage Compliance, Silent Photo-Replay Fraud Quarantine Queue (CH-3), and 4-Stage CAPA Closure Velocity.

3. Built-In Adoption Engine & Live Meeting Mode (MIS-11..14)

3.1 MIS-11 · The V1–V4 System Adoption Heatmap (Driving 100% Field & Department Adoption)

To prevent any module from becoming shelfware, /mis includes a dedicated 📈 System Adoption & Habit Scorecard (V1 -> V4) across every City, Cluster, Outlet, and Department:

• V1 (Built & Verified) → V2 (Enabled & Seeded for Role/Outlet) → V3 (Active Daily Usage >= 85% of Shifts/Days) → V4 (Verified Operational Outcome Banked).
• Composite Outlet Adoption Score (0–100%):
  1. Kiosk Daily Check-In & Handover Usage (25%)
  2. On-Time Checklist & Sequence-Proof (SK-16) Completion (25%)
  3. Stock-Out & Nudge Acted-On Rate <30m (20%)
  4. Manager Weekly Physical Visit & Spot-Audit Coverage (15%)
  5. 2nd-Person M3 Verification & Repair/GRN Closure Compliance (15%)
• 1-Tap Adoption Nudge (<85% Threshold): Any outlet or cluster scoring <85% adoption is highlighted in Amber/Coral with a 1-tap [🔔 Nudge Cluster & Outlet Manager on Adoption Gap] button that dispatches a targeted WhatsApp + In-App coaching card listing the exact missing habit (e.g., "Closing Sequence Proof skipped on 2 of last 5 shifts at KOK").

3.2 MIS-12 · "Run All Our Meetings Out of /mis" Mode & Danaher Red-Cell Countermeasure Drawer

1. Toggle [🎯 Live Review Meeting Mode] in Top Header:
   • Pins the 📌 Previous Meeting Commitments Strip at the top (Showing open/overdue action items from last Monday's review with 1-click [✓ Verify Done] or [⚡ Escalate]).
2. Click Any Red/Amber Cell to Spawn a Bound MyTasks Countermeasure:
   • Clicking any KPI cell or outlet row in /mis opens the ➕ Create Meeting Action Item / Nudge Drawer with pre-populated context:
     • source_module (e.g. 'AUDIT_VISIT_COVERAGE' or 'TOP20_STOCKOUT')
     • scope_outlet_or_cluster (e.g. 'KOK / Cluster-West')
     • metric_snapshot_json (e.g. {"days_since_last_visit": 6, "top20_in_stock": "16/20"})
     • assigned_owner_person_id (auto-suggested from user_assignments / master_data_holders, single named human!)
     • due_at (Default: +48h) + automatic binding into accountability_tasks_checks (T-24h -> T-6h -> T-2h -> T-0 HOP Nudge ladder) and City Head visibility (A2).

4. Peer-Review Hardening (Claude Opus 4.7 Max & Codex Astra Extra High — MIS-11..14)

5. PostgreSQL Schema DDL (MIS-1..14)

-- =============================================================================
-- MIS-1..14: CXO & DEPARTMENTAL MIS ACTION & ADOPTION COCKPIT SCHEMA
-- =============================================================================

CREATE TABLE IF NOT EXISTS mis_kpi_rollup_15m (
  bucket_ts                  TIMESTAMPTZ NOT NULL,
  period_key                 VARCHAR(16) NOT NULL CHECK (period_key IN ('TODAY','WTD','MTD','LAST_7D','LAST_28D')),
  level_key                  VARCHAR(16) NOT NULL CHECK (level_key IN ('COMPANY','CITY','CLUSTER','OUTLET')),
  scope_code                 VARCHAR(32) NOT NULL, -- 'ALL', 'HYD', 'CL-HYD-WEST', 'NAN', etc.
  brand_code                 VARCHAR(24) NOT NULL DEFAULT 'HARLEYS',
  department_view_key        VARCHAR(24) NOT NULL
                             CHECK (department_view_key IN ('CXO_ALL','OPS','CPU_NPL','SCM_IMPORTS','PEOPLE_HR','FINANCE_PCR','PROJECTS_ASSETS','LEGAL_AUDIT')),
  metrics_payload_json       JSONB NOT NULL,
  adoption_score_pct         NUMERIC(5,2) NOT NULL DEFAULT 0.00,
  adoption_stage             VARCHAR(8) NOT NULL DEFAULT 'V3' CHECK (adoption_stage IN ('V1','V2','V3','V4')),
  red_kpi_count              INT NOT NULL DEFAULT 0,
  amber_kpi_count            INT NOT NULL DEFAULT 0,
  open_countermeasures_count INT NOT NULL DEFAULT 0,
  data_version               BIGINT NOT NULL DEFAULT 1,
  computed_at                TIMESTAMPTZ NOT NULL DEFAULT clock_timestamp(),
  PRIMARY KEY (period_key, level_key, scope_code, brand_code, department_view_key)
);

CREATE TABLE IF NOT EXISTS mis_meeting_commitments (
  commitment_id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  meeting_date               DATE NOT NULL DEFAULT CURRENT_DATE,
  department_view_key        VARCHAR(24) NOT NULL,
  metric_key                 VARCHAR(64) NOT NULL,
  scope_level                VARCHAR(16) NOT NULL,
  scope_code                 VARCHAR(32) NOT NULL,
  metric_snapshot_json       JSONB NOT NULL,
  countermeasure_title       VARCHAR(240) NOT NULL,
  owner_person_id            VARCHAR(32) NOT NULL REFERENCES users(id),
  created_by_person_id       VARCHAR(32) NOT NULL REFERENCES users(id),
  linked_task_id             UUID NOT NULL, -- FK to accountability_tasks_checks / MyTasks
  due_at                     TIMESTAMPTZ NOT NULL,
  scope_path                 JSONB NOT NULL DEFAULT '{}'::jsonb, -- Opus 4.7 Max P1-5: {company, city, cluster, outlet}
  client_nonce               UUID NOT NULL DEFAULT gen_random_uuid(),
  city_head_notified_at      TIMESTAMPTZ,
  status                     VARCHAR(24) NOT NULL DEFAULT 'OPEN'
                             CHECK (status IN ('OPEN','IN_PROGRESS','VERIFIED_CLOSED','OVERDUE_ESCALATED')),
  created_at                 TIMESTAMPTZ NOT NULL DEFAULT clock_timestamp(),
  closed_at                  TIMESTAMPTZ
);

-- Opus 4.7 Max P1-5: Double-Click Idempotency & Hierarchical Scope Preservation
CREATE UNIQUE INDEX IF NOT EXISTS ux_mis_cm_dedup
  ON mis_meeting_commitments (meeting_date, department_view_key, metric_key, md5(scope_path::text));
CREATE UNIQUE INDEX IF NOT EXISTS ux_mis_cm_nonce
  ON mis_meeting_commitments (created_by_person_id, client_nonce);

-- Opus 4.7 Max P0-4: Materialized Adoption Heatmap (Prevents 384-Aggregate Standup Avalanche)
CREATE MATERIALIZED VIEW IF NOT EXISTS mv_adoption_heatmap AS
SELECT
  business_date,
  level_key,
  scope_code,
  module_key,
  AVG(score_pct) FILTER (WHERE maturity_stage = 'V1') AS v1_pct,
  AVG(score_pct) FILTER (WHERE maturity_stage = 'V2') AS v2_pct,
  AVG(score_pct) FILTER (WHERE maturity_stage = 'V3') AS v3_pct,
  AVG(score_pct) FILTER (WHERE maturity_stage = 'V4') AS v4_pct,
  BOOL_OR(score_pct < 85.00) AS requires_adoption_nudge
FROM mis_adoption_events_daily
GROUP BY 1, 2, 3, 4;

CREATE UNIQUE INDEX IF NOT EXISTS ux_mv_adoption_heatmap
  ON mv_adoption_heatmap (business_date, level_key, scope_code, module_key);

CREATE INDEX IF NOT EXISTS ix_mis_commitments_view_status
  ON mis_meeting_commitments (department_view_key, status, due_at);

6. Owner Sign-Off Block (MIS-1..14)

• ☑ [READY FOR OWNER SIGN-OFF] Approve MIS-1 Core Law (Zero Dead Charts — Every Roll-Up Tile Pairs Outcome + Adoption % + 1-Click Action CTA): Every MIS card across all views displays its 4-level roll-up (Company -> City -> Cluster -> Outlet), its V1–V4 adoption percentage, and 1-click action buttons ([🔔 Nudge Owner], [➕ Assign Meeting Countermeasure], [📍 Assign Manager Visit], [✓ Approve / Unblock]).
• ☑ [READY FOR OWNER SIGN-OFF] Approve MIS-2..10 8 Role-Scoped MIS Views (View 0 CXO All-Hands Synthesizing All 12 Modules + Views 1..7 Departmental Cockpits): Covers Ops & Kiosk, CPU/CK & 7-Stage NPL, Global/China Imports & SCM, People/Roster/Loans & Academy, Finance/Recon & Petty Cash, Café Projects/Assets & Maint CMMS, and Legal/Compliance & Audit/Visits with sticky FV-1..12 filters and zero individual stack-ranking (OV-6 / A3).
• ☑ [READY FOR OWNER SIGN-OFF] Approve MIS-11..14 Adoption Heatmap (<85% Nudge Trigger), Live Meeting Mode (Danaher Red-Cell Countermeasures into MyTasks), and <80ms Pre-Aggregated Roll-Up Spine (mis_kpi_rollup_15m): Enables running all weekly executive and departmental reviews directly out of /mis without slide decks or spreadsheets.