MEDS_REV_LAST_LIST

Description:

This table lists the patient's current medications from the last time a user reviewed the patient's medications. Reviewing user and other information about the most recent review of medications is in the PATIENT table in columns MEDS_LAST_REV_TM, MEDS_LST_REV_USR_ID, and MEDS_LAST_REV_CSN. The list of medications current at each review instance is in the MEDS_REV_HX_LIST table. Reviewing user and other information about each medication's review instance is in the MEDS_REV_HX table.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE_COUNT	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	LINE_COUNT	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	MEDICATION_ORDER_ID	NUMERIC	No
	The unique ID of one of the patient's current medication orders at the most recent time of review.
4	TAKING_YN	VARCHAR	No
	Indicates whether the associated medication order was marked as taking at the most recent time of review. May contain organization-specific values: No Category Entries: No Yes
5	TAKING_ACTION_C_NAME	VARCHAR	No
	This virtual item separates out the taking category from item EPT 17224. May contain organization-specific values: No Category Entries: Pended Reorder Invalid Defaults Historical Med Edited Initial Prescription Prescribed Sig Changed Taking Differently Taking As Reported Taking As Prescribed Not Taking Taking Unknown Taking Not Set