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

# Worklist

> Query Elation Billing biller worklists to see which claims are flagged for review and their outstanding balance.

One row per worklisted claim - a claim flagged onto a biller worklist in Elation Billing, with the claim's outstanding balance at the time it was flagged. Each row joins back to the claim via `claim_id`, and the reason it was flagged lives in the companion `worklist_reason` table.

This table's columns and relationships are shown in the [Hosted Database schema](/articles/hdb/schema).

<Note>
  `worklist.claim_id` is the Elation Billing claim id and joins to `claim.id` - it is not an EHR `bill` id.
</Note>

**For reporting on but not limited to:**

* Claims currently on a biller worklist
* Outstanding balance carried by worklisted claims
* Worklist backlog size and value over time

## Claims currently on a worklist

Returns the active worklist with each claim's payer-facing detail and the balance recorded when it was flagged.

<CodeGroup>
  ```sql sql theme={null}
  select
      w.id as worklist_id
    , w.claim_id
    , c.local_id as claim_local_id
    , c.practice_id
    , c.patient_id
    , c.rendering_provider_name
    , w.balance
    , w.created_timestamp as worklisted_at
  from worklist w
    join claim c on c.id = w.claim_id
  where w.is_deleted = false
    and c.is_deleted = false
  order by w.balance desc;
  ```
</CodeGroup>

## Worklist backlog by practice

Summarizes the size and outstanding value of each practice's worklist.

<CodeGroup>
  ```sql sql theme={null}
  select
      c.practice_id
    , count(*) as worklisted_claims
    , sum(w.balance) as total_balance
    , avg(w.balance) as avg_balance
  from worklist w
    join claim c on c.id = w.claim_id
  where w.is_deleted = false
    and c.is_deleted = false
  group by c.practice_id
  order by total_balance desc;
  ```
</CodeGroup>

## Claims on a worklist over 30 days

Surfaces worklisted claims open longer than 30 days - an aging view for prioritizing biller follow-up on stale items.

<CodeGroup>
  ```sql sql theme={null}
  select
      w.claim_id
    , c.local_id as claim_local_id
    , c.practice_id
    , c.rendering_provider_name
    , w.balance
    , w.created_timestamp as worklisted_at
    , datediff(day, w.created_timestamp, current_date) as days_on_worklist
  from worklist w
    join claim c on c.id = w.claim_id
  where w.is_deleted = false
    and c.is_deleted = false
    and w.created_timestamp < dateadd(day, -30, current_date)
  order by days_on_worklist desc;
  ```
</CodeGroup>

*If you have any questions about this topic please reach out to [Elation Support Portal](/articles/support-portal-introduction) with the subject line HDB - \<your\_question>*