OTP_INFO_4

Description:

This table contains additional information about patient order templates.

Primary Key

Column Name	Ordinal Position
OTP_ID	1

Column Information

	Name	Type	Discontinued?
1	OTP_ID	NUMERIC	No
	The unique identifier (.1 item) for the patient order template record.
2	DOSE_ADJ_ACCEPTED_YN	VARCHAR	No
	Stores whether the dose adjustment is accepted May contain organization-specific values: No Category Entries: No Yes
3	OTP_SIGN_PAT_ENC_CSN_ID	NUMERIC	No
	Stores the patient CSN that the order template was signed in.
4	INTENDED_DISPENSE_DAYS_SUPPLY	INTEGER	No
	Indicates the intended number of days supplied by each dispense of a prescription.
5	IS_OTP_DELETED_YN	VARCHAR	No
	Virtual item that determines if an order template (OTP) has been deleted or not. An order template is considered deleted if it's associated to a deleted treatment day (VI TRG 10010), it's not yet signed or released (I OTP 140), and it's either listed as deleted in a treatment day (I TRG 1060), or (for therapy plan OTPs) is no longer linked to a specific treatment day. The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
6	NO_REIMBURS_CODESET	VARCHAR	No
	Holds the code set of the selected reimbursement code.
7	SEND_TO_PHARM_REASON_C_NAME	VARCHAR	No
	Reasons for sending a prescription directly to a pharmacy. For Australia e-prescribing. May contain organization-specific values: Yes Category Entries: Provided to Patient Dosing Point Staged Supply Repeats Kept on File
8	RX_MOBILE_NUM	VARCHAR	No
	Patient's mobile phone number. For Australia e-prescribing.
9	MED_DIRECTIONS	VARCHAR	No
	The directions for the linked medication for the order template in this row.
10	VERB_ORD_CMT	VARCHAR	No
	The verbal order comment for the order template in this row.
11	NON_PREF_PROV_LVL_REASON_C_NAME	VARCHAR	No
	Stores the reason why a non preferred level provider was chosen May contain organization-specific values: Yes