ORDER_EQUIPMENT_INFO
Description:
Information related to equipment orders.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of 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_DISP_QTY NUMERIC No
The dispense quantity for item.
4 FILL_SOURCE_C_NAME VARCHAR No
Where the prescription fill was requested from.
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
E-Transfer
5 CHARGING_CSN NUMERIC No
Contains the unique contact serial number for the patient's pharmacy visit contact to use for charge and payment posting.
6 FILL_EPISODE_ID NUMERIC No
This item is a link from the order fill to the therapy episode under which the medication is being given.
7 FILL_DELIVERY_TYPE_C_NAME VARCHAR No
The delivery type for this order's fill. Delivery type in this context refers to the type of delivery mechanism that infuses the medication from the bag to the patient, not a commercial shipping carrier.
May contain organization-specific values: Yes
8 EQUIPMENT_DVT_CSN NUMERIC No
The unique contact serial number for the device tracking record.
9 DISPENSE_PHR_ID NUMERIC No
The dispensing pharmacy for the order.
10 DISPENSE_PHR_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.