Skip to main content

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.

Report on what bills were created from your practice to assess what was billed for a patient’s visit note, what codes were used. For reporting on but not limited to:
  • Common procedural codes used for billing in order
  • Visibility into what DX codes were used in order
  • Visit note sign off and creation dates
select
   vn.patient_id
 , pt.first_name as "PATIENT_FIRST_NAME"
 , pt.last_name as "PATIENT_LAST_NAME"
 , pt.dob as "PATIENT_DOB"
 , vn.id as "VISIT_NOTE_ID"
 , chart_feed_date as "VISIT_NOTE_DATE"
 , sl.name as "SERVICE_LOCATION"
 , bi.id as "BILL_ITEM_ID"
 , billing_date
 , billing_status
 , billing_error
 , ref_number
 , b.notes
 , cpt
 , modifier_1
 , modifier_2
 , modifier_3
 , modifier_4
 , LISTAGG(icd10_code,', ') WITHIN GROUP (ORDER BY dx.seqno) AS "ICD_10 CODES"
 , concat(floor(vn.time_with_patient/60/60%24), ':', floor(vn.time_with_patient/60%60)) as "TIME_WITH_PATIENT"
 , concat('(', vn.signed_by_user_id, ')', ' ', s_user.first_name, ' ', s_user.last_name, ', ', s_user.credentials) as "VISIT_NOTE_SIGNED_BY"
 , vn.signed_time as "VISIT_NOTE_SIGNED_TIME"
 , concat('(', bi.created_by_user_id, ')', ' ', c_user.first_name, ' ', c_user.last_name, ', ', c_user.credentials) as "BILL_CREATED_BY"
 , bi.creation_time as "BILL_CREATION_TIME"
 , bi.last_modified as "BILL_LAST_MODIFIED"
from visit_note vn
  left join bill b on b.visit_note_id = vn.id
  join patient pt on pt.id = vn.patient_id
  left join bill_item bi on bi.bill_id = b.id
  left join bill_item_dx dx on dx.bill_item_id = bi.id
  left join service_location sl on sl.id = b.service_location_id
  left join user c_user on bi.created_by_user_id = c_user.id
  left join user s_user on vn.signed_by_user_id = s_user.id
where vn.deleted_by_user_id is null
and bi.deleted_by_user_id is null
and dx.deletelog_id is null
group by vn.patient_id, pt.first_name, pt.last_name, pt.dob, vn.id, chart_feed_date, bi.id, billing_date, billing_status, billing_error, ref_number, b.notes, cpt, modifier_1, modifier_2, modifier_3, modifier_4, vn.time_with_patient, vn.signed_by_user_id, vn.signed_time, bi.created_by_user_id, bi.creation_time, bi.last_modified, s_user.first_name, s_user.last_name, s_user.credentials, c_user.first_name, c_user.last_name, c_user.credentials, dx.bill_item_id, sl.name, bi.seqno
order by vn.patient_id, chart_feed_date, vn.id, bi.last_modified, bi.seqno;
If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>
Referrals Appointments