SOCIAL_ADL_HX

Description:

This table contains data recorded in the activities of daily living section of social history contacts entered in the patient's chart during a clinical system encounter. Note: This table is designed to hold a patient's history over time; however, it is most typically implemented to only extract the latest patient history contact.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	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.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	HX_ADL_QUESTION_ID	VARCHAR	No
	Stores the link to the unique ID of the ADL question.
4	HX_ADL_QUESTION_ID_RECORD_NAME	VARCHAR	No
	The name of the Visit Navigator (VN) History Template Definition (LQH) record.
5	HX_ADL_RESPONSE_C_NAME	VARCHAR	No
	This column stores the category value (1, 2 or 3) of the response to ADL questions. May contain organization-specific values: No Category Entries: Yes No Not Asked
6	HX_ADL_COMMENTS	VARCHAR	No
	Holds comments for Activities of Daily Living (ADL) questions.