We use cookies from Google Analytics to improve our website. By accepting, you will receive these cookies from open.epic. Decline if you wish to use open.epic without these cookies. Read our privacy policy here.

ORD_MED_PROD_ADMIN
Description:
This table contains product-specific administration instructions. This information is already contained as a part of the table ORD_MED_ADMININSTR so this table does not have to be extracted.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique ID of the medication order (prescription) record. NOTE: This is an internal unique identifier for order (ORD) master file records in this table and cannot be used to link to CLARITY_MEDICATION.rd.
2 LINE INTEGER No
The line number for each product-specific administration instruction line.
3 MED_PROD_ADMN_INSTR VARCHAR No
Product-specific administration instructions converted to plain text. This item is automatically updated whenever the medication product changes for the given order, either through intelligent medication selection (IMS) for mixtures or by user action. It is automatically appended to item Administration instructions.
4 ORDERING_DATE DATETIME No
The date the order was placed in calendar format.