SRS: UC_9.9 — Flow 31: Aggregate Exhaustion Monitor (Sev-1)

SELECT
  SUM(current_mtd_volume) AS total_mtd_volume,
  SUM(monthly_limit)      AS total_aggregate_capacity
FROM merchant_routing_config
WHERE is_active = TRUE;

N = current day of month (e.g. 15)
ADV = total_mtd_volume / N

T = total days in current calendar month (e.g. 30 for September)
Projected_EOM_Volume = ADV × T

IF Projected_EOM_Volume >= total_aggregate_capacity:
  projected_exhaustion = true
ELSE:
  projected_exhaustion = false

🚨 [SEV-1 CRITICAL] AGGREGATE VOLUME PACING EXHAUSTION DETECTED
Current Day: [current_day_of_month] / [total_days_in_month]
Total MTD Volume: $[total_mtd_volume]
Average Daily Volume: $[average_daily_volume]/day
Projected EOM Volume: $[projected_eom_volume]
Total Aggregate Capacity: $[total_aggregate_capacity]

CRITICAL: Aggregate pacing indicates all merchant accounts will exhaust
capacity before month end. Immediate intervention required.

{
  "calculation_date": "2026-09-03",
  "current_day_of_month": 3,
  "total_days_in_month": 30,
  "total_mtd_volume": 45000.00,
  "total_aggregate_capacity": 450000.00,
  "average_daily_volume": 15000.00,
  "projected_eom_volume": 450000.00,
  "projected_exhaustion": true,
  "active_mids_count": 4
}

{
  "projected_exhaustion": false,
  "total_aggregate_capacity": 0,
  "active_mids_count": 0,
  "status_code": "NO_ACTIVE_MIDS_WARNING",
  "message": "All payment MIDs are currently inactive. Ops Config Warning dispatched."
}

IF current_day_of_month <= 3:
  → return { projected_exhaustion: false }  // Grace period — skip pacing math
ELSE:
  → Execute standard ADV / Projected_EOM_Volume calculation

Step 1: Query active MIDs
  activeMIDs = SELECT * FROM Merchant_Routing_Config WHERE is_active = TRUE

Step 2: Compute total_aggregate_capacity
  total_aggregate_capacity = SUM(activeMIDs.monthly_limit)

GUARD CLAUSE:
  IF activeMIDs.length = 0 OR total_aggregate_capacity = 0:
    → log WARN: "All payment MIDs inactive — suppressing SEV-1 exhaustion alert"
    → return { projected_exhaustion: false, status_code: "NO_ACTIVE_MIDS_WARNING",
               active_mids_count: 0, total_aggregate_capacity: 0 }
    → Middleware MUST additionally dispatch a separate Ops Config Warning
      to **`#ops-treasury`** (distinct from SEV-1, NOT routed to Freshdesk):
      "🚨 CRITICAL CONFIGURATION ERROR: All MIDs are currently marked inactive."

Step 3 onwards: Standard pacing math — only executes when active_mids_count > 0

🟡 [SEV-2 WARNING] Volume Pacing Monitoring Endpoint Unavailable
• Event: Zapier Flow 31 failed to fetch MID volume pacing metrics.
• Target Endpoint: GET /calculate-volume-pacing
• Status: Failed after 3 retries (Non-200 / Timeout).
• Impact: Daily aggregate merchant capacity check was SKIPPED tonight.
• Action Required: @dev_ops please inspect Middleware Hub logs in AWS CloudWatch.

Zapier Flow 31: GET /calculate-volume-pacing
         │
         ├─ HTTP 200 OK
         │    ├─ projected_exhaustion = true  → SEV-1 Slack Alert (#ops-treasury)
         │    └─ projected_exhaustion = false → Pass (no alert)
         │
         └─ Non-200 / Timeout
              └─ Auto-retry 3×, 5 min intervals
                   └─ Persistent fail (all 3 retries exhausted)
                        └─ SEV-2 Slack Alert (#ops-treasury + #dev_ops)