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 NUMERIC No
This column stores the ID of the pharmacy that accepted the prescription.
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 VARCHAR No
The unique identifier of the provider under whose supervision a prescription was placed.
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.