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

# Medication Orders

Report on all Medication Orders created and sent from your practice

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

* Medication information

  * Name of medication
  * Type of medication
  * Instructions and sig

* Track which Pharmacy your practice is sending medications to

* How many controlled substances was prescribed

* Tracking in house medication(s) for inventory purposes

* When and who prescribed a medication

<CodeGroup>
  ```sql sql theme={null}
  select
     mo.ID as "MED_ORDER_ID"
   , mo.PATIENT_ID
   , pt.first_name as "PATIENT_FIRST_NAME"
   , pt.last_name as "PATIENT_LAST_NAME"
   , pt.dob as "PATIENT_DOB"
   , mo.MED_ORDER_THREAD_ID
   , concat('(', PRESCRIBING_USER_ID , ')', ' ', p_user.first_name, ' ', p_user.last_name) as "PRESCRIBING_USER"
   , concat('(', mo.DOCUMENTING_PERSONNEL_ID , ')', ' ', doc_user.first_name, ' ', doc_user.last_name) as "DOCUMENTING_PERSONNEL"
   , mo.START_DATE
   , mo.MEDICATION_ID
   , controlled
   , dea_description
   , mo.DISPLAYED_MEDICATION_NAME
   , med.brand_name
   , med.generic_name
   , mo.TYPE
   , mo.ROUTE
   , mo.STRENGTH
   , mo.FORM
   , mo.NDC
   , mo.MEDICATION_TYPE
   , mo.DIRECTIONS
   , mo.INDICATION
   , mo.QTY
   , mo.QTY_UNITS
   , mo.AUTH_REFILLS
   , mo.AUTH_REFILLS_QUALIFIER
   , mo.PHARMACY_NCPDPID
   , pharm.store_name as "PHARMACY_STORE_NAME"
   , mo.PHARMACY_INSTRUCTIONS
   , mo.SUBSTITUTIONS
   , mo.ORIGIN
   , mo.NOTES
   , mo.FULFILLMENT_TYPE
   , concat('(', mo.signed_by_user_id, ')', ' ', s_user.first_name, ' ', s_user.last_name, ', ', s_user.credentials) as "SIGNED_BY"
   , mo.SIGNED_TIME
   , concat('(', mo.created_by_user_id, ')', ' ', c_user.first_name, ' ', c_user.last_name, ', ', c_user.credentials) as "CREATED_BY"
   , mo.CREATION_TIME
   , concat('(', mo.deleted_by_user_id, ')', ' ', d_user.first_name, ' ', d_user.last_name, ', ', d_user.credentials) as "DELETED_BY"
   , mo.DELETION_TIME
   , mo.LAST_MODIFIED
  from med_order mo
    join patient pt on pt.id = mo.patient_id
    left join user p_user on mo.prescribing_user_id = p_user.id
    left join user c_user on mo.created_by_user_id = c_user.id
    left join user d_user on mo.deleted_by_user_id = d_user.id
    left join user s_user on mo.signed_by_user_id = s_user.id
    left join user doc_user on doc_user.physician_id = mo.documenting_personnel_id
    left join pharmacy pharm on mo.pharmacy_ncpdpid = pharm.ncpdpid
    left join medication med on med.id = mo.medication_id;
  ```
</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>*