MTD Completed Encounters Report — Exult Clinic
Date range: 2026-06-01 through 2026-06-16
Scope: completed encounters (excl $CNS99 no-show code, excl DANA provider)
Categories: med mgmt, therapy, TMS

STATUS: BLOCKED — could not execute report

BLOCKER:
This task was dispatched into the Sendblue orchestrator worktree
(tools/sendblue-channel), whose Bash hook validator (hooks/validate-bash.sh)
blocks curl, python3 (except /tmp/cksum.py), and any path outside
/Users/<user>/openclaw or /Users/<user>/.claude or /tmp.

Specific gaps preventing execution:
1. No AMD credentials file present at ~/claude-workspace/config/credentials/
   advancedmd.json (the path the advancedmd skill points to). The path does
   not exist on this container.
2. The Bash hook allowlist permits only tmux inspection, orchestrator
   dispatch scripts, read-only pnpm/git/gh, and bounded filesystem reads.
   No HTTP client (curl) and no scripting interpreter (python3) is callable.
3. The user explicitly excluded Keragon MCP (the only MCP-side AMD client
   wired into this conversation) due to earlier auth issues.
4. No worker tmux pane pool (_boot:1.3 / 1.4) is present in this VM — the
   three existing tmux sessions (exult-agent, outlook, teams) are peer
   Claude orchestrators, not delegation targets for an AMD API caller.

WHAT WOULD UNBLOCK:
- Run this report from a host that has AMD credentials loaded AND an HTTP
  client available (iMac exult-agent — which is the box that owns
  ~/claude-workspace/config/credentials/advancedmd.json — or any worker
  with curl + the credentials file).
- The AMD primary API is the ppmdmsg dispatcher at
  {webserver}/xmlrpc/processrequest.aspxx (JSON broker). Initial login
  goes to https://partnerlogin.advancedmd.com/practicemanager/xmlrpc/
  processrequest.aspx with office 161112, then resubmits to the redirected
  webserver to receive a usercontext token (24h validity).
- Query plan once auth is held: action=getdatevisits for each date
  2026-06-01..2026-06-16, OR action=getupdatedvisits with datechanged set
  to 2026-06-01T00:00:00 (single call). Filter results by:
    * appointment status indicating completed/checked-out (not CXL/NS)
    * provider != DANA
    * exclude any visit whose linked charge has procedure code CNS99
  Categorize remaining visits by AppointmentType into med-mgmt / therapy /
  TMS buckets.

NO COUNTS AVAILABLE.