‹ Back

Medication Order

The MEDICATION_ORDER table contains information relating to inpatient or admission/discharge (outpatient) medication orders.

Field Name Field Description
MEDICATION_ORDER_ID The unique primary identifier of the medication order table
LEGACY_ORDER_ID This is the non unique order code in the emr data extract
ORDER_TYPE Medication order type (e.g. Inpatient, Discharge Medication as Rx, Documented Medication by Hx). Inpatient is a medication that is prescribed for administration during the current encounter. Discharge medication as Rx is a medication prescribed and script provided to patient to use as an outpatient (this medication may not nessesarily be given to patient whist an inpatient) Documented medication by Hx is a medication prescribed and recorded as history/discharge medication, pharmacy provides these to the patient on discharge (this medication may not nessesarily be given to patient whist an inpatient)
ORDER_STATUS The status of the medication order (e.g. Ordered, Completed). Ordered is an active order where the medication is currently being administered to the patient. Completed is an order that is no longer active and is not being administered to the patient
DRUG_CODE_CNUM Cerner Multum code for the ordered drug
DOSE Medication dose ordered
ORDER_ROUTE Medication adminstration route ordered
ORDER_DRUG_FORM Medication form ordered
ORDER_FREQUENCY Medication administration frequency ordered
ORDER_START_DT_TM The start date/time of this order.
ORDER_STOP_DT_TM The projected stop date and time for this order.
OUTPATIENT_ORDER Indicated if the medication order was extracted from the outpatient medication (history/discharge orders) table in the original data extract
ORDER_PRIMARY The primary mnemonic of the orderable medication. This is the common name recognized by all clinicians who provide services to patients. For Pharmacy orders, this is the legal generic name.
ORDER_AS_MNEMONIC Name, dose and form of the ordered medication order. This is the mnemonic used by direct care providers (physicians, nurses, etc.) when they place orders in applications such as PowerOrders. This field is important for free text orderables, since order_primary is a generic name and ordered_as_mnemonic carries specific information about the order.
ORDER_PRN Indicates if the medication is ordered as a 'pro re nata' or scheduled for adminstration as needed
SPECIAL_INSTRUCTION Special instructions associated with this medication order
ORDER_DT_TM The start date/time of this order.
DRUG_CODE_DNUM Multum drug number for the ordered drug
DRUG_CODE_MMDC Main Multum drug code for the ordered drug
ADDITIONAL_CHARTS Custom drug order
ORDER_NAME Name, dose, and form of the ordered medication order