> ## 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.

# Claim Note

> Query the notes billers leave on Elation Billing claims, including who wrote each note and when.

One row per note per claim - the trail of notes billers build up on an Elation Billing claim as they work it. Each row carries the note text, the Elation Billing user who wrote it, and when it was written. Every note is attributed to a user, so this table is the record of who touched a claim and what they said about it. Filter on `is_deleted = false` to exclude notes that have since been removed.

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

<Note>
  `claim_note.claim_id` is the Elation Billing claim id and joins to [claim](/articles/hdb/claim)`.id` - it is not an EHR `bill` id. `claim_note.elation_billing_user_id` joins to `elation_billing_user.id` and is an Elation Billing user identifier, not an Elation EHR user id.
</Note>

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

* The full note history on a single claim, in the order it was written
* Which biller last touched a claim, and when
* Note volume per biller over a date range
* Notes flagged to count toward a patient's statement (`is_statement_note = true`)
* Auditing follow-up on denied or aging claims by pairing notes with claim status

## Note history for a claim

Returns every note on a single claim, oldest first, with the name and login of the biller who wrote it.

<CodeGroup>
  ```sql sql theme={null}
  select
      n.id as claim_note_id
    , n.created_timestamp
    , concat(u.first_name, ' ', u.last_name) as author_name
    , u.email as author_email
    , n.is_statement_note
    , n.note
  from claim_note n
    left join elation_billing_user u on u.id = n.elation_billing_user_id
  where n.is_deleted = false
    and n.claim_id = 1234567890  -- Replace with actual claim ID
  order by n.created_timestamp;
  ```
</CodeGroup>

## Claims by who last touched them

Returns the most recent note on each claim, so you can see which biller worked a claim last and how long ago.

<CodeGroup>
  ```sql sql theme={null}
  select
      c.id as claim_id
    , c.local_id
    , c.from_date
    , c.is_billed
    , n.created_timestamp as last_note_timestamp
    , concat(u.first_name, ' ', u.last_name) as last_author_name
    , n.note as last_note
  from claim c
    inner join claim_note n on n.claim_id = c.id
    left join elation_billing_user u on u.id = n.elation_billing_user_id
  where c.is_deleted = false
    and n.is_deleted = false
  qualify row_number() over (partition by c.id order by n.created_timestamp desc) = 1
  order by n.created_timestamp desc
  limit 100;
  ```
</CodeGroup>

## Note volume per biller

Ranks billers by how many claim notes they wrote over the last 90 days.

<CodeGroup>
  ```sql sql theme={null}
  select
      concat(u.first_name, ' ', u.last_name) as author_name
    , u.email as author_email
    , count(*) as notes_written
    , count(distinct n.claim_id) as distinct_claims
    , max(n.created_timestamp) as most_recent_note
  from claim_note n
    left join elation_billing_user u on u.id = n.elation_billing_user_id
  where n.is_deleted = false
    and n.created_timestamp >= dateadd(day, -90, current_date)
  group by u.first_name, u.last_name, u.email
  order by notes_written desc;
  ```
</CodeGroup>

## Statement notes for a patient

Returns only the notes flagged to count toward a patient's statement, across every claim for that patient.

<CodeGroup>
  ```sql sql theme={null}
  select
      pat.first_name
    , pat.last_name
    , c.id as claim_id
    , c.local_id
    , n.created_timestamp
    , concat(u.first_name, ' ', u.last_name) as author_name
    , n.note
  from claim_note n
    inner join claim c on c.id = n.claim_id
    left join patient pat on pat.id = c.patient_id
    left join elation_billing_user u on u.id = n.elation_billing_user_id
  where n.is_deleted = false
    and n.is_statement_note = true
    and c.patient_id = 1234567890  -- Replace with actual patient ID
  order by n.created_timestamp 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>*