MDL_HISTORY

Description:

The MDL_HISTORY table enables you to report on Medication Problem List history information over time.

Primary Key

Column Name	Ordinal Position
MED_PRBLM_LIST_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	MED_PRBLM_LIST_ID	NUMERIC	No
	The unique identifier for the med problem list record.
2	CONTACT_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this contact in your system. The integer portion of the number specifies the date of the contact. The digits after the decimal point indicate multiple contacts on one day.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	LNG_TRM_OVERTIME_YN	VARCHAR	No
	The changes to the long-term indicator over time. May contain organization-specific values: No Category Entries: Yes No