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	NUMERIC	No
	Stores the medication NDC code i.e national drug code which is associated with ERX (.1 medication ID number).
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