ORD_EREFILL_REQ
Description:
This table gives all the electronic refill information. The information covers details of ordered medications, who ordered them and from where they were ordered.

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 ID for the order with which the e-refill is associated.
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 CONTACT_DATE DATETIME No
The date of this contact (when the order was placed) in calendar format.
4 EREFILL_REQ_RX_NAM VARCHAR No
The name of the e-refill requested medication.
5 EREFILL_MED_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.
6 EREFILL_REQ_RX_QTY NUMERIC No
The quantity of the requested medication.
7 EREFILL_REQ_RX_UNIT VARCHAR No
Stores the units of the quantity of requested medication.
8 EREFILL_REQ_RX_SIG VARCHAR No
Stores the user signature for the requested e-refill.
9 EREFILL_REQ_RFL_NUM NUMERIC No
The number of refills requested in the e-refill.
10 EREFILL_REQ_END_DT DATETIME No
Refill request end date
11 EREFILL_PHARM_ID NUMERIC No
Stores the ID of the requesting pharmacy
12 EREFILL_PHARM_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
13 EREFILL_REQ_PERSON VARCHAR No
Stores the EMP ID of the person requesting the refill.
14 EREFILL_REQ_DT DATETIME No
Stores the date and time the e-refill was requested.
15 EREFILL_REQ_COMMENT VARCHAR No
Stores the ID of the Note (HNO) record that stores the pharmacy comments.
16 ERFLL_REQ_RFL_PRN_C_NAME VARCHAR No
Stores the As Needed (PRN) value for refills (for example PRN-2Yr or PRN-1Yr), referring to the length of time the 'as needed' medication can be refilled.
May contain organization-specific values: No
Category Entries:
PRN-2Yr
PRN-1Yr
PRN-Other