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.