OTP_ORDER_SPEC_QST

Description: |
The order specific questions for an order template.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | OTP_ID | NUMERIC | No |
The order template ID.
2 | LINE | INTEGER | No |
The line number that corresponds to each order specific question in the order template in this row.
3 | ORD_SPEC_QUESN_ID_QUEST_NAME | VARCHAR | No |
The name of the question record.
4 | ORD_SPEC_QUESN_DT | NUMERIC | No |
The contact date of an order specific question in the order template in this row.
5 | ORD_SPEC_QUESN_RESP | VARCHAR | No |
The response to an order specific question in the order template in this row.
6 | ORD_SPEC_QUESN_CMT | VARCHAR | No |
The comment on an order specific question in the order template in this row.
7 | IS_ANSWR_BYPROC_YN | VARCHAR | No |
The Y/N flag for whether or not the question in the order template in this row should be answered per procedure.
May contain organization-specific values: No
Category Entries:
Yes
No
8 | ORD_SPEC_QUESN_COMP | NUMERIC | No |
The order specific question component for the order template in this row.
9 | ORD_SPEC_QUESN_DTE | NUMERIC | No |
The contact date in decimal format of the question.