ORDER_MED_2
Description:
This table enables you to report on medications ordered in EpicCare or Ambulatory Pharmacy (Prescriptions).
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 ID of the order record associated with this medication order. This is an internal unique identifier for order records in this table and cannot be used to link to CLARITY_MEDICATION.
2 TXT_AUTHPROV_NAME VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's name.
3 TXT_AUTHPROV_DEA VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's Dynamic Epic Advisory Database (DEA) number.
4 TXT_AUTHPROV_PHONE VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's phone number.
5 TXT_AUTHPROV_FAX VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's fax number.
6 TXT_AUTHPROV_STREET VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's street address information.
7 TXT_AUTHPROV_CITY VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's city.
8 TXT_AUTHPROV_ZIP VARCHAR No
In ambulatory pharmacy, a prescription order could be authorized by a non-EpicCare provider. There is no provider record for this provider. This is used to store the non-EpicCare provider's zip code.
9 RX_NUM_FORMATTED VARCHAR No
The formatted prescription number for the order.
10 RX_COMMENTS VARCHAR No
In an ambulatory pharmacy, the person who enters the prescription into the system can add additional comments to the prescription. The comments are not part of the order and are used for pharmacy internal communication only. The comments do not affect the patient instructions, nor the dispense information.
11 RX_WRITTEN_DATE DATETIME No
Store the prescription written date, which is the date the prescription was entered into the system through EpicCare, or the date the prescription was written to the paper prescription.
12 MED_DISCONT_ENC NUMERIC No
*** Deprecated *** The data in this column does not correctly link to PAT_ENC.PAT_ENC_DATE_REAL. ORDER_MED_5.DISCON_PAT_ENC_DATE_REAL should be used for this link instead. ******
13 EFQ_OVRD_DAY_TYPE NUMERIC No
Specifies what the numeric values in the frequency override days columns represent. If it is 1 then the listed days are relative days. If it is 2 then the listed days are weekdays. Any other value has no meaning.
14 EFQ_OVRD_CYCL_LEN NUMERIC No
If there is a frequency override specified, this item will contain the length of a relative specified type cycle. For all other specified types this value will be ignored (and should be empty).
15 CHART_CORRECTION_ID NUMERIC No
For chart corrections, links the order to a Chart Correction Audit (CCA) record.
16 PARENT_CE_ORDER_ID NUMERIC No
When a cross-encounter order is released, this item stores the ID of the parent order.
17 TPL_WT_SRC_C_NAME VARCHAR No
The weight source of the treatment plan for this order, as of the time the order is signed.
May contain organization-specific values: Yes
Category Entries:
Treatment plan weight
Past measured weight
Most current measured weight (actual)
Ideal body weight
Adjusted body weight
User entered weight
Lean body weight
Dosing weight
Other
18 OVERRIDE_LINKED_C_NAME VARCHAR No
The linked override resolved category number for the medication order. The category indicates whether the admins in the override pull are all linked to pharmacy orders.
May contain organization-specific values: No
Category Entries:
Resolved
Do not link
19 CONDITIONAL_C_NAME VARCHAR No
Identifies an inpatient order as "conditional".
May contain organization-specific values: No
Category Entries:
No
Yes
Yes - Initiated
Force No Condition
20 COND_STATUS_C_NAME VARCHAR No
For a conditional order, indicates whether the conditions for the order have been satisfied yet.
May contain organization-specific values: No
Category Entries:
Conditions not met
All conditions met
21 PEND_REF_REAS_COMM VARCHAR No
Extracts the comment attached to the pend refusal reason (I ORD 7706)
22 PRIORITIZED_INST_TM DATETIME (Local) No
The time and date that is used as the prioritized date.
23 ORDER_QUESN_LIST VARCHAR No
The order specific questions that are listed in the order composer for the order.
24 EXT_PHARM_MED_NAME VARCHAR No
Medication display name received from an external pharmacy.
25 PEND_MED_ACTIVE_YN VARCHAR No
A flag to determine if this is an active pending medication or not.
May contain organization-specific values: No
Category Entries:
Yes
No
26 PEND_PREV_ORD_ID VARCHAR No
The previous order ID for the pending medication. This item is NOT networked to orders.
27 TXT_AUTHPROV_NPI VARCHAR No
If the authorizing provider for a medication is not currently an Epic provider (no SER record for this provider), free text provider items are used to save information about this provider. This item stores the National Provider ID (NPI) of the provider.
28 ORD_TRANS_METHOD_C_NAME VARCHAR No
This item holds the method of transmission for a given order. It should only be set from within an order transmittal rule using the transmission method property (LRC 161).
May contain organization-specific values: Yes
Category Entries:
Printed
Faxed
E-Prescribed
Mail Ordered
Phoned In
OTC
Vended
Internal Pharmacy
29 PROFILE_ONLY_RX_YN VARCHAR No
This item specifies whether the medication order is intended to be filled by the pharmacy immediately or should be filled later when requested by the patient. This flag can be set in order entry based on the order class or by selecting the 'profile only' checkbox in pharmacy order entry.
May contain organization-specific values: No
Category Entries:
No
Yes
30 DISP_QTY_REM NUMERIC No
Stores the remaining authorized quantity (in Written Dispense Quantity unit) that the pharmacist can dispense. It is used in Ambulatory Pharmacy to calculate the Refills Remaining.
31 FREQ_UNSCHEDULED_C_NAME VARCHAR No
If the frequency is unscheduled, this column will store a 1. If the frequency is not unscheduled, this column will be blank.
May contain organization-specific values: No
Category Entries:
YES
32 DURATION INTEGER No
Duration for this medication.
33 INTERVENTION VARCHAR No
Intervention for this medication.
34 LAST_SUSPEND_DTTM DATETIME (Local) No
Instant this medication was last suspended.
35 SIGN_ACTION_PEND_C_NAME VARCHAR No
Sign action for pended order.
May contain organization-specific values: No
Category Entries:
Sign
Sign & Hold
36 ORIG_MED_ID NUMERIC No
Original prescription column; contains the medication order medication ID.
37 ORIG_STRENGTH VARCHAR No
Original prescription column; contains the medication order strength.
38 ORIG_ROUTE_C_NAME VARCHAR No
Original prescription column; contains the medication order route.
May contain organization-specific values: Yes
39 ORIG_MED_SOURCE_C_NAME VARCHAR No
Original prescription column; contains the medication order source.
May contain organization-specific values: Yes
No Entries Defined
40 ORIG_DIS_DISP_QTY NUMERIC No
Original prescription column; contains the medication order discrete dispense quantity.
41 ORIG_DISP_UNIT_C_NAME VARCHAR No
Original prescription column; contains the medication order discrete dispense unit.
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
42 ORIG_START_DATE DATETIME No
Original prescription column; contains the medication order start date.
43 ORIG_END_DATE DATETIME No
Original prescription column; contains the medication order end date.
44 ORIG_DAW_YN VARCHAR No
Original prescription column; contains the medication order 'dispense as written?' flag and is either yes or no.
The category values for this column were already listed for column: PEND_MED_ACTIVE_YN
45 PENDDC_STATUS_C_NAME VARCHAR No
Status of an order with regard to pending discontinue.
May contain organization-specific values: No
Category Entries:
D/C Accepted
Pending D/C
D/C Rejected
46 MED_DISC_REFILLS INTEGER No
Saves the discrete medication refills information for the order.
47 BACK_DATED_YN VARCHAR No
Indicates whether the order was back-dated at the time the start date was entered
The category values for this column were already listed for column: PEND_MED_ACTIVE_YN
48 RX_CLINICALLY_RV_YN VARCHAR No
This specifies whether the prescription has been clinically reviewed by a pharmacist. Clinical review can either be required to occur before a prescription is filled or after it is filled during fill verification.
The category values for this column were already listed for column: PROFILE_ONLY_RX_YN
49 PRIORITIZED_UTC_DTTM DATETIME (UTC) No
Stores the prioritized instant for the result in UTC