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.