ORDER_MED_MORPHINE_EQUIV
Description:
This table stores virtual morphine equivalence items in ORD.

Primary Key
Column Name Ordinal Position
ORDER_ID 1

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier (.1 item) for the order record.
2 PCA_MORPHINE_EQUIV_CONV_FACTOR NUMERIC No
This column stores the calculated morphine equivalent conversion factor of a patient-controlled analgesia (PCA) order. If the order is not for a PCA or it does not have a linked PCA assessment configured, the value will be null. The conversion factor is calculated as the equivalent amount of mg of morphine based on a 1-unit dose of the order. If the medication doesn't contain an opioid, the value will be zero. If there is an error calculating the morphine equivalency, the value will be 999999.