OTP_INFO_1

Description:

This table is a continuation of related table OTP_INFO. It stores additional information about a treatment plan order, such as verbal signing information, inpatient medication information, 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	TRANSPORTATION_C_NAME	VARCHAR	No
	The transportation type associated with the order template in this row. May contain organization-specific values: Yes
3	IP_DISC_INTERVAL_ID	VARCHAR	No
	The discrete interval associated with the order template in this row.
4	IP_DISC_INTERVAL_ID_FREQ_NAME	VARCHAR	No
	The name of the frequency record.
5	IP_STANDING_COUNT	NUMERIC	No
	The standing count associated with the order template in this row.
6	IP_STAND_CNT_TYPE_C_NAME	VARCHAR	No
	The inpatient standing count type (Dose/Days/etc) associated with the order template in this row. May contain organization-specific values: No Category Entries: Days Weeks Hours Occurrences Months Years
7	IP_INCLUDE_NOW_C_NAME	VARCHAR	No
	The frequency associated with the order template in this row, for example, "Include Now", "As Scheduled", "At Nurse Discretion." May contain organization-specific values: No Category Entries: Include Now As Scheduled At Nurse Discretion
8	SCHED_EXTRA_DOSE_TM	DATETIME (Local)	No
	The time at which to schedule the first occurrence of the associated order template in this row.
9	COST_CENTER_ID	NUMERIC	No
	The unique identifier for the cost center associated with the order template in this row.
10	COST_CENTER_ID_COST_CENTER_NAME	VARCHAR	No
	The name of the cost center.
11	ORDERING_MODE_C_NAME	VARCHAR	No
	The ordering mode (inpatient or outpatient) of the order template in this row. May contain organization-specific values: No Category Entries: Outpatient Inpatient
12	SELF_ADMIN_YN	VARCHAR	No
	Indicates whether the order template in this row is self-administered. ‘Y’ indicates that the order template in this row is self-administered. ‘N’ or NULL indicate that the order template in this row is not self-administered. May contain organization-specific values: No Category Entries: Yes No
13	PAT_SUPP_MED_YN	VARCHAR	No
	Indicates whether the order template in this row is a patient supplied medication. ‘Y’ indicates that the order template in this row is a patient supplied medication. ‘N’ or NULL indicate that the order template in this row is not a patient supplied medication. The category values for this column were already listed for column: SELF_ADMIN_YN
14	PAT_SUPPLIED_DOSES	NUMERIC	No
	The number of patient supplied doses.
15	CALC_DOSE_AMOUNT	VARCHAR	No
	The calculated dose to administer for the order template in this row.
16	CALC_DOSE_UNIT_C_NAME	VARCHAR	No
	The units for the calculated dose to administer for 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
17	DOSE_CALC_INFO	VARCHAR	No
	The dose calculation information for the order template in this row.
18	ADMIN_DOSE	VARCHAR	No
	The amount to administer for the medication in this order template.
19	ADMIN_UNIT_C_NAME	VARCHAR	No
	The units to use with the amount to administer for the medication in this order template. The category values for this column were already listed for column: CALC_DOSE_UNIT_C_NAME
20	VERB_ORD_TYPE_C_NAME	VARCHAR	No
	The verbal order type for the order template in this row. For example, Ordering, Cosign, or Discontinuing. May contain organization-specific values: Yes Category Entries: Ordering Cosign Discontinuing Pending Discontinue Edit Delete Continue on Transfer Discontinue on Transfer New on Transfer Unreview on Transfer Holding Unholding Order and Hold Assigning Administration Responsibility Cancel Hold Discontinue on Admission Discontinue on Discharge Sign on Admission Sign on Discharge Modify for Admission Modify for Discharge Modify for Transfer Continue on Admission Continue on Discharge Do Not Order on Admission Do Not Prescribe on Discharge Do Not Order on Transfer Sign on Inter-Facility Transfer Modify for Inter-Facility Transfer Discontinue on Inter-Facility Transfer Continue on Inter-Facility Transfer Do Not Order on Inter-Facility Transfer Pause on Discharge Resume from Pause on Discharge
21	VERB_ORD_COMM_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.
22	VERB_ORD_SIGNER_ID	VARCHAR	No
	The user ID of the verbal order signer for the order template in this row.
23	VERB_ORD_SIGNER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
24	VERB_ORD_MSGRCP_ID	VARCHAR	No
	The user ID of the verbal order message recipient for the order template in this row.
25	VERB_ORD_MSGRCP_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
26	VERB_ORD_MSG_ID	VARCHAR	No
	The ID of the verbal order message.
27	VERB_ORD_SIGN_INST	DATETIME (Attached)	No
	The date/time in external format when the verbal order was signed.
28	VERB_ORD_MODE_C_NAME	VARCHAR	No
	The verbal order mode of the order template in this row. May contain organization-specific values: Yes Category Entries: Verbal Standard
29	ORD_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.
30	AUTH_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.
31	CALC_RATE_FRM_VD_YN	VARCHAR	No
	Indicated whether or not to calculate rate given volume and duration. "Y" indicates that the rate will be calculated. "N" indicates that rate will not be calculated. May contain organization-specific values: No Category Entries: No Yes
32	CONDITION_FLAG	NUMERIC	No
	The condition flag for the order template in this row.
33	MED_DOSE_PP_DESC	VARCHAR	No
	The free text description of the dose calculation for the order template in this row.
34	OTP_ISOLATION_C_NAME	VARCHAR	No
	The isolation category for the order template in this row. May contain organization-specific values: Yes
35	OTP_CODESTATUS_C_NAME	VARCHAR	No
	The code status for the order template in this row. May contain organization-specific values: Yes Category Entries: <Disabled> Full Code DNR Partial Code
36	CODESTATUS_COMMENT	VARCHAR	No
	The code status comments for the order template in this row.
37	DIET_C_NAME	VARCHAR	No
	The diet specified in the order template in this row. May contain organization-specific values: Yes
38	DIET_COMMENTS	VARCHAR	No
	The diet comments in the order template in this row.
39	DOSE_ADJ_TYPE_C_NAME	VARCHAR	No
	This contains the type of dose adjustment - maximum, minimum, or standardized. May contain organization-specific values: No Category Entries: Maximum Dose Minimum Dose Minimum and Maximum Adjustment
40	DOSE_ADJ_OVERRID_YN	VARCHAR	No
	Indicates whether dose adjustment in I OTP 34180 was overridden. "Y" indicates that dose adjustment was overridden. "N" indicates that dose adjustment was not overridden. The category values for this column were already listed for column: CALC_RATE_FRM_VD_YN
41	EFQ_OVRD_DAY_TYPE	INTEGER	No
	If column EFQ_OVRD_REL_DAYS in table OTP_FREQ_OV_REL_D is populated, this item specifies what the numeric values in that item represent. If this item's value is 1, then column EFQ_OVRD_CYCL_LEN stores relative days, otherwise OTP_FREQ_OV_REL_D stores weekdays.
42	EFQ_OVRD_CYCL_LEN	INTEGER	No
	If EFQ_OVRD_DAY_TYPE is 1 (meaning the override times stored in the record are relative cycles), then this item stores the length of the cycle.
43	ORX_ID	NUMERIC	No
	Networked Order Lookup Index Panel ID of an order template record applied to a patient.
44	ORX_ID_ORDER_LOOKUP_NAME	VARCHAR	No
	The name (.2 item) for the order panel record.
45	CSGN_CREATE_DTTM	DATETIME (UTC)	No
	When the cosign requirement was created (UTC Time).
46	DFI_ID	NUMERIC	No
	The unique identifier for the Deficiency Instance record associated with the cosignature requirement for this order.
47	CSGN_RQRD_C_NAME	VARCHAR	No
	Stores a yes/no flag for if an action requires a cosign (I OTP 34856). May contain organization-specific values: No Category Entries: Yes No Administratively Closed
48	MEDS_ACTION_VERB_C_NAME	VARCHAR	No
	Action verb which is used in patient sig of the order. May contain organization-specific values: Yes No Entries Defined
49	PRIOR_AUTH_NEEDED_YN	VARCHAR	No
	Stores if an order needs prior authorization. The category values for this column were already listed for column: CALC_RATE_FRM_VD_YN
50	UNROUNDED_DOSE_MIN	NUMERIC	No
	The unrounded dose of this order. If the dose has a range (e.g. 1-2 mg), this is the lower end of the range. If the dose does not have a range, then this will store the dose.
51	UNROUNDED_DOSE_MAX	NUMERIC	No
	The unrounded dose of this order. If the dose has a range (e.g. 1-2 mg), this is the upper end of the range. Otherwise, this is null.
52	UNROUND_DOSE_UNIT_C_NAME	VARCHAR	No
	The dose unit category ID for the unrounded dose of this order. The category values for this column were already listed for column: CALC_DOSE_UNIT_C_NAME
53	TO_PHARMACY_ID	NUMERIC	No
	The pharmacy that the order will be sent to.
54	TO_PHARMACY_ID_PHARMACY_NAME	VARCHAR	No
	The name of the pharmacy.
55	MLSIG_SIGTYPE_C_NAME	VARCHAR	No
	The type of sig being used. May contain organization-specific values: No Category Entries: SIMPLE THEN AND THEN-AND
56	COLLECTED_BY_USER_ID	VARCHAR	No
	This is the user who collected the specimen.
57	COLLECTED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
58	COUNT_RANGE	VARCHAR	No
	This item stores a ranged value for the count of the order that goes along with the standing count type, indicating the number of hours, days, weeks, or occurrences for which the order will take place. Currently only available in Finland.
59	COUNT_RANGE_STND_TP_C_NAME	VARCHAR	No
	This ranged count type goes along with the count from OTP-34042 to indicate the number of days, weeks, months, years, or occurrences for which the order will take place. Currently only available in Finland. The category values for this column were already listed for column: IP_STAND_CNT_TYPE_C_NAME