> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vizkraft.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Healthcare / ops

> Connect clinic operations data, build four dashboards, and track volume, claims, utilization, and wait times — modeled on CareBridge Clinics.

export const CookbookDemoVideo = ({slug, caption = "See this cookbook in Vizkraft"}) => {
  const base = `/public/recordings/cookbooks/${slug}`;
  return <figure className="not-prose my-8 overflow-hidden rounded-xl border border-gray-200 dark:border-gray-800">
      {caption ? <figcaption className="border-b border-gray-200 bg-gray-50 px-4 py-2 text-center text-sm text-gray-600 dark:border-gray-800 dark:bg-gray-900 dark:text-gray-400">
          {caption}
        </figcaption> : null}
      <video autoPlay muted loop playsInline className="w-full dark:hidden">
        <source src={`${base}/mist.webm`} type="video/webm" />
        <source src={`${base}/mist.mp4`} type="video/mp4" />
      </video>
      <video autoPlay muted loop playsInline className="hidden w-full dark:block">
        <source src={`${base}/carbon.webm`} type="video/webm" />
        <source src={`${base}/carbon.mp4`} type="video/mp4" />
      </video>
    </figure>;
};

This cookbook is for **healthcare operations** teams managing scheduling, encounters, billing, and provider capacity. The examples use **CareBridge Clinics**, a fictional multi-site outpatient network.

## Who this is for

|                  |                                                       |
| ---------------- | ----------------------------------------------------- |
| **Company type** | Outpatient clinics, provider networks, health systems |
| **Connector**    | PostgreSQL                                            |
| **Teams**        | Clinic ops, revenue cycle, medical leadership         |

## Get started

<Steps>
  <Step title="Add PostgreSQL">
    Connect your scheduling, EHR, or revenue warehouse. See [Add connectors](/guides/add-connectors).
  </Step>

  <Step title="Index and mark key tables">
    Flag appointments, admissions, claims, and providers.
  </Step>

  <Step title="Ask your first question">
    Try: *What is no-show rate by site for the last 90 days?*
  </Step>

  <Step title="Build the dashboards below">
    Share operational and revenue-cycle views with site leaders.
  </Step>
</Steps>

## See it in Vizkraft

<CookbookDemoVideo slug="healthcare-ops" caption="CareBridge clinic operations in Vizkraft" />

## Your data

| Table           | What it holds                                      |
| --------------- | -------------------------------------------------- |
| `patients`      | Demographics, insurance type, region               |
| `providers`     | Specialty, site, FTE                               |
| `appointments`  | Scheduled visits, status, wait time                |
| `admissions`    | Encounters — department, admit and discharge       |
| `claims`        | Claim amount, status, submission and payment dates |
| `billing_codes` | Procedure and diagnosis reference                  |

### Tables to mark during indexing

* **Appointments** — volume, no-shows, wait times
* **Admissions** — encounter volume and capacity
* **Claims** — revenue cycle and A/R
* **Providers** — utilization and scheduling load

## Dashboards to build

### Patient volume and capacity

**Answers:** How busy are our sites and where are no-shows highest?

Include appointment and admission KPIs, no-show rate, daily volume trend, and volume by site.

### Claims and revenue cycle

**Answers:** How efficiently are we collecting revenue?

Include days in A/R and denial rate KPIs; claims by status; and an aging claims table.

### Provider utilization

**Answers:** Are clinicians scheduled efficiently?

Include utilization and FTE KPIs; utilization by specialty; and provider schedule load table.

### Wait times and SLA

**Answers:** Are patients waiting too long?

Include average and p95 wait KPIs; wait trend over time; and wait by department.

## Questions to ask by role

| Role               | Questions to try                                        |
| ------------------ | ------------------------------------------------------- |
| Clinic ops manager | What is no-show rate by site and specialty?             |
| RCM analyst        | What are days in A/R and denial rate by insurance type? |
| Medical director   | What is provider utilization by specialty and site?     |

## Example conversations

### No-show rate

**Ask:** What is no-show rate by site for the last 90 days?

Use the result to compare sites fairly — pair rate with appointment volume.

## Metrics worth defining

Add to [Connector memory](/features/connector-memory) as needed:

* **No-show rate** — no-show appointments ÷ scheduled appointments
* **Days in A/R** — average days from claim submission to payment
* **Utilization** — booked clinical time ÷ available capacity
* **Denial rate** — denied claim amount ÷ submitted amount