THOR Medical — Mission Control

📊 Overview

📋 Attorney Outreach

🏥 Surgery Center

⚠️ Encounter Compliance

🧠 Kanzi Brain

📂 AR Workflow

💎 QoE

💰 Collection Rates

🌿 Growth Intelligence

📍 Geo-Analytics

🏋️ Kanzi Training Camp

Total Open AR

$206.9M

55,474 patients

Total Billed

$561.1M

2020+ across all firms

Total Collected

$170.5M

Insurance + Patient payments

Overall Collection Rate

30.4%

Billed-basis | Collectible: 45.2%

ℹ tap to explore

🚨 Critical Firms — Collection Rate Below 15%

📈 Quarterly AR Trend & Concentration

Quarterly Outstanding AR

AR Concentration — Top 10 Firms

🏆 Top 50 Attorney Firms by Outstanding AR

Firm	Patients	Billed	Collected	Open AR	Coll%	Status

🏥 Surgery Center

📈 AR Story

🔗 Bridge & Raw Data

Gross Charges

—

— cases

Payments

—

— of charges

Write-offs

—

— of charges

Outstanding AR

—

net balance

Collection Rate

—

payments ÷ charges

Top 50 Patients by Outstanding AR

#	Patient	DOB	City, ST	Cases	Charges	Payments	Write-offs	Net AR
Loading…

👥 Patient Explorer (full SIS patient list — click any row to drill into Cases, Statements, Procedures…)

—

PatientKey	Name	DOB	MRN	City, ST	Cases	Statements	Net AR
Loading…

🏥 Surgery Center — SIS Data Feed Bridge

CareCloud Patients

—

demographics loaded

SIS Patients

—

Roswell ASC (1 facility)

Auto-matched

—

Needs Review

—

T3 + ambiguous

Unmatched

—

no CC record found

Match Tier Breakdown

Tier	Match Rule	Confidence	Count	% of SIS
Loading…

Review Queue (T3 + ambiguous + unmatched — human judgment required)

SIS Key	SIS MRN	SIS Name	DOB	Tier	Matched On	CC Patient ID
Loading…

Source: thor.db.sis_patient_bridge (SIS OData v1.0 ↔ CareCloud ODS). Last bridge run: —. Bridge logic: T1-SSN → T1-EXACT (name+DOB [+tiebreak]) → T2-FUZZY (DOB + Lev≤1) → T3-REVIEW (DOB+last only).

📦 SIS Data Explorer (full historical feed — every row from every SIS entity)

—

Pick an entity to load data

⚠️ Migration Errors (unresolved rows from the SIS full load — drive retry logic)

Entity	PK	Reason	Retries	Last Attempt
Loading…

📊 Watermark Status (per-entity row count + last ingest)

Entity	Rows	SIS Total	Coverage	Last Full Load	Last Incremental	Errors
Loading…

💰 Collection Rate Analysis — Top 50 Firms

Collection rates for the top 50 attorney firms by outstanding AR (2020+), grouped by performance tier. ■ Green (30%+) — on track (16 firms · best: Van Sant Law 47.7%). ■ Yellow (15–29%) — at risk, requires active outreach (20 firms). ■ Red (<15%) — critical, low or stalled collections (14 firms · worst: The Ettinoffe Law Firm 1.1%). Median collection rate across top 50: 24.4%. Target: 30%+.

📋 Attorney Outreach CasesDOS window: 24 – 36 months prior

This list contains every open attorney-referred patient account with a date of service falling 24 to 36 months ago — the optimal window for collections outreach, as most PI and lien cases reach settlement within 2–3 years of treatment.

Each row represents one patient. The Open AR column shows the net outstanding balance after all insurance and patient payments. Click any row to open the Case Detail panel — use it to review every charge, appointment, and encounter making up the balance before contacting the attorney.

🔎 How to use: Sort by Open AR (default) to prioritize largest balances. Filter by firm or entity using the search box. For NLR-flagged records, verify current representation before outreach — the original attorney may no longer hold the lien.

Attorney Firm	Patient	MRN	Open AR ▼	First DOS	Physician	Entity	Method

🔴 Clawback Risk ℹ️

138,759

unsigned encounters w/ payments collected

$124.6M

collected against unsigned notes

⚠️ Active payer audit risk. Providers must retrospectively sign or face repayment demands.

🟡 Blocked AR ℹ️

76,983

unsigned encounters w/ charges, no payment

$153.0M

open AR blocked from payer submission

⏳ Revenue at risk of timely filing deadline. Sign oldest encounters first.

⚪ No Findings ℹ️

20,169

encounters with no charges or findings

financial impact — record integrity gap only

📋 Batch audit recommended. Likely mix of placeholders and forgotten notes.

👤 Provider Compliance Leaderboard ℹ️

Provider	Unsigned	🔴 w/ Payments	⏰ >90 Days
ERIK BENDIKS	22,657	19,004	22,356
JOSHUA LEVY	18,775	11,960	17,556
VINSON SMITH	18,161	12,327	17,328
DARYL FIGA	18,084	12,906	17,377
THAI TRUONG	17,190	10,514	15,793
AUGUSTO CIANCIABELLA	15,479	8,672	14,012
QUENTIN JENKINS	10,214	5,536	9,255
JOE MONTES DE OCA	9,978	4,754	8,815
NICHOLAS CAPUTO	9,780	5,019	8,699
JASON CROWDER	9,462	4,644	8,329

🚧 Coming Soon — THOR Autonomous Agents

🚧

Send Provider Reminder

via THOR Agent

🚧

Bulk Remind Provider

via THOR Agent

🚧

Create Charge

via THOR Agent

🚧

Export Worklist

Scheduled Report

🚧

Auto-Escalate Rules

Rules Engine + API

🏦

Payment Reconciliation

Bank · Merchant · Lockbox

DataChimpLabs × THOR Medical

🌱 Growth Intelligence

pSEO engine performance · keyword opportunity · organic lead pipeline

17,436

Pages Deployed

sitemap-verified · 3 sites

Live Sites

Languages

—

Low-Comp Keywords

Paid Ad Spend

100% organic

2.1M+

Mo. Searches Targeted

~180K est. local · GA · NC · TN

🚀 Deployed Sites

🔧

pseo.thormed.ai

Template / staging environment

↗ 🍑

Georgia — gaspineortho.com

9 clinic locations · :8081

↗ 🐝

NC + SC — apexosn.com

5 clinic locations · :8082

↗ 🎸

Tennessee — apexosntn.com

2 clinic locations · :8083

↗

📖 What is pSEO?

Keyword Research

1,755 total keywords (all low-competition) — 79 T1 money keywords · 37 T2 high-volume · 30 T3 long-tail patterns · 1,609 site-specific. Sourced from Google Ads Keyword Planner against GaSpineOrtho.com and ApexOSN.com seed URLs.

Template × Scale

1 React SPA codebase deployed 3 times — once per brand. 54 services × 44 locations (18 GA + 14 NC/SC + 12 TN) × 6 languages + 249 blog articles = 17,436 sitemap-verified indexed pages. Zero manual content writing.

Organic Traffic → Patients

Each ranked page = a free lead channel. As pages index, organic traffic compounds monthly — reducing paid acquisition cost toward zero.

Measure → Optimize

Next: Google Analytics integration to track page → appointment conversion. Compare keyword performance to actual AR intake.

🔑 Keyword Poolloading…

LOW comp MEDIUM comp HIGH comp

Tier	Keyword	Avg Mo. Searches	Competition	Low CPC	High CPC
Loading keywords…

Tier:

🌍 Languages Deployed

🇺🇸

English

🇪🇸

Spanish

🇫🇷

French

🇰🇷

Korean

🇯🇵

Japanese

🇵🇹

Portuguese

+ Google Analytics integration coming

THOR Medical · 16 Clinic Locations

📍 Patient Geo-Analytics

Drive-time friction · no-show correlation · weather/DOI · air quality patterns

🏥 Clinic Registry — 16 Locations

🍑 Georgia — gaspineortho.com (entity 3307)

Atlanta · 30328 · Fulton

Roswell · 30076 · Fulton

Marietta · 30060 · Cobb

Suwanee · 30024 · Gwinnett

Tucker · 30084 · DeKalb

College Park · 30337 · Fulton

Stockbridge · 30281 · Henry

Columbus · 31901 · Muscogee

Dalton · 30721 · Whitfield

🐝 NC + SC — apexosn.com (entity 5573/6143)

Charlotte NC · 28210 · Mecklenburg

Raleigh NC · 27615 · Wake

High Point NC · 27262 · Guilford

Wilmington NC · 28401 · New Hanover

Rock Hill SC · 29732 · York

🎸 Tennessee — apexosntn.com

Chattanooga · 37411 · Hamilton

Nashville · 37211 · Davidson

⚙️ How Drive Time is Calculated

1. Patient ZIP → geocode (lat/lng)

2. patient.entity_id → nearest clinic location

3. Clinic address → geocode (lat/lng)

4. Google Distance Matrix → drive minutes

5. Join appointments → no-show rate by distance bucket

📊 Distance Buckets

0–15 min 15–30 min 30–45 min 45–60 min 60+ min

🔬 Analysis Queries — Click to run

🏥

No-Show Baseline by Clinic

Entity-level no-show rate across all 4 clinic groups. Establishes the baseline — how many scheduled appointments result in a no-show at each location? Updated every 4 hours from live appointment data.

Data source: SQLite appointments snapshot (pre-computed cache)

▶ Run Analysis

⛈️

Weather vs. Date-of-Injury Spikes

Cross-reference patient DOI dates against historical weather events (storms, ice, rain) by clinic region. Do weather events predict injury intake spikes?

Data sources: patients.doi + Open-Meteo historical weather API

▶ Run Analysis

🌿

Air Quality + Pollen vs. Patient Volume

Correlate daily AQI and pollen index by clinic location against appointment volume spikes. Do high-pollen/pollution days drive more visits for respiratory and allergy conditions?

Data sources: appointments + Google Air Quality + Pollen API

▶ Run Analysis

📍

Drive-Time No-Show Analysis

LIVE API

Real drive times via Google Distance Matrix. ZIP-level no-show rates bucketed by <15 min, 15–30 min, 30–45 min, 45–60 min, 60+ min. Identifies high-risk ZIPs for telehealth outreach targeting.

Data sources: CareCloud ODS patient ZIPs + Google Distance Matrix API

▶ Run Analysis

💡

Marketing insight from geo-analytics: Patients who live 45+ min from a clinic have 2–3× higher no-show rates on average in comparable ortho practices. This unlocks telehealth outreach targeting, reminder call prioritization by distance bucket, and location-specific pSEO pages targeting patients in underserved drive-time zones.

Living Intelligence · Self-Reporting

🤖 Kanzi Intelligence Log

Query audit · edge cases · parse errors · timing anomalies

—

Total Queries

—

Query Errors

—

ETL Errors

—

Doc Errors

—

Brain Errors

—

Slow (>90s)

—

Out of Scope

—

Avg Time (s)

—

Unique Users

Filter:

Time	User	Question	Source	Status	Repair	Time (s)	Parts
Loading log…

—

Per page: 1 / 1

Living Intelligence · Neural Graph

🧠 Kanzi Brain

Knowledge rules · Conversations · Memory · Growing with every interaction

Filter: 🔵 Rules 🟢 Conv 🟣 Cat 🟡 Docs 🦩 Files (off) 📄 Upload

📄

Select a rule or document from the tree

Click any item to view and edit its content

AR Adjudication · Patient Workflow Intelligence

📂 AR Workflow

Click a bucket → patient list → patient row → full patient modal (Overview · History · Notes · Tasks)

Entity: Year: Self-pay only

Loading adjudication data…

🏷 Sentiment Tag Dictionary — how collectibility risk is scored from patient notes

▼

Tags are detected by scanning the most recent 20 notes for keyword patterns. The Risk Score (0–100) starts at 50 and is adjusted by: note recency (±40), note frequency in 90d (±15), and tag signals below.

promised_payment+20

Notes mention patient/attorney promised payment or agreed to a plan. Positive collectibility signal.

unreachable−15

No answer / voicemail / disconnected / wrong number. Negative signal. Escalate via certified mail or attorney contact.

attorney_repneutral

Notes reference attorney, counsel, or law firm representing the patient. Confirms representation for lien collection.

deceased−50

Patient passed away. Major writeoff risk. Verify against patient status. Contact estate executor or attorney.

disputed−20

Patient/firm disputes, refuses, or challenges the bill. Needs legal review. Do not send demand without compliance approval.

settled+10

Case settled / paid in full / closed. Positive signal. Reconcile against payments to confirm balance is $0.

active_followup+10 if ≤30d

Recent follow-up activity (call/email/letter sent). Positive only if note is ≤30 days old. Stale follow-ups add no score.

Risk Score formula: Base 50 · Note recency: ≤14d +25, ≤30d +15, ≤60d +5, ≤90d −10, ≤180d −25, >180d −40 · Notes in 90d: ≥5 +15, ≥2 +8 · Tag signals as above. Range: 0–100. Score ≥70 = strong, 40–69 = moderate, <40 = at-risk.

Portfolio Intelligence · All Entities

💎 Quality of Earnings (QoE)

Investor-grade portfolio rollup · collected cash vs open AR vs writeoff, per entity

Year:

Loading portfolio data…

Entity ↕	Patients ↕	Billed ↕	Collected ↕	Open AR ↕	Writeoff ↕	Rate ↕	Buckets

⚕️ THOR Medical — AR Mission Control

Quarterly Outstanding AR

AR Concentration — Top 10 Firms

📋 Report Library

Quarterly Outstanding AR

AR Concentration — Top 10 Firms

Case

📋 Report Library

🤖 Ask THOR Living Data Intelligence · Powered by Kanzi