OTP_INFO

Description:

This table stores basic information about a treatment plan order, such as its status, display name, which medication or procedure it represents, etc.

Primary Key

Column Name	Ordinal Position
OTP_ID	1

Column Information

	Name	Type	Discontinued?
1	OTP_ID	NUMERIC	No
	The unique identifier for the patient order template record.
2	ORDER_TYPE_C_NAME	VARCHAR	No
	The order type of the order template in this row. May contain organization-specific values: Yes Category Entries: Medications
3	PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
4	ORDER_DESC	VARCHAR	No
	The description of the order linked to the order template in this row.
5	DISPLAY_NAME	VARCHAR	No
	The display name of the order template in this row.
6	PRESEL_DISPLAY_NAME	VARCHAR	No
	The pre-selection display name for the order template in this row.
7	ORDER_CLASS_C_NAME	VARCHAR	No
	The order class of the order template in this row. May contain organization-specific values: Yes Category Entries: Normal
8	RESULTING_AGENCY_ID	NUMERIC	No
	The resulting agency ID of the order template in this row.
9	RESULTING_AGENCY_ID_LLB_NAME	VARCHAR	No
	Interface laboratory name.
10	OTP_STATUS_C_NAME	VARCHAR	No
	The status of the order template in this row. May be empty, or In Process (being released), or Converted (actually released). May contain organization-specific values: No Category Entries: In Process Converted Released for scheduling
11	PRIORITY_C_NAME	VARCHAR	No
	The priority of the order template in this row. May contain organization-specific values: Yes
12	ORDERING_QUANTITY	NUMERIC	No
	The ordering quantity of the order template in this row.
13	DX_FOLLOW_UP_C_NAME	VARCHAR	No
	The diagnostic followup of the order template in this row. May contain organization-specific values: Yes
14	CHECK_OUT_COMMENT	VARCHAR	No
	The check-out comments for the order template in this row.
15	SPECIMEN_TYPE_C_NAME	VARCHAR	No
	The specimen type for the order template in this row. May contain organization-specific values: Yes
16	SPECIMEN_SOURCE_C_NAME	VARCHAR	No
	The specimen source for the order template in this row. May contain organization-specific values: Yes
17	ORD_SIGN_CONTEXT_C_NAME	VARCHAR	No
	The context of revalidation for the order template in this row. May contain organization-specific values: Yes Category Entries: Login Other Encounters Exam Room Charting Med Orders - Ambulatory and Inpatient Addendum Immunization History Procedure Orders - Ambulatory and Inpatient Change Assoc DX SmartSets Meds except for reorders Orders through Addendum Mark letter as Sent Cosign Orders Sign Verbal Orders Documentation Flowsheet Discharge Writer Notes Discontinue/Cancel Order Change Order Status from Report Med Orders - Ambulatory Procedure Orders - Ambulatory Med Orders - Inpatient Procedure Orders - Inpatient RxRefill Request - In Basket Message (RAR) Medication Administration Pharmacy Enter Verification Pharmacy Per Order Verification E-Prescribing Pharmacy - Ambulatory Medication Order Edit Change Challenge Answers Med Orders - Controlled Pharmacy Controlled Med Verification Pharmacy Dispense Checking Pharmacy Compounding and Repackaging Anesthesia User Verification Medication Review Verification Pharmacy Dispense Preparation Imaging Study Pre-Login Status Board Case Tracking E-Prescribing Controlled Medications - First Context E-Prescribing Controlled Medications - Second Context Break-the-Glass Home Care Add New Medication Home Care Edit Medication Sig Home Care Discontinue Medication Rover Medication Administration Ambulatory Pharmacy Prescription Actions Remote Client Login PDC Signoff Pharmacy Intervention Pharmacy Dispense Tracking Minimum Data Set Signatures Cosign Medication Orders Cosign Procedure Orders Sign Verbal Medications Sign Verbal Procedures Rover Feedings Administration IRF Patient Assessment Instrument Infertility Open Anonymous Chart Standalone Staff Badge Scan Specialty Narrator Staff Badge Scan Chart Abstraction Plan of Care Signatures Enroll in Native Two Factor Authentication PDC Waste Signoff BMT Plan Verification Dental Sign-Off Rover Work List Authentication Therapy Plan Review Beacon Verbally Remove Orders Beacon Sign Stage Cancel Order Reconciliation Anesthesia Narcotic Reconciliation First User Verification Anesthesia Narcotic Reconciliation Second User Verification OpTime Timeout Verification Lab QC Report Signature Fertility Embryology Documentation Finalize Med Orders - Outpatient Controlled Med Orders - Inpatient Controlled MyChart Administrator Login Fertility Embryology Personnel Authentication OpTime Trigger Charges Verification OpTime Scheduling Override Authentication User Passive Authentication CDA Password Verification Authentication into Third Party E-Signature Authentication Willow Ambulatory Login Ambulatory Pharmacy Security Point Actions (Login User Missing Security) Ambulatory Pharmacy Security Point Actions Ambulatory Pharmacy Point Of Sale Workflow Resumption Stork Delivery Summary Sign Clarity Console Login Specialty Narrator Staff Sign-off Default User PATIENT 1 PATIENT 2 PATIENT 3 PATIENT 4 PATIENT 5 PATIENT 6 PATIENT 7 PATIENT 8 PATIENT 9 Kiosk Identification Kiosk Verification Hyperspace Identification Hyperspace Verification Hyperspace Passive Identification Hyperspace On-Demand Identification Hyperspace Enrollment Kiosk Enrollment Default Patient E-Signature (Default) E-Signature (Full Client) E-Signature (Thin Client) Haiku Login Canto Login Mobile Close Encounter Canto SmartSets Mobile Meds except for reorders Mobile Cosign Orders Mobile Sign Verbal Orders Mobile Notes Mobile Discontinue/Cancel Order Mobile Med Orders - Ambulatory Mobile Procedure Orders - Ambulatory Mobile Med Orders - Inpatient Mobile Procedure Orders - Inpatient Mobile IP Discontinue Medication Mobile IP Discontinue Procedure Mobile Med Orders - Controlled Mobile OP Discontinue Medication Mobile Cosign Medication Orders Mobile Cosign Procedure Orders Mobile Sign Verbal Medications Mobile Sign Verbal Procedures Mobile Med Orders - Outpatient Controlled Mobile Med Orders - Inpatient Controlled Mobile E-Prescribing Pharmacy - Ambulatory Mobile E-Prescribing Controlled Medications - First Context Mobile E-Prescribing Controlled Medications - Second Context Mobile Break-the-Glass Epic Monitor Login Rover Login Mobile Change PIN Mobile Medication Dual Sign Default Context EpicCare Link Login
18	ORDER_ID	NUMERIC	No
	The unique identifier of the order record linked to the order template in this row.
19	STANDING_ORDER_C_NAME	VARCHAR	No
	The standing status of the order template in this row, for example Standing or Future. May contain organization-specific values: No Category Entries: Standing Future
20	STANDING_EXP_DATE	VARCHAR	No
	The standing expiration date of the order template in this row.
21	FUT_EXPECT_COMP_DT	VARCHAR	No
	The future expected completion date of the order template in this row.
22	FUT_APPROX_DT_YN	VARCHAR	No
	The Y/N flag for the approximate future expected date for the order template in this row. May contain organization-specific values: No Category Entries: Yes No
23	STAND_INTERVAL	VARCHAR	No
	The standing interval for the order template in this row.
24	DISCRETE_INTERVAL_C_NAME	VARCHAR	No
	The discrete interval selection for the order template in this row. May contain organization-specific values: Yes
25	STAND_OCCUR	NUMERIC	No
	The standing occurrences for the order template in this row.
26	STAND_ORIG_OCCUR	NUMERIC	No
	The original number of standing occurrences for the order template in this row.
27	PERFORMING_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
28	REFG_PROV_ID	VARCHAR	No
	The ID of the referring provider for the order template in this row.
29	REFG_PROV_ID_REFERRING_PROV_NAM	VARCHAR	No
	The name of the referral source.
30	SER_ADDRESSID	VARCHAR	No
	Stores the referring provider address ID for referral orders. The format is provider external ID - Address line number. For example, if provider external ID = 123 and Address line = 4, the value would be 123-4. If the referring provider has no address, this will store the provider external ID only.
31	REFD_TO_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
32	REFD_TO_FACILITY_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
33	REFD_TO_SPECLTY_C_NAME	VARCHAR	No
	The referred-to specialty for the order template in this row. May contain organization-specific values: Yes
34	DEPT_REF_TO_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
35	DEPT_SPEC_REF_TO_C_NAME	VARCHAR	No
	The referred-to department specialty for the order template in this row. May contain organization-specific values: Yes
36	RFL_PRIORITY_C_NAME	VARCHAR	No
	The referral priority for the order template in this row. May contain organization-specific values: Yes Category Entries: Routine Urgent Emergency Elective Two Week Wait See Details
37	RFL_TYPE_C_NAME	VARCHAR	No
	The referral type for the order template in this row. This links to ZC_RFL_TYPE. May contain organization-specific values: Yes
38	RSN_FOR_RFL_C_NAME	VARCHAR	No
	The reason for referral for the order template in this row. May contain organization-specific values: Yes
39	RFL_NUM_VIS	NUMERIC	No
	The referral number of visits for the order template in this row.
40	RFL_EXPIRE_DT	VARCHAR	No
	The referral expiration date for the order template in this row.
41	PRN_COMMENT	VARCHAR	No
	The user-entered comments for why the PRN medication should be administered.
42	MED_ID_MEDICATION_NAME	VARCHAR	No
	The name of this medication record.
43	MED_CONTACT_DAT	NUMERIC	No
	The contact date of the linked medication for the order template in this row.
44	MED_ROUTE_C_NAME	VARCHAR	No
	The route of the linked medication for the order template in this row. May contain organization-specific values: Yes
45	MED_QUANTITY	VARCHAR	No
	The quantity of the linked medication for the order template in this row.
46	MED_REFILLS	VARCHAR	No
	The refill information for the linked medication for the order template in this row.
47	MED_DIRECTN_LONG	VARCHAR	No
	The long version of the instructions for the medication linked to the order template in this row.
48	MED_START_DATE	VARCHAR	No
	The start date of the medication linked to the order template in this row.
49	START_TIME	DATETIME (Local)	No
	The start time of the medication linked to the order template in this row.
50	MED_END_TIME	DATETIME (Local)	No
	The end time of the medication linked to the order template in this row.
51	MED_END_DATE	VARCHAR	No
	The end date of the medication linked to the order template in this row.
52	DISP_AS_WRITTEN_YN	VARCHAR	No
	The Y/N flag to dispense as written for the medication linked to the order template in this row. May contain organization-specific values: No Category Entries: Yes No
53	MED_DFL_DSCR_FRQ_YN	VARCHAR	No
	The Y/N flag to indicate if this order template applied to a patient should default discrete frequency info for after-visit (take-home prescription) orders. May contain organization-specific values: No Category Entries: Yes No
54	MED_DFL_DSCR_DOS_YN	VARCHAR	No
	The Y/N flag to indicate if this order template applied to a patient should default discrete dose info for after-visit (take-home prescription) orders. The category values for this column were already listed for column: MED_DFL_DSCR_FRQ_YN
55	MED_NF_CODE_C_NAME	VARCHAR	No
	The non-formulary code for the medication linked to the order template in this row. May contain organization-specific values: Yes
56	MED_COMMENTS	VARCHAR	No
	The medication comments for the medication linked to the order template in this row.
57	MED_NUM_OF_DOSES	NUMERIC	No
	The number of doses for the medication linked to the order template in this row.
58	MED_TYPE_C_NAME	VARCHAR	No
	The type of medication linked to the order template in this row. May contain organization-specific values: No Category Entries: Mixture TPN Combination
59	MODIFIED_MIXTURE_YN	VARCHAR	No
	The Y/N flag for whether the order template in this row is a modified mixture. The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
60	MED_INFUSION_TYPE_C_NAME	VARCHAR	No
	The infusion type for the medication linked to the order template in this row. May contain organization-specific values: Yes Category Entries: Continuous
61	MED_INFUSION_RATE	VARCHAR	No
	The infusion rate for the medication linked to the order template in this row.
62	MED_RATE_UNIT_C_NAME	VARCHAR	No
	The units to use with the rate for the medication linked to the order template in this row. May contain organization-specific values: Yes Category Entries: mL L mg g Units mmol mEq mcg % Int'l Units Million Units kcal ng mg PE milli-units pg KBq MBq GBq mcL mL/min L/min mg/min g/min Units/min mmol/min mEq/min mcg/min kJ/min Int'l Units/min Million Units/min kcal/min ng/min mg PE/min milli-units/min pg/min KBq/min MBq/min GBq/min mcL/min mL/hr L/hr mg/hr g/hr Units/hr mmol/hr mEq/hr mcg/hr kJ/hr Int'l Units/hr Million Units/hr kcal/hr ng/hr mg PE/hr milli-units/hr pg/hr KBq/hr MBq/hr GBq/hr mcL/hr mL/day L/day mg/day g/day Units/day mmol/day mEq/day mcg/day kJ/day Int'l Units/day Million Units/day kcal/day ng/day mg PE/day milli-units/day pg/day Inch/day KBq/day MBq/day GBq/day mcL/day IR/day BAU/day PFU/day Million PFU/day Million Int'l Units/day Kilo Int'l Units/day EIN/day Million EIN/day mL/kg L/kg mg/kg g/kg Units/kg mmol/kg mEq/kg mcg/kg kJ/kg Int'l Units/kg Million Units/kg kcal/kg ng/kg mg PE/kg milli-units/kg pg/kg mg/kg (Actual) Each/kg Puff/kg Package/kg Drop/kg Inch/kg KBq/kg MBq/kg GBq/kg mcL/kg IR/kg BAU/kg Million Int'l Units/kg mcmol/kg 1e12 Vector Genomes/kg Vector Genomes/kg Dose/kg mcg DFE/kg Kilo Int'l Units/kg 1e11 Vector Genomes/kg 1e13 Vector Genomes/kg 1e14 Vector Genomes/kg 1e15 Vector Genomes/kg EIN/kg IR/min BAU/min Million Int'l Units/min Kilo Int'l Units/min IR/hr BAU/hr Million Int'l Units/hr Kilo Int'l Units/hr mL/mL L/mL mg/mL g/mL Units/mL mmol/mL mEq/mL mcg/mL kJ/mL Int'l Units/mL Million Units/mL kcal/mL ng/mL mg PE/mL milli-units/mL pg/mL KBq/mL MBq/mL GBq/mL mcL/mL IR/mL BAU/mL PFU/mL Million PFU/mL Million Int'l Units/mL mcmol/mL 1e12 Vector Genomes/mL Vector Genomes/mL Kilo Int'l Units/mL 1e11 Vector Genomes/mL 1e13 Vector Genomes/mL 1e14 Vector Genomes/mL 1e15 Vector Genomes/mL millicurie/mL mL/L L/L mg/L g/L Units/L mmol/L mEq/L mcg/L kJ/L Int'l Units/L Million Units/L kcal/L ng/L mg PE/L milli-units/L pg/L KBq/L MBq/L GBq/L mcL/L IR/L BAU/L Million Int'l Units/L Kilo Int'l Units/L mL/m2 L/m2 mg/m2 g/m2 Units/m2 mmol/m2 mEq/m2 mcg/m2 kJ/m2 Int'l Units/m2 Million Units/m2 kcal/m2 ng/m2 mg PE/m2 milli-units/m2 pg/m2 mg/m2 (Actual) Each/m2 Puff/m2 Package/m2 Drop/m2 KBq/m2 MBq/m2 GBq/m2 mcL/m2 IR/m2 BAU/m2 Million Int'l Units/m2 mcmol/m2 1e12 Vector Genomes/m2 Vector Genomes/m2 Kilo Int'l Units/m2 1e11 Vector Genomes/m2 1e13 Vector Genomes/m2 1e14 Vector Genomes/m2 1e15 Vector Genomes/m2 mL/1.7m2 L/1.7m2 mg/1.7m2 g/1.7m2 Units/1.7m2 mmol/1.7m2 mEq/1.7m2 mcg/1.7m2 kJ/1.7m2 Int'l Units/1.7m2 Million Units/1.7m2 kcal/1.7m2 ng/1.7m2 mg PE/1.7m2 milli-units/1.7m2 pg/1.7m2 Each/1.7m2 KBq/1.7m2 MBq/1.7m2 GBq/1.7m2 mcL/1.7m2 IR/1.7m2 BAU/1.7m2 Million Int'l Units/1.7m2 Kilo Int'l Units/1.7m2 mL/kg (IDL) L/kg (IDL) mg/kg (IDL) g/kg (IDL) Units/kg (IDL) mmol/kg (IDL) mEq/kg (IDL) mcg/kg (IDL) Int'l Units/kg (IDL) Million Units/kg (IDL) Kcal/kg (IDL) ng/kg (IDL) mg PE/kg (IDL) milli-units/kg (IDL) pg/kg (IDL) mg/m2 (IDL) mL/kg (ADJ) L/kg (ADJ) mg/kg (ADJ) g/kg (ADJ) Units/kg (ADJ) mmol/kg (ADJ) mEq/kg (ADJ) mcg/kg (ADJ) Int'l Units/kg (ADJ) Million Units/kg (ADJ) Kcal/kg (ADJ) ng/kg (ADJ) mg PE/kg (ADJ) milli-units/kg (ADJ) pg/kg (ADJ) mg/m2 (ADJ) mL/100 mL L/100 mL mg/100 mL g/100 mL Units/100 mL mmol/100 mL mEq/100 mL mcg/100 mL kJ/100 mL Int'l Units/100 mL Million Units/100 mL kcal/100 mL ng/100 mL mg PE/100 mL milli-units/100 mL pg/100 mL KBq/100 mL MBq/100 mL GBq/100 mL mcL/100 mL IR/100 mL BAU/100 mL Million Int'l Units/100 mL Kilo Int'l Units/100 mL mL/oz L/oz mg/oz g/oz Units/oz mmol/oz mEq/oz mcg/oz kJ/oz Int'l Units/oz Million Units/oz kcal/oz ng/oz mg PE/oz milli-units/oz pg/oz KBq/oz MBq/oz GBq/oz mcL/oz IR/oz BAU/oz Million Int'l Units/oz Kilo Int'l Units/oz mL/kg/min L/kg/min mg/kg/min g/kg/min Units/kg/min mmol/kg/min mEq/kg/min mcg/kg/min kJ/kg/min Int'l Units/kg/min Million Units/kg/min kcal/kg/min ng/kg/min mg PE/kg/min milli-units/kg/min pg/kg/min KBq/kg/min MBq/kg/min GBq/kg/min mcL/kg/min mL/kg/min (IDL) L/kg/min (IDL) mg/kg/min (IDL) g/kg/min (IDL) Units/kg/min (IDL) mmol/kg/min (IDL) mEq/kg/min (IDL) mcg/kg/min (IDL) Int'l Units/kg/min (IDL) Million Units/kg/min (IDL) Kcal/kg/min (IDL) ng/kg/min (IDL) mg PE/kg/min (IDL) milli-units/kg/min (IDL) pg/kg/min (IDL) mL/kg/min (ADJ) L/kg/min (ADJ) mg/kg/min (ADJ) g/kg/min (ADJ) Units/kg/min (ADJ) mmol/kg/min (ADJ) mEq/kg/min (ADJ) mcg/kg/min (ADJ) Int'l Units/kg/min (ADJ) Million Units/kg/min (ADJ) Kcal/kg/min (ADJ) ng/kg/min (ADJ) mg PE/kg/min (ADJ) milli-units/kg/min (ADJ) pg/kg/min (ADJ) IR/kg/min BAU/kg/min Million Int'l Units/kg/min Kilo Int'l Units/kg/min mL/m2/min L/m2/min mg/m2/min g/m2/min Units/m2/min mmol/m2/min mEq/m2/min mcg/m2/min kJ/m2/min Int'l Units/m2/min Million Units/m2/min kcal/m2/min ng/m2/min mg PE/m2/min milli-units/m2/min pg/m2/min KBq/m2/min MBq/m2/min GBq/m2/min mcL/m2/min mL/1.7m2/min L/1.7m2/min mg/1.7m2/min g/1.7m2/min Units/1.7m2/min mmol/1.7m2/min mEq/1.7m2/min mcg/1.7m2/min kJ/1.7m2/min Int'l Units/1.7m2/min Million Units/1.7m2/min kcal/1.7m2/min ng/1.7m2/min mg PE/1.7m2/min milli-units/1.7m2/min pg/1.7m2/min KBq/1.7m2/min MBq/1.7m2/min GBq/1.7m2/min mSv mGy mcL/1.7m2/min mg of pseudoephedrine IR/m2/min BAU/m2/min Million Int'l Units/m2/min Kilo Int'l Units/m2/min IR/1.7m2/min BAU/1.7m2/min Million Int'l Units/1.7m2/min Kilo Int'l Units/1.7m2/min mL/kg/hr L/kg/hr mg/kg/hr g/kg/hr Units/kg/hr mmol/kg/hr mEq/kg/hr mcg/kg/hr kJ/kg/hr Int'l Units/kg/hr Million Units/kg/hr kcal/kg/hr ng/kg/hr mg PE/kg/hr milli-units/kg/hr pg/kg/hr KBq/kg/hr MBq/kg/hr GBq/kg/hr mcL/kg/hr mL/kg/hr (IDL) L/kg/hr (IDL) mg/kg/hr (IDL) g/kg/hr (IDL) Units/kg/hr (IDL) mmol/kg/hr (IDL) mEq/kg/hr (IDL) mcg/kg/hr (IDL) Int'l Units/kg/hr (IDL) Million Units/kg/hr (IDL) Kcal/kg/hr (IDL) ng/kg/hr (IDL) mg PE/kg/hr (IDL) milli-units/kg/hr (IDL) pg/kg/hr (IDL) mL/kg/hr (ADJ) L/kg/hr (ADJ) mg/kg/hr (ADJ) g/kg/hr (ADJ) Units/kg/hr (ADJ) mmol/kg/hr (ADJ) mEq/kg/hr (ADJ) mcg/kg/hr (ADJ) Int'l Units/kg/hr (ADJ) Million Units/kg/hr (ADJ) Kcal/kg/hr (ADJ) ng/kg/hr (ADJ) mg PE/kg/hr (ADJ) milli-units/kg/hr (ADJ) pg/kg/hr (ADJ) IR/kg/hr BAU/kg/hr Million Int'l Units/kg/hr Kilo Int'l Units/kg/hr mL/m2/hr L/m2/hr mg/m2/hr g/m2/hr Units/m2/hr mmol/m2/hr mEq/m2/hr mcg/m2/hr kJ/m2/hr Int'l Units/m2/hr Million Units/m2/hr kcal/m2/hr ng/m2/hr mg PE/m2/hr milli-units/m2/hr pg/m2/hr KBq/m2/hr MBq/m2/hr GBq/m2/hr mcL/m2/hr mL/1.7m2/hr L/1.7m2/hr mg/1.7m2/hr g/1.7m2/hr Units/1.7m2/hr mmol/1.7m2/hr mEq/1.7m2/hr mcg/1.7m2/hr kJ/1.7m2/hr Int'l Units/1.7m2/hr Million Units/1.7m2/hr kcal/1.7m2/hr ng/1.7m2/hr mg PE/1.7m2/hr milli-units/1.7m2/hr pg/1.7m2/hr KBq/1.7m2/hr MBq/1.7m2/hr GBq/1.7m2/hr mcL/1.7m2/hr IR/1.7m2/hr BAU/1.7m2/hr Million Int'l Units/1.7m2/hr Kilo Int'l Units/1.7m2/hr IR/m2/hr BAU/m2/hr Million Int'l Units/m2/hr Kilo Int'l Units/m2/hr mL/kg/day L/kg/day mg/kg/day g/kg/day Units/kg/day mmol/kg/day mEq/kg/day mcg/kg/day kJ/kg/day Int'l Units/kg/day Million Units/kg/day kcal/kg/day ng/kg/day mg PE/kg/day milli-units/kg/day pg/kg/day Inch/kg/day KBq/kg/day MBq/kg/day GBq/kg/day mL/kg/day (IDL) L/kg/day (IDL) mg/kg/day (IDL) g/kg/day (IDL) Units/kg/day (IDL) mmol/kg/day (IDL) mEq/kg/day (IDL) mcg/kg/day (IDL) Int'l Units/kg/day (IDL) Million Units/kg/day (IDL) Kcal/kg/day (IDL) ng/kg/day (IDL) mg PE/kg/day (IDL) milli-units/kg/day (IDL) pg/kg/day (IDL) mL/kg/day (ADJ) L/kg/day (ADJ) mg/kg/day (ADJ) g/kg/day (ADJ) Units/kg/day (ADJ) mmol/kg/day (ADJ) mEq/kg/day (ADJ) mcg/kg/day (ADJ) Int'l Units/kg/day (ADJ) Million Units/kg/day (ADJ) Kcal/kg/day (ADJ) ng/kg/day (ADJ) mg PE/kg/day (ADJ) milli-units/kg/day (ADJ) pg/kg/day (ADJ) mcL/kg/day IR/kg/day BAU/kg/day Million Int'l Units/kg/day mL/m2/day L/m2/day mg/m2/day g/m2/day Units/m2/day mmol/m2/day mEq/m2/day mcg/m2/day kJ/m2/day Int'l Units/m2/day Million Units/m2/day kcal/m2/day ng/m2/day mg PE/m2/day milli-units/m2/day pg/m2/day KBq/m2/day MBq/m2/day GBq/m2/day mcL/m2/day mL/1.7m2/day L/1.7m2/day mg/1.7m2/day g/1.7m2/day Units/1.7m2/day mmol/1.7m2/day mEq/1.7m2/day mcg/1.7m2/day kJ/1.7m2/day Int'l Units/1.7m2/day Million Units/1.7m2/day kcal/1.7m2/day ng/1.7m2/day mg PE/1.7m2/day milli-units/1.7m2/day pg/1.7m2/day KBq/1.7m2/day MBq/1.7m2/day GBq/1.7m2/day mcL/1.7m2/day mL/oz/day L/oz/day mg/oz/day g/oz/day Units/oz/day mmol/oz/day mEq/oz/day mcg/oz/day kJ/oz/day Int'l Units/oz/day Million Units/oz/day kcal/oz/day ng/oz/day mg PE/oz/day milli-units/oz/day pg/oz/day KBq/oz/day MBq/oz/day GBq/oz/day mcL/oz/day IR/m2/day BAU/m2/day Million Int'l Units/m2/day Kilo Int'l Units/m2/day IR/1.7m2/day BAU/1.7m2/day Million Int'l Units/1.7m2/day Kilo Int'l Units/1.7m2/day IR/oz/day BAU/oz/day Million Int'l Units/oz/day Kilo Int'l Units/oz/day kJ/30 mL kcal/30 mL Gy-cm2 mL/cm2 mg/cm2 mOsmol each tablet capsule drop tsp puff suppository spray Squirt inch patch Act ampule Bar Bottle Can Device enema Gallon Inhaler kit lb lozenge oz packet Stick strip Tbsp Tube vial Wafer Container Syringe Package applicator cm Applicatorful Troche millicurie Intra Uterine Device Part m Film Million Cells Dose mm IR BAU kg cm2 Imperial Gallon kJ PFU Piece Million PFU Doses/Fill Cartridge Thousand Units Lipoprotein Lipase Releasing Unit Scoop Million Int'l Units mm2 Pump fluid ounce Product Bag mcmol 1e12 Vector Genomes Vector Genomes millicurie/kg millicurie/m2 millicurie/1.7m2 microcurie microcurie/kg microcurie/m2 microcurie/1.7m2 Canister mcg DFE Billion Cells Application Box Capful Inhalation Lancet Needle Pad Pen Piece of gum Ring Swab Sachet Implant Insert Pools Kilo Int'l Units Kilo Int'l Units/kg/day 1e11 Vector Genomes 1e13 Vector Genomes 1e14 Vector Genomes 1e15 Vector Genomes Cells EIN Million EIN EIN/kg/day None / Other
63	MED_INFUSE_DURATION	VARCHAR	No
	The duration for the medication linked to the order template in this row.
64	MED_DURATION_UNIT_C_NAME	VARCHAR	No
	The units to use with the duration of the medication linked to the order template in this row. May contain organization-specific values: No Category Entries: Minutes Hours Days
65	TPN_SITE_C_NAME	VARCHAR	No
	The infusion site of the medication linked to the order template in this row. May contain organization-specific values: Yes Category Entries: Central Peripheral Umbilical None / Other
66	MED_VOLUME	VARCHAR	No
	The volume of the medication linked to the order template in this row.
67	MED_VOLUME_UNIT_C_NAME	VARCHAR	No
	The units to use with the volume of the medication linked to the order template in this row. The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
68	CALCULATE_VOLUME_YN	VARCHAR	No
	The Y/N flag for whether or not the volume should be calculated for the medication linked to the order template in this row. The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
69	MIXTURE_CONC_C_NAME	VARCHAR	No
	The concentration of a mixture (for fixed ratio mixtures) for the medication linked to the order template in this row. May contain organization-specific values: Yes
70	DISCRETE_FREQ_ID	VARCHAR	No
	The discrete frequency for the medication linked to the order template in this row.
71	DISCRETE_FREQ_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
72	DISCRETE_DOSE_MIN	VARCHAR	No
	The minimum discrete dose for a medication whose dose was entered as a range, or the discrete dose amount for a medication whose dose was not entered as a range.
73	DOSE_UNIT_C_NAME	VARCHAR	No
	The dose unit category for the medication linked to the order template in this row. The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
74	ORDER_TIME_PRIOR_C_NAME	VARCHAR	No
	The discrete order time priority for the medication linked to the order template in this row. May contain organization-specific values: Yes Category Entries: Now AM Today Tomorrow Next Draw
75	ENC_CSN	NUMERIC	No
	The contact serial number (CSN) of the encounter linked to the order template in this row.
76	ORDER_FREQ	VARCHAR	No
	The frequency of the medication being ordered in this order template.
77	OTP_TPL_ID	NUMERIC	No
	The ID of the treatment plan that contains this order template.
78	OTP_TRG_ID	NUMERIC	No
	The ID of the treatment day that contains this order template.
79	DISCRETE_DOSE_MAX	VARCHAR	No
	The maximum discrete dose for a medication whose dose was entered as a range.
80	MAX_DOSE	NUMERIC	No
	This column stores the suggested maximum dose amount for the patient order template record.
81	MAX_DOSE_UNIT_C_NAME	VARCHAR	No
	This column stores the suggested maximum dose unit for the patient order template record. The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
82	OVRD_IMS_PROD_ID_MEDICATION_NAME	VARCHAR	No
	The name of this medication record.
83	INDICATION_COMMENTS	VARCHAR	No
	User's comments for the corresponding Indications of Use (stored in OTP_INDICATIONS table)
84	MED_DISP_QTY	NUMERIC	No
	This item stores the medication dispense quantity when discrete dispense is enabled.
85	MED_DISP_UNIT_C_NAME	VARCHAR	No
	This item stores the medication dispense unit when discrete dispense is enabled. The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
86	MAX_BSA	NUMERIC	No
	The maximum Body Surface Area (BSA) for an order, if the selected BSA is greater than this BSA than the selected BSA will be capped at this value.