ORD_SPEC_QUEST

Description: |
This table contains order specific questions and their responses.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | LINE | INTEGER | No |
The line item for this record determined by the order specific question ID
3 | ORD_QUEST_ID_QUEST_NAME | VARCHAR | No |
The name of the question record.
4 | ORD_QUEST_DATE | DATETIME | No |
The date of the question for this order.
5 | IS_ANSWR_BYPROC_YN | VARCHAR | No |
Indicates whether or not this question was answered by the procedure. 'Y' indicates that the question was answered. 'N' indicates that the question was not answered.
May contain organization-specific values: No
Category Entries:
Yes
No
6 | ORD_QUEST_COMP | INTEGER | No |
The line number of the medication in the mixture that triggers this specific question for an IV or total parenteral nutrition (TPN) order.
7 | ORD_QUEST_RESP | VARCHAR | No |
The response to the question for this order.
8 | ORD_QUEST_CMT | VARCHAR | No |
The comments on the question of the order.