ORDER_MED_3
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 ORIG_RX_DOSAGE VARCHAR No
Original prescription column; contains the medication order dosage.
3 ORIG_RX_QUANTITY VARCHAR No
Original prescription column; contains the medication order quantity.
4 ORIG_RX_REFILLS VARCHAR No
Original prescription column; contains the medication refills.
5 ORIG_RX_DIRECTIONS VARCHAR No
Original prescription column; contains the medication directions.
6 ORIG_RX_PRE_PROV_ID VARCHAR No
Original prescription column; contains the medication order prescriber ID.
7 ORIG_RX_COMMENTS VARCHAR No
Original prescription column; contains the medication comments.
8 PRESCRIP_EXP_DATE DATETIME No
Contains the expiration date for the prescription.
9 ORD_AUC NUMERIC No
Item to store the area under curve value for medications using this value in dose calculation.
10 ORD_SEL_TARGETAUC_C_NAME VARCHAR No
Selected type of the Target AUC in the order composer.
May contain organization-specific values: Yes
Category Entries:
Treatment Plan Target AUC
Order-Specific Target AUC
11 ORIG_RX_PHRM_ID NUMERIC No
Original prescription column; contains the pharmacy
12 ORIG_RX_PHRM_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
13 ORD_PHASE_OF_CARE_C_NAME VARCHAR No
This item will store the phase of care for which this order was created. Example: Pre-Op, Intra-Op, PACU.
May contain organization-specific values: Yes
14 ORIGINAL_MED_ID NUMERIC No
The unique ID of the medication that determines the formulary status of the order at order entry. The formulary status of this medication at the time of ordering is found in the column ORDER_MED.NON_FORMULARY_YN. For Intelligent Medication Selection (IMS) cases, it will be the medication picked by the user before IMS changes the medication. This is only set for inpatient medication orders. It is recommended to use the Clarity column ORDER_MEDINFO.DISPENSABLE_MED_ID when reporting on medication orders. Use ORIGINAL_MED_ID for reporting on the formulary status of medications chosen by ordering users.
15 INTERACT_COMMENT VARCHAR No
Interaction override comment.
16 COPY_POINTER_ID NUMERIC No
This object tracks order (ORD) record links created when using the inpatient or ambulatory order mover utilities to move an ORD record. This item is populated on the source ORD record and points to the target ORD record(s) created.
17 CONDITION_FLAG INTEGER No
This column contains the Condition Flag for an order.
18 PRINT_LOCAL_COPY_YN VARCHAR No
Indicates whether to print a copy of this order. 'Y' indicates to print a copy of this order. 'N' indicates not to print a copy of this order.
May contain organization-specific values: No
Category Entries:
Yes
No
19 ORX_ID NUMERIC No
This column contains the record ID from the Order Lookup Index (ORX). The ORX contains records for all active medication records and procedure records. This may be populated if an order originates from an Order Panel.
20 ORX_ID_ORDER_LOOKUP_NAME VARCHAR No
The name (.2 item) for the order panel record.
21 SELECTED_FOR_OPC_YN VARCHAR No
Indicates whether the order has been selected for resulting in the Orderable/Performable/Chargeable navigator.
May contain organization-specific values: No
Category Entries:
Yes
No
22 MEDS_RESYME_REASO_C_NAME VARCHAR No
This item stores the reason to resume the medication.
May contain organization-specific values: Yes
23 MEDS_DC_REASON_C_NAME VARCHAR No
This item is populated in discharge navigator to save discontinue reason at the time of discharge. The value entered will be copied to I ORD 7074.
May contain organization-specific values: Yes
24 IP_INCLUDE_NOW_C_NAME VARCHAR No
This is when to start the medication administration.
May contain organization-specific values: No
Category Entries:
Include Now
As Scheduled
At Nurse Discretion
25 IP_INCL_NOW_SCH_C_NAME VARCHAR No
Result of Scheduling Include Now Instant for Order
May contain organization-specific values: No
Category Entries:
No Include Now Instant
Distinct Include Now Instant
Standard Time Matches Include Now Instant
26 LAST_SCHED_DATE DATETIME No
The last scheduled date of the order.
27 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
28 MED_SOURCE_C_NAME VARCHAR No
Source of externally ordered medication.
May contain organization-specific values: Yes
No Entries Defined
29 CRCL_FORMULA_ID NUMERIC No
The creatinine clearance CrCl programming point that will be used for AUC calculations for order whose dose calculation programming point does not specify a CrCl programming point.
30 CRCL_FORMULA_ID_LPP_NAME VARCHAR No
The name of the extension.
31 AFTER_ORDER_ID NUMERIC No
This column contains the After Order ID for an order.
32 BEFORE_ORDER_ID NUMERIC No
This column contains the Before Order ID for an order.
33 DIET_COMMENTS VARCHAR No
This column contains the Diet Comments entered for an order.
34 END_DT_BEF_FILL_DT DATETIME No
Stores the order's end date before it was changed due to the order being (re)filled. This is needed so that if the fills are ever cancelled, we know what to set the end date back to.
35 PREV_POC_C_NAME VARCHAR No
This column contains the previous phase of care (I ORD 61040). The phase of care for an order is stored in I ORD 61010. If the phase of care is not needed when the sign and held order is released, the phase of care stored in I ORD 61010 is moved to I ORD 61040 for tracking purposes. The phase of care stored in I ORD 61040 can still be used in the MAR activity to allow for continued phase of care grouping. The list of phases of care not needed when sign and held orders are released is stored in I LSD 61050.
The category values for this column were already listed for column: ORD_PHASE_OF_CARE_C_NAME
36 ORDER_TIME DATETIME (Local) No
The date and time when the medication order was placed.
37 IS_HELD_ORDER_C_NAME VARCHAR No
This item stores 1 if the order is signed and held and active
May contain organization-specific values: No
Category Entries:
Yes
38 TXT_ORDPROV_NAME VARCHAR No
The name of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
39 TXT_ORDPROV_DEA VARCHAR No
The DEA number of the ordering provider, for providers that do not yet exist in the Provider (SER) master file. A DEA number is given to providers by the Drug Enforcement Administration and allows them to prescribe controlled substances.
40 TXT_ORDPROV_NPI VARCHAR No
The National Provider Identifier (NPI) of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
41 TXT_ORDPROV_PHONE VARCHAR No
The phone number of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
42 TXT_ORDPROV_FAX VARCHAR No
The fax number of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
43 TXT_ORDPROV_STREET VARCHAR No
The street address of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
44 TXT_ORDPROV_CITY VARCHAR No
The city of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
45 TXT_ORDPROV_STATE_C_NAME VARCHAR No
The state of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
May contain organization-specific values: Yes
46 TXT_ORDPROV_ZIP VARCHAR No
The zip code of the ordering provider, for providers that do not yet exist in the Provider (SER) master file.
47 RX_SERIAL_NUMBER VARCHAR No
Stores the prescription serial number commonly found on triplicate prescription forms. Triplicate prescription forms are used for controlled substances and require multiple copies of the prescription form.
48 NOCHRG_EXT_RSLT_YN VARCHAR No
This column returns whether the order is an external result that should not drop charges. A value of 1 returns Y. A value of 0 returns N. A null value will return null but is treated the same as 0 when dropping charges.
May contain organization-specific values: No
Category Entries:
No
Yes
49 WT_MAX_DOSE NUMERIC No
This column returns the saved weight-based or body surface area (BSA)-based maximum dose for the order (ORD).
50 WT_MAX_DOSE_UNIT_C_NAME VARCHAR No
This column returns the saved unit for the weight-based or body surface area (BSA)-based maximum dose for the order (ORD).
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
51 MAX_DOSE_SOURCE_C_NAME VARCHAR No
This column returns the source of max dose information that was used in the order (ORD).
May contain organization-specific values: No
Category Entries:
Preference List
Order Set
Treatment Plan Protocol
Medication
Order Panel or Group
Other
Dose Rule
Similar Order
52 SRC_RX_MED_ID NUMERIC No
The ID of the originally prescribed medication as returned by the pharmacy in a refill request.
53 SRC_RX_QUANTITY VARCHAR No
The quantity of the originally prescribed medication as returned by the pharmacy in a refill request.
54 SRC_RX_DIS_DISP_QTY NUMERIC No
The discrete dispense quantity of the originally prescribed medication as returned by the pharmacy in a refill request.
55 SRC_RX_DISP_UNIT_C_NAME VARCHAR No
The discrete dispense unit of the originally prescribed medication as returned by the pharmacy in a refill request.
The category values for this column were already listed for column: WT_MAX_DOSE_UNIT_C_NAME
56 SRC_RX_REFILLS VARCHAR No
The number of refills of the originally prescribed medication as returned by the pharmacy in a refill request.
57 SRC_RX_DIRECTIONS VARCHAR No
The directions (patient sig) of the originally prescribed medication as returned by the pharmacy in a refill request.
58 SRC_RX_START_DATE DATETIME No
The start date of the originally prescribed medication as returned by the pharmacy in a refill request.
59 SRC_RX_END_DATE DATETIME No
The end date of the originally prescribed medication as returned by the pharmacy in a refill request.
60 SRC_RX_DAW_YN VARCHAR No
The Dispense as Written (DAW) flag of the originally prescribed medication as returned by the pharmacy in a refill request.
The category values for this column were already listed for column: SELECTED_FOR_OPC_YN
61 SRC_RX_PRES_PROV_ID VARCHAR No
The ID of the prescribing provider of the originally prescribed medication as returned by the pharmacy in a refill request.
62 SRC_RX_COMMENTS VARCHAR No
The comments associated with the originally prescribed medication as returned by the pharmacy in a refill request.
63 PAT_SIG_REPLY_C_NAME VARCHAR No
This column contains the user's response to the sig-related questions for previous sig reorder workflows. The sig is the description of how a medication is supposed to be administered which includes the dose and frequency.
May contain organization-specific values: No
Category Entries:
Yes, use this sig
No, don't use this sig
Acknowledge can't use freetext sig.
Use discrete sig
Use freetext sig
Reported Sig - No Response
Use Prescribed Sig
Use Patient Reported Sig
Reported Sig - Use Other
Use Alternative Defaults
Multi-Product IMS Reorder - No Response
Multi-Product IMS Reorder - Individual
Multi-Product IMS Reorder - Overall
Reported Sig - Defer to Prescriber
Reported Sig - Take as Needed
Reported Sig - Restart Taking
64 SIG_REVIEW_USER_ID VARCHAR No
Holds the user ID of the user who reviewed the patient sig for accuracy. The sig is the description of how a medication is supposed to be administered which includes the dose and frequency.
65 SIG_REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
66 SIG_REVIEW_INS_DTTM DATETIME (Local) No
Holds the instant that the user took action on the patient sig in previous sig workflows. The sig is the description of how a medication is supposed to be administered which includes the dose and frequency.
67 SRC_RX_WRITTEN_DATE DATETIME No
The written date of the originally prescribed medication as returned by the pharmacy in a refill request.
68 DOSE_RND_ACK_RSN_C_NAME VARCHAR No
The category number for the acknowledgement reason given by the user to override a dose rounding warning on this order.
May contain organization-specific values: Yes
69 SRC_RX_DESC VARCHAR No
The description of the originally prescribed medication as returned by the pharmacy in a refill request.
70 EPRES_DEST_C_NAME VARCHAR No
Indicates the destination of e-prescribing order. It will be set by an interface or the ambulatory pharmacy system. The item may not be populated for the old order records.
May contain organization-specific values: No
Category Entries:
Outgoing Interface
Willow Ambulatory
71 CTRL_MED_YN VARCHAR No
Indicates whether the medication was controlled when the order was signed.
The category values for this column were already listed for column: NOCHRG_EXT_RSLT_YN