MEDS_REV_HX_LIST

Description:

This table lists the patient's current medications from each time a user reviewed the patient's medications. Reviewing user and other information about each instance of medication review is in the MEDS_REV_HX table. The list of medications at the most recent review instance is in the MEDS_REV_LAST_LIST table. 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.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
CONTACT_SERIAL_NUM	2
LINE_COUNT	3
VALUE_COUNT	4

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	CONTACT_SERIAL_NUM	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
3	LINE_COUNT	INTEGER	No
	The line number of the associated instance of medication review in the patient's record. Together with PAT_ID, this forms the foreign key to the MEDS_REV_HX table.
4	VALUE_COUNT	INTEGER	No
	The line number of one of the multiple medication orders that are associated with the patient and the instance of medication review from the MEDS_REV_HX table.
5	MEDICATION_ORDER_ID	NUMERIC	No
	The unique ID of one of the patient's current medication orders at the time of review.
6	TAKING_YN	VARCHAR	No
	Indicates whether the associated medication order was marked as taking at the time of review.