Skip to content
Mimic Docs

Dentrix SQL and DEXIS Explorer

Use Agent View to inspect Dentrix SQL records, audit DEXIS image metadata, and run deterministic non-standard claim attachment workflows without leaving the platform.

Open the tools

  1. Go to /app/agents.
  2. Open an agent and enter Agent View.
  3. Use SQL Explorer for direct SQL query execution on the worker.
  4. Use DEXIS Images for patient-to-image inventory lookup, preview conversion, and tooth composites.
  5. Use Claim Workflow for non-standard claim Scope -> Validate -> Gather -> Review -> Queue.

Use SQL Explorer

Run deterministic SQL discovery and diagnostics:

  • Select a template (schema scan, patient lookup, image-table checks).
  • Configure or switch connection profiles.
  • Execute queries and review tabular or raw output.
  • Copy result data as TSV or JSON for triage handoff.

Operator guidance:

  • Keep queries bounded with TOP N and explicit WHERE clauses.
  • Treat this panel as investigation tooling; do not use write queries in production workflows.

Use DEXIS Images

Inspect DEXIS inventory from Dentrix identifiers:

  • Search by patient name, chart number, PATID, or PATIMAGEID.
  • Resolve patient in DDB_PAT, then derive the digit-sharded DEXIS path.
  • Parse DEXIS.dat and display image inventory with date, type, and tooth mapping.
  • Filter by image type, tooth, and date range.
  • Use Grid view for thumbnail browsing.
  • Use Table view for sortable metadata.
  • Use Fields view for raw field-level diagnostics from DEXIS.dat.
  • Use Scope view to classify procedures as Standard or Non-Standard and generate attachment requirement signals per procedure (XR, Perio, Narr, Pros) with image and provider-note availability indicators.
  • Optionally apply a service-date filter (YYYY-MM-DD) in Scope view to scope procedure analysis to one date; without a date filter, the panel analyzes the most recent 90 days.
  • Use Generate Composite Image to request ADA tooth numbers (1-32) and create one labeled PNG from the most recent image per requested tooth.

When image previews are needed, the panel calls /api/agents/{id}/dexis-images and polls /api/agents/{id}/dexis-images/status to convert .dex TIFF payloads into JPEG assets.

When tooth composites are needed, the panel calls /api/agents/{id}/dexis-composite and polls /api/agents/{id}/dexis-composite/status. The worker resolves the patient through Dentrix SQL, decodes tooth tags from DEXIS.dat field [10], assembles a labeled PNG, uploads it to S3, and returns composite_key for /api/assets/view?key=....

Use Claim Workflow

Run the non-standard attachment readiness flow from Agent View:

  • Scope: scan a date range for patients with non-standard ADA codes.
  • Validate: select one patient/date claim bundle and confirm code mix.
  • Gather: build a virtual file from Dentrix procedures, recent clinical notes, tooth-linked DEXIS inventory, prior tooth-procedure history, and evidence-of-need phrase matches.
  • Review: confirm readiness signals for required evidence (XR, Perio, Narr, Pros), select per-procedure actions, and finalize an overall decision (approve, hold, skip).
  • Queue: track persisted work orders by status, inspect readiness/decision detail, review execution timeline, and retry or delete failed records.

Implementation details:

  • Scope and Gather run deterministic worker snippets through /api/agents/{id}/run-snippet and poll /api/agents/{id}/run-snippet/status.
  • Scope patient labels are emitted from Dentrix as LASTNAME, FIRSTNAME.
  • Gather starts with procedure-linked teeth from the selected claim.
  • If procedures provide no tooth linkage, Gather falls back to note-derived teeth only when note date equals the selected claim service date.
  • If tooth linkage is still missing, Gather falls back to same-day DEXIS images as a last resort and matches those images to unresolved procedures.
  • Gather classifies prosthesis context per tooth from prior ledger history as initial or replacement, and extracts prep-date hints from recent crown/prosthesis-related procedures.
  • Gather tags notes with provider-authorship and evidence phrases (fracture, caries, needs crown, open margin, etc.) to support deterministic narrative checks.
  • Review computes deterministic readiness flags (pass, warn, fail) and score across X-ray, narrative, perio, and prosthesis checks.
  • X-ray readiness aligns to Y (recent), ! (found but older than 6 months), or N (missing); a generated composite image is treated as available evidence for readiness display.
  • Review marks narratives as Y when provider-authored evidence is present, ! for partial conditions (for example DOS note without evidence phrase), and N when no usable note is found.
  • Review persists work-order data locally per agent (mimic_wo_* keys) so Queue state survives panel refreshes.
  • Queue status model is draft, approved, executing, completed, failed, held; execution writes step-level detail and screenshot metadata into the same work-order record.
  • Composite generation reuses /api/agents/{id}/dexis-composite and /api/agents/{id}/dexis-composite/status, with patientLookup set to the selected PATIMAGEID string for deterministic patient resolution.
  • Outputs are marker-delimited JSON payloads for stable UI parsing and operator review (__CW_SCOPE_*, __CW_GATHER_*, __CW_EXEC_*).

Operating model

This surface follows Mimic’s RPA-First, LLM-Fallback philosophy:

  • Metadata resolution and parsing are deterministic.
  • Worker-side conversion is explicit and auditable.
  • No agentic inference is required for Dentrix/DEXIS inventory checks or claim attachment readiness classification.