SOCIAL_HX_ALC_USE

Description: |
The SOCIAL_HX_ALC_USE table contains social alcohol history data entered in clinical system patient encounters. Note: Typically, only the most recent social history data for a patient is extracted. However, you may elect to extract all social history contacts if you wish. In this case, since one patient encounter may contain multiple social history contacts, each contact is uniquely identified by a combination of the 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 | 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 | CONTACT_DATE | DATETIME | No |
The contact date on which the history information was collected.
4 | ALCOHOL_DRINKS_WK | VARCHAR | No |
Stores the alcohol history of drinks per week.
5 | HX_DRINK_TYPES_C_NAME | VARCHAR | No |
Stores the type of alcohol consumed for alcohol history.
May contain organization-specific values: Yes
Category Entries:
Glasses of wine
Cans of beer
Shots of liquor
Drinks containing 0.5 oz of alcohol
Standard drinks or equivalent