ORDER_MED

Description: |
The ORDER_MED table enables you to report on medications ordered in EpicCare (prescriptions). We have also included patient and contact identification information for each record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_MED_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_MED_ID | NUMERIC | No |
The unique ID of the order record associated with this medication order. This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION.
2 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this line. This column is frequently used to link to the PATIENT table.
3 | PAT_ENC_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number (CSN) for the patient contact associated with this medication order. This number is unique across patients and encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5 | ORDERING_DATE | DATETIME | No |
The date when the medication order was placed.
6 | ORDER_CLASS_C_NAME | VARCHAR | No |
The category number for the order class. This value is used to define how clinical systems process the order.
May contain organization-specific values: Yes
Category Entries:
Normal
7 | PHARMACY_ID | NUMERIC | No |
The unique ID of the pharmacy record that is associated with this medication order. This column is frequently used to link to the RX_PHR table. This field is only populated if the clinical system user selects a specific pharmacy from the list, otherwise the field is null. This field is only populated by the ambulatory clinical system, not the pharmacy system.
8 | PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.
9 | ORD_CREATR_USER_ID | VARCHAR | No |
The EMP ID (.1) of the user who signed the order (for a non-signed and held order) or the last person who performed a sign and hold or release action for a signed and held order.
10 | ORD_CREATR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
12 | DESCRIPTION | VARCHAR | No |
The description of the order. This information is found in the Order field of clinical system’s Order Detail window.
13 | DOSAGE | VARCHAR | No |
The dispensation amount for the prescription entered by the user in the orders activity. This amount is stored as a string in the orders database.
14 | QUANTITY | VARCHAR | No |
The quantity of the prescription being dispensed as entered by the user.
15 | REFILLS | VARCHAR | No |
The number of refills allowed for this prescription as entered by the user.
16 | START_DATE | DATETIME | No |
The date when the medication order started. The date appears in calendar format.
17 | END_DATE | DATETIME | No |
The date when the medication order is to end.
18 | DISP_AS_WRITTEN_YN | VARCHAR | No |
Indicates whether or not the prescription should be dispensed as written for this medication.
May contain organization-specific values: No
Category Entries:
Yes
No
19 | RSN_FOR_DISCON_C_NAME | VARCHAR | No |
The category number for the reason a prescription has been discontinued. This column contains data only in prescription orders that have been discontinued.
May contain organization-specific values: Yes
20 | MED_PRESC_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.
21 | NONFRM_XCPT_CD_C_NAME | VARCHAR | No |
The category number for medication's exception code. This code explains the reason a non-formulary medication was ordered.
May contain organization-specific values: Yes
22 | PANEL_MED_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
23 | UPDATE_DATE | DATETIME (Local) | No |
The date and time when this row was created or last updated in Clarity.
24 | ORDER_INST | DATETIME (Local) | No |
The date and time the order was placed. The date appears in calendar format.
25 | DISPLAY_NAME | VARCHAR | No |
The name of the medication as it appears on the medication record itself.
26 | AS_MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
27 | HV_HOSPITALIST_YN | VARCHAR | No |
Indicates whether this is a hospitalist order. A Y indicates a hospitalist order.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
28 | ORDER_PRIORITY_C_NAME | VARCHAR | No |
The category number for the priority assigned to an order.
May contain organization-specific values: Yes
29 | MED_ROUTE_C_NAME | VARCHAR | No |
The category number for the route of administration of a medication.
May contain organization-specific values: Yes
30 | DISCON_USER_ID | VARCHAR | No |
The unique ID of the user who discontinued the order.
31 | DISCON_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
32 | DISCON_TIME | DATETIME (UTC) | No |
The date and time when the medication order was discontinued. The date appears in calendar format.
33 | CHNG_ORDER_MED_ID | NUMERIC | No |
The unique ID of the changed or reordered medication order that this order replaced. This column is frequently used to link back to the ORDER_MED table.
34 | PEND_APPR_USER_ID | VARCHAR | No |
The unique ID of the user who approved a pended order.
35 | PEND_APPR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
36 | PEND_REF_REAS_C_NAME | VARCHAR | No |
The category number for the reason a pended medication was refused.
May contain organization-specific values: Yes
37 | HV_DISCR_FREQ_ID | VARCHAR | No |
The unique ID of the discrete frequency record associated with this medication order. This column is frequently used to link to the IP_FREQUENCY table.
38 | HV_DISCR_FREQ_ID_FREQ_NAME | VARCHAR | No |
The name of the frequency record.
39 | HV_DISCRETE_DOSE | VARCHAR | No |
The discrete dose for a medication as entered by the user in the orders activity.
40 | HV_DOSE_UNIT_C_NAME | VARCHAR | No |
The category number for the dosage unit of a medication.
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
mcSv
Sv
µGy
cGy
Gy
mRAD
RAD
mg of pseudoephedrine
mg of ephedrine
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
µGy-cm2
mGy-cm2
cGy-cm2
dGy-cm2
µGy-m2
mGy-m2
cGy-m2
dGy-m2
Gy-m2
mRAD-cm2
RAD-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
mGy-cm
cGy-cm
dGy-cm
Gy-cm
mGy-m
cGy-m
dGy-m
Gy-m
Hounsfield Units
mg/mL/min (AUC)
None / Other
41 | HV_IS_SELF_ADM_YN | VARCHAR | No |
Indicates whether this medication was self-administered. A Y indicates that the order was self-administered.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
42 | ORDER_START_TIME | DATETIME (Local) | No |
The date and time when the medication order is to start. The date appears in calendar format.
43 | ORDER_END_TIME | DATETIME (Local) | No |
The date and time when the medication order is scheduled to end. The date appears in calendar format.
44 | NON_FORMULARY_YN | VARCHAR | No |
Indicates whether this medication is not on the formulary. A Y indicates a non-formulary medication.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
45 | ORDER_STATUS_C_NAME | VARCHAR | No |
The category number for the current status of an order.
May contain organization-specific values: No
Category Entries:
Pending
Sent
Resulted
Canceled
Completed
Holding for Referral
Denied Approval
Suspend
Discontinued
Verified
Dispensed
Pending Verify
46 | AUTHRZING_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.
47 | 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.
48 | MIN_DISCRETE_DOSE | NUMERIC | No |
The minimum ordered dose amount for the medication as specified by the user in the orders activity.
49 | MAX_DISCRETE_DOSE | NUMERIC | No |
The maximum ordered dose amount for the medication as specified by the user in the orders activity.
50 | DOSE_UNIT_C_NAME | VARCHAR | No |
The category number for the dose unit of a medication.
The category values for this column were already listed for column: HV_DOSE_UNIT_C_NAME
51 | IS_PENDING_ORD_YN | VARCHAR | No |
Indicates whether the order has a pending status. A Y indicates that the order does have a pending status.
May contain organization-specific values: No
Category Entries:
Yes
52 | BULK_DISP_YN | VARCHAR | No |
Indicates whether this is a bulk dispense order. A Y indicates this is a bulk dispense order.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
53 | PROVIDER_TYPE_C_NAME | VARCHAR | No |
The medication provider type category number for the order. This item distinguishes between authorizing and documenting provider types for historical and non-historical medications. If the medication was ordered as historical, the provider is considered the documenting provider and is reflected as such in this item. If the medication was not ordered as historical, the provider is considered the authorizing provider is reflected in this item as such.
May contain organization-specific values: Yes
Category Entries:
Authorizing
Documenting
54 | MODIFY_TRACK_C_NAME | VARCHAR | No |
The category number for the flag that both indicates and distinguishes whether an order was reordered or modified.
May contain organization-specific values: No
Category Entries:
REORDERED
MODIFIED
55 | SPECIFIED_FIRST_TM | DATETIME (Local) | No |
If the order was placed with a Specified frequency (the frequency's Type (I EFQ 50) item has a value of 1) and the user specified a first occurrence time, the time specified is stored in this column.
56 | SCHED_START_TM | DATETIME (Local) | No |
The date and time at which an order was scheduled to begin. The date appears in calendar format.
57 | ACT_ORDER_C_NAME | VARCHAR | No |
The category number indicating additional information about an order's status--Active, Completed, Discontinued, or Cancelled. An active order is any order that has not been completed, discontinued, cancelled, pended, or signed and held.
May contain organization-specific values: No
Category Entries:
Active Medication
Active Procedure
Discontinued Medication
Canceled Procedure
Completed Medication
Completed Procedure
58 | EXP_AFT_START_DATE | DATETIME | No |
The number of days after the start date that the medication order will expire based on the setting in the medication record. The date appears in calendar format.
59 | EXP_BEF_END_DATE | DATETIME | No |
The number of days before the end date that the medication order will expire based on the setting in the medication record. The date appears in calendar format.
60 | MED_COMMENTS | VARCHAR | No |
Comments for a medication order, as entered by the ordering user when entering the order.
61 | USER_SEL_MED_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
62 | USER_SEL_ERX_DAT | DATETIME | No |
The date that the medication record was actually selected by the user. This item is populated only if Intelligent Medication Selection (IMS) replaced the original user-selected medication with another medication record.
63 | REQ_RNVERIFY_YN | VARCHAR | No |
Indicates whether this medication order requires RN verification before it is administered. A Y indicates that it does require RN verification.
May contain organization-specific values: No
Category Entries:
No
Yes
64 | MDL_ID | NUMERIC | No |
The unique ID of the medication problem list record that is associated with this medication order. This column is frequently used to link to the MDL_MD_PRBLM_LIST table.
65 | LASTDOSE | VARCHAR | No |
Comments for the last administered dose of a medication entered in the medication documentation navigator section.
66 | INFORMANT_C_NAME | VARCHAR | No |
The category number for the informant of a prior to admission (PTA) medication. The informant is the person who reports a PTA medication being taken by the patient.
May contain organization-specific values: Yes
67 | AMB_MED_DISP_NAME | VARCHAR | No |
The name of the ambulatory medication.
68 | WEIGHT_BASED_YN | VARCHAR | No |
Indicates whether the dose for this medication order is based on the patient's weight.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
69 | WEIGHT_REVIEW_YN | VARCHAR | No |
Indicates whether or not the patient's weight needs to be reviewed for this medication order due to the patient's weight change.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
70 | ORD_TM_WEIGHT | NUMERIC | No |
The patient's last reviewed weight at the time the medication was ordered.
71 | ORDER_TIME_WT_INST | DATETIME (Local) | No |
The date and time when a new weight is recorded for a patient for a weight based medication review.
72 | REVIEW_WEIGHT | NUMERIC | No |
The patient's last non-reviewed weight at the time the medication was ordered.
73 | REVIEW_WEIGHT_INST | DATETIME (Local) | No |
The instant when the patient's last non-reviewed weight was entered prior to when the medication was ordered.
74 | REFILLS_REMAINING | NUMERIC | No |
The number of refills remaining in the medication.
75 | MED_REFILL_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.
76 | OLD_ORDER_ID | NUMERIC | No |
The unique ID of the order record that points to the parent medication for refills.
77 | OLD_ORDER_DAT | VARCHAR | No |
The internal contact date of the parent medication in integer format. Used to identify the parent medication and will only be populated for child orders. This does not link to CONTACT_DATE_REAL.
78 | RESUME_STATUS_C_NAME | VARCHAR | No |
The category number that indicates an outpatient medication order's status before it was suspended as a result on inpatient admission.
The category values for this column were already listed for column: ORDER_STATUS_C_NAME
79 | USER_ID_OF_PROV | VARCHAR | No |
The unique ID of the user record that is linked to the provider ID in the AUTHRZING_PROV_ID column.
80 | ORDERING_MODE_C_NAME | VARCHAR | No |
The category number for the ordering mode of the order (i.e. Outpatient, Inpatient). Note that Outpatient orders can be placed from an Inpatient encounter as discharge orders / take-home prescriptions. This column might be blank for Outpatient orders placed prior to the creation of the IP module.
May contain organization-specific values: No
Category Entries:
Outpatient
Inpatient
81 | PEND_APPROVE_FLAG_C_NAME | VARCHAR | No |
The pending medication approval status category number for the order.
May contain organization-specific values: No
Category Entries:
Approved
Refused
82 | NF_POST_VERIF_YN | VARCHAR | No |
Indicates whether a medication order has been verified by the pharmacist as non-formulary. A Y indicates that the pharmacist verified the medication order as non-formulary. An administrator can use this column to report on how many orders that were placed as non-formulary were also verified as such. To find which orders were placed as non-formulary, use the NON_FORMULARY_YN column.
The category values for this column were already listed for column: REQ_RNVERIFY_YN
83 | EXT_ELG_SOURCE_ID | VARCHAR | No |
External eligibility source ID
84 | EXT_ELG_MEMBER_ID | VARCHAR | No |
External eligibility member ID
85 | EXT_FORMULARY_ID | VARCHAR | No |
External formulary ID
86 | EXT_COVERAGE_ID | VARCHAR | No |
External coverage ID
87 | EXT_COPAY_ID | VARCHAR | No |
This column contains the external copay ID for an order.
88 | EXT_PHARMACY_TYPE_C_NAME | VARCHAR | No |
External pharmacy type
May contain organization-specific values: Yes
Category Entries:
Retail
Mail Order
Retail+Mail
89 | EXT_FORMULARY_STAT | VARCHAR | No |
External Formulary Status
90 | EXT_COV_AGE_LMT_YN | VARCHAR | No |
External coverage age limits
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
91 | EXT_COV_EXCLUS_YN | VARCHAR | No |
External coverage product coverage exclusion
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
92 | EXT_COV_SEX_LMT_YN | VARCHAR | No |
External coverage gender limits
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
93 | EXT_COV_MED_NCST_YN | VARCHAR | No |
External coverage medical necessity
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
94 | EXT_COV_PRI_AUTH_YN | VARCHAR | No |
External coverage prior authorization
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
95 | EXT_COV_QNTY_LMT_YN | VARCHAR | No |
External coverage quantity limits
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
96 | EXT_COV_LNK_DRUG_YN | VARCHAR | No |
External coverage resource link drug
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
97 | EXT_COV_LNK_SMRY_YN | VARCHAR | No |
External coverage resource link summary
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
98 | EXT_COV_STEP_MED_YN | VARCHAR | No |
External coverage step medication
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
99 | EXT_COV_STEP_THR_YN | VARCHAR | No |
External coverage step therapy
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
100 | USR_SEL_IMS_YN | VARCHAR | No |
This item stores whether the product to use with IMS was selected by the user or chosen automatically. Yes means the user chose the product, No means the product was selected automatically.
The category values for this column were already listed for column: REQ_RNVERIFY_YN
101 | INDICATION_COMMENTS | VARCHAR | No |
The comment entered for the indications of use for this order.
102 | DOSE_ADJ_TYPE_C_NAME | VARCHAR | No |
The type of dose adjustment that was triggered by the order (i.e. maximum or minimum dose).
May contain organization-specific values: No
Category Entries:
Maximum Dose
Minimum Dose
Minimum and Maximum Adjustment
103 | DOSE_ADJ_OVERRID_YN | VARCHAR | No |
This item indicates whether the dose adjustment (i.e. maximum or minimum dose) was overridden.
The category values for this column were already listed for column: REQ_RNVERIFY_YN
104 | MAX_DOSE | NUMERIC | No |
The maximum allowed dose for this medication order.
105 | MAX_DOSE_UNIT_C_NAME | VARCHAR | No |
The unit for the maximum allowed dose for this medication order.
The category values for this column were already listed for column: HV_DOSE_UNIT_C_NAME
106 | PRN_COMMENT | VARCHAR | No |
The user-entered comments for why the as needed (PRN) medication should be administered.
107 | INST_OF_UPDATE_TM | DATETIME (Local) | No |
The day and time the order record was last updated.
108 | PEND_ACTION_C_NAME | VARCHAR | No |
The manner in which the medication was reordered, such as reorder from order review or reorder from the medications activity.
May contain organization-specific values: No
Category Entries:
Change
Reorder
Request From Existing
Request From Preference List
Reorder from Medication Activity
Reorder from Order Review
Reorder from Reports
109 | MED_DIS_DISP_QTY | NUMERIC | No |
This item stores the discrete dispense quantity when discrete dispense is enabled.
110 | MED_DIS_DISP_UNIT_C_NAME | VARCHAR | No |
This item stores the discrete dispense unit when discrete dispense is enabled.
The category values for this column were already listed for column: HV_DOSE_UNIT_C_NAME
111 | END_BEFORE_CMP_INST | DATETIME (Local) | No |
The default end date and time of a completed order. When an order is completed, we will store the system calculated end date and time (which may differ from the actual completion time) in this column in the event the completion is reversed and the defaults need to be restored.
112 | BSA_BASED_YN | VARCHAR | No |
Indicates whether the dose for this medication order is based on the patient's body surface area (BSA).
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
113 | BSA_REVIEW_YN | VARCHAR | No |
Flags orders that need to be reviewed because of a BSA change.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
114 | ORD_TM_BSA | NUMERIC | No |
The patient's last reviewed BSA at the time this order was placed.
115 | REVIEW_BSA | NUMERIC | No |
The patient's last non-reviewed body surface areas (BSA) at the time the medication was ordered.
116 | LAST_DOSE_TIME | VARCHAR | No |
Store the time that a PTA med was last taken.