ORDER_DISP_INFO
Description:
This table contains dispense information for orders.

Primary Key
Column Name Ordinal Position
ORDER_MED_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 ORDER_MED_ID NUMERIC No
The unique ID of the order that these actions were taken on.
2 CONTACT_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.
3 FILL_PHR_ID NUMERIC No
The fill pharmacy for prescription being filled from Integrated pharmacy for each fill. A prescription could be filled multiple times and each fill will have a fill pharmacy saved. A fill request is a contact on the order record recording information about the specific dispense of the order.
4 FILL_PHR_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
5 FILL_AUTHPHRMCST_ID VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This item saves the pharmacist who will take responsibility of the fill when sending an adjudication message.
6 FILL_SERVICE_DATE DATETIME No
The date of service for a prescription fill. The date of service can be entered by a user during the filling process. If no service date was entered by the user, then the date of service is the date of the first successful adjudication. If the prescription fill was not adjudicated, then the date of service is the date the fill was dispensed.
7 FILL_NUMBER NUMERIC No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. The value is used in adjudication to indicate what fill we are adjudicating. The fill numbers are sequential with the first fill set to 0 and all refills numbered 1-99.
8 FILL_SUPPLY_DAYS NUMERIC No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This is the number of days this fill will supply. For example, this fill dispensed enough to cover a 30-day supply.
9 FILL_DISP_QTY NUMERIC No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This is the actual amount the pharmacy is dispensing. This may be different from the intended quantity, which is what the prescriber intended the patient to receive. The two numbers may be different if the patient can only pay for a smaller days supply, or the pharmacy may only have a small amount of the medication left to dispense.
10 FILL_INT_SUP_DAYS NUMERIC No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. If the fill is a partial fill, this is the number of days the supply that is dispensed will cover. For example, I have a partial fill of 15 tabs for a Daily medication. The intended days supply would be 15.
11 FILL_IS_PARTIAL_YN VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This item indicates if the fill is a partial one. If the patient can only pay for a smaller supply or the pharmacy may only have a small amount of the medication left to dispense, then the actual amount dispensed will be different from the intended amount, which is what the prescriber intended the patient to receive. For example, if the patient has a fill of 30 tabs for a Daily medication for 30 days of supply, a partial fill of 15 tabs will cover 15 days of supply; and the patient can receive the rest of the fill later when the patient can pay or the pharmacy has more to dispense. This flag is also used in adjudication to let the insurer know that a fill is a partial one and the insurance company will adjust the payment amount accordingly.
May contain organization-specific values: No
Category Entries:
No
Yes
12 FILL_SOURCE_C_NAME VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This item saves the information about where/how the fill was initiated. For example, if the patient walks in the pharmacy and hands a paper script to the pharmacist, then the source will be Walk-in; if the prescription is routed from EpicCare order entry, then the source will be EpicCare; and if the patient requests a refill through MyChart, then the source will be MyChart.
May contain organization-specific values: No
Category Entries:
IVR
Web
Pharmacy
Ambulatory
Discharge
External E-Prescription
Other
Telephone
Hospital Outpatient
Surgery
Emergency
System
Call Center
Reporting Workbench
Automatic Refill
Pharmacy Front Counter
Dispense Activity
External System
Willow Home Infusion
Prescription Document
Willow Inpatient
Resupply Request
Residential Facility
Hospital
Test Billing
13 FILL_TYPE_C_NAME VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This item saves the type of the fill. The first fill on the new prescription will have the type of New; a refill will have the type of Refill; and refill requests will have the type of EpicCare Refill Request or Non-EpicCare Refill Request, depending on whether the authorizing provider is an EpicCare provider.
May contain organization-specific values: No
Category Entries:
First Fill
Fill
EpicCare Refill Request
Non-EpicCare Refill Request
First Fill from Transfer
14 FILL_STATUS_C_NAME VARCHAR No
When a order is placed in an integrated pharmacy, a contact is created in the order and all order information is saved to this order contact. This item saves the current status of the order. An order could have different status. For example, when it's being reviewed, the status will be marked as Reviewed; when it's being filled, its status will be marked as Filled.
May contain organization-specific values: Yes
Category Entries:
New
Pending Rx Entry
Scheduled Fill
Pending Fill
Fill Rejected
Waiting For Approval
Ready to Fill
Fill Initiated
Filled
Ready to Verify
Fill Rejected
Verified
Ready to Package
Ready to Transport
In Transit
Received
Waiting for Filling Pharmacies
Ready to Dispense
Dispense Documented
Dispense Received from External System
Dispensed
Shipped
Delivered
Consult
Completed
Approved Refill Request
Denied Refill Request
Profiled
Canceled
Order Edited
Flag Removed
Fill Returned
Fill Wasted
Clinically Reviewed
Clinical Changes Reviewed
Charge
Payment
Bagged
Toted
Trucked
Boxed
Packaged
Sealed
Barcode Scan
Patient Notification
Abandoned Rx Sale
Needs Tracking Number
No Sale Completed
Authentication
Payment Amount Changed
Invalidated Billing Item
Prescription Revision Needed
Prescription Revised
IP Dispense Prepared
IP Dispense Prep Started
IP Dispense Prep Saved Work
IP Dispense Prep Pending Final Review
IP Reused For Another Dose Dispense Prep
IP Reused From Previous Dose Dispense Prep
IP Dispense Prep Partial Complete
IP Dispense Prep Resumed
IP Dispense Prep Stopped
IP Dispense Prep Saved on Admin
IP Dispense Checked
IP Dispense Prep Partial Check
IP Dispense Prep Revise
IP Dispense Prep Requeued
IP Dispense Rejected
IP Dispense Check Removed
IP Dispense Check Started
IP Second Dispense Check
IP Dispense Final Label Check
IP Final Label Check Deferred
IP Added to Dispense Queue
IP Printed From Dispense Queue
IP Automatically Removed From Dispense Queue
IP Manually Removed From Dispense Queue
Rx Dispense Sent
Rx Dispense Received
Rx Cancel Tracking Action
IP Dispense Prepared via Interface
Download Request Pending
Download Request Submitted
Download Successful
Download Request Rejected
Download Request Canceled
Download Error
Download Not Attempted
Sale Completed
Sale Updated
Sale Canceled
Sale Price Override Approved
Sale Pending
Fee Sold in POS
Waiting on Third Party
Tax Exemption Applied
Tax Exemption Removed
Tax Charge
Rx Inv Stock Location Overridden
Rx Inv Stock Location Override Removed
Not Dispensed
HI Shipment Started
HI Shipment Audited
HI Dispensed
HI Worksheet Printed
HI New Revision
HI Meds Staged
HI Supplies Staged
HI Meds Stage Checked
HI Supplies Stage Checked
HI Staged
HI Stage Checked
HI Meds Packed
HI Supplies Packed
HI Packed
HI Ready To Ship
HI Post Shipment Change
HI In Transit
HI Delivered
HI Complete
HI Canceled
15 FILL_DISP_QTYUNT_C_NAME VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This is the actual amount unit the pharmacy is dispensing. The actual amount dispensed from the pharmacy could be different from the intended quantity, which is what the prescriber intended the patient to receive. The two numbers may be different in the case the patient can only pay for a smaller supply, or the pharmacy may only have a small amount of the medication left to dispense.
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
16 FILL_INT_QTY NUMERIC No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This is the amount the prescriber intended the patient to receive. In the case of a partial fill, the patient can only pay for a smaller supply or the pharmacy may only have a small amount of the medication left to dispense, and this actual dispense amount is saved in the dispense quantity.
17 FILL_INT_QTYUNT_C_NAME VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This is the amount unit the prescriber intended the patient to receive. In the case of a partial fill, the patient can only pay for a smaller supply or the pharmacy may only have a small amount of the medication left to dispense, and this actual dispense amount is saved in the dispense quantity.
The category values for this column were already listed for column: FILL_DISP_QTYUNT_C_NAME
18 CHG_STATUS_C_NAME VARCHAR No
When a prescription is filled in an integrated pharmacy, a fill contact is created in the order and all fill information is saved to this fill contact. A prescription can have multiple fills. This item indicates the current charging status of the fill. It is used to track if the payor has agreed to pay the pharmacy for this fill.
May contain organization-specific values: No
Category Entries:
Not Attempted
Pending
Success
Failure
Cash
Charge Recalculation Needed
In Progress
19 CASH_PRICE NUMERIC No
The cash price for this order.
20 RX_TO_PHRM_USER_ID VARCHAR No
This is the user that authorized the incoming prescription transfer (typically a pharmacist) when the user exists in the User (EMP) master file.
21 RX_TO_PHRM_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
22 RX_TO_PHRM_USERNAM VARCHAR No
This is the name of the user that authorized the incoming prescription transfer (typically a pharmacist) when the user does not exist in the User (EMP) master file.
23 RX_FRM_PHRM_USER_ID VARCHAR No
This is the user that authorized the outgoing prescription transfer (typically a pharmacist) when the user exists in the User (EMP) master file.
24 RX_FRM_PHRM_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
25 RX_FRM_PHRM_USERNAM VARCHAR No
This is the name of the user that authorized the outgoing prescription transfer (typically a pharmacist) when the user does not exist in the User (EMP) master file.
26 RX_FRM_PHRM_ID NUMERIC No
This is the pharmacy from which the prescription was transferred when the pharmacy exists in the Pharmacy (PHR) master file.
27 RX_FRM_PHRM_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
28 RX_FRM_PHRM_NAM VARCHAR No
This is the name of the pharmacy from which the prescription was transferred when the pharmacy does not exist in the Pharmacy (PHR) master file.
29 RX_FRM_PHRM_PHNUM VARCHAR No
This is the phone number of the pharmacy from which the prescription was transferred when the pharmacy does not exist in the Pharmacy (PHR) master file.
30 RX_TO_PHRM_NAM VARCHAR No
This is the name of the pharmacy to which the prescription was transferred when the pharmacy does not exist in the Pharmacy (PHR) master file.
31 RX_TO_PHRM_PHNUM VARCHAR No
This is the phone number of the pharmacy to which the prescription was transferred when the pharmacy does not exist in the Pharmacy (PHR) master file.
32 RX_TRANSFER_COMMENT VARCHAR No
These are the comments that are entered along with the prescription transfer.
33 PAT_PAY_AMOUNT NUMERIC No
This is the expected payment amount for this order. This can be calculated by the system and optionally overridden by the user. If the patient pay amount was overridden, then the override amount is stored here.
34 FILL_PKG_DISPQTY NUMERIC No
The number of packages dispensed for this fill.
35 FILL_NDC_CSN VARCHAR No
This column stores the package (NDC) contact serial number (CSN) for the dispensed medication.
36 DISP_WHOLE_PKG_YN VARCHAR No
Is the medication order dispensed in whole packages or not. This item is set to Yes when the order is dispensed as a whole package and does not apply for the orders merely dispensed in multiple packages.
May contain organization-specific values: No
Category Entries:
Yes
No
37 HAS_RX_FLAGS_YN VARCHAR No
This indicates whether the fill request currently has any flags. Fill requests with flags appear in the flagged orders queue in Ambulatory Pharmacy.
The category values for this column were already listed for column: FILL_IS_PARTIAL_YN
38 DAW_REASON_C_NAME VARCHAR No
The category number for dispense as written (DAW) reason. It can be specified when dispensing a brand package (NDC) for a prescription fill. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: Yes
Category Entries:
No Product Selection Indicated
Prescriber Requested
Patient Requested
Pharmacist Selected
Generic Not in Stock
Brand Dispensed as Generic
Override
Brand Mandated by Law
Generic Not Available in Marketplace
Substitution Allowed By Prescriber but Plan Requests Brand - Patient's Plan Requested