RXHI_SHIPMENT_STATUS
Description:
Current and previous shipment status information for a home infusion shipment.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier (.1 item) for the work request record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 RXHI_SHIP_STATUS_C_NAME VARCHAR No
This item stores the current and past statuses for a home infusion shipment. The current status is stored on the last (highest numbered) line
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
4 RXHI_STS_UTC_DTTM DATETIME (UTC) No
This item stores the instant of update for each change to the home infusion shipment status (I RXW 10091). The most recent update is stored in the last (highest numbered) line
5 RXHI_STATUS_COMMENT VARCHAR No
User entered or system generated comment for a home infusion status event.
6 RXHI_CHNG_RSN_C_NAME VARCHAR No
The reason why the medications or supplies in an order have been modified after the shipment has left the pharmacy.
May contain organization-specific values: Yes
No Entries Defined