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	VARCHAR	No
	The question (LQL) record ID of an order specific question in the order template in this row. Stores the history of the patient contact serial number (CSN) that the order template was signed in.
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.