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_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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 E-Transfer
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 Pending E-Transfer 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 Prep Reuse Started IP Dispense Prep Reuse Stopped IP Queued For Dispense Check Without Prep IP Dispense Check Removed IP Dispense Check Started IP Second Dispense Check IP Dispense Final Label Check IP Final Label Check Deferred IP Final Label Check Overridden 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 E-Transfer Request Pending Send E-Transfer Request Sent E-Transfer Request Sent Successfully E-Transfer Request Sending Error E-Transfer Request Approved E-Transfer Request Denied E-Transfer Pending Reconciliation E-Transfer Reconciled E-Transfer Confirmation Sent E-Transfer Confirmation Success E-Transfer Confirmation Error E-Transfer Request Received E-Transfer Response Pending Send E-Transfer Response Sent E-Transfer Response Sent Successfully E-Transfer Response Sending Error E-Transfer Confirmation Received 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