RXFILL
Description:
RxFill and adherence information.

Primary Key
Column Name Ordinal Position
MED_PRBLM_LIST_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 MED_PRBLM_LIST_ID NUMERIC No
The unique identifier for the referral 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 RXFILL_STATUS_C_NAME VARCHAR No
Stores the status received from the pharmacy's RxFill message.
May contain organization-specific values: No
Category Entries:
Dispensed
Not Dispensed
Partial Dispense
Transferred
Event Notification
Profiled
4 RXFILL_DATE DATETIME No
This item stores the date when the RxFill message was generated/received.
5 RXFILL_DAYS_DISP INTEGER No
This item stores the number of days for which the medication was dispensed, according to the RxFill message (if the message status is Dispensed)
6 RXFILL_ORDER_ID NUMERIC No
Stores a link to the original order for which the RxFill message was sent.
7 RXFILL_MED_ID NUMERIC No
Stores the original medication (ERX) record for which the RxFill message was sent.
8 REFERENCE_NUMBER VARCHAR No
Stores a reference number that uniquely identifies this dispense.
9 RXFILL_PHARMACY_ID NUMERIC No
Stores the ID of the pharmacy that sent the RxFill message.
10 RXFILL_PHARMACY_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.