ProEHR Refill Status Codes

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

I have been working on a report to indicate which refill requests will be coming in the future and I’ve had to do some digging in the database. Found this little nugget of information while working in the HPSITE.REFILL table.

This is HPSITE.REFILL table description followed by HPSITE.REFILL.RFL_STATUS description.

HPSITE.REFILL: This table stores the data related to ordering a refill of a patient’s medication.

HPSITE.REFILL.RFL_STATUS: This column indicates the current status of the refill. It equates to the dict_type of ‘RFLSTS’ in the dictionaries_master.

RFLSTS is found in the HPSITE.DICTIONARIES_VIEW

SELECT * FROM HPSITE.DICTIONARIES_VIEW WHERE DICT_TYPE='RFLSTS'
DICT_TYPE	DICT_CODE	DICT_DESCRIPTION	DICT_EXTRAINFORMATION	DICT_ORDER	DICT_TABLE	DICT_ARCHIVED
RFLSTS	0	Rejected Called In	 	0	 	0
RFLSTS	1	Approved Called In	Called In	1	 	0
RFLSTS	2	Requested	 	2	 	0
RFLSTS	3	Rejected	 	3	 	0
RFLSTS	4	Approved	Filed	4	 	0
RFLSTS	5	Approved Faxed In	Faxed	5	NULL	0
RFLSTS	6	Approved Printed	Printed	6	NULL	0
RFLSTS	7	Approved Transmitted	Transmitted	7	NULL	0
RFLSTS	9	Approved Dispensed	Dispensed	9	NULL	0

This is using current 9.3.034 version of Allscripts ProEHR.