MEDICAL_HX

Description:

The MEDICAL_HX table contains data from medical history contacts entered in clinical system patient encounters. Since one patient encounter may contain multiple medical history contacts, each contact is uniquely identified by a patient encounter serial number and a line number.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LINE	INTEGER	No
	The line number of the medical history contact within the encounter. Each line of history is stored in enterprise reporting as its own record; a given patient may have multiple records (identified by line number) that reflect multiple lines of history.
2	DX_ID	NUMERIC	No
	The unique ID of the diagnosis record associated with the medical history contact. Note: This is NOT the ICD9 diagnosis code. It is an internal identifier that is typically not visible to a user.
3	MEDICAL_HX_DATE	VARCHAR	No
	The free-text date entered in clinical system’s Medical History window for the diagnosis. This field is free-text due to the imprecise nature of patient-provided historical information.
4	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
5	MED_HX_ANNOTATION	VARCHAR	No
	This column contains the medical history annotation.