ORDER_RPTD_SIG_INSTR

Description: |
For each row in ORDER_RPTD_SIG_HX, this table contains the free-text instructions that were entered, if any.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with the instructions for this medication.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of instructions within this record.
4 | INSTRUCTIONS | VARCHAR | No |
The additional instructions included with the medication instructions.
5 | MED_USE_IDENT | VARCHAR | No |
This item stores the MGB ID for MP9.
6 | MED_USE_UTC_DTTM | DATETIME (UTC) | No |
This is the effective instant of the medication use.
7 | MED_USE_PERIOD | INTEGER | No |
This stores the period (amount of time in seconds) of a medication use.