ORDER_MED_4

Description:

This table enables you to report on medications ordered. This table should be used with ORDER_MED.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	E_PRES_EARLIEST_DAT	DATETIME	No
	This column stores the earliest date on which a prescription can be filled for a Schedule II controlled medication. The date must occur on or before the start date for the prescription. It can't be changed after the order is signed.
3	ORDER_CONTEXT_ID	NUMERIC	No
	The unique identifier of the order context record associated with the order, which contains additional information about when the order is intended to be used.
4	PREV_ORD_CONTEXT_ID	NUMERIC	No
	The unique identifier of the order context record associated with the order, which contains additional information about when the order is intended to be used.
5	PARENT_ORDER_ID	NUMERIC	No
	The unique ID of the parent order record for Home Health (HH) orders. An HH order is an order which represents documentation by a user whose scope of practice doesn't include editing prescription data. Furthermore, the child order created will not be an actual prescription, but merely represents new instructions to the patient regarding how to take a medication.
6	LINKED_OP_MED_ID	NUMERIC	No
	The unique ID of the orders record. When Home Health and Hospice clinicians need to document a medication administration against an inpatient medication, a copy of the medication is created with an order mode of inpatient to document the administration. This column holds a link to the original outpatient medication.
7	INTERFACE_STAT_C_NAME	VARCHAR	No
	This column stores the ID of the interface status of the order. May contain organization-specific values: No Category Entries: ORDER SENT ORDER CANCELLED ORDER CREATED FROM INTERFACE ORDER COMP - QUEUED FOR SEND ORDER HELD
8	PRESC_ORD_SIG	VARCHAR	No
	The originally prescribed medication instructions for an order. This will be null if the original and current medication instructions are identical or if the order is not for a controlled medication that was electronically prescribed.
9	PRESC_ORD_MED_NAME	VARCHAR	No
	The originally prescribed medication name for an order. This will be null if the original medication name and current medication name are identical or if the order is not for a controlled medication that was electronically prescribed.
10	PRESC_ORD_REFILLS	VARCHAR	No
	The originally prescribed refills for an order. This will be null if the original refills and current refills are identical or if the order is not for a controlled medication that was electronically prescribed.
11	PRESC_ORD_QUANTITY	VARCHAR	No
	The originally prescribed quantity for an order. This will be null if the original quantity and current quantity are identical or if the order is not for a controlled medication that was electronically prescribed.
12	TXT_AUTHPROV_EXT_YN	VARCHAR	No
	Indicates whether the order's authorizing provider is from an external provider database. 'Y' indicates that the provider does not have a provider record in this EHR system and is from an external provider database. 'N' or NULL indicates that the provider has a provider record in this EHR system. May contain organization-specific values: No Category Entries: No Yes
13	TXT_ORDPROV_EXT_YN	VARCHAR	No
	Indicates whether the order's ordering provider is from an external provider database. 'Y' indicates that the provider does not have a provider record in this EHR system and is from an external provider database. 'N' or NULL indicates that the provider has a provider record in this EHR system. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
14	WAS_FMLY_CHECKED_YN	VARCHAR	No
	Indicates whether the medication order was compared to a formulary during signing. 'Y' indicates that the medication was compared to a payor-plan formulary, external formulary, or hospital formulary. 'N' or NULL indicates that the medication was not compared to a formulary. This does not indicate that the medication is or is not on any formulary, only that a formulary was checked for the medication. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
15	SELECTED_CRCL_SRC_C_NAME	VARCHAR	No
	The selected CrCl source category ID for the order record, indicating the source of the creatinine clearance (CrCl) value. May contain organization-specific values: No Category Entries: Formula Order Specific
16	CRCL_ORD_SPEC_VAL	NUMERIC	No
	This column stores the creatinine clearance (CrCL) value in the order.
17	SELECTED_SCR_SRC_C_NAME	VARCHAR	No
	The selected sCr source category ID for the order record, indicating the source of the serum creatinine (sCr) value. May contain organization-specific values: No Category Entries: Lab Value Order Specific
18	SCR_ORD_SPEC_VAL	NUMERIC	No
	The serum creatinine (sCr) value for the order record.
19	TRANSIG_LANGUAGE_ID	NUMERIC	No
	The unique identifier of the language record used for translating patient-facing information in this order record.
20	TRANSIG_LANGUAGE_ID_LANGUAGE_NAME	VARCHAR	No
	The language name. If the language is written and uses more than one script to represent it, the name will contain the script in parentheses after the language name.
21	ORIG_DOSE_BEFORE_SWITCH	VARCHAR	No
	The original dose of the medication before the dose was adjusted.
22	ORIG_DOSE_UNIT_BEFORE_SWITCH_C_NAME	VARCHAR	No
	The unit category ID for the order record. 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
23	MAXDOSE_HARDSTOP_YN	VARCHAR	No
	Indicate whether the max dose limit is a hard stop for this order. If "Yes", the max dose is a hard stop. Otherwise, the max dose is not a hard stop. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
24	TXT_AUTHPROV_DIST_C_NAME	VARCHAR	No
	The district category ID associated with the authorizing provider for this order record. May contain organization-specific values: Yes
25	TXT_AUTHPROV_CTY_C_NAME	VARCHAR	No
	The county category ID associated with the authorizing provider for this order record. May contain organization-specific values: Yes
26	TXT_AUTHPROV_CTRY_C_NAME	VARCHAR	No
	The country category ID associated with the authorizing provider for this order record. May contain organization-specific values: Yes
27	TXT_ORDPROV_HOUSE	VARCHAR	No
	The house number of the ordering provider for this order record.
28	TXT_ORDPROV_DIST_C_NAME	VARCHAR	No
	The district category ID associated with the ordering provider for this order record. The category values for this column were already listed for column: TXT_AUTHPROV_DIST_C_NAME
29	TXT_ORDPROV_CNTY_C_NAME	VARCHAR	No
	The county category ID associated with the ordering provider for this order record. The category values for this column were already listed for column: TXT_AUTHPROV_CTY_C_NAME
30	TXT_ORDPROV_CNTRY_C_NAME	VARCHAR	No
	The country category ID associated with the ordering provider for this order record. The category values for this column were already listed for column: TXT_AUTHPROV_CTRY_C_NAME
31	MAX_BSA	NUMERIC	No
	The maximum Body Surface Area (BSA) for an order, if the selected BSA is greater than this BSA then the selected BSA will be capped at this value.
32	MAX_DAILY_DOSE	NUMERIC	No
	Max daily dose value entered by the provider or defaulted as the calculated daily dose
33	MAX_DLY_DOSE_UNIT_C_NAME	VARCHAR	No
	The unit category ID for the orders record The category values for this column were already listed for column: ORIG_DOSE_UNIT_BEFORE_SWITCH_C_NAME
34	TXT_AUTHPROV_HOUSE	VARCHAR	No
	The house number of the authorizing provider for this order record.
35	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.
36	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.
37	UNROUND_DOSE_UNIT_C_NAME	VARCHAR	No
	The med & dose unit category ID for the unrounded dose of this order record. The category values for this column were already listed for column: ORIG_DOSE_UNIT_BEFORE_SWITCH_C_NAME
38	ION_SPEC_AC_AMT	NUMERIC	No
	This column shows the amount of acetate that a provider entered in this order record. This column will be empty if a chloride:acetate ratio or maximize option was selected.
39	ION_SPEC_AC_UNIT_C_NAME	VARCHAR	No
	The med & dose unit category ID for the acetate amount that a provider entered in this order record. This column will be empty if a chloride:acetate ratio or maximize option was selected. The category values for this column were already listed for column: ORIG_DOSE_UNIT_BEFORE_SWITCH_C_NAME
40	ION_MAXIMIZE_C_NAME	VARCHAR	No
	The ion maximize selection category ID for the order record. May contain organization-specific values: No Category Entries: Maximize Chloride Maximize Acetate
41	ION_RATIO	VARCHAR	No
	This column shows the chloride:acetate ratio option that was selected. This column is empty when a specified acetate amount was entered or when a maximize option was selected.
42	ION_BASED_TPN_YN	VARCHAR	No
	This column indicates how users specify electrolyte amounts for a total parenteral nutrition (TPN) order. 'Y' indicates that users enter amounts for specific ions to add in the TPN. 'N' indicates that users enter amounts for specific salts to add in the TPN. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
43	CALC_CL_AC_RATIO	NUMERIC	No
	This column stores the calculated chloride:acetate ratio for an ion-based total parenteral nutrition (TPN).
44	ION_PRI_CALC_AMT_C_NAME	VARCHAR	No
	This column indicates whether the primary calculated amount is a weight-based or non-weight-based value. May contain organization-specific values: No Category Entries: Base Unit Weight-Based Unit
45	USE_AUC_DOSE_YN	VARCHAR	No
	Indicates whether the system should automatically update the dose for the order based on the area under the curve (AUC) calculations. 'Y' indicates that the system updates the dose based on AUC calculations. 'N' or NULL indicates that the system does not update the dose based on AUC calculations. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
46	EPRES_PHARMACY_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
47	EPRES_PHARMACIST_ID	VARCHAR	No
	This column stores the ID of the pharmacist or pharmacy technician who accepted the prescription.
48	EPRES_PHARMACIST_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
49	RX_ACCEPT_DTTM	DATETIME (Local)	No
	Stores the instant at which the prescription was accepted.
50	RPTSIG_EXISTS_YN	VARCHAR	No
	Indicates whether the patient has indicated that they are taking this med differently from how it was prescribed to them for this order. If yes, the patient reported that they are taking the med differently. If no or null, the patient did not report that they are taking the med differently. May contain organization-specific values: No Category Entries: Yes
51	HOLD_PENDING_PA_YN	VARCHAR	No
	This item indicates whether the order is waiting for a prior authorization request to be completed before being sent to its final destination. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
52	SEND_PA_REQ_YN	VARCHAR	No
	Indicates whether a prior authorization request should be sent for a medication order when it is signed. 'Y' indicates that a prior authorization request should be sent. 'N' indicates that a prior authorization request should not be sent. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
53	PA_ORG_ID	NUMERIC	No
	The unique ID of the data exchange organization associated with the order record, which specifies the payer that a prior authorization request should be sent to when a medication order is signed.
54	PA_ORG_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
55	SCRIPT_SUP_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.
56	ONE_STEP_MEDPROC_ID	NUMERIC	No
	The unique ID of the order record. This item points to a procedure order record for the procedure used to administer the medication. The item is populated when administering a medication that is documented as administered in an Ophthalmology or Orthopedic context.
57	SPEC_DOSE_LMT_HR	INTEGER	No
	The number of hours the dosing limit represents.
58	SPEC_MED_TYPE_C_NAME	VARCHAR	No
	The special medication type category ID for this order. This indicates whether the medication uses special dosing parameters, such as for patient-controlled analgesia orders. May contain organization-specific values: No Category Entries: Non-specific Orderable Simple Generic Blood-Transfuse Feedings PCA Blood-Prepare Cyclic TPN Feedings on MAR Rapid Blood Transfuse
59	RX_TRANSITION_ID	NUMERIC	No
	The unique identifier for the patient follow-up tracking record, which stores information about how a patient is transitioning from one medication to another.
60	RX_TRANSITION_STAT_C_NAME	VARCHAR	No
	The medication transition status category ID for the order record. May contain organization-specific values: No Category Entries: Rejected Active Completed
61	RX_TRANSITION_STAT_RSN_C_NAME	VARCHAR	No
	The medication transition status change reason category ID for the order record. May contain organization-specific values: Yes Category Entries: Transition Added Patient Requested Provider Requested Transition Completed Prescription Reordered Fill Already In Progress
62	RX_TRANSITION_STAT_CMT	VARCHAR	No
	This item stores any additional comments about why the medication transition status was changed.
63	RX_TRANSITION_STAT_USR_ID	VARCHAR	No
	The unique identifier of the user who changed the transition status of the medication.
64	RX_TRANSITION_STAT_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
65	RX_TRANSITION_STAT_UTC_DTTM	DATETIME (UTC)	No
	The date and time the medication transition status of the order was changed.
66	DISCON_LOCAL_TIME	DATETIME (Local)	No
	This item stores the instant in the patient's local time zone that an order was discontinued.
67	RX_REQUEST_TYPE_C_NAME	VARCHAR	No
	The prescription request type category ID for the order record May contain organization-specific values: No Category Entries: Refill Request Therapeutic Change Generic Substitution Other Change Medication Unavailable at Selected Pharmacy Drug Use Evaluation Conflict Script Clarification Prescriber Authorization NewRx Request
68	DISC_WAIT_PA_YN	VARCHAR	No
	This column indicates whether an order was discontinued while waiting for prior authorization. The category values for this column were already listed for column: TXT_AUTHPROV_EXT_YN
69	ERX_ORD_NAME	VARCHAR	No
	The name of an order that was electronically prescribed.