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

# Lab Results

Report of all Lab Results received and documented

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

* All results received to your practice including test category, name, and result values.
* Name of lab a result was received by
* Results collected date and resulted date.
* Audit of who signed and/or deleted the results

<CodeGroup>
  ```sql sql theme={null}
  select
     r.patient_id
   , pt.first_name as "PATIENT_FIRST_NAME"
   , pt.last_name as "PATIENT_LAST_NAME"
   , pt.dob as "PATIENT_DOB"
   , lr.lab_report_id
   , lr.collected_date
   , r.chart_feed_date
   , r.requisition_number
   , r.ordering_provider_name
   , r.vendor_name
   , r.order_status
   , lr.resulted_date
   , lr.accession_status
   , lr.accession_number
   , lr.test_category
   , lr.test_name
   , lr.value
   , lr.units
   , lr.value_type
   , lr.reference_min
   , lr.reference_max
   , lr.is_abnormal
   , lr.abnormal_flag
   , lr.report_text
   , lr.value_note
   , lr.note
   , lr.loinc
   , lr.is_deleted
   , concat('(', r.signed_by_user_id, ')', ' ', s_user.first_name, ' ', s_user.last_name, ', ', s_user.credentials) as "SIGNED_BY"
   , r.signed_time
   , concat('(', r.created_by_user_id, ')', ' ', c_user.first_name, ' ', c_user.last_name, ', ', c_user.credentials) as "CREATED_BY"
   , r.creation_time
   , concat('(', r.deleted_by_user_id, ')', ' ', d_user.first_name, ' ', d_user.last_name, ', ', d_user.credentials) as "DELETED_BY"
   , r.DELETION_TIME
   , r.last_modified
  from report r
    left join lab_result lr on lr.lab_report_id = r.id
    join patient pt on pt.id = r.patient_id
    left join user s_user on r.signed_by_user_id = s_user.id
    left join user c_user on r.created_by_user_id = c_user.id
    left join user d_user on r.deleted_by_user_id = d_user.id
  where report_type = 'Lab'
  and is_deleted = 'FALSE';
  ```
</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>*