- Lab orders sent from you practice including the diagnosis code(s)
- What labs an order was sent to
- Count of how many orders were sent to specific labs
- How orders are being sent
- What codes and test names were used in the order.
- When and how an order was created by and signed and by who
- Which visit or non-visit note an order was placed from
visit_note_id and non_visit_note_id name the note each order was placed from, and are empty for an order created outside a note. See Orders placed from a note.
Results for an order
resolving_document_id is the lab report that fulfilled the order. Join it to lab_result.lab_report_id for the result values, or to report.id for the report itself.
resolving_document_id holds a value only for orders with an order_state of fulfilled, and is empty for outstanding and cancelled orders. See Following up on outstanding orders & referrals.
This returns the result values for each fulfilled lab order: